#3239: Report 'All Tickets By Milestone (including closed)' broken on
postgresql-8.1
------------------------------------+---------------------------------------
Reporter: [EMAIL PROTECTED] | 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/>
_______________________________________________
Trac-Tickets mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac-tickets
