[SAC] Trac postgres conversion
Frank Warmerdam
warmerdam at pobox.com
Mon Jul 6 12:47:19 EDT 2009
Jason Birch wrote:
> I believe that all of the canned report 6 "All Tickets By Milestone (Including closed)" are broken because of this statement:
>
> ORDER BY (milestone IS NULL), milestone DESC, (status = 'closed'),
> (CASE status WHEN 'closed' THEN modified ELSE (-1)*p.value END) DESC
>
> The fixed version (referencing the underlying column for modified and casting the p.value) looks something like
>
> ORDER BY (milestone IS NULL), milestone DESC, (status = 'closed'),
> (CASE status WHEN 'closed' THEN changetime ELSE (-1 * CAST(p.value AS numeric)) END) DESC
>
> I've fixed MapGuide's and FDO's, but it looks like others are broken, such as:
>
> http://trac.osgeo.org/gdal/report/6
>
> Other than that this seems to have gone well. Great job folks!
Jason,
Thanks for the clear analysis. I will try and fixup the other trac's today.
Best regards,
--
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush | Geospatial Programmer for Rent
More information about the Sac
mailing list