pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedSmall query yields "error: no relation entry for relid 11"
2+ messages / 2 participants
[nested] [flat]
Commits from this thread:
2020-12-05 e98c900993 77a94c30da 7d43b76f6e Fix missed step in removal of useless RESULT RTEs in the planner.
* Small query yields "error: no relation entry for relid 11"
@ 2020-12-05 17:30 Tom Ellis <tom-lists-postgresql.org@jaguarpaw.co.uk>
0 siblings, 1 reply; 2+ messages in thread
From: Tom Ellis @ 2020-12-05 17:30 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org
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"
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Small query yields "error: no relation entry for relid 11"
@ 2020-12-05 21:17 Tom Lane <tgl@sss.pgh.pa.us>
parent: Tom Ellis <tom-lists-postgresql.org@jaguarpaw.co.uk>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2020-12-05 21:17 UTC (permalink / raw)
To: Tom Ellis <tom-lists-postgresql.org@jaguarpaw.co.uk>; +Cc: pgsql-bugs@lists.postgresql.org
Tom Ellis <tom-lists-postgresql.org@jaguarpaw.co.uk> writes:
> 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.
Cute ... fix pushed, thanks for the report!
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2020-12-05 21:17 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-12-05 17:30 Small query yields "error: no relation entry for relid 11" Tom Ellis <tom-lists-postgresql.org@jaguarpaw.co.uk>
2020-12-05 21:17 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox