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

From: Tom Ellis <tom-lists-postgresql(dot)org(at)jaguarpaw(dot)co(dot)uk>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Small query yields "error: no relation entry for relid 11"
Date: 2020-12-05 17:30:56
Message-ID: 20201205173056.GF30712@cloudinit-builder
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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"

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2020-12-05 21:17:06 Re: Small query yields "error: no relation entry for relid 11"
Previous Message Andy S 2020-12-04 17:43:38 Re: BUG #16763: CREATE TABLE IF NOT EXISTS fails with "relation exists"