RE: Crash on UNION with PG 17

2024-04-02 Thread Regina Obe
> On Thu, 28 Mar 2024 at 04:34, Regina Obe wrote: > > 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 > > )

Re: Crash on UNION with PG 17

2024-04-01 Thread David Rowley
On Thu, 28 Mar 2024 at 04:34, Regina Obe wrote: > 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_no

Re: Crash on UNION with PG 17

2024-03-27 Thread David Rowley
On Thu, 28 Mar 2024 at 04:34, Regina Obe wrote: > 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

Re: Crash on UNION with PG 17

2024-03-27 Thread Bruce Momjian
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/?

Crash on UNION with PG 17

2024-03-27 Thread Regina Obe
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 Th