[postgis-devel] [PostGIS] #689: ST_CoveredBy LINESTRINGM/LINESTRING with POLYGON empty

[PostGIS]

#689: ST_CoveredBy LINESTRINGM/LINESTRING with POLYGON empty
---------------------+------------------------------------------------------
 Reporter:  robe     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.0.0
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------
Description changed by robe:

Old description:

> Paul -- let me know if you'd like me to stop and give you a chance to
> catch up.
>
> -- distilled query
>
> {{{
> SELECT ST_CoveredBy(ST_GeomFromText('POLYGON EMPTY'),
> ST_GeomFromText('LINESTRING(-10 50,50 -10)'));
> }}}
>

> -- full query
>
> {{{
>
> "SELECT ST_CoveredBy(foo1.the_geom, foo2.the_geom) As result,
> ST_AsText(foo1.the_geom) As ref1_geom, ST_AsText(foo2.the_geom) As
> ref2_geom
>         FROM ((SELECT ST_GeomFromText('GEOMETRYCOLLECTION EMPTY',4326) As
> the_geom
>                         UNION ALL SELECT ST_GeomFromText('POLYGON
> EMPTY',4326) As the_geom
>                         UNION ALL SELECT ST_GeomFromText('POINT
> EMPTY',4326) As the_geom
>                         UNION ALL SELECT ST_GeomFromText('MULTIPOINT
> EMPTY',4326) As the_geom
>                         UNION ALL SELECT ST_GeomFromText('MULTIPOLYGON
> EMPTY',4326) As the_geom
>                         UNION ALL SELECT ST_GeomFromText('LINESTRING
> EMPTY',4326) As the_geom
>                         UNION ALL SELECT ST_GeomFromText('MULTILINESTRING
> EMPTY',4326) As the_geom ) ) As foo1 CROSS JOIN ((SELECT
> ST_MakeLine(ST_SetSRID(ST_MakePointM(i,j,m),4326),ST_SetSRID(ST_MakePointM(j,i,m),4326))
> As the_geom FROM generate_series(-10,50,10) As i CROSS JOIN
> generate_series(50,70, 20) As j CROSS JOIN generate_series(1,2) As m
> WHERE NOT(i = j) ORDER BY i, j, m, i*j*m)) As foo2;
> }}}

New description:

 Paul -- let me know if you'd like me to stop and give you a chance to
 catch up.

 -- distilled query

 {{{
 SELECT ST_CoveredBy(ST_GeomFromText('POLYGON EMPTY'),
 ST_GeomFromText('LINESTRING(-10 50,50 -10)'));
 }}}


 -- full query

 {{{

 SELECT ST_CoveredBy(foo1.the_geom, foo2.the_geom) As result,
 ST_AsText(foo1.the_geom) As ref1_geom, ST_AsText(foo2.the_geom) As
 ref2_geom
         FROM ((SELECT ST_GeomFromText('GEOMETRYCOLLECTION EMPTY',4326) As
 the_geom
                         UNION ALL SELECT ST_GeomFromText('POLYGON
 EMPTY',4326) As the_geom
                         UNION ALL SELECT ST_GeomFromText('POINT
 EMPTY',4326) As the_geom
                         UNION ALL SELECT ST_GeomFromText('MULTIPOINT
 EMPTY',4326) As the_geom
                         UNION ALL SELECT ST_GeomFromText('MULTIPOLYGON
 EMPTY',4326) As the_geom
                         UNION ALL SELECT ST_GeomFromText('LINESTRING
 EMPTY',4326) As the_geom
                         UNION ALL SELECT ST_GeomFromText('MULTILINESTRING
 EMPTY',4326) As the_geom ) ) As foo1 CROSS JOIN ((SELECT
 ST_MakeLine(ST_SetSRID(ST_MakePointM(i,j,m),4326),ST_SetSRID(ST_MakePointM(j,i,m),4326))
 As the_geom FROM generate_series(-10,50,10) As i CROSS JOIN
 generate_series(50,70, 20) As j CROSS JOIN generate_series(1,2) As m WHERE
 NOT(i = j) ORDER BY i, j, m, i*j*m)) As foo2 LIMIT 2;
 }}}

--

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