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 1q2a4J-0008P8-7W for pgsql-committers@arkaria.postgresql.org; Fri, 26 May 2023 16:13:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q2a4I-0006T4-2M for pgsql-committers@arkaria.postgresql.org; Fri, 26 May 2023 16:13:30 +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 1q2a4H-0006So-RZ for pgsql-committers@lists.postgresql.org; Fri, 26 May 2023 16:13:29 +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 1q2a4F-0021Vz-8J for pgsql-committers@lists.postgresql.org; Fri, 26 May 2023 16:13:28 +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 1q2a4E-0003qP-NQ for pgsql-committers@lists.postgresql.org; Fri, 26 May 2023 16:13:26 +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 1q2a4E-001qcA-2E for pgsql-committers@lists.postgresql.org; Fri, 26 May 2023 16:13:25 +0000 Content-Type: multipart/mixed; boundary="===============7214192571552894136==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix joinclause removal logic to cope with cloned clauses. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 26 May 2023 16:13:25 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7214192571552894136== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IGpvaW5jbGF1c2UgcmVtb3ZhbCBsb2dpYyB0byBjb3BlIHdpdGggY2xvbmVkIGNsYXVzZXMu CgpXaGVuIHdlJ3JlIGRlbGV0aW5nIGEgbm8tb3AgTEVGVCBKT0lOIGZyb20gdGhlIHF1ZXJ5LCB3 ZSBtdXN0IHJlbW92ZQp0aGUgam9pbidzIGpvaW5jbGF1c2VzIGZyb20gc3Vydml2aW5nIHJlbGF0 aW9ucycgam9pbmluZm8gbGlzdHMuClRoZSBpbnZlbnRpb24gb2YgImNsb25lZCIgY2xhdXNlcyBp biAyNDg5ZDc2YzQgYnJva2UgdGhlIGxvZ2ljIGZvcgp0aGF0OyBpdCdkIGZhaWwgdG8gcmVtb3Zl IGNsb25lcyB0aGF0IGluY2x1ZGUgT0ogcmVsaWRzIG91dHNpZGUgdGhlCmRvb21lZCBqb2luJ3Mg bWluIHJlbGlkIHNldHMsIHdoaWNoIGNvdWxkIGhhcHBlbiBpZiB0aGF0IGpvaW4gd2FzCnByZXZp b3VzbHkgZGlzY292ZXJlZCB0byBjb21tdXRlIHdpdGggc29tZSBvdGhlciBqb2luLgoKVGhpcyBh Y2NpZGVudGFsbHkgZmFpbGVkIHRvIGNhdXNlIHByb2JsZW1zIGluIHRoZSBtYWpvcml0eSBvZiBj YXNlcywKYmVjYXVzZSB3ZSdkIG5ldmVyIGRlY2lkZSB0aGF0IHN1Y2ggYSBjbG9uZWQgY2xhdXNl IHdhcyBldmFsdWF0YWJsZSBhdAphbnkgc3Vydml2aW5nIGpvaW4uICBIb3dldmVyLCBSaWNoYXJk IEd1byBkaXNjb3ZlcmVkIGEgY2FzZSB3aGVyZSB0aGF0CmRpZCBoYXBwZW4sIGxlYWRpbmcgdG8g Im5vIHJlbGF0aW9uIGVudHJ5IGZvciByZWxpZCIgZXJyb3JzIGxhdGVyLgpBbHNvLCBhZGRpbmcg YXNzZXJ0aW9ucyB0aGF0IGEgbm9uLXJlbW92ZWQgY2xhdXNlIGNvbnRhaW5zIG5vIFZhcnMgZnJv bQp0aGUgZG9vbWVkIGpvaW4gZXhwb3NlcyB0aGF0IHRoZXJlIGFyZSBxdWl0ZSBhIGZldyBleGlz dGluZyByZWdyZXNzaW9uCnRlc3QgY2FzZXMgd2hlcmUgdGhlIHByb2JsZW0gaGFwcGVucyBidXQg aXMgYWNjaWRlbnRhbGx5IG5vdCBleHBvc2VkLgoKVGhlIGZpeCBmb3IgdGhpcyBpcyBqdXN0IHRv IGluY2x1ZGUgdGhlIHRhcmdldCBqb2luJ3MgY29tbXV0ZV9hYm92ZV9yCmFuZCBjb21tdXRlX2Jl bG93X2wgc2V0cyBpbiB0aGUgcmVsaWQgc2V0IHdlIHRlc3QgYWdhaW5zdCB3aGVuCmRlY2lkaW5n IHdoZXRoZXIgYSBqb2luIGNsYXVzZSBpcyAicHVzaGVkIGRvd24iIGFuZCB0aHVzIG5vdApyZW1v dmFibGUuCgpXaGlsZSBhdCBpdCwgZG8gYSBsaXR0bGUgcmVmYWN0b3Jpbmc6IHRoZSBqb2luJ3Mg cmVsaWQgc2V0IGNhbiBiZQpjb21wdXRlZCBpbnNpZGUgcmVtb3ZlX3JlbF9mcm9tX3F1ZXJ5IHJh dGhlciB0aGFuIGluIHRoZSBjYWxsZXIuCgpQYXRjaCBieSBtZTsgdGhhbmtzIHRvIFJpY2hhcmQg R3VvIGZvciByZXZpZXcuCgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL0NBTWJXczRf UEhyUnFUS0ROblRSc3h4UXk2QnRZQ1ZLc2dYbTFfZ2ROMnlRPWttY081Z0BtYWlsLmdtYWlsLmNv bQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0 Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzdhODQ0Yzc3ZWNlMWJkYTNiMDc2MDM0YmMyMDE0MmQ0 YmQ2NmRiN2EKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL29wdGlt aXplci9wbGFuL2FuYWx5emVqb2lucy5jIHwgOTEgKysrKysrKysrKysrKysrKysrKystLS0tLS0t LS0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2pvaW4ub3V0ICAgICAgICB8IDE2ICsrKysr KwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9qb2luLnNxbCAgICAgICAgICAgICB8ICA2ICsrCjMgZmls ZXMgY2hhbmdlZCwgODIgaW5zZXJ0aW9ucygrKSwgMzEgZGVsZXRpb25zKC0pCgo= --===============7214192571552894136==--