Re: BUG #16978: Nested CTEs give ERROR in v13

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #16978: Nested CTEs give ERROR in v13
Дата
Msg-id 1313767.1619186886@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #16978: Nested CTEs give ERROR in v13  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #16978: Nested CTEs give ERROR in v13  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> This narrowed down SQL (from what SQLSmith generated) seems to error out
> only with N levels of CTE nesting - no tables / views / 1-row output. 
> The SQL works fine with v12.4 but raises an ERROR in v13 which seems like a
> regression. Is this owing a recent change in v13 - that could affect this?

FWIW, I don't see any error from this, either in HEAD or the
back branches.

$ cat recursive.sql
WITH RECURSIVE w6(c6) AS
     (WITH w6(c6) AS
      (WITH w8(c8) AS
      (WITH w9(c9) AS
      (WITH w10(c10) AS
      (WITH w11(c11) AS
      (WITH w_err(c12) AS
   (SELECT 1)
    SELECT * FROM w_err)
    SELECT * FROM w11)
    SELECT * FROM w10)
    SELECT * FROM w9)
    SELECT * FROM w8)
     SELECT * FROM w6)
     SELECT * FROM w6;
$ psql -f recursive.sql
 c6 
----
  1
(1 row)

            regards, tom lane



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

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16982: pg_rewind cannot deal with configuration files (postgresql.conf) located outside data directory
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #16979: WITH RECURSIVE SQL crashes v13.x