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 1lkYEl-0008Gx-2r for pgsql-bugs@arkaria.postgresql.org; Sat, 22 May 2021 20:28:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lkYEk-0003aL-38 for pgsql-bugs@arkaria.postgresql.org; Sat, 22 May 2021 20:28:42 +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 1lkUND-0000uX-D7 for pgsql-bugs@lists.postgresql.org; Sat, 22 May 2021 16:21:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lkUN7-0000TW-3t for pgsql-bugs@lists.postgresql.org; Sat, 22 May 2021 16:21:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=9aDpUOi2cpcjozpjBgc95x1GLwbR3lH3WhTSE/uOg10=; b=rDudKKsGaiG0JN6cHFlbymAL61 FOZcld05b/yfqRL2t5G5B6arl+Xnqowd6HxsttT6IcoGoTAhXPhD9O+yEnkMkU/IIKbhWwtKPcC0E RbJachkYUwVJq8n+LysfXhy8uVPso1OPnjuR4cRrAieDyzR8gl0mGokJNegOWEeRXOPUw/VauOL6J Zgiv2UJtHNseZ1dZtyTcvyoAdrIN3kaLWXdKiE8KVNwfE927i8Vebauk43Ua9glaViBOZUu/1hu1f ASPdZnodc6sgf4b1PO9ozV4HGraamTQbhQgOhRpy61KcDEF585CnI0VovLrg1NIQoFM+o9HmFpqKQ FUPSx3xg==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lkUN5-0007lp-I2 for pgsql-bugs@lists.postgresql.org; Sat, 22 May 2021 16:21:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lkUN4-0000xv-Dj for pgsql-bugs@lists.postgresql.org; Sat, 22 May 2021 16:21:02 +0000 Content-Type: multipart/mixed; boundary="===============5198859354554113195==" MIME-Version: 1.0 Subject: BUG #17030: ERROR: cannot decompile join alias var in plan tree introduced in pg14beta1 To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: buschmann@nidsa.net Reply-To: buschmann@nidsa.net, pgsql-bugs@lists.postgresql.org Date: Sat, 22 May 2021 16:20:29 +0000 Message-ID: <17030-5844aecae42fe223@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5198859354554113195== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzAzMApMb2dnZWQgYnk6ICAgICAgICAgIEhhbnMgQnVzY2htYW5uCkVt YWlsIGFkZHJlc3M6ICAgICAgYnVzY2htYW5uQG5pZHNhLm5ldApQb3N0Z3JlU1FMIHZlcnNpb246 IDE0YmV0YTEKT3BlcmF0aW5nIHN5c3RlbTogICBXaW5kb3dzIFNlcnZlciAyMDE5IDY0IGJpdApE ZXNjcmlwdGlvbjogICAgICAgIAoKT24gV2luZG93cyBJIGluc3RhbGxlZCB0aGUgbmV3IHBnMTRi ZXRhMSBkb3dubG9hZGVkIGZyb20gRURCIFdlYnNpdGUuDQp4eHhkYj0jIHNlbGVjdCB2ZXJzaW9u ICgpOw0KICAgICAgICAgICAgICAgICAgICAgICAgICAgIHZlcnNpb24NCi0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIFBvc3Rn cmVTUUwgMTRiZXRhMSwgY29tcGlsZWQgYnkgVmlzdWFsIEMrKyBidWlsZCAxOTE0LCA2NC1iaXQN CigxIFplaWxlKQ0KDQpXaGVuIHRlc3Rpbmcgb3VyIGFwcGxpY2F0aW9uIEkgc3VkZGVubHkgZ290 IHRoZSAkc3ViamVjdCBlcnJvciBtZXNzYWdlOg0KDQpFUlJPUjogIGNhbm5vdCBkZWNvbXBpbGUg am9pbiBhbGlhcyB2YXIgaW4gcGxhbiB0cmVlDQoNClRoaXMgb2NjdXJzIG9uIGEgcXVpdGUgY29t cGxleCBDVEUgcXVlcnkgb2YgdGhlIHN0eWxlIChoZXJlIG9ubHkgYQpzaW1wbGlmaWVkIGxheW91 dCB0byBnaXZlIGFuIGlkZWEpOiANCg0Kd2l0aA0KcXh4eCBhcyAoDQpzZWxlY3QgYSxiLGMNCmZy b20gdGFiYQ0KbGVmdCBqb2luIHRhYmINCi4uLikNCnNlbGVjdCB4bWxlbGVtZW50IChuYW1lIHNl bCwNCnhtbGVsZW1lbnQobmFtZSBiYmINCi4uLg0KKSkNCmZyb20gKHNlbGVjdCAqIGZyb20gcXh4 eCBvcmRlciBieSBjb2xvcmRlcikgYXMgcXhvDQopDQoNClRoaXMgcGFydGljdWxhciBxdWVyeSAo Z2VuZXJhdGluZyBhbiBYTUwtdHJlZSkgd29ya2VkIGZvciBhYm91dCA1IHllYXJzIG9uCmFsbCBu ZXdlc3QgbWlub3IgdmVyc2lvbnMgZnJvbSA5LjYgdG8gMTMuMy4NCg0KSSBrbm93IHRoYXQgdGhp cyBpcyBub3QgYW4gcmVwcm9kdWNlYmxlIGNhc2UsIGJ1dCBJIGNhbiBzdXBwbHkgdGhlIGV4ZWN1 dGlvbgpwbGFuIGZyb20gcGcxMy4zIGlmIG5lZWRlZC4NCg0KVGhhbmtzIGZvciBpbnZlc3RpZ2F0 aW9uDQoNCkhhbnMgQnVzY2htYW5uCgo= --===============5198859354554113195==--