Opened 14 years ago

Last modified 14 years ago

#689 closed defect

ST_CoveredBy LINESTRINGM/LINESTRING with POLYGON empty — at Initial Version

Reported by: robe Owned by: pramsey
Priority: medium Milestone: PostGIS 2.0.0
Component: postgis Version: master
Keywords: Cc:

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;

Change History (0)

Note: See TracTickets for help on using tickets.