Ticket #689 (closed defect: fixed)

Opened 3 years ago

Last modified 3 years ago

ST_CoveredBy LINESTRINGM/LINESTRING with POLYGON empty

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

Description (last modified by robe) (diff)

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;

Change History

Changed 3 years ago by robe

  • description modified (diff)

Changed 3 years ago by pramsey

  • status changed from new to closed
  • resolution set to fixed
Note: See TracTickets for help on using tickets.