[postgis-tickets] [PostGIS] #5586: Crash bug when using ST_Intersects

[PostGIS]

#5586: Crash bug when using ST_Intersects
----------------------+---------------------------
 Reporter:  Wenjing   |      Owner:  pramsey
     Type:  defect    |     Status:  new
 Priority:  critical  |  Milestone:  PostGIS 3.4.1
Component:  postgis   |    Version:  3.4.x
 Keywords:            |
----------------------+---------------------------
 {{{
 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.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5586>
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.