Small query yields "error: no relation entry for relid 11"
Tom Ellis <tom-lists-postgresql.org@jaguarpaw.co.uk>
From: Tom Ellis <tom-lists-postgresql.org@jaguarpaw.co.uk>
To: pgsql-bugs@lists.postgresql.org
Date: 2020-12-05T17:30:56Z
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"
Commits
-
Fix missed step in removal of useless RESULT RTEs in the planner.
- e98c900993e8 14.0 landed
- 7d43b76f6ed9 13.2 landed
- 77a94c30da61 12.6 landed