-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello,
it has been brought to my attention by a request in IRC #trac today, that a user is experiencing following issue with report 6 in default configuration on latest stable 0.12: 'My Tickets' is shown _after_ 'Active Tickets' Before the changeset it was ok. Work-around is to rename groups or use ORDER BY (COALESCE(owner, '') = '$USER') DESC, ... instead of ORDER BY (owner = '$USER') DESC, ... Hint: The underlying query seem to not get the DESC rule, when the column is added the new way, as SQL logging reveals ([2] last line). Well, looks like there is simply no way to attach a 'DESC' to the __group__ directive, right? Since I'm not a SQL guru, I start with discussion here rather than filing a ticket right-away. Sincerely, Steffen Hoffmann [1] http://trac.edgewall.org/changeset/10892 [2] http://pastebin.com/G3criDRQ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk8TOHMACgkQ31DJeiZFuHerswCgt0vEC5hw/eloK/i3UbNcxnG1 jFAAoOJpFbfqY9Qn/YhpkX7hrDH+KTEp =W5uA -----END PGP SIGNATURE----- -- You received this message because you are subscribed to the Google Groups "Trac Development" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/trac-dev?hl=en.
