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 1v4dRJ-0037W5-V5 for pgsql-bugs@arkaria.postgresql.org; Fri, 03 Oct 2025 10:55:06 +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 1v4dRI-00CfYq-1Q for pgsql-bugs@arkaria.postgresql.org; Fri, 03 Oct 2025 10:55:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v4clk-00CXPT-MK for pgsql-bugs@lists.postgresql.org; Fri, 03 Oct 2025 10:12:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1v4cli-000BEh-35 for pgsql-bugs@lists.postgresql.org; Fri, 03 Oct 2025 10:12: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=94aKyBorRuTQxgegJkRao5h+QW04cnbz8b6nKTUu8b8=; b=j8OEpH7fcV3dncCmiOfYJLNw6o jj/9aHcHrQMLbLgnttD6c0O6r+9R/LSg0xH6+0CGqRhS0kk50s7OiswOtIdQ48bzY4Xim4aLuNwX5 NvkVselqZaR/HuRTYjjAhyJB1PAzqD2uIjM4xD5xb8w/MRGRIQ5w9zxaTE5zSp4FVgpJy+11tJnlM 4rxVSmHp77VMkJLialGnF9T37Y/kNz1vEWuILJyjsL4uX9Ko3cYPGdtEYC9jniqR48ptxbKIv9a2h SqU//QUuUlSpoTxfu/k9mcj0dhpxzULs9X7wMwUtqtbaowGVJbQ84oQElw5hQRVu22sjKMm6QWNXo yJC9GcVw==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v4cle-003ICl-Vr for pgsql-bugs@lists.postgresql.org; Fri, 03 Oct 2025 10:12:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1v4cle-006suT-2r for pgsql-bugs@lists.postgresql.org; Fri, 03 Oct 2025 10:12:02 +0000 Content-Type: multipart/mixed; boundary="===============8360109856305077858==" MIME-Version: 1.0 Subject: BUG #19071: commit b448f1c8d broke LEFT JOIN pushdown To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: a.ratundalov@postgrespro.ru Reply-To: a.ratundalov@postgrespro.ru, pgsql-bugs@lists.postgresql.org Date: Fri, 03 Oct 2025 10:11:17 +0000 Message-ID: <19071-91078e3db3a9d7bc@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 --===============8360109856305077858== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTA3MQpMb2dnZWQgYnk6ICAgICAgICAgIEFudG9uIFJhdHVuZGFsb3YK RW1haWwgYWRkcmVzczogICAgICBhLnJhdHVuZGFsb3ZAcG9zdGdyZXNwcm8ucnUKUG9zdGdyZVNR TCB2ZXJzaW9uOiAxOC4wCk9wZXJhdGluZyBzeXN0ZW06ICAgRGViaWFuIDYuMS4xNDgtMSAoMjAy NS0wOC0yNikgeDg2XzY0IEdOVS9MaW51eApEZXNjcmlwdGlvbjogICAgICAgIAoKRERMIDoKCiAg ICAgICAgXGMgcG9zdGdyZXMgYW50b24gMTI3LjAuMC4yIDY1NDMyCgogICAgICAgIERST1AgVEFC TEUgSUYgZXhpc3RzIGE7CiAgICAgICAgRFJPUCBUQUJMRSBJRiBleGlzdHMgYjsKCiAgICAgICAg Q1JFQVRFIFRBQkxFIElGIE5PVCBleGlzdHMgYSAoYzEgaW50ZWdlciBOT1QgTlVMTCwgYzIgdGV4 dCk7CiAgICAgICAgQ1JFQVRFIFRBQkxFIElGIE5PVCBleGlzdHMgYiAoYzEgaW50ZWdlciBOT1Qg TlVMTCwgYzIgdGV4dCk7CgogICAgICAgIFxjIHBvc3RncmVzIGFudG9uIDEyNy4wLjAuMSA2NTQz MgoKICAgICAgICBDUkVBVEUgZXh0ZW5zaW9uIElGIE5PVCBleGlzdHMgcG9zdGdyZXNfZmR3OwoK ICAgICAgICBDUkVBVEUgc2VydmVyIElGIE5PVCBleGlzdHMgczIgRk9SRUlHTiBkYXRhIHdyYXBw ZXIgcG9zdGdyZXNfZmR3Cm9wdGlvbnMgKGhvc3QgJzEyNy4wLjAuMicsIHBvcnQgJzY1NDMyJywg ZGJuYW1lICdwb3N0Z3JlcycpOwogICAgICAgIENSRUFURSBVU0VSIG1hcHBpbmcgSUYgTk9UIGV4 aXN0cyBGT1IgYW50b24gc2VydmVyIHMyIG9wdGlvbnMgKFVTRVIKJ2FudG9uJyk7CgogICAgICAg IERST1AgVEFCTEUgSUYgZXhpc3RzIGEgY2FzY2FkZTsKICAgICAgICBEUk9QIFRBQkxFIElGIGV4 aXN0cyBiIGNhc2NhZGU7CgogICAgICAgIENSRUFURSBUQUJMRSBJRiBOT1QgZXhpc3RzIGEgKGMx IGludGVnZXIgTk9UIE5VTEwsIGMyIHRleHQpCnBhcnRpdGlvbiBieSBoYXNoKGMxKTsKICAgICAg ICBDUkVBVEUgVEFCTEUgSUYgTk9UIGV4aXN0cyBhX3AxIHBhcnRpdGlvbiBvZiBhIEZPUiB2YWx1 ZXMgV0lUSAoobW9kdWx1cyAyLCByZW1haW5kZXIgMCk7CiAgICAgICAgQ1JFQVRFIEZPUkVJR04g VEFCTEUgSUYgTk9UIGV4aXN0cyBhX3AyIHBhcnRpdGlvbiBvZiBhIEZPUiB2YWx1ZXMKV0lUSCAo bW9kdWx1cyAyLCByZW1haW5kZXIgMSkgc2VydmVyIHMyIG9wdGlvbnMgKHRhYmxlX25hbWUgJ2En KTsKCiAgICAgICAgQ1JFQVRFIFRBQkxFIElGIE5PVCBleGlzdHMgYiAoYzEgaW50ZWdlciBOT1Qg TlVMTCwgYzIgdGV4dCkKcGFydGl0aW9uIGJ5IGhhc2goYzEpOwogICAgICAgIENSRUFURSBUQUJM RSBJRiBOT1QgZXhpc3RzIGJfcDEgcGFydGl0aW9uIG9mIGIgRk9SIHZhbHVlcyBXSVRICihtb2R1 bHVzIDIsIHJlbWFpbmRlciAwKTsKICAgICAgICBDUkVBVEUgRk9SRUlHTiBUQUJMRSBJRiBOT1Qg ZXhpc3RzIGJfcDIgcGFydGl0aW9uIG9mIGIgRk9SIHZhbHVlcwpXSVRIIChtb2R1bHVzIDIsIHJl bWFpbmRlciAxKSBzZXJ2ZXIgczIgb3B0aW9ucyAodGFibGVfbmFtZSAnYicpOwoKICAgICAgICBJ TlNFUlQgSU5UTyBhICggYzEsIGMyICkgU0VMRUNUIGksICd0ZXh0Xyd8fChpKTo6dGV4dCBGUk9N CmdlbmVyYXRlX3NlcmllcygxLDYpIGk7CiAgICAgICAgSU5TRVJUIElOVE8gYiAoIGMxLCBjMiAp IFNFTEVDVCBpLCAndGV4dF8nfHwoaSk6OnRleHQgRlJPTQpnZW5lcmF0ZV9zZXJpZXMoMSw0KSBp OwoKICAgICAgICBzZXQgZW5hYmxlX3BhcnRpdGlvbndpc2Vfam9pbiBUTyBPTjsKClFVRVJZIDoK CiAgICAgICAgRVhQTEFJTiggdmVyYm9zZSwgY29zdHMgb2ZmICkKICAgICAgICBTRUxFQ1QgKiBG Uk9NIGEgTEVGVCBKT0lOIGIgT04gYS5jMT1iLmMxIFdIRVJFIGEuYzE9NjsKClBMQU4gOgoKICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIFFVRVJZIFBMQU4KLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCiBO ZXN0ZWQgTG9vcCBMZWZ0IEpvaW4KICAgT3V0cHV0OiBhLmMxLCBhLmMyLCBiLmMxLCBiLmMyCiAg IC0+ICBGb3JlaWduIFNjYW4gb24gcHVibGljLmFfcDIgYQogICAgICAgICBPdXRwdXQ6IGEuYzEs IGEuYzIKICAgICAgICAgUmVtb3RlIFNRTDogU0VMRUNUIGMxLCBjMiBGUk9NIHB1YmxpYy5hIFdI RVJFICgoYzEgPSA2KSkKICAgLT4gIE1hdGVyaWFsaXplCiAgICAgICAgIE91dHB1dDogYi5jMSwg Yi5jMgogICAgICAgICAtPiAgRm9yZWlnbiBTY2FuIG9uIHB1YmxpYy5iX3AyIGIKICAgICAgICAg ICAgICAgT3V0cHV0OiBiLmMxLCBiLmMyCiAgICAgICAgICAgICAgIFJlbW90ZSBTUUw6IFNFTEVD VCBjMSwgYzIgRlJPTSBwdWJsaWMuYiBXSEVSRSAoKGMxID0gNikpCigxMCByb3dzKQoKUExBTiBC RUZPUkUgVEhFIENIQU5HRVMgOgoKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFFVRVJZClBMQU4KLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQogRm9yZWlnbiBTY2FuCiAgIE91dHB1dDogYS5jMSwg YS5jMiwgYi5jMSwgYi5jMgogICBSZWxhdGlvbnM6IChwdWJsaWMuYV9wMiBhKSBMRUZUIEpPSU4g KHB1YmxpYy5iX3AyIGIpCiAgIFJlbW90ZSBTUUw6IFNFTEVDVCByNC5jMSwgcjQuYzIsIHI1LmMx LCByNS5jMiBGUk9NIChwdWJsaWMuYSByNCBMRUZUIEpPSU4KcHVibGljLmIgcjUgT04gKCgocjQu YzEgPSByNS5jMSkpIEFORCAoKHI1LmMxID0gNikpKSkgV0hFUkUgKChyNC5jMSA9IDYpKQooNCBy b3dzKQoK --===============8360109856305077858==--