[postgis-devel] [PostGIS] #705: ST_Distance on points crashes server

[PostGIS]

#705: ST_Distance on points crashes server
---------------------+------------------------------------------------------
 Reporter:  robe     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  blocker  |   Milestone:  PostGIS 2.0.0
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------
 I assume this is a result of recent changes since it wasn't crashing last
 I tried on Friday.

 {{{
 -- this crashes --
 SELECT ST_Distance(foo1.the_geom, foo2.the_geom)
 FROM (SELECT ST_GeomFromText('POINT(-11.1111111 40)') UNION ALL
         SELECT ST_GeomFromText('POINT(-11.1111111 55)') ) As
 foo1(the_geom)
         CROSS JOIN (SELECT ST_GeomFromText('POINT(-11.1111111 40)')
   UNION ALL SELECT ST_GeomFromText('POINT(-11.1111111 55)') ) As
 foo2(the_geom);
 }}}

 -- this doesn't crash -
 {{{
 SELECT ST_Distance(foo1.the_geom, foo2.the_geom)
 FROM (SELECT ST_GeomFromText('POINT(-11.1111111 40)') UNION ALL
         SELECT ST_GeomFromText('POINT(-11.1111111 55)') ) As
 foo1(the_geom)
         CROSS JOIN (SELECT ST_GeomFromText('POINT(-11.1111111 40)')
   UNION ALL SELECT ST_GeomFromText('POINT(-11.1111111 55)') ) As
 foo2(the_geom) limit 1;
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/705>
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.