Menu

#21 Database format: sort_l field has inconsistent type

future
open
nobody
database (3)
3
2017-07-29
2009-12-12
No

In database format 3, the sort_l column in the category table is defined as string[1] with default value '2', but in the code it is always handled as number. It works fine because the SQLite3 library is tolerant regarding types and does implicit retyping. But it is strange and should be fixed with the next database version.

Discussion

  • Mathias Kussinger

    • assigned_to: nobody --> ndegendogo
     
  • Mathias Kussinger

    • assigned_to: ndegendogo --> nobody
     
  • Mathias Kussinger

    When entering a category the console shows the error message:
    SQL3: unexpected datatype 3 instead of SQLITE_INTEGER for column 8

     
  • Mathias Kussinger

    • labels: 1165701 --> 1397011
     
  • Mathias Kussinger

    • labels: 1397011 --> database
    • milestone: 969212 -->
     
  • Mathias Kussinger

    that's more a bug, to be fixed in database version 4

     
  • Mathias Kussinger

    • Group: --> database_later
     
  • Christa Runge

    Christa Runge - 2017-07-29

    Ticket moved from /p/karatasi/bugs/205/

    Can't be converted:

    • _milestone: database_later
     
  • Christa Runge

    Christa Runge - 2017-07-29
    • Group: database_later --> future
     

Log in to post a comment.