#3194: "All Tickets By Milestone (Including closed)" report execution fails on
PostgreSQL
------------------------------------+---------------------------------------
Reporter: [EMAIL PROTECTED] | Owner: daniel
Type: defect | Status: new
Priority: normal | Milestone: 0.10
Component: report system | Version: devel
Severity: normal | Keywords:
------------------------------------+---------------------------------------
It fails with the following error message:
{{{
'Report execution failed: ERROR: column "modified" does not exist'
}}}
The problem is in the 'ORDER BY' statement. I temporary fixed it:
{{{
- ORDER BY (milestone IS NULL), milestone DESC, (status = 'closed'),
- (CASE status WHEN 'closed' THEN modified ELSE (-1)*p.value END)
DESC
+ ORDER BY (milestone IS NULL), milestone DESC, (status = 'closed'),
changetime DESC
}}}
but I'm not sure if it's correct.
--
Ticket URL: <http://projects.edgewall.com/trac/ticket/3194>
The Trac Project <http://trac.edgewall.com/>
_______________________________________________
Trac-Tickets mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac-tickets
