[Trac-tickets] [The Trac Project] #3239: Report 'All Tickets By Milestone (including closed)' broken on postgresql-8.1

[The Trac Project]

#3239: Report 'All Tickets By Milestone (including closed)' broken on
postgresql-8.1
------------------------------------+---------------------------------------
 Reporter:  goodguy at goodguy.spb.ru  |       Owner:  daniel
     Type:  defect                  |      Status:  new   
 Priority:  normal                  |   Milestone:        
Component:  report system           |     Version:  0.9.3 
 Severity:  normal                  |    Keywords:        
------------------------------------+---------------------------------------
 Using Trac 0.9.3 and Postgresql-8.1.3 it is unable to use report '{6} All
 tickets by milestone (including closed)' due to some bugs in SQL code.
 Instead of
 {{{
 (CASE status WHEN 'closed' THEN modified ELSE (-1) * p.value END)
 }}}

 where should be something like

 {{{
 (CASE status WHEN 'closed' THEN changetime ELSE (-1) * p.value::int END)
 }}}

 i.e. {{{changetime}}} field instead of {{{modified}}} and {{{p.value}}}
 should be converted to number.

-- 
Ticket URL: <http://projects.edgewall.com/trac/ticket/3239>
The Trac Project <http://trac.edgewall.com/>