Opened 17 years ago
Last modified 16 years ago
#4715 closed defect
SQLite and > 9 priorities values does not sort correctly — at Initial Version
Reported by: | StefanC | Owned by: | Jonas Borgström |
---|---|---|---|
Priority: | normal | Milestone: | 0.11 |
Component: | report system | Version: | |
Severity: | normal | Keywords: | priority enum sort |
Cc: | vnaum@…, mmanulis@… | Branch: | |
Release Notes: | |||
API Changes: | |||
Internal Changes: |
Description
When using assigning priorities like this
Text : Value ---------- Prio100 : 6 Prio90 : 7 Prio80 : 8 Prio70: 9 Prio60: 10 Prio50: 11
And you try to sort on the priority, it won't work as expected (they should fall from 100 down to 50). It is my suspicion that the problem lies in sqlite's "feature" to be un-typed. I have had the same problem before with sqlite and integer ordereing. It will think that 11 is less than 6, as it does character comparision or something.
Note:
See TracTickets
for help on using tickets.