Small query using LATERAL that segfaults Postgres

Поиск
Список
Период
Сортировка
От Tom Ellis
Тема Small query using LATERAL that segfaults Postgres
Дата
Msg-id 20200713175124.GQ8220@cloudinit-builder
обсуждение исходный текст
Ответы Re: Small query using LATERAL that segfaults Postgres  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Small query using LATERAL that segfaults Postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
This small query seems to segfault Postgres.  I've tried on the
version of Postgres 11 that comes with Debian Stable and all versions
on https://www.db-fiddle.com/ including 13 (Beta).  DB Fiddle actually
says "An unexpected error occurred." but I suspect that's the
segfault.

Tom


SELECT
0
FROM (SELECT
      TRUE as "r",
      SUM(0)
      ) as "T1",
LATERAL
(SELECT TRUE as "b"
    UNION ALL
    SELECT
    "r" as "b"
    FROM (SELECT 0 ORDER BY COALESCE(0)) as "T1"
    ) as "T2"
WHERE "b"



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

Предыдущее
От: Arne Roland
Дата:
Сообщение: Re: BUG #16153: foreign key update should probably move dependent rows in the case of tuple rerouting
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: Small query using LATERAL that segfaults Postgres