RE: Crash on UNION with PG 17

Поиск
Список
Период
Сортировка
От Regina Obe
Тема RE: Crash on UNION with PG 17
Дата
Msg-id 000b01da8538$268f01a0$73ad04e0$@pcorp.us
обсуждение исходный текст
Ответ на Re: Crash on UNION with PG 17  (David Rowley <dgrowleyml@gmail.com>)
Список pgsql-hackers
> 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

Thanks for the fix.  I confirm it works now and our bots are green again.

Regina




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Fixing backslash dot for COPY FROM...CSV
Следующее
От: "Daniel Verite"
Дата:
Сообщение: Re: psql's FETCH_COUNT (cursor) is not being respected for CTEs