Report 'All Tickets By Milestone (including closed)' broken on postgresql-8.1

[goodguy@…]

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.

[jensen@…]

I confirm the bug and the fix. Both are valid in 0.9.6 as well.

[Christian Boos]

See also #2123.

I'll have a look if we can find a syntax that works everywhere.

[anonymous]

I have the same problem in 0.10/pg 8.1.5.

[anonymous]

I've had the same problem. Also can use the

CAST(p.value AS INT)

syntax for compatibility.

[Christian Boos]

Duplicate of #5543.