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 1urgnw-00AjA2-UU for pgsql-committers@arkaria.postgresql.org; Thu, 28 Aug 2025 17:52:58 +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 1urgnw-004Fk6-D1 for pgsql-committers@arkaria.postgresql.org; Thu, 28 Aug 2025 17:52:57 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1urgl2-004Eg2-Lo for pgsql-committers@lists.postgresql.org; Thu, 28 Aug 2025 17:49:57 +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.96) (envelope-from ) id 1urgl0-002EB3-0Q for pgsql-committers@lists.postgresql.org; Thu, 28 Aug 2025 17:49:56 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1urgl0-0067A6-6g for pgsql-committers@lists.postgresql.org; Thu, 28 Aug 2025 17:49:54 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1urgkz-0026la-10 for pgsql-committers@lists.postgresql.org; Thu, 28 Aug 2025 17:49:53 +0000 Content-Type: multipart/mixed; boundary="===============8481713667077746388==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix "variable not found in subplan target lists" in semijoin de- X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 28 Aug 2025 17:49:53 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8481713667077746388== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4ICJ2YXJpYWJsZSBub3QgZm91bmQgaW4gc3VicGxhbiB0YXJnZXQgbGlzdHMiIGluIHNlbWlq b2luIGRlLWR1cGxpY2F0aW9uLgoKT25lIG1lY2hhbmlzbSB3ZSBoYXZlIGZvciBpbXBsZW1lbnRp bmcgc2VtaS1qb2lucyBpcyB0byBkZS1kdXBsaWNhdGUKdGhlIG91dHB1dCBvZiB0aGUgUkhTIGFu ZCB0aGVuIHRyZWF0IHRoZSBqb2luIGFzIGEgcGxhaW4gaW5uZXIgam9pbi4KSW5pdGlhbCBjb25z dHJ1Y3Rpb24gb2YgdGhlIGpvaW4ncyBTcGVjaWFsSm9pbkluZm8gaWRlbnRpZmllcyB0aGUKUkhT IGNvbHVtbnMgdGhhdCBuZWVkIHRvIGJlIGRlLWR1cGxpY2F0ZWQsIGJ1dCBsYXRlciB3ZSBtYXkg ZmluZCB0aGF0CnNvbWUgb2YgdGhvc2UgZG9uJ3QgbmVlZCB0byBiZSBoYW5kbGVkIGV4cGxpY2l0 bHksIGVpdGhlciBiZWNhdXNlCnRoZXkncmUga25vd24gdG8gYmUgY29uc3RhbnQgb3IgYmVjYXVz ZSB0aGV5IGFyZSByZWR1bmRhbnQgd2l0aCBzb21lCnByZXZpb3VzIGNvbHVtbi4KClVwIHRvIG5v dywgd2hpbGUgc29ydC1iYXNlZCBkZS1kdXBsaWNhdGlvbiBoYW5kbGVkIHN1Y2ggY2FzZXMgd2Vs bCwKaGFzaC1iYXNlZCBkZS1kdXBsaWNhdGlvbiBkaWRuJ3Q6IHdlJ2Qgc3RpbGwgaGFzaCBvbiBh bGwgb2YgdGhlCm9yaWdpbmFsbHktaWRlbnRpZmllZCBjb2x1bW5zLiAgVGhpcyBpcyBwcm9iYWJs eSBub3QgYSB2ZXJ5IGJpZwpkZWFsIHBlcmZvcm1hbmNlLXdpc2UsIGJ1dCBpbiB0aGUgd2FrZSBv ZiBjb21taXQgYTMxNzlhYjY5IGl0IGNhbgpjYXVzZSBwbGFubmVyIGVycm9ycy4gIFRoYXQgaGFw cGVucyB3aGVuIGpvaW4gZWxpbWluYXRpb24gY2F1c2VzCnJlY2FsY3VsYXRpb24gb2YgdmFyaWFi bGVzJyBhdHRyX25lZWRlZCBiaXRtYXBzZXRzLCBhbmQgd2UgZGVjaWRlCnRoYXQgYSB2YXJpYWJs ZSBtZW50aW9uZWQgaW4gYSBzZW1pam9pbiBjbGF1c2UgZG9lc24ndCBuZWVkIHRvIGJlCnByb3Bh Z2F0ZWQgdXAgdG8gdGhlIGpvaW4gbGV2ZWwgYW55bW9yZS4KClRoZXJlIGFyZSBhIG51bWJlciBv ZiB3YXlzIHdlIGNvdWxkIHNsaWNlIHRoZSBibGFtZSBmb3IgdGhpcywgYnV0IHRoZQpvbmx5IGZp eCB0aGF0IGRvZXNuJ3QgcmVzdWx0IGluIHBlc3NpbWl6aW5nIHBsYW5zIGZvciBsb29zZWx5LXJl bGF0ZWQKY2FzZXMgaXMgdG8gYmUgbW9yZSBjYXJlZnVsIGFib3V0IG5vdCBoYXNoaW5nIGNvbHVt bnMgd2UgZG9uJ3QKYWN0dWFsbHkgbmVlZCB0byBkZS1kdXBsaWNhdGUuICBXZSBjYW4gaW5zdGFs bCB0aGF0IGNvbnNpZGVyYXRpb24KaW50byBjcmVhdGVfdW5pcXVlX3BhdGhzIGluIG1hc3Rlciwg b3IgdGhlIHByZWRlY2Vzc29yIGNvZGUgaW4KY3JlYXRlX3VuaXF1ZV9wYXRoIGluIHYxOCwgd2l0 aG91dCBtdWNoIHJlZmFjdG9yaW5nLgoKKEFzIGZvbGxvdy11cCB3b3JrLCBpdCBtaWdodCBiZSBh IGdvb2QgaWRlYSB0byBsb29rIGF0IG1vcmUtaW52YXNpdmUKcmVmYWN0b3JpbmcsIGluIGhvcGVz IG9mIHByZXZlbnRpbmcgb3RoZXIgYnVncyBpbiB0aGlzIGFyZWEuICBCdXQKd2l0aCB2MTggcmVs ZWFzZSBzbyBjbG9zZSwgdGhlcmUncyBub3QgdGltZSBmb3IgdGhhdCBub3csIG5vciB3b3VsZAp3 ZSBiZSBsaWtlbHkgdG8gd2FudCB0byBwdXQgc3VjaCByZWZhY3RvcmluZyBpbnRvIHYxOCBhbnl3 YXkuKQoKUmVwb3J0ZWQtYnk6IFNlcmdleSBTb2xvdmlldiA8c2VyZ2V5LnNvbG92aWV2QHRhbnRv cmxhYnMucnU+CkRpYWdub3NlZC1ieTogUmljaGFyZCBHdW8gPGd1b2ZlbmdsaW51eEBnbWFpbC5j b20+CkF1dGhvcjogVG9tIExhbmUgPHRnbEBzc3MucGdoLnBhLnVzPgpSZXZpZXdlZC1ieTogUmlj aGFyZCBHdW8gPGd1b2ZlbmdsaW51eEBnbWFpbC5jb20+CkRpc2N1c3Npb246IGh0dHBzOi8vcG9z dGdyLmVzL20vMWZkMWE0MjEtNDYwOS00ZDQ2LWExYWYtYWI3NGQ1ZGU1MDRhQHRhbnRvcmxhYnMu cnUKQmFja3BhdGNoLXRocm91Z2g6IDE4CgpCcmFuY2gKLS0tLS0tClJFTF8xOF9TVEFCTEUKCkRl dGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzNh ZWU2MjgzNzA5ZjZhN2Q4MjZiM2ZiNTc3M2NjNDQ5Njc4OGE1ZGYKCk1vZGlmaWVkIEZpbGVzCi0t LS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL29wdGltaXplci91dGlsL3BhdGhub2RlLmMgICAgfCAx NTUgKysrKysrKysrKysrKysrKysrKysrKysrKysrKy0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVj dGVkL2FnZ3JlZ2F0ZXMub3V0IHwgIDIwIC0tLS0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9q b2luLm91dCAgICAgICB8ICA4MCArKysrKysrKysrKysrKysrCnNyYy90ZXN0L3JlZ3Jlc3Mvc3Fs L2FnZ3JlZ2F0ZXMuc3FsICAgICAgfCAgIDkgLS0Kc3JjL3Rlc3QvcmVncmVzcy9zcWwvam9pbi5z cWwgICAgICAgICAgICB8ICAzMyArKysrKysrCjUgZmlsZXMgY2hhbmdlZCwgMjU0IGluc2VydGlv bnMoKyksIDQzIGRlbGV0aW9ucygtKQoK --===============8481713667077746388==--