Opened 13 months ago

Last modified 12 months ago

#5586 closed defect

Crash bug when using ST_Intersects — at Initial Version

Reported by: Wenjing Owned by: pramsey
Priority: critical Milestone: PostGIS GEOS
Component: postgis Version: 3.4.x
Keywords: Cc:

Description

DROP TABLE IF EXISTS t;
CREATE TABLE t (geom geometry);
INSERT INTO t (geom) VALUES ((ST_GeomFromText('GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,1 0))')));
INSERT INTO t (geom) SELECT ST_Boundary(t.geom) FROM t;
SELECT * FROM t As a1 JOIN t As a2 ON ST_Intersects(a1.geom, a2.geom);

ERROR INFO:
-- psql:script/simplify.sql:7: server closed the connection unexpectedly
-- This probably means the server terminated abnormally
-- before or while processing the request.
-- psql:script/simplify.sql:7: error: connection to server was lost

It could be ST_Boundary makes the boundary of POINT(0 0) be 'EMPTY' instead of POINT EMPTY, resulting in this crash.

Change History (0)

Note: See TracTickets for help on using tickets.