Re: Crash on UNION with PG 17

On Thu, 28 Mar 2024 at 04:34, Regina Obe <lr@pcorp.us> 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_node id FROM edge UNION
>   SELECT end_node FROM edge;

As of d5d2205c8, this query should work as expected.

Thank you for letting us know about this.

David