Hello,
We just upgraded to trac 0.9.3, and now our reports which have numeric
custom fields are not sorting correctly. For example, 10,100,20,200.
This appears to be because this is how SQLite3 sorts text type fields,
I can confirm this by doing queries directly against the ticket_custom
field. How can I fix it, though? Anyone else had this problem? Here's
an example - thanks in advance.
-- Chad
sqlite> .schema ticket_custom
CREATE TABLE ticket_custom (
ticket integer,
name text,
value text,
UNIQUE(ticket,name)
);
sqlite> .schema ticket_custom
CREATE TABLE ticket_custom (
ticket integer,
name text,
value text,
UNIQUE(ticket,name)
);
sqlite> select distinct value from ticket_custom where name='rank'
order by value;
1
10
100
1000
101
105
11
110
12
120
13
_______________________________________________
Trac mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac
