[PostGIS] #5701: topology crashing under PG17

PostGIS trac at osgeo.org
Wed Mar 27 08:20:29 PDT 2024


#5701: topology crashing under PG17
-----------------------+---------------------------
  Reporter:  robe      |      Owner:  strk
      Type:  defect    |     Status:  new
  Priority:  blocker   |  Milestone:  PostGIS 3.5.0
 Component:  topology  |    Version:  master
Resolution:            |   Keywords:
-----------------------+---------------------------
Comment (by robe):

 I have confirmed this is not our fault.

 I can crash PG 17 with this query:


 {{{
 CREATE TABLE edge_data AS
 SELECT i AS edge_id, i + 1 AS start_node, i + 2 As end_node
 FROM generate_series(1,10) AS i;


 CREATE TEMP TABLE edge1_endnodes AS
   WITH edge AS (
     SELECT start_node, end_node
     FROM edge_data
     WHERE edge_id = 1
   )
   SELECT start_node id FROM edge UNION
   SELECT end_node FROM edge;
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5701#comment:3>
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.


More information about the postgis-tickets mailing list