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 1tt4bL-008ISV-4e for pgsql-bugs@arkaria.postgresql.org; Fri, 14 Mar 2025 12:57:23 +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 1tt4bJ-006hHR-Kt for pgsql-bugs@arkaria.postgresql.org; Fri, 14 Mar 2025 12:57:21 +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 1tszza-000ye2-54 for pgsql-bugs@lists.postgresql.org; Fri, 14 Mar 2025 08:02:06 +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.96) (envelope-from ) id 1tszzY-002la2-1S for pgsql-bugs@lists.postgresql.org; Fri, 14 Mar 2025 08:02: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=oJCG4BGxPeI0ZmjnvvDNl9jm113zPCdk5W9REHFen8g=; b=JlGjEJAXjvg8cdTZ925nopFRYk PA1dMUdyppaElBHLosapRk7HxwpzRcffptnmm3rpIUjQiw6aA2+2CI9EaY2qv0m0vVk7En7KwCESD eD7hEm2yyNL/XCQiCFlWXtZQlHfMdSkYrHgb6op3AyL+qTgUNVviGqWKaRhA87pts0c3r9RPud5RK fvzNc6l9inoKxEsLOhWRPepLhcQUo7+pk1j4H0YDNJeuuDJCQy+6Ofn9k861KbUWepYrbsD/t4LsG o3bjctmGezUhFljs66BkhCHZ4IRUVrnzlm2sQnN7GE+kK2zAa7H+gwwGvUDXfdpdoGn0s+mh1NtBW Co3HiFrw==; 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 1tszzY-0079Xk-2A for pgsql-bugs@lists.postgresql.org; Fri, 14 Mar 2025 08:02:04 +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 1tszzX-00GWod-9j for pgsql-bugs@lists.postgresql.org; Fri, 14 Mar 2025 08:02:02 +0000 Content-Type: multipart/mixed; boundary="===============2433009638332684739==" MIME-Version: 1.0 Subject: BUG #18846: Incorrect Filtering Behavior with FULL OUTER JOIN and WHERE Condition To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: cheng.zhi.qiang@outlook.com Reply-To: cheng.zhi.qiang@outlook.com, pgsql-bugs@lists.postgresql.org Date: Fri, 14 Mar 2025 08:01:15 +0000 Message-ID: <18846-87207bf7520c0c43@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 --===============2433009638332684739== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODg0NgpMb2dnZWQgYnk6ICAgICAgICAgIHpoaXFpYW5nIGNoZW5nCkVt YWlsIGFkZHJlc3M6ICAgICAgY2hlbmcuemhpLnFpYW5nQG91dGxvb2suY29tClBvc3RncmVTUUwg dmVyc2lvbjogMTYuMQpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMC4wNApEZXNjcmlwdGlv bjogICAgICAgIAoKRGVzY3JpcHRpb246DQpXaGVuIGV4ZWN1dGluZyBhIG11bHRpLWxldmVsIEZV TEwgT1VURVIgSk9JTiBxdWVyeSB3aXRoIHN1YnF1ZXJpZXMsIHRoZQpmaWx0ZXJpbmcgY29uZGl0 aW9uIGluIHRoZSBXSEVSRSBjbGF1c2UgdW5leHBlY3RlZGx5IHJlbW92ZXMgdmFsaWQgcm93cy4K QmFzZWQgb24gdGhlIGZpcnN0IHF1ZXJ5J3Mgb3V0cHV0IHs5LCBOVUxMfSwgdGhlIHNlY29uZCBx dWVyeSBzaG91bGQgcmV0dXJuCjksIGJ1dCBpdCByZXR1cm5zIGFuIGVtcHR5IHJlc3VsdCBzZXQg aW5zdGVhZC4NCg0KU3RlcHMgdG8gUmVwcm9kdWNlOg0KQ3JlYXRlIHRoZSB0ZXN0IHRhYmxlIGFu ZCBpbnNlcnQgZGF0YToNCkNSRUFURSBUQUJMRSB0MSAoDQogICAgYzEgSU5URUdFUg0KKTsNCklO U0VSVCBJTlRPIHQxIChjMSkgVkFMVUVTICg5KTsNCg0KcXVlcnkxOg0Kc2VsZWN0ICANCiAgcmVm XzAuYzEgYXMgY18xDQpmcm9tIA0KICAodDEgYXMgcmVmXzANCiAgICBmdWxsIG91dGVyIGpvaW4g KChzZWxlY3QgZGlzdGluY3QgDQogICAgICAgICAgICByZWZfMS5jMSBhcyBjXzENCiAgICAgICAg ICBmcm9tIA0KICAgICAgICAgICAgdDEgYXMgcmVmXzENCiAgICAgICAgICApIGFzIHN1YnFfMA0K ICAgICAgZnVsbCBvdXRlciBqb2luIChzZWxlY3QgIA0KICAgICAgICAgICAgcmVmXzMuYzEgYXMg Y18zDQogICAgICAgICAgZnJvbSANCiAgICAgICAgICAgICh0MSBhcyByZWZfMg0KICAgICAgICAg ICAgICBmdWxsIG91dGVyIGpvaW4gdDEgYXMgcmVmXzMNCiAgICAgICAgICAgICAgb24gKHJlZl8y LmMxID0gcmVmXzMuYzEgKSkNCiAgICAgICAgICB3aGVyZSAoZmFsc2U6OmJvb2wpKSBhcyBzdWJx XzENCiAgICAgIG9uIChzdWJxXzAuY18xID0gc3VicV8xLmNfMyApKQ0KICAgIG9uIChyZWZfMC5j MSA9IHN1YnFfMS5jXzMgKSkNCg0Kb3V0cHV0Og0KIGNfMSAgDQotLS0tLS0NCiAgICA5DQogTlVM TA0KKDIgcm93cykNCg0KcXVlcnkyOg0Kc2VsZWN0ICANCiAgcmVmXzAuYzEgYXMgY18xDQpmcm9t IA0KICAodDEgYXMgcmVmXzANCiAgICBmdWxsIG91dGVyIGpvaW4gKChzZWxlY3QgZGlzdGluY3Qg DQogICAgICAgICAgICByZWZfMS5jMSBhcyBjXzENCiAgICAgICAgICBmcm9tIA0KICAgICAgICAg ICAgdDEgYXMgcmVmXzENCiAgICAgICAgICApIGFzIHN1YnFfMA0KICAgICAgZnVsbCBvdXRlciBq b2luIChzZWxlY3QgIA0KICAgICAgICAgICAgcmVmXzMuYzEgYXMgY18zDQogICAgICAgICAgZnJv bSANCiAgICAgICAgICAgICh0MSBhcyByZWZfMg0KICAgICAgICAgICAgICBmdWxsIG91dGVyIGpv aW4gdDEgYXMgcmVmXzMNCiAgICAgICAgICAgICAgb24gKHJlZl8yLmMxID0gcmVmXzMuYzEgKSkN CiAgICAgICAgICB3aGVyZSAoZmFsc2U6OmJvb2wpKSBhcyBzdWJxXzENCiAgICAgIG9uIChzdWJx XzAuY18xID0gc3VicV8xLmNfMyApKQ0KICAgIG9uIChyZWZfMC5jMSA9IHN1YnFfMS5jXzMgKSkN CndoZXJlICgocmVmXzAuYzEgKSA+IDAgKQ0KDQpvdXRwdXQ6DQogY18xIA0KLS0tLS0NCigwIHJv d3MpDQoNCkV4cGVjdGVkIGJlaGF2aW9yOg0KU2luY2UgdGhlIGZpcnN0IHF1ZXJ5IHByb2R1Y2Vz IHs5LCBOVUxMfSwgdGhlIHNlY29uZCBxdWVyeSwgd2hpY2ggYXBwbGllcwp0aGUgY29uZGl0aW9u IFdIRVJFIHJlZl8wLmMxID4gMCwgc2hvdWxkIHJldHVybiA5IGluc3RlYWQgb2YgYW4gZW1wdHkg cmVzdWx0CnNldC4gDQoNCkFjdHVhbCBiZWhhdmlvcjoNCkhvd2V2ZXIsIHRoZSByZXN1bHQgaXMg dW5leHBlY3RlZGx5IGVtcHR5Lg0KDQpQb3N0Z3JlcyB2ZXJzaW9uOg0KR2l0aHViIGNvbW1pdDog M2YxYWFhYTE4MDY4OWYyMDE1ZTdmN2JkMDFjOWJlNmQ3YTk5M2I0Mg0KVmVyc2lvbjogIFBvc3Rn cmVTUUwgMTZiZXRhMSBvbiB4ODZfNjQtcGMtbGludXgtZ251LCBjb21waWxlZCBieSBnY2MgKFVi dW50dQo5LjQuMC0xdWJ1bnR1MX4yMC4wNC4yKSA5LjQuMCwgNjQtYml0DQoNCk9wZXJhdGluZyBz eXN0ZW06DQpMaW51eCB1YnVudHUgNS4xNS4wLTEzNC1nZW5lcmljICMxNDV+MjAuMDQuMS1VYnVu dHUgU01QIE1vbiBGZWIgMTcgMTM6Mjc6MTYKVVRDIDIwMjUgeDg2XzY0IHg4Nl82NCB4ODZfNjQg R05VL0xpbnV4Cgo= --===============2433009638332684739==--