Priority sorting breaks when grouping is enabled

[d.sullivan@…]

I have a report that lists tickets grouped by milestone, but when I try to sort by priority, in some cases the priority list is not ordered properly. If I remove the milestone grouping, the sorting works fine.

I have 12 different priorities:

BOMB 1 Critical 2 High 3 High 4 Med+ 5 Med+ 6 Med- 7 Med- 8 Low 9 Low 0 Low -

Each with values from 1 to 12 from top to bottom.

When grouped by milestone, for example, the priorities for one report show up like this, sorted ascending:

Milestone 1

• 3 High
• 6 Med-

Milestone 2

• 3 High
• 4 Med+
• 5 Med+
• 6 Med-
• 0 Low
• 4 Med+
• 5 Med+
• 6 Med-
• 9 Low

Using sqlite 3.7.3, Trac 1.0, Python 2.6.6

[Ryan J Ollos]

Moved ticket assigned to next-stable-1.0.x since maintenance of 1.0.x is coming to a close. Please move the ticket back if it's critical to fix on 1.0.x.

[Ryan J Ollos]

Milestone renamed