[Trac-tickets] [The Trac Project] #3194: "All Tickets By Milestone (Including closed)" report execution fails on PostgreSQL

[The Trac Project]

#3194: "All Tickets By Milestone (Including closed)" report execution fails on
PostgreSQL
------------------------------------+---------------------------------------
 Reporter:  kbogdanov at redsolex.com  |       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/>