pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Small 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>
  2020-12-05 21:17 ` Re: Small query yields "error: no relation entry for relid 11" Tom Lane <tgl@sss.pgh.pa.us>
  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 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>
  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