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 1pP8N6-0006bT-OC for pgsql-committers@arkaria.postgresql.org; Mon, 06 Feb 2023 20:45:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pP8N4-0004ah-6o for pgsql-committers@arkaria.postgresql.org; Mon, 06 Feb 2023 20:45:50 +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 1pP8N3-0004aX-Vs for pgsql-committers@lists.postgresql.org; Mon, 06 Feb 2023 20:45:49 +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 1pP8Mw-0005Pf-TC for pgsql-committers@lists.postgresql.org; Mon, 06 Feb 2023 20:45:49 +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 1pP8Mu-0001Bp-PK for pgsql-committers@lists.postgresql.org; Mon, 06 Feb 2023 20:45:40 +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 1pP8Ms-001voE-9Q for pgsql-committers@lists.postgresql.org; Mon, 06 Feb 2023 20:45:39 +0000 Content-Type: multipart/mixed; boundary="===============0294702960879707874==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix up join removal's interaction with PlaceHolderVars. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 06 Feb 2023 20:45:39 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0294702960879707874== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHVwIGpvaW4gcmVtb3ZhbCdzIGludGVyYWN0aW9uIHdpdGggUGxhY2VIb2xkZXJWYXJzLgoK VGhlIHBvcnRpb24gb2Ygam9pbl9pc19yZW1vdmFibGUoKSB0aGF0IGNoZWNrcyBQbGFjZUhvbGRl clZhcnMKY2FuIGJlIG1hZGUgYSBsaXR0bGUgbW9yZSBhY2N1cmF0ZSBhbmQgaW50ZWxsaWdpYmxl IHRoYW4gaXQgd2FzLgpUaGUga2V5IHBvaW50IGlzIHRoYXQgd2UgY2FuIGFsbG93IGpvaW4gcmVt b3ZhbCBldmVuIGlmIGEgUEhWCm1lbnRpb25zIHRoZSB0YXJnZXQgcmVsIGluIHBoX2V2YWxfYXQs IGlmIHRoYXQgbWVudGlvbiB3YXMgb25seQphZGRlZCBhcyBhIGNvbnNlcXVlbmNlIG9mIGZvcmNp bmcgdGhlIFBIViB1cCB0byBhIGpvaW4gbGV2ZWwKdGhhdCdzIGF0L2Fib3ZlIHRoZSBvdXRlciBq b2luIHdlJ3JlIHRyeWluZyB0byBnZXQgcmlkIG9mLgpXZSBjYW4gY2hlY2sgdGhhdCBieSB0ZXN0 aW5nIGZvciB0aGUgT0oncyByZWxpZCBhcHBlYXJpbmcgaW4KcGhfZXZhbF9hdCwgaW5kaWNhdGlu ZyB0aGF0IGl0J3Mgc3VwcG9zZWQgdG8gYmUgZXZhbHVhdGVkIGFmdGVyCnRoZSBvdXRlciBqb2lu LCBwbHVzIHRoZSBleGlzdGluZyB0ZXN0IHRoYXQgdGhlIGNvbnRhaW5lZApleHByZXNzaW9uIGRv ZXNuJ3QgYWN0dWFsbHkgbWVudGlvbiB0aGUgdGFyZ2V0IHJlbC4KCldoaWxlIGhlcmUsIGFkZCBh biBleHBsaWNpdCBjaGVjayB0aGF0IHRoZXJlJ2xsIGJlIHNvbWV0aGluZyBsZWZ0CmluIHBoX2V2 YWxfYXQgYWZ0ZXIgd2UgcmVtb3ZlIHRoZSB0YXJnZXQgcmVsIGFuZCBPSiByZWxpZC4gIFRoZXJl CmlzIGFuIEFzc2VydCBsYXRlciBvbiBhYm91dCB0aGF0LCBhbmQgSSdtIG5vdCB0b28gc3VyZSB0 aGF0IHRoZQpjYXNlIGNvdWxkIGhhcHBlbiBmb3IgYSBQSFYgc2F0aXNmeWluZyB0aGUgb3RoZXIg Y29uc3RyYWludHMsCmJ1dCBsZXQncyBqdXN0IGNoZWNrLiAgKFRoZXJlIHdhcyBwcmV2aW91c2x5 IGEgYm1zX2lzX3N1YnNldCB0ZXN0CnRoYXQgbWVhbnQgdG8gY292ZXIgdGhpcyByaXNrLCBidXQg aXQncyBicm9rZW4gbm93IGJlY2F1c2UgaXQKZG9lc24ndCBhY2NvdW50IGZvciB0aGUgZmFjdCB0 aGF0IHdlJ2xsIGFsc28gcmVtb3ZlIHRoZSBPSiByZWxpZC4pCgpUaGUgcmVhbCByZWFzb24gZm9y IHJldmlzaXRpbmcgdGhpcyBjb2RlIHRob3VnaCBpcyB0aGF0IHRoZQpBc3NlcnQgSSBsZWZ0IGJl aGluZCBpbiA4NTM4NTE5ZGIgdHVybnMgb3V0IHRvIGJlIGVhc2lseQpyZWFjaGFibGUsIGJlY2F1 c2UgaWYgYSBQSFYgb2YgdGhpcyBzb3J0IGFwcGVhcnMgaW4gYW4gdXBwZXItbGV2ZWwKcXVhbCBj bGF1c2UgdGhlbiB0aGF0IGNsYXVzZSdzIGNsYXVzZV9yZWxpZHMgd2lsbCBpbmNsdWRlIHRoZQpQ SFYncyBwaF9ldmFsX2F0IHJlbGlkcy4gIFRoaXMgaXMgYSBtaXJhZ2UgdGhvdWdoOiB3ZSBoYXZl IG9yIHNvb24Kd2lsbCByZW1vdmUgdGhlc2UgcmVsaWRzIGZyb20gdGhlIFBIVidzIHBoX2V2YWxf YXQsIGFuZCB0aGVyZWZvcmUKdGhleSBubyBsb25nZXIgYmVsb25nIGluIHF1YWwgY2xhdXNlcycg Y2xhdXNlX3JlbGlkcyBlaXRoZXIuClJlbW92ZSB0aGF0IEFzc2VydCBpbiBqb2luX2lzX3JlbW92 YWJsZSwgYW5kIHJlcGxhY2UgdGhlIHNpbWlsYXIKb25lIGluIHJlbW92ZV9yZWxfZnJvbV9xdWVy eSB3aXRoIGNvZGUgdG8gcmVtb3ZlIHRoZSBkZWxldGVkIHJlbGlkcwpmcm9tIGNsYXVzZV9yZWxp ZHMuCgpQZXIgYnVnICMxNzc3MyBmcm9tIFJvYmlucyBUaGFyYWthbi4KCkRpc2N1c3Npb246IGh0 dHBzOi8vcG9zdGdyLmVzL20vMTc3NzMtYTU5MmU2Y2VkYmM3YmFjNUBwb3N0Z3Jlc3FsLm9yZwoK QnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jl c3FsLm9yZy9wZy9jb21taXRkaWZmL2NhZDU2OTIwNTEzZTViN2NjZGQzZDQxYjBlYTg5M2ViMzM4 M2Y4NjMKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL29wdGltaXpl ci9wbGFuL2FuYWx5emVqb2lucy5jIHwgNTIgKysrKysrKysrKysrKysrKysrLS0tLS0tLS0tLS0t LQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2pvaW4ub3V0ICAgICAgICB8IDIwICsrKysrKysr KysrKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9qb2luLnNxbCAgICAgICAgICAgICB8ICA4ICsrKysr CjMgZmlsZXMgY2hhbmdlZCwgNTggaW5zZXJ0aW9ucygrKSwgMjIgZGVsZXRpb25zKC0pCgo= --===============0294702960879707874==--