[postgis-devel] [PostGIS] #370: ST_CollectionExtract not Empty safe

[PostGIS]

#370: ST_CollectionExtract not Empty safe
----------------------+-----------------------------------------------------
  Reporter:  robe     |       Owner:  pramsey      
      Type:  defect   |      Status:  new          
  Priority:  medium   |   Milestone:  PostGIS 1.5.0
 Component:  postgis  |     Version:  trunk        
Resolution:           |    Keywords:               
----------------------+-----------------------------------------------------
Old description:

> SELECT ST_CollectionExtract(foo1.the_geom, 3)
>
>                         FROM ((SELECT ST_GeomFromText('GEOMETRYCOLLECTION
> EMPTY',4326) As the_geom
>                         UNION ALL SELECT ST_GeomFromText('POLYGON
> EMPTY',4326) As the_geom
>                 )
>                 ) As foo1
>                         LIMIT 3;
>
> Crashes server.

New description:

 {{{
 SELECT ST_CollectionExtract(foo1.the_geom, 3)
   FROM ((SELECT ST_GeomFromText('GEOMETRYCOLLECTION EMPTY',4326) As
 the_geom
   UNION ALL SELECT ST_GeomFromText('POLYGON EMPTY',4326) As the_geom
 )
 ) As foo1
 LIMIT 3;
 }}}
 Crashes server.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/370#comment:1>
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.