Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1klbPJ-0002U4-2J for pgsql-bugs@arkaria.postgresql.org; Sat, 05 Dec 2020 17:31:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1klbOm-0001g2-52 for pgsql-bugs@arkaria.postgresql.org; Sat, 05 Dec 2020 17:31:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1klbOl-0001fv-V4 for pgsql-bugs@lists.postgresql.org; Sat, 05 Dec 2020 17:31:07 +0000 Received: from balrog.mythic-beasts.com ([2a00:1098:0:82:1000:0:2:1]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1klbOe-0001go-T2 for pgsql-bugs@lists.postgresql.org; Sat, 05 Dec 2020 17:31:06 +0000 Received: from [2a00:1098:86:79::1] (port=45092 helo=cloudinit-builder) by balrog.mythic-beasts.com with esmtpsa (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92.3) (envelope-from ) id 1klbOd-0004cp-AA for pgsql-bugs@lists.postgresql.org; Sat, 05 Dec 2020 17:30:59 +0000 Received: from tom (uid 1000) (envelope-from tom-2018@jaguarpaw.co.uk) id 8138b by cloudinit-builder (DragonFly Mail Agent v0.11); Sat, 05 Dec 2020 17:30:56 +0000 Date: Sat, 5 Dec 2020 17:30:56 +0000 From: Tom Ellis To: pgsql-bugs@lists.postgresql.org Subject: Small query yields "error: no relation entry for relid 11" Message-ID: <20201205173056.GF30712@cloudinit-builder> Mail-Followup-To: Tom Ellis , pgsql-bugs@lists.postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline X-Penguin-0: * .^. * X-Penguin-1: - /V\ - X-Penguin-2: * // \\ * X-Penguin-3: - /( )\ - X-Penguin-4: * ^^-^^ * User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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"