[postgis-devel] [PostGIS] #1144: ST_MakeLine agregation error in order

[PostGIS]

#1144: ST_MakeLine agregation error in order
----------------------+-----------------------------------------------------
 Reporter:  arturbac  |       Owner:  pramsey      
     Type:  defect    |      Status:  new          
 Priority:  medium    |   Milestone:  PostGIS 2.0.0
Component:  postgis   |     Version:  1.5.X        
 Keywords:            |  
----------------------+-----------------------------------------------------
 There is a bug in ST_MakeLine agregate version.
 According to
 http://postgis.refractions.net/documentation/manual-1.5/ST_MakeLine.html

 Such agregation works by ony when I dont agregate anything other that
 geometry on big table (with milions of records )


 {{{
         select
                 wayid,
                 sub_seq,
                 /*count(*)*/ 0 as points,
                 st_makeline( geom ) as geom
         from (
                 select
                         wayid, sub_seq, geom
                 from osm.segments_ways_t h
                         join osm.node_t n using( nodeid )
                 order by wayid, sub_seq asc, seq asc
         ) ws
         group by wayid, sub_seq;

 }}}

 If I uncomment "count(*)" mots of linestrings have wrong vertex order , it
 looks like the order by in subquery stops working.
 Another fact is when I restrict query to single wayid before order by for
 example by where wayid=xxxxxx, agregation of other things don't distorts
 vertex order

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1144>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.