Custom field of type time cannot be sorted

[massimo.b@…]

In [ticket-custom] we created a due date field for tickets:

duedate = time
duedate.format = date
duedate.label = Due date
duedate.order = 14

Creating new tickets works and the field can be seen in custom queries, but pressing the column for sorting results in this error:

 Trac detected an internal error:

ProgrammingError: COALESCE types text and integer cannot be matched
LINE 5: ORDER BY COALESCE("duedate".value,0)=0,"duedate".value,t.id)...
                                          ^

[massimo.b@…]

Can be fixed with this patch:

query.py

@@ -656 +656 @@
                 # FIXME: This is a somewhat ugly hack.  Can we also have the
                 #        column type for this?  If it's an integer, we do
                 #        first one, if text, we do 'else'
-                if name == 'id' or name in self.time_fields:
+                if name == 'id':
                     sql.append("COALESCE(%s,0)=0%s," % (col, desc))
                 else:
                     sql.append("COALESCE(%s,'')=''%s," % (col, desc))

[Jun Omae]

Thanks for the patch but lead another issue when passing order=time to query page.

[Jun Omae]

Proposed changes in [7cde3e59f/jomae.git].

[Ryan J Ollos]

The changes look good.

[Jun Omae]

Thanks. Committed in [16570] and merged in [16571].