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 1qhboo-003dxj-Fs for pgsql-bugs@arkaria.postgresql.org; Sat, 16 Sep 2023 20:23: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 1qhbom-000nSy-Uy for pgsql-bugs@arkaria.postgresql.org; Sat, 16 Sep 2023 20:23: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 1qhUWw-00CGuR-As for pgsql-bugs@lists.postgresql.org; Sat, 16 Sep 2023 12:36:10 +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 1qhUWr-005Rzv-LN for pgsql-bugs@lists.postgresql.org; Sat, 16 Sep 2023 12:36: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=tOCq80VY1N6gEHX2Wl14wgeiegU2JmkYvfQIZaa7Z/g=; b=niAmJBdP181oo4s3FQ8Ptyvgfy Vgac71DpxNBjcWfUjHtgCZqfU0lCn/j60+gjgxeTrmC0Qu02IcVvXmwJC2VqnUdJ27Pmac26xXBWq 8KCLGgvrQQZ0FLFZirz2paou9U8FHyc1Lhe/M3+kcRZifNC91zzZGbR93iiA06MXfwJwoiEGGWfXm kTBO195kIKL4hOxFtqyNmCMLpQegKGdpWwoadM/XqFGcY193Z7iXhrRHn/eqN5ff0yMi+wpd7eldH aKCyjArPVxZJ6cJuo4H/DRChXaij57QGvxlcFrwRymm8xnlrpwHq9qknET2fh9wks5hvitjAiJ2LL G6N5u2hw==; 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 1qhUWq-0000eJ-6P for pgsql-bugs@lists.postgresql.org; Sat, 16 Sep 2023 12:36: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 1qhUWo-00GUBq-I3 for pgsql-bugs@lists.postgresql.org; Sat, 16 Sep 2023 12:36:02 +0000 Content-Type: multipart/mixed; boundary="===============3218231118280150180==" MIME-Version: 1.0 Subject: BUG #18114: FULL JOIN is replaced by LEFT JOIN in plan To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: crvv.mail@gmail.com Reply-To: crvv.mail@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sat, 16 Sep 2023 12:35:58 +0000 Message-ID: <18114-c360a22e03a2fe2b@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 --===============3218231118280150180== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODExNApMb2dnZWQgYnk6ICAgICAgICAgIGNydnYKRW1haWwgYWRkcmVz czogICAgICBjcnZ2Lm1haWxAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTYuMApPcGVy YXRpbmcgc3lzdGVtOiAgIExpbnV4CkRlc2NyaXB0aW9uOiAgICAgICAgCgpTRUxFQ1QgKiBGUk9N IChWQUxVRVMgKDEpKSBBUyB0KGlkKQ0KICAgIENST1NTIEpPSU4gdW5uZXN0KCd7MSwyfSc6Omlu dFtdKSBBUyBhKHgpDQogICAgRlVMTCBKT0lOIHVubmVzdCgnezIsM30nOjppbnRbXSkgQVMgYih4 KSBPTiBhLnggPSBiLngNCldIRVJFIHQuaWQgPSAxDQoNCkV4ZWN1dGUgdGhpcyBTUUwsIEkgZ2V0 IHRoZSByZXN1bHQgDQogaWQgfCB4IHwgeA0KLS0tLSstLS0rLS0tDQogIDEgfCAxIHwNCiAgMSB8 IDIgfCAyDQoNCk15IGV4cGVjdGlvbiBpcw0KIGlkIHwgeCB8IHgNCi0tLS0rLS0tKy0tLQ0KICAx IHwgMSB8DQogIDEgfCAyIHwgMg0KICAgIHwgICB8IDMNCg0KVGhlIHF1ZXJ5IHBsYW4gaXMNCiAg ICAgICAgICAgICAgICAgICAgICAgICAgICBRVUVSWSBQTEFODQotLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogTmVzdGVk IExvb3AgTGVmdCBKb2luICAoY29zdD0wLjAxLi4wLjA4IHJvd3M9MSB3aWR0aD0xMikNCiAgIEpv aW4gRmlsdGVyOiAoYS54ID0gYi54KQ0KICAgLT4gIEZ1bmN0aW9uIFNjYW4gb24gdW5uZXN0IGEg IChjb3N0PTAuMDAuLjAuMDMgcm93cz0xIHdpZHRoPTgpDQogICAgICAgICBGaWx0ZXI6ICgxID0g MSkNCiAgIC0+ICBGdW5jdGlvbiBTY2FuIG9uIHVubmVzdCBiICAoY29zdD0wLjAwLi4wLjAyIHJv d3M9MiB3aWR0aD00KQ0KDQpTbyBJIHRoaW5rIHRoZSBGVUxMIEpPSU4gaXMgcmVwbGFjZWQgYnkg TEVGVCBKT0lOLg0KDQpUaGUgZm9sbG93aW5nIFNRTCBzdGF0ZW1lbnRzIGJvdGggZ2l2ZSBtZSB0 aGUgZXhwZWN0ZWQgcmVzdWx0Lg0KU0VMRUNUICogRlJPTSAoVkFMVUVTICgxKSkgQVMgdChpZCkN CiAgICBDUk9TUyBKT0lOIHVubmVzdCgnezEsMn0nOjppbnRbXSkgQVMgYSh4KQ0KICAgIEZVTEwg Sk9JTiB1bm5lc3QoJ3syLDN9Jzo6aW50W10pIEFTIGIoeCkgT04gYS54ID0gYi54Ow0KDQpTRUxF Q1QgKiBGUk9NIChWQUxVRVMgKDEpKSBBUyB0KGlkKSwgdW5uZXN0KCd7MSwyfSc6OmludFtdKSBB UyBhKHgpDQogICAgRlVMTCBKT0lOIHVubmVzdCgnezIsM30nOjppbnRbXSkgQVMgYih4KSBPTiBh LnggPSBiLngNCldIRVJFIHQuaWQgPSAxOw0KDQpJIGNhbiByZXByb2R1Y2Ugb24gUG9zdGdyZVNR TCAxNi4wLCAxNS40IGFuZCAxNC45LgoK --===============3218231118280150180==--