Trac ticket report {8} (Active Tickets, Mine first) does not work as advertised

[Util]

Ticket report {8} describes itself as:

• List all active tickets by priority.
• Show all tickets owned by the logged in user in a group first.

The report does make a separate group(s) of the user's tickets, but fails to sort on the grouping criteria, causing the group to appear at some random point anywhere in the multi-page report, and usually causing multiple sub-groups instead of a single "Mine" group.

[Util]

For reference, here is the original (faulty) SQL code of the report:

SELECT p.value AS __color__,
   (CASE owner 
     WHEN $USER THEN 'My Tickets' 
     ELSE 'Active Tickets' 
    END) AS __group__,
   id AS ticket, summary, component, version, milestone, t.type AS type, 
   owner, status,
   time AS created,
   changetime AS _changetime, description AS _description,
   reporter AS _reporter
  FROM ticket t
  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
  WHERE status <> 'closed' 
  ORDER BY (owner = $USER) DESC, p.value, milestone, t.type, time

[Util]

Changes made:

1. Resolved the issue by sorting on the grouping criteria.
2. Moved the the sort fields to be the first columns of the report, to make the sort order evident.
3. Changed the population of the numeric Priority from a LEFT JOIN to a sub-select, for clarity.
4. Formatted the SQL.

Closing ticket.