Small query yields "error: no relation entry for relid 11"

Поиск
Список
Период
Сортировка
От Tom Ellis
Тема Small query yields "error: no relation entry for relid 11"
Дата
Msg-id 20201205173056.GF30712@cloudinit-builder
обсуждение исходный текст
Ответы Re: Small query yields "error: no relation entry for relid 11"  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
This small query results in "error: no relation entry for relid 11" in
Postgres 12 and 13 (beta) on db-fiddle.com.  It runs fine in Posgres
11.

Tom


SELECT 0
      FROM
      (SELECT 0) as "T1"
      LEFT OUTER JOIN
      (SELECT * FROM (SELECT *
        FROM
        (SELECT
         0) as "T1"
        LEFT OUTER JOIN
        (SELECT
         TRUE as "r") as "T2"
        ON
        TRUE) as "T1",
       LATERAL
       (SELECT
        TRUE as "b"
        UNION ALL
        SELECT
        CASE WHEN "r" THEN TRUE ELSE TRUE END as "b") as "T2"
        ) as "T2"
      ON
      "b"



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

Предыдущее
От: Andy S
Дата:
Сообщение: Re: BUG #16763: CREATE TABLE IF NOT EXISTS fails with "relation exists"
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Small query yields "error: no relation entry for relid 11"