[PostGIS] #5997: Pg19 Crash

PostGIS trac at osgeo.org
Mon Oct 6 12:14:06 PDT 2025


#5997: Pg19 Crash
----------------------+---------------------------
 Reporter:  pramsey   |      Owner:  pramsey
     Type:  defect    |     Status:  new
 Priority:  critical  |  Milestone:  PostGIS 3.6.1
Component:  postgis   |    Version:  master
 Keywords:            |
----------------------+---------------------------
 As of a recent update to Pg19, our use of window functions is causing a
 crash. Reproduce:
 {{{
 CREATE TEMPORARY TABLE cluster_inputs (id int, geom geometry);
 INSERT INTO cluster_inputs VALUES
 (1, 'LINESTRING (0 0, 1 1)'),
 (2, 'LINESTRING (5 5, 4 4)'),
 (3, NULL),
 (4, 'LINESTRING (0 0, -1 -1)'),
 (5, 'LINESTRING (6 6, 7 7)'),
 (6, 'POLYGON EMPTY'),
 (7, 'POLYGON ((0 0, 4 0, 4 4, 0 4, 0 0))');

 SELECT 't5', id, ST_AsText(geom),
   ST_ClusterWithinWin(geom, 1.4) OVER () AS cluster
   FROM cluster_inputs;
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5997>
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