Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qq9d4-008M9G-UO for pgsql-bugs@arkaria.postgresql.org; Tue, 10 Oct 2023 10:06:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qq9d2-006ZHy-Qv for pgsql-bugs@arkaria.postgresql.org; Tue, 10 Oct 2023 10:06:17 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qq6Cv-004dWK-VO for pgsql-bugs@lists.postgresql.org; Tue, 10 Oct 2023 06:27:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qq6Cu-000uEi-8L for pgsql-bugs@lists.postgresql.org; Tue, 10 Oct 2023 06:27:05 +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=2gh011wwIKku7H181C44a9Km6CT7nGvnf76hPQjqEX0=; b=hoUr3xJxZxI7ol3mFa5TDZ9CWh RVEyt1kVkOTq0RWS7aztZxs0DcSGJK39InJpYwjB+AS+H+8K+OVCBAxwEYEOIkbKSww9PvtBmGmfl 6h5iB4VKmOIMZmAr2NzcGZHncpXW3IBpwUR15Z1+4QfSCVkMxO+SkcNTad5mdy/xgYAFiXbfWEAYm h/Z90skvriXomw1ObqtRe32nSfQhcA6eeyBKMSexD/H+UuoKEnzykMOILFMgNRM5Dlp3X6Quu6D20 ED9B6Z5CxKiz/1Z7/oA5FBJzOGprKmRQ49YIFjOdpD2Nx+P6T/FkPAuUEem1WGb9+zQTVF35pzL7y Z+TJ43SQ==; 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 1qq6Ct-0007Ve-NV for pgsql-bugs@lists.postgresql.org; Tue, 10 Oct 2023 06:27:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qq6Cr-003a0J-O7 for pgsql-bugs@lists.postgresql.org; Tue, 10 Oct 2023 06:27:02 +0000 Content-Type: multipart/mixed; boundary="===============0539947546447104507==" MIME-Version: 1.0 Subject: BUG #18152: Join condition is not pushed down to union all subquery To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: lauri.kajan@gmail.com Reply-To: lauri.kajan@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 10 Oct 2023 06:26:26 +0000 Message-ID: <18152-72d0fe42ca4283d9@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 --===============0539947546447104507== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODE1MgpMb2dnZWQgYnk6ICAgICAgICAgIExhdXJpIEthamFuCkVtYWls IGFkZHJlc3M6ICAgICAgbGF1cmkua2FqYW5AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTYuMApPcGVyYXRpbmcgc3lzdGVtOiAgICZxdW90O1Bvc3RncmVTUUwgMTYuMCAoRGViaWFuIDE2 LjAtMS5wZ2RnMTEwKzEpIG9uIHg4Nl8KRGVzY3JpcHRpb246ICAgICAgICAKClRoZSBqb2luIGNv bmRpdGlvbiBpcyBub3QgcHVzaGVkIGRvd24gdG8gYSBzdWJxdWVyeSBjb250YWluaW5nIFVOSU9O IEFMTAp3aGVuIGV2ZW4gYSBzaW5nbGUgcXVlcnkgd2l0aGluIHRoZSBzdWJxdWVyeSBjb250YWlu cyBhIFdIRVJFIGNsYXVzZS4gVGhpcwppc3N1ZSBwcmV2ZW50cyB0aGUgb3B0aW1pemVyIGZyb20g Y3JlYXRpbmcgYSBwbGFuIHRoYXQgdXRpbGl6ZXMgdGhlIGluZGV4IG9uCnRoZSBqb2luIGNvbHVt bi4gSG93ZXZlciwgd2hlbiB0aGUgV0hFUkUgY2xhdXNlIGlzIG1vdmVkIHRvIHRoZSB0b3AtbGV2 ZWwKcXVlcnksIHRoZSBvcHRpbWl6ZXIgcHJvZHVjZXMgdGhlIGRlc2lyZWQgcGxhbi4NCg0KRVhQ TEFJTg0KV0lUSA0KICB0YXJnZXRzIEFTICgNCiAgICBTRUxFQ1QgJ2Jpa2UnIEFTIHZlaGljbGUs IGlkLCBkZWFsZXJfbmFtZSwgZnJhbWVfc2l6ZSBGUk9NIGJpa2VzIFdIRVJFCmZyYW1lX3NpemUg PSA1Mg0KICAgIFVOSU9OIEFMTA0KICAgIFNFTEVDVCAnY2FyJyBBUyB2ZWhpY2xlLCBpZCwgZGVh bGVyX25hbWUsIG51bGw6OmludCBBUyBmcmFtZV9zaXplIEZST00KY2Fycw0KICApDQpTRUxFQ1QN CiAgZGVhbGVycy5uYW1lIGRlYWxlciwNCiAgdGFyZ2V0cy52ZWhpY2xlLA0KICB0YXJnZXRzLmlk DQpGUk9NDQogIGRlYWxlcnMNCiAgSk9JTiB0YXJnZXRzDQogICAgT04gZGVhbGVycy5uYW1lID0g dGFyZ2V0cy5kZWFsZXJfbmFtZQ0KV0hFUkUNCiAgZGVhbGVycy5pZCBJTiAoNTQsMTIsNDU2KQ0K Ow0KLS0tDQpIYXNoIEpvaW4gIChjb3N0PTE2LjkxLi40NTg3Ljc3IHJvd3M9MzI1IHdpZHRoPTQx KSAoYWN0dWFsCnRpbWU9MC4yNzAuLjI3LjEzMyByb3dzPTI3NSBsb29wcz0xKQ0KICBIYXNoIENv bmQ6ICgiIipTRUxFQ1QqIDEiIi5kZWFsZXJfbmFtZSA9IGRlYWxlcnMubmFtZSkNCiAgLT4gIEFw cGVuZCAgKGNvc3Q9MC4wMC4uNDAyNi4yMCByb3dzPTEwODI4MCB3aWR0aD00MSkgKGFjdHVhbAp0 aW1lPTAuMDA5Li4yMC4zNzYgcm93cz0xMDgyMjIgbG9vcHM9MSkNCiAgICAgICAgLT4gIFN1YnF1 ZXJ5IFNjYW4gb24gIiIqU0VMRUNUKiAxIiIgIChjb3N0PTAuMDAuLjE5MDguODAgcm93cz04Mjgw CndpZHRoPTQxKSAoYWN0dWFsIHRpbWU9MC4wMDkuLjYuNzA4IHJvd3M9ODIyMiBsb29wcz0xKQ0K ICAgICAgICAgICAgICAtPiAgU2VxIFNjYW4gb24gYmlrZXMgIChjb3N0PTAuMDAuLjE4MjYuMDAg cm93cz04MjgwIHdpZHRoPTQ1KQooYWN0dWFsIHRpbWU9MC4wMDkuLjYuMTE0IHJvd3M9ODIyMiBs b29wcz0xKQ0KICAgICAgICAgICAgICAgICAgICBGaWx0ZXI6IChmcmFtZV9zaXplID0gNTIpDQog ICAgICAgICAgICAgICAgICAgIFJvd3MgUmVtb3ZlZCBieSBGaWx0ZXI6IDkxNzc4DQogICAgICAg IC0+ICBTZXEgU2NhbiBvbiBjYXJzICAoY29zdD0wLjAwLi4xNTc2LjAwIHJvd3M9MTAwMDAwIHdp ZHRoPTQxKQooYWN0dWFsIHRpbWU9MC4wMTIuLjguNDMzIHJvd3M9MTAwMDAwIGxvb3BzPTEpDQog IC0+ICBIYXNoICAoY29zdD0xNi44OC4uMTYuODggcm93cz0zIHdpZHRoPTUpIChhY3R1YWwgdGlt ZT0wLjAxNy4uMC4wMTgKcm93cz0zIGxvb3BzPTEpDQogICAgICAgIEJ1Y2tldHM6IDEwMjQgIEJh dGNoZXM6IDEgIE1lbW9yeSBVc2FnZTogOWtCDQogICAgICAgIC0+ICBJbmRleCBTY2FuIHVzaW5n IGRlYWxlcnNfcGtleSBvbiBkZWFsZXJzICAoY29zdD0wLjI4Li4xNi44OApyb3dzPTMgd2lkdGg9 NSkgKGFjdHVhbCB0aW1lPTAuMDA5Li4wLjAxNSByb3dzPTMgbG9vcHM9MSkNCiAgICAgICAgICAg ICAgSW5kZXggQ29uZDogKGlkID0gQU5ZICgnezU0LDEyLDQ1Nn0nOjppbnRlZ2VyW10pKQ0KUGxh bm5pbmcgVGltZTogMC4xNDggbXMNCkV4ZWN1dGlvbiBUaW1lOiAyNy4xNzAgbXMNCg0KDQoNCk1v dmluZyB0aGUgV0hFUkUgY2xhdXNlIHRvIHRoZSB0b3AtbGV2ZWwgcXVlcnkgcHJvZHVjZXMgYSBt b3JlIGVmZmljaWVudApxdWVyeSBleGVjdXRpb24gcGxhbi4gRXhhbXBsZToNCg0KRVhQTEFJTiBB TkFMWVpFDQpXSVRIDQogIHRhcmdldHMgQVMgKA0KICAgIFNFTEVDVCAnYmlrZScgQVMgdmVoaWNs ZSwgaWQsIGRlYWxlcl9uYW1lLCBmcmFtZV9zaXplIEZST00gYmlrZXMNCiAgICBVTklPTiBBTEwN CiAgICBTRUxFQ1QgJ2NhcicgQVMgdmVoaWNsZSwgaWQsIGRlYWxlcl9uYW1lLCBudWxsOjppbnQg QVMgZnJhbWVfc2l6ZSBGUk9NCmNhcnMNCiAgKQ0KU0VMRUNUDQogIGRlYWxlcnMubmFtZSBkZWFs ZXIsDQogIHRhcmdldHMudmVoaWNsZSwNCiAgdGFyZ2V0cy5pZA0KRlJPTQ0KICBkZWFsZXJzDQog IEpPSU4gdGFyZ2V0cw0KICAgIE9OIGRlYWxlcnMubmFtZSA9IHRhcmdldHMuZGVhbGVyX25hbWUN CldIRVJFDQogIGRlYWxlcnMuaWQgSU4gKDU0LDEyLDQ1NikNCiAgQU5EIChmcmFtZV9zaXplIElT IG51bGwgT1IgZnJhbWVfc2l6ZSA9IDUyKQ0KOw0KLS0tLQ0KTmVzdGVkIExvb3AgIChjb3N0PTUu MzIuLjE0NDMuNjcgcm93cz0zMjUgd2lkdGg9NDEpIChhY3R1YWwKdGltZT0wLjEwNi4uMC44MTUg cm93cz0yNzUgbG9vcHM9MSkNCiAgLT4gIEluZGV4IFNjYW4gdXNpbmcgZGVhbGVyc19wa2V5IG9u IGRlYWxlcnMgIChjb3N0PTAuMjguLjE2Ljg4IHJvd3M9Mwp3aWR0aD01KSAoYWN0dWFsIHRpbWU9 MC4wMTkuLjAuMDMxIHJvd3M9MyBsb29wcz0xKQ0KICAgICAgICBJbmRleCBDb25kOiAoaWQgPSBB TlkgKCd7NTQsMTIsNDU2fSc6OmludGVnZXJbXSkpDQogIC0+ICBBcHBlbmQgIChjb3N0PTUuMDQu LjQ3NC41MiByb3dzPTEwOCB3aWR0aD00MSkgKGFjdHVhbAp0aW1lPTAuMDQ4Li4wLjI1MCByb3dz PTkyIGxvb3BzPTMpDQogICAgICAgIC0+ICBCaXRtYXAgSGVhcCBTY2FuIG9uIGJpa2VzICAoY29z dD01LjA0Li4yMzcuMTAgcm93cz04IHdpZHRoPTQxKQooYWN0dWFsIHRpbWU9MC4wNDUuLjAuMTIz IHJvd3M9OSBsb29wcz0zKQ0KICAgICAgICAgICAgICBSZWNoZWNrIENvbmQ6IChkZWFsZXJfbmFt ZSA9IGRlYWxlcnMubmFtZSkNCiAgICAgICAgICAgICAgRmlsdGVyOiAoKGZyYW1lX3NpemUgSVMg TlVMTCkgT1IgKGZyYW1lX3NpemUgPSA1MikpDQogICAgICAgICAgICAgIFJvd3MgUmVtb3ZlZCBi eSBGaWx0ZXI6IDkxDQogICAgICAgICAgICAgIEhlYXAgQmxvY2tzOiBleGFjdD0yNzQNCiAgICAg ICAgICAgICAgLT4gIEJpdG1hcCBJbmRleCBTY2FuIG9uIGJpa2VzX2RlYWxlcl9uYW1lX2lkeCAK KGNvc3Q9MC4wMC4uNS4wNCByb3dzPTEwMCB3aWR0aD0wKSAoYWN0dWFsIHRpbWU9MC4wMTAuLjAu MDEwIHJvd3M9MTAwCmxvb3BzPTMpDQogICAgICAgICAgICAgICAgICAgIEluZGV4IENvbmQ6IChk ZWFsZXJfbmFtZSA9IGRlYWxlcnMubmFtZSkNCiAgICAgICAgLT4gIEJpdG1hcCBIZWFwIFNjYW4g b24gY2FycyAgKGNvc3Q9NS4wNy4uMjM2Ljg3IHJvd3M9MTAwIHdpZHRoPTQxKQooYWN0dWFsIHRp bWU9MC4wMjcuLjAuMTE2IHJvd3M9ODIgbG9vcHM9MykNCiAgICAgICAgICAgICAgUmVjaGVjayBD b25kOiAoZGVhbGVyX25hbWUgPSBkZWFsZXJzLm5hbWUpDQogICAgICAgICAgICAgIEhlYXAgQmxv Y2tzOiBleGFjdD0yMzMNCiAgICAgICAgICAgICAgLT4gIEJpdG1hcCBJbmRleCBTY2FuIG9uIGNh cnNfZGVhbGVyX25hbWVfaWR4IAooY29zdD0wLjAwLi41LjA0IHJvd3M9MTAwIHdpZHRoPTApIChh Y3R1YWwgdGltZT0wLjAxNy4uMC4wMTcgcm93cz04Mgpsb29wcz0zKQ0KICAgICAgICAgICAgICAg ICAgICBJbmRleCBDb25kOiAoZGVhbGVyX25hbWUgPSBkZWFsZXJzLm5hbWUpDQpQbGFubmluZyBU aW1lOiAwLjIzOCBtcw0KRXhlY3V0aW9uIFRpbWU6IDAuODYzIG1zDQoNClVuZm9ydHVuYXRlbHkg dGhpcyB3b3JrYXJvdW5kIG1heSBiZWNvbWUgY29tcGxleCBpZiB0aGVyZSBhcmUgbXVsdGlwbGUK ZmlsdGVycyBmb3IgbXVsdGlwbGUgdGFibGVzLCBhcyBlYWNoIGZpbHRlcmVkIGNvbHVtbiBtdXN0 IGJlIGFkZGVkIHRvIGV2ZXJ5CnVuaW9uZWQgcXVlcnkuDQoNCg0KSGVyZSdzIGEgc2NyaXB0IHRv IGdlbmVyYXRlIHNhbXBsZSBkYXRhIGZvciB0aGUgZXhhbXBsZSBjYXNlOg0KDQpDUkVBVEUgVEFC TEUgZGVhbGVycyBBUw0KU0VMRUNUDQogIGlkLA0KICAoU0VMRUNUIHN0cmluZ19hZ2coQ0hSKDY1 KyhyYW5kb20oKSAqIDI1KTo6aW50ZWdlciksICcnKSBGUk9NCmdlbmVyYXRlX3NlcmllcygxLCA0 KSBXSEVSRSBpZD4wKSBuYW1lDQpGUk9NIGdlbmVyYXRlX3NlcmllcygxLCAxMDAwKSBBUyBpZA0K Ow0KQUxURVIgVEFCTEUgZGVhbGVycyBBREQgcHJpbWFyeSBrZXkgKGlkKTsNCkNSRUFURSBJTkRF WCBPTiBkZWFsZXJzKG5hbWUpOw0KDQpDUkVBVEUgVEFCTEUgYmlrZXMgQVMNClNFTEVDVA0KICBn ZW5lcmF0ZV9zZXJpZXMgQVMgaWQsDQogIChTRUxFQ1QgbmFtZSBGUk9NIGRlYWxlcnMgV0hFUkUg ZGVhbGVycy5pZCA9IChTRUxFQ1QgKHJhbmRvbSgpKjEwMDApOjppbnQKV0hFUkUgZ2VuZXJhdGVf c2VyaWVzPjApKSBBUyBkZWFsZXJfbmFtZSwNCiAgKHJhbmRvbSgpKjEyKzUwKTo6aW50IGFzIGZy YW1lX3NpemUNCkZST00gZ2VuZXJhdGVfc2VyaWVzKDEsIDEwMDAwMCk7DQpBTFRFUiBUQUJMRSBi aWtlcyBBREQgcHJpbWFyeSBrZXkgKGlkKTsNCkNSRUFURSBJTkRFWCBPTiBiaWtlcyhkZWFsZXJf bmFtZSk7DQoNCkNSRUFURSBUQUJMRSBjYXJzIEFTDQpTRUxFQ1QNCiAgZ2VuZXJhdGVfc2VyaWVz IGFzIGlkLA0KICAoU0VMRUNUIG5hbWUgRlJPTSBkZWFsZXJzIFdIRVJFIGRlYWxlcnMuaWQgPSAo U0VMRUNUIChyYW5kb20oKSoxMDAwKTo6aW50CldIRVJFIGdlbmVyYXRlX3Nlcmllcz4wKSkgQVMg ZGVhbGVyX25hbWUsDQogIChyYW5kb20oKSo3KzE0KTo6aW50IGFzIHdoZWVsX3NpemUNCkZST00g Z2VuZXJhdGVfc2VyaWVzKDEsIDEwMDAwMCk7DQpBTFRFUiBUQUJMRSBjYXJzIEFERCBwcmltYXJ5 IGtleSAoaWQpOw0KQ1JFQVRFIElOREVYIE9OIGNhcnMoZGVhbGVyX25hbWUpOwoK --===============0539947546447104507==--