On Wed, Mar 27, 2024 at 11:33:55AM -0400, Regina Obe wrote: > Our PostGIS bot that follows master branch has been crashing for past couple > of days on one of our tests > > https://trac.osgeo.org/postgis/ticket/5701 > > I traced the issue down to this commit: > https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=66c0185a3d14b > bbf51d0fc9d267093ffec735231 > > > The issue can be exercised without postgis installed as follows: > > > 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; > > 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;
I can confirm the crash in git master. -- Bruce Momjian <br...@momjian.us> https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.