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 1urgl4-00AiSP-JJ for pgsql-committers@arkaria.postgresql.org; Thu, 28 Aug 2025 17:49:59 +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 1urgl2-004EgF-PM for pgsql-committers@arkaria.postgresql.org; Thu, 28 Aug 2025 17:49: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-004Eg3-IM 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-002EB4-0N 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-0067A5-BC 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-0026lY-0s for pgsql-committers@lists.postgresql.org; Thu, 28 Aug 2025 17:49:53 +0000 Content-Type: multipart/mixed; boundary="===============5740708037919201817==" 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 --===============5740708037919201817== 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 cnUKQmFja3BhdGNoLXRocm91Z2g6IDE4CgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwot LS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvYjhhMWJkYzQ1 OGUzZTgxODk4YTFmZTNkMjYxODhiYzFkY2JhYzk2NQoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0t LS0tLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BsYW4vcGxhbm5lci5jICAgICB8IDgwICsrKysr KysrKysrKysrKysrKysrKysrKysrLS0tLS0tCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvYWdn cmVnYXRlcy5vdXQgfCAyMCAtLS0tLS0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2pvaW4u b3V0ICAgICAgIHwgODAgKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKysKc3JjL3Rlc3Qv cmVncmVzcy9zcWwvYWdncmVnYXRlcy5zcWwgICAgICB8ICA5IC0tLS0Kc3JjL3Rlc3QvcmVncmVz cy9zcWwvam9pbi5zcWwgICAgICAgICAgICB8IDMzICsrKysrKysrKysrKysKNSBmaWxlcyBjaGFu Z2VkLCAxNzkgaW5zZXJ0aW9ucygrKSwgNDMgZGVsZXRpb25zKC0pCgo= --===============5740708037919201817==--