Horton

Thread

Commits

  1. Fix missed step in removal of useless RESULT RTEs in the planner.

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

    Tom Ellis <tom-lists-postgresql.org@jaguarpaw.co.uk> — 2020-12-05T17:30:56Z

    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"

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

    Tom Lane <tgl@sss.pgh.pa.us> — 2020-12-05T21:17:06Z

    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