Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pVE6m-0001g3-Dr for pgsql-committers@arkaria.postgresql.org; Thu, 23 Feb 2023 16:06:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pVE6l-0002nT-BB for pgsql-committers@arkaria.postgresql.org; Thu, 23 Feb 2023 16:06:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pVE6l-0002mN-44 for pgsql-committers@lists.postgresql.org; Thu, 23 Feb 2023 16:06:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pVE6h-0002zH-18 for pgsql-committers@lists.postgresql.org; Thu, 23 Feb 2023 16:06:10 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pVE6f-0000SC-DE for pgsql-committers@lists.postgresql.org; Thu, 23 Feb 2023 16:06:05 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pVE6d-000KA3-VS for pgsql-committers@lists.postgresql.org; Thu, 23 Feb 2023 16:06:04 +0000 Content-Type: multipart/mixed; boundary="===============2220336706924725110==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix mis-handling of outer join quals generated by EquivalenceCla X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 23 Feb 2023 16:06:04 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2220336706924725110== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IG1pcy1oYW5kbGluZyBvZiBvdXRlciBqb2luIHF1YWxzIGdlbmVyYXRlZCBieSBFcXVpdmFs ZW5jZUNsYXNzZXMuCgpJdCdzIHBvc3NpYmxlLCBpbiBhZG1pdHRlZGx5LXJhdGhlci1jb250cml2 ZWQgY2FzZXMsIGZvciBhbiBlY2xhc3MKdG8gZ2VuZXJhdGUgYSBkZXJpdmVkICJqb2luIiBxdWFs IHRoYXQgY29uc3RyYWlucyB0aGUgcG9zdC1vdXRlci1qb2luCnZhbHVlKHMpIG9mIHNvbWUgUkhT IHZhcmlhYmxlKHMpIHdpdGhvdXQgbWVudGlvbmluZyB0aGUgTEhTIGF0IGFsbC4KV2hpbGUgdGhl IG1lY2hhbmlzbXMgd2VyZSBzZXQgdXAgdG8gd29yayBmb3IgdGhpcywgd2UgZmVsbCBmb3VsIG9m CnRoZSAiZ2V0X2NvbW1vbl9lY2xhc3NfaW5kZXhlcyIgZmlsdGVyIGluc3RhbGxlZCBieSBjb21t aXQgMzM3M2M3MTU1OgppdCBjb3VsZCBkZWNpZGUgdGhhdCBzdWNoIGFuIGVjbGFzcyB3YXNuJ3Qg cmVsZXZhbnQgdG8gdGhlIGpvaW4sIHNvCnRoYXQgdGhlIHJlcXVpcmVkIHF1YWwgY2xhdXNlIHdv dWxkbid0IGdldCBlbWl0dGVkIHRoZXJlIG9yIGFueXdoZXJlCmVsc2UuCgpUbyBmaXgsIGFwcGx5 IGdldF9jb21tb25fZWNsYXNzX2luZGV4ZXMgb25seSBhdCBpbm5lciBqb2lucywgd2hlcmUKaXRz IHJ1bGUgaXMgc3RpbGwgdmFsaWQuICBBdCBhbiBvdXRlciBqb2luLCBmYWxsIGJhY2sgdG8gZXhh bWluaW5nIGFsbAplY2xhc3NlcyB0aGF0IG1lbnRpb24gZWl0aGVyIGlucHV0IChvciB0aGUgT0og cmVsaWQsIHRob3VnaCBpdCBzaG91bGQKYmUgaW1wb3NzaWJsZSBmb3IgYW4gZWNsYXNzIHRvIG1l bnRpb24gdGhhdCB3aXRob3V0IG1lbnRpb25pbmcgZWl0aGVyCmlucHV0KS4gIFBlcmhhcHMgd2Ug Y2FuIGltcHJvdmUgb24gdGhhdCBsYXRlciwgYnV0IHRoZSBjb3N0L2JlbmVmaXQgb2YKYWRkaW5n IG1vcmUgY29tcGxleGl0eSB0byBza2lwIHNvbWUgaXJyZWxldmFudCBlY2xhc3NlcyBpcyBkdWJp b3VzLgoKVG8gYWxsb3cgY2hlYXBseSBkaXN0aW5ndWlzaGluZyBvdXRlciBmcm9tIGlubmVyIGpv aW5zLCBwYXNzIHRoZQpvanJlbGlkIHRvIGdlbmVyYXRlX2pvaW5faW1wbGllZF9lcXVhbGl0aWVz IGFzIGEgc2VwYXJhdGUgYXJndW1lbnQuClRoaXMgYWxzbyBhbGxvd3MgY2xlYW5pbmcgdXAgc29t ZSBzbG9wcGluZXNzIHRoYXQgaGFkIGNyZXB0IGludG8KdGhlIGRlZmluaXRpb24gb2YgaXRzIGpv aW5fcmVsaWRzIGFyZ3VtZW50LCBhbmQgaXQgYWxsb3dzIGFjY3VyYXRlCmNhbGN1bGF0aW9uIG9m IG5vbWluYWxfam9pbl9yZWxpZHMgZm9yIGEgY2hpbGQgb3V0ZXIgam9pbi4gIChUaGUKbGF0dGVy IG92ZXJzaWdodCBzZWVtcyBub3QgdG8gaGF2ZSBiZWVuIGEgbGl2ZSBidWcsIGJ1dCBpdCBjZXJ0 YWlubHkKY291bGQgaGF2ZSBjYXVzZWQgcHJvYmxlbXMgaW4gZnV0dXJlLikKCkFsc28gZml4IHdo YXQgbWlnaHQgYmUgYSBsaXZlIGJ1ZyBpbiBjaGVja19pbmRleF9wcmVkaWNhdGVzOiBpdCB3YXMK YmVpbmcgc2xvcHB5IGFib3V0IHdoYXQgaXQgcGFzc2VkIHRvIGdlbmVyYXRlX2pvaW5faW1wbGll ZF9lcXVhbGl0aWVzLgoKUGVyIHJlcG9ydCBmcm9tIFJpY2hhcmQgR3VvLgoKRGlzY3Vzc2lvbjog aHR0cHM6Ly9wb3N0Z3IuZXMvbS9DQU1iV3M0LURzVEJmT3ZYdXc2NEdkRnNzMj1NNWN3dEVoWT0w RENTN3QyZ1Q3UDZoU0FAbWFpbC5nbWFpbC5jb20KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRh aWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi83Mzlm MWQ2MjE4ZjVjZTFlMDI0MzEyN2FiMjNmNDMxYTdkMDc5NzdjCgpNb2RpZmllZCBGaWxlcwotLS0t LS0tLS0tLS0tLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGF0aC9lcXVpdmNsYXNzLmMgICB8IDUw ICsrKysrKysrKysrKysrKysrKysrKysrKysrLS0tLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3Bh dGgvaW5keHBhdGguYyAgICAgfCAgNiArKystCnNyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL2Fu YWx5emVqb2lucy5jIHwgIDMgKy0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3V0aWwvcmVsbm9kZS5j ICAgICAgfCAyMiArKysrKysrKystLS0tLQpzcmMvaW5jbHVkZS9vcHRpbWl6ZXIvcGF0aHMuaCAg ICAgICAgICAgICB8ICAzICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvam9pbi5vdXQgICAg ICAgIHwgMzIgKysrKysrKysrKysrKysrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwvam9pbi5z cWwgICAgICAgICAgICAgfCAgOSArKysrKysKNyBmaWxlcyBjaGFuZ2VkLCAxMDcgaW5zZXJ0aW9u cygrKSwgMTggZGVsZXRpb25zKC0pCgo= --===============2220336706924725110==--