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 1qjHEU-00A5Kb-UV for pgsql-bugs@arkaria.postgresql.org; Thu, 21 Sep 2023 10:48:30 +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 1qjHET-00BAoO-DV for pgsql-bugs@arkaria.postgresql.org; Thu, 21 Sep 2023 10:48:29 +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 1qjDER-0092LE-Q9 for pgsql-bugs@lists.postgresql.org; Thu, 21 Sep 2023 06:32:12 +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.94.2) (envelope-from ) id 1qjDEN-006T4c-HL for pgsql-bugs@lists.postgresql.org; Thu, 21 Sep 2023 06:32:11 +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=E8vZH45Gm80IqqbZBwuk3pn1UuCbaK+YkwfJjrRyOe0=; b=foPhCBRy821m5/lwIUSXEmoojH RzMi7eyRqaOQVKPQhNyRGxtD+NrOAPVpLmjAccCslcNslZX4ZoyJ5BuRlM0kpixHlCx1zE1FcKX59 gpVMEKHiS8nMsugK/auyHXTGQProElU0jz7i31hPpUKQGdDN2AiobH8WGV+SbgLGMafnppoaLxTw/ DYEhN2AW5PsNQzFMCq8Uygb1ii6wN6BXjNGrK5dxVb8yYQcN/lNWs6iwMXRBxDNyJAggFif0YC93w jEVlXDaqvzbxu21oLdlhvqT2xCra1C82xwx76Hla4BKQTreMC7o9HVE1yKz/TSLeYxkrgMv65iIGt drCYe7vg==; 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 1qjDEK-0004DQ-3A for pgsql-bugs@lists.postgresql.org; Thu, 21 Sep 2023 06:32:06 +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 1qjDEI-001kSb-9r for pgsql-bugs@lists.postgresql.org; Thu, 21 Sep 2023 06:32:02 +0000 Content-Type: multipart/mixed; boundary="===============7872192871127466931==" MIME-Version: 1.0 Subject: BUG #18123: The execution plan for the left join is incorrect, returning incorrect rows of data. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: dafoer_x@163.com Reply-To: dafoer_x@163.com, pgsql-bugs@lists.postgresql.org Date: Thu, 21 Sep 2023 06:31:16 +0000 Message-ID: <18123-8604341c777ccee6@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 --===============7872192871127466931== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODEyMwpMb2dnZWQgYnk6ICAgICAgICAgIFRoZSBleGVjdXRpb24gcGxh biBmb3IgdGhlIGxlZnQgam9pbiBpcyBpbmNvcnJlY3QsIHJldHVybmluZyBpbmNvcnJlY3Qgcm93 cwpvZiBkYXRhLgpFbWFpbCBhZGRyZXNzOiAgICAgIGRhZm9lcl94QDE2My5jb20KUG9zdGdyZVNR TCB2ZXJzaW9uOiAxNC4wCk9wZXJhdGluZyBzeXN0ZW06ICAgY2VudG9zX3g4NgpEZXNjcmlwdGlv bjogICAgICAgIAoKY3JlYXRlIHRhYmxlIHRiMTEoYSBpbnQsIGIgaW50KTsNCmluc2VydCBpbnRv IHRiMTEgdmFsdWVzKDEsMSk7DQpzZWxlY3QgY291bnQoMSkgZnJvbSB0YjExIGExIHdoZXJlIGEx LmEgPTE7DQpzZWxlY3QgY291bnQoMSkgZnJvbSB0YjExIGExIGxlZnQgam9pbiB0YjExIGEyIG9u IGExLmE9YTIuYSB3aGVyZSBhMS5hPTEgYW5kCmEyLmE9MzsNCg0KcG9zdGdyZXM9IyBzZWxlY3Qg Y291bnQoMSkgZnJvbSB0YjExIGExIHdoZXJlIGExLmEgPTE7DQogY291bnQgDQotLS0tLS0tDQog ICAgIDENCigxIHJvdykNCg0KcG9zdGdyZXM9IyBzZWxlY3QgY291bnQoMSkgZnJvbSB0YjExIGEx IGxlZnQgam9pbiB0YjExIGEyIG9uIGExLmE9YTIuYSB3aGVyZQphMS5hPTEgYW5kIGEyLmE9MzsN CiBjb3VudCANCi0tLS0tLS0NCiAgICAgMA0KKDEgcm93KQ0KDQpwb3N0Z3Jlcz0jIGV4cGxhaW4g c2VsZWN0IGNvdW50KDEpIGZyb20gdGIxMSBhMSBsZWZ0IGpvaW4gdGIxMSBhMiBvbgphMS5hPWEy LmEgd2hlcmUgYTEuYT0xIGFuZCBhMi5hPTM7DQogICAgICAgICAgICAgICAgICAgUVVFUlkgUExB TiAgICAgICAgICAgICAgICAgICANCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLQ0KIEFnZ3JlZ2F0ZSAgKGNvc3Q9MC4wMC4uMC4wMSByb3dzPTEgd2lkdGg9 OCkNCiAgIC0+ICBSZXN1bHQgIChjb3N0PTAuMDAuLjAuMDAgcm93cz0wIHdpZHRoPTApDQogICAg ICAgICBPbmUtVGltZSBGaWx0ZXI6IGZhbHNlDQooMyByb3dzKQ0KDQoNCkluIHRoZSBsZWZ0IGpv aW4gc2NlbmFyaW8sIHRoZSBjb25jbHVzaW9uIG9mICdyZXN1bHQgPSBmYWxzZScgY2Fubm90IGJl Cm9idGFpbmVkLg0KQ291bGQgeW91IHBsZWFzZSBoZWxwIGFuYWx5emUgdGhpcyBpc3N1ZT8gDQoN ClRoYW5rIHlvdS4NCmRhZm9lcgoK --===============7872192871127466931==--