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 1q2BxQ-0002g3-0h for pgsql-committers@arkaria.postgresql.org; Thu, 25 May 2023 14:28:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q2BxO-0005VX-KL for pgsql-committers@arkaria.postgresql.org; Thu, 25 May 2023 14:28:46 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q2BxO-0005VO-Dc for pgsql-committers@lists.postgresql.org; Thu, 25 May 2023 14:28:46 +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.94.2) (envelope-from ) id 1q2BxL-001plb-Cc for pgsql-committers@lists.postgresql.org; Thu, 25 May 2023 14:28:45 +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 1q2BxL-0000AE-13 for pgsql-committers@lists.postgresql.org; Thu, 25 May 2023 14:28:43 +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 1q2BxK-001fs0-Np for pgsql-committers@lists.postgresql.org; Thu, 25 May 2023 14:28:42 +0000 Content-Type: multipart/mixed; boundary="===============2055467919616159058==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix filtering of "cloned" outer-join quals some more. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 25 May 2023 14:28:42 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2055467919616159058== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IGZpbHRlcmluZyBvZiAiY2xvbmVkIiBvdXRlci1qb2luIHF1YWxzIHNvbWUgbW9yZS4KCldl J3ZlIGhhZCBtdWx0aXBsZSBpc3N1ZXMgd2l0aCB0aGUgY2xhdXNlX2lzX2NvbXB1dGFibGVfYXQg bG9naWMgdGhhdApJIGludHJvZHVjZWQgaW4gMjQ4OWQ3NmM0OiBpdCdzIGJlZW4ga25vd24gdG8g YWNjZXB0IG1vcmUgdGhhbiBvbmUKY2xvbmUgb2YgdGhlIHNhbWUgcXVhbCBhdCB0aGUgc2FtZSBw bGFuIG5vZGUsIGFuZCBhbHNvIHRvIGFjY2VwdCBubwpjbG9uZXMgYXQgYWxsLiAgSXQncyBsb29r aW5nIGltcHJhY3RpY2FsIHRvIGdldCBpdCAxMDAlIHJpZ2h0IG9uIHRoZQpiYXNpcyBvZiB0aGUg Y3VycmVudGx5LXN0b3JlZCBpbmZvcm1hdGlvbiwgc28gZml4IGl0IGJ5IGludHJvZHVjaW5nIGEK bmV3IFJlc3RyaWN0SW5mbyBmaWVsZCAiaW5jb21wYXRpYmxlX3JlbGlkcyIgdGhhdCBleHBsaWNp dGx5IHNob3dzCndoaWNoIG91dGVyIGpvaW5zIGEgZ2l2ZW4gY2xvbmUgbXVzdG4ndCBiZSBwdXNo ZWQgYWJvdmUuCgpJbiBwcmluY2lwbGUgd2UgY291bGQgcG9wdWxhdGUgdGhpcyBmaWVsZCBpbiBl dmVyeSBSZXN0cmljdEluZm8sIGJ1dAp0aGF0IHdvdWxkIGNvc3Qgc3BhY2UgYW5kIHRoZXJlIGRv ZXNuJ3QgcHJlc2VudGx5IHNlZW0gdG8gYmUgYSBuZWVkCmZvciBpdCBpbiBnZW5lcmFsLiAgQWxz bywgd2hpbGUgZGVjb25zdHJ1Y3RfZGlzdHJpYnV0ZV9val9xdWFscyBjYW4KZWFzaWx5IGZpbGwg dGhlIGZpZWxkIHdpdGggdGhlIHJlbWFpbmluZyBtZW1iZXJzIG9mIHRoZSBjb21tdXRhdGl2ZQpq b2luIHNldCB0aGF0IGl0J3MgY29uc2lkZXJpbmcsIGNvbXB1dGluZyBpdCBpbiB0aGUgZ2VuZXJh bCBjYXNlCnNlZW1zIGFnYWluIHByZXR0eSBjb21wbGljYXRlZC4gIFNvIGZvciBub3csIGp1c3Qg ZmlsbCBpdCBmb3IKY2xvbmUgcXVhbHMuCgpBbG9uZyB0aGUgd2F5LCBmaXggYSBidWcgdGhhdCBt YXkgb3IgbWF5IG5vdCBiZSBvbmx5IGxhdGVudDoKZXF1aXZjbGFzcy5jIHdhcyBnZW5lcmF0aW5n IHJlcGxhY2VtZW50IGNsYXVzZXMgd2l0aCBpc19wdXNoZWRfZG93bgphbmQgaGFzX2Nsb25lL2lz X2Nsb25lIG1hcmtpbmdzIHRoYXQgZGlkbid0IG1hdGNoIHRoZWlyCnJlcXVpcmVkX3JlbGlkcy4g IFRoaXMgbGVkIG1lIHRvIGNvbmNsdWRlIHRoYXQgbGVhdmluZyB0aGUgY2xvbmUgZmxhZ3MKb3V0 IG9mIG1ha2VfcmVzdHJpY3RpbmZvJ3MgcHVydmlldyB3YXNuJ3Qgc3VjaCBhIGdyZWF0IGlkZWEg YWZ0ZXIgYWxsLApzbyBhZGQgdGhlbS4KClBlciByZXBvcnQgZnJvbSBSaWNoYXJkIEd1by4KCkRp c2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vQ0FNYldzNDhFWWlfOS1wU2QwT1JlczFrVG1U ZUFqVDRRM2d1NDloSnRZQ2JTbjJKeWVBQG1haWwuZ21haWwuY29tCgpCcmFuY2gKLS0tLS0tCm1h c3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1p dGRpZmYvOTkxYTNkZjIyN2U5ZThiMTZkNzM5OWRmMzk2MWRmYWFlNGFlNjc3YwoKTW9kaWZpZWQg RmlsZXMKLS0tLS0tLS0tLS0tLS0KY29udHJpYi9wb3N0Z3Jlc19mZHcvcG9zdGdyZXNfZmR3LmMg ICAgICAgfCAgIDMgKwpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvUkVBRE1FICAgICAgICAgICAgICB8 ICAxNSArKy0tCnNyYy9iYWNrZW5kL29wdGltaXplci9wYXRoL2VxdWl2Y2xhc3MuYyAgIHwgIDIx ICsrKysrLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGxhbi9pbml0c3BsYW4uYyAgICB8ICA1NSAr KysrKysrKysrKystLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvdXRpbC9pbmhlcml0LmMgICAgICB8 ICAxMCArKy0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3V0aWwvb3JjbGF1c2VzLmMgICAgfCAgIDMg KwpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvdXRpbC9yZWxub2RlLmMgICAgICB8ICAyMiArKy0tLS0K c3JjL2JhY2tlbmQvb3B0aW1pemVyL3V0aWwvcmVzdHJpY3RpbmZvLmMgfCAxMTkgKysrKysrKysr KystLS0tLS0tLS0tLS0tLS0tLS0tCnNyYy9pbmNsdWRlL25vZGVzL3BhdGhub2Rlcy5oICAgICAg ICAgICAgIHwgIDEyICsrKwpzcmMvaW5jbHVkZS9vcHRpbWl6ZXIvcmVzdHJpY3RpbmZvLmggICAg ICB8ICAgOSArKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9qb2luLm91dCAgICAgICAgfCAg MjEgKysrKysrCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2pvaW4uc3FsICAgICAgICAgICAgIHwgICA2 ICsrCjEyIGZpbGVzIGNoYW5nZWQsIDE3OCBpbnNlcnRpb25zKCspLCAxMTggZGVsZXRpb25zKC0p Cgo= --===============2055467919616159058==--