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 1v67g2-00HBHM-5v for pgsql-committers@arkaria.postgresql.org; Tue, 07 Oct 2025 13:24:26 +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 1v67fz-00HMtG-2D for pgsql-committers@arkaria.postgresql.org; Tue, 07 Oct 2025 13:24:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v67fy-00HMt0-OE for pgsql-committers@lists.postgresql.org; Tue, 07 Oct 2025 13:24:23 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1v67fw-000rhV-30 for pgsql-committers@lists.postgresql.org; Tue, 07 Oct 2025 13:24:23 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=G1Ldy6SD7OQZzdwvhoaz7LCOLA2UpVaQEHXfeHNWsz0=; b=DdSr+FWW+84oghY1p9eZzC+lxK hRs7yEIc/NhmhCis32OJOKCML9clOmo0U48ZQaFbwmQ5Zg0ou2NSJwU+89xHZSuhAv9MEWScX6KMC 3RPsAVMsForIerOLRiYJGnIAZA1zdTas+mupydgH0SvXixQRh36wQahAfr0IYcscXQZgwvefAbALZ gkCGYsTIb9oyFlXwu/fiXMA0Klspowjtek4+gvNdMPUyqVA7PEQdOYchKnbnQzDpmHkrnFJDKwQJB BxaAxSuA2sDlylS95lZ0c+bP678WidSive6rJc+RGi0BMt2CctcQLQvLVQbfvY+cb2Zgu4AK1gcmG C0YDO9MA==; 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 1v67fv-001RBr-5U for pgsql-committers@lists.postgresql.org; Tue, 07 Oct 2025 13:24:19 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1v67fu-000Vpy-2F for pgsql-committers@lists.postgresql.org; Tue, 07 Oct 2025 13:24:18 +0000 Content-Type: multipart/mixed; boundary="===============5141696655879423941==" MIME-Version: 1.0 From: Robert Haas To: pgsql-committers@lists.postgresql.org Subject: pgsql: Assign each subquery a unique name prior to planning it. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 07 Oct 2025 13:24:18 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5141696655879423941== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QXNzaWduIGVhY2ggc3VicXVlcnkgYSB1bmlxdWUgbmFtZSBwcmlvciB0byBwbGFubmluZyBpdC4K ClByZXZpb3VzbHksIHN1YnF1ZXJpZXMgd2VyZSBnaXZlbiBuYW1lcyBvbmx5IGFmdGVyIHRoZXkg d2VyZSBwbGFubmVkLAp3aGljaCBtYWtlcyBpdCBkaWZmaWN1bHQgdG8gdXNlIGluZm9ybWF0aW9u IGZyb20gYSBwcmV2aW91cyBleGVjdXRpb24gb2YKdGhlIHF1ZXJ5IHRvIGd1aWRlIGZ1dHVyZSBw bGFubmluZy4gSWYsIGZvciBleGFtcGxlLCB5b3Uga25ldyBzb21ldGhpbmcKYWJvdXQgaG93IHlv dSB3YW50ICJJbml0UGxhbiAyIiB0byBiZSBwbGFubmVkLCB5b3Ugd29uJ3Qga25vdyB3aGV0aGVy CnRoZSBzdWJxdWVyeSB5b3UncmUgY3VycmVudGx5IHBsYW5uaW5nIHdpbGwgZW5kIHVwIGJlaW5n ICJJbml0UGxhbiAyIgp1bnRpbCBhZnRlciB5b3UndmUgZmluaXNoZWQgcGxhbm5pbmcgaXQsIGJ5 IHdoaWNoIHBvaW50IGl0J3MgdG9vIGxhdGUgdG8KdXNlIHRoZSBpbmZvcm1hdGlvbiB0aGF0IHlv dSBoYWQuCgpUbyBmaXggdGhpcywgYXNzaWduIGVhY2ggc3VicGxhbiBhIHVuaXF1ZSBuYW1lIGJl Zm9yZSB3ZSBiZWdpbiBwbGFubmluZwppdC4gVG8gaW1wcm92ZSBjb25zaXN0ZW5jeSwgdXNlIHRl eHR1YWwgbmFtZXMgZm9yIGFsbCBzdWJwbGFucywgcmF0aGVyCnRoYW4sIGFzIHdlIGRpZCBwcmV2 aW91c2x5LCBhIG1peCBvZiBudW1iZXJzIChzdWNoIGFzICJJbml0UGxhbiAxIikgYW5kCm5hbWVz IChzdWNoIGFzICJDVEUgZm9vIiksIGFuZCBtYWtlIHN1cmUgdGhhdCB0aGUgc2FtZSBuYW1lIGlz IG5ldmVyCmFzc2lnbmVkIG1vcmUgdGhhbiBvbmNlLgoKV2UgYWRvcHQgdGhlIHNvbWV3aGF0IGFy Yml0cmFyeSBjb252ZW50aW9uIG9mIHVzaW5nIHRoZSB0eXBlIG9mIHN1YmxpbmsKdG8gc2V0IHRo ZSBwbGFuIG5hbWU7IGZvciBleGFtcGxlLCBhIHF1ZXJ5IHRoYXQgcHJldmlvdXNseSBoYWQgdHdv CmV4cHJlc3Npb24gc3VibGlua3Mgc2hvd24gYXMgSW5pdFBsYW4gMiBhbmQgSW5pdFBsYW4gMSB3 aWxsIG5vdyBlbmQgdXAKbmFtZWQgZXhwcl8xIGFuZCBleHByXzIuIEJlY2F1c2UgbmFtZXMgYXJl IGFzc2lnbmVkIGJlZm9yZSByYXRoZXIgdGhhbgphZnRlciBwbGFubmluZywgc29tZSBvZiB0aGUg cmVncmVzc2lvbiB0ZXN0IG91dHB1dHMgc2hvdyB0aGUgbnVtZXJpY2FsCnBhcnQgb2YgdGhlIG5h bWUgc3dpdGNoaW5nIHBvc2l0aW9uczogd2hhdCB3YXMgcHJldmlvdXNseSBTdWJQbGFuIDIgd2Fz CmFjdHVhbGx5IHRoZSBmaXJzdCBvbmUgZW5jb3VudGVyZWQsIGJ1dCB3ZSBmaW5pc2hlZCBwbGFu bmluZyBpdCBsYXRlci4KCldlIGFzc2lnbiBuYW1lcyBldmVuIHRvIHN1YnF1ZXJpZXMgdGhhdCBh cmVuJ3Qgc2hvd24gYXMgc3VjaCB3aXRoaW4gdGhlCkVYUExBSU4gb3V0cHV0LiBUaGVzZSBpbmNs dWRlIHN1YnF1ZXJpZXMgdGhhdCBhcmUgYSBGUk9NIGNsYXVzZSBpdGVtIG9yCmEgYnJhbmNoIG9m IGEgc2V0IG9wZXJhdGlvbiwgcmF0aGVyIHRoYW4gc29tZXRoaW5nIHRoYXQgd2lsbCBiZSB0dXJu ZWQKaW50byBhbiBJbml0UGxhbiBvciBTdWJQbGFuLiBUaGUgcHVycG9zZSBvZiB0aGlzIGlzIHRv IG1ha2Ugc3VyZSB0aGF0LApiZWxvdyB0aGUgdG9wbW9zdCBxdWVyeSBsZXZlbCwgdGhlcmUncyBh bHdheXMgYSBuYW1lIGZvciBlYWNoIHN1YnF1ZXJ5CnRoYXQgaXMgc3RhYmxlIGZyb20gb25lIHBs YW5uaW5nIGN5Y2xlIHRvIHRoZSBuZXh0IChhc3N1bWluZyBubyBjaGFuZ2VzCnRvIHRoZSBxdWVy eSBvciB0aGUgZGF0YWJhc2Ugc2NoZW1hKS4KCkF1dGhvcjogUm9iZXJ0IEhhYXMgPHJoYWFzQHBv c3RncmVzcWwub3JnPgpDby1hdXRob3JlZC1ieTogVG9tIExhbmUgPHRnbEBzc3MucGdoLnBhLnVz PgpSZXZpZXdlZC1ieTogQWxleGFuZHJhIFdhbmcgPGFsZXhhbmRyYS53YW5nLm9zc0BnbWFpbC5j b20+ClJldmlld2VkLWJ5OiBSaWNoYXJkIEd1byA8Z3VvZmVuZ2xpbnV4QGdtYWlsLmNvbT4KUmV2 aWV3ZWQtYnk6IFRvbSBMYW5lIDx0Z2xAc3NzLnBnaC5wYS51cz4KUmV2aWV3ZWQtYnk6IEp1bndh bmcgWmhhbyA8emhqd3BrdUBnbWFpbC5jb20+CkRpc2N1c3Npb246IGh0dHA6Ly9wb3N0Z3IuZXMv bS8zNjQxMDQzLjE3NTg3NTEzOTlAc3NzLnBnaC5wYS51cwoKQnJhbmNoCi0tLS0tLQptYXN0ZXIK CkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZm LzhjNDlhNDg0ZThlYmIwMTk5ZmJhNGJkNjhlYWFlZGFmNDliNDhlZDAKCk1vZGlmaWVkIEZpbGVz Ci0tLS0tLS0tLS0tLS0tCmNvbnRyaWIvcG9zdGdyZXNfZmR3L2V4cGVjdGVkL3Bvc3RncmVzX2Zk dy5vdXQgfCAgNzAgKysrLS0tCnNyYy9iYWNrZW5kL2NvbW1hbmRzL2V4cGxhaW4uYyAgICAgICAg ICAgICAgICAgfCAgMTUgKy0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BhdGgvYWxscGF0aHMuYyAg ICAgICAgICB8ICAgNiArLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGxhbi9wbGFuYWdnLmMgICAg ICAgICAgIHwgICAzICsKc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BsYW4vcGxhbm5lci5jICAgICAg ICAgICB8ICA3OCArKysrKystCnNyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL3N1YnNlbGVjdC5j ICAgICAgICAgfCAgODcgKysrKy0tLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcHJlcC9wcmVwam9p bnRyZWUuYyAgICAgIHwgICAxICsKc3JjL2JhY2tlbmQvb3B0aW1pemVyL3ByZXAvcHJlcHVuaW9u LmMgICAgICAgICB8ICAgNSArLQpzcmMvYmFja2VuZC91dGlscy9hZHQvcnVsZXV0aWxzLmMgICAg ICAgICAgICAgIHwgIDMzICsrLQpzcmMvaW5jbHVkZS9ub2Rlcy9wYXRobm9kZXMuaCAgICAgICAg ICAgICAgICAgIHwgICA2ICsKc3JjL2luY2x1ZGUvbm9kZXMvcHJpbW5vZGVzLmggICAgICAgICAg ICAgICAgICB8ICAgMSArCnNyYy9pbmNsdWRlL29wdGltaXplci9wbGFubmVyLmggICAgICAgICAg ICAgICAgfCAgIDQgKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2FnZ3JlZ2F0ZXMub3V0ICAg ICAgIHwgIDU4ICsrLS0tCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvY3JlYXRlX2luZGV4Lm91 dCAgICAgfCAgMTQgKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9ncm91cGluZ3NldHMub3V0 ICAgICB8ICA5NCArKysrLS0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2luY3JlbWVudGFs X3NvcnQub3V0IHwgICA4ICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvaW5oZXJpdC5vdXQg ICAgICAgICAgfCAgMzIgKy0tCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvaW5zZXJ0X2NvbmZs aWN0Lm91dCAgfCAgIDQgKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9qb2luLm91dCAgICAg ICAgICAgICB8ICA3OCArKystLS0tCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvam9pbl9oYXNo Lm91dCAgICAgICAgfCAgMzIgKy0tCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvbWVtb2l6ZS5v dXQgICAgICAgICAgfCAgIDQgKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9tZXJnZS5vdXQg ICAgICAgICAgICB8ICAxMiArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3BhcnRpdGlvbl9w cnVuZS5vdXQgIHwgMzAwICsrKysrKysrKysrKy0tLS0tLS0tLS0tLS0Kc3JjL3Rlc3QvcmVncmVz cy9leHBlY3RlZC9wb3J0YWxzLm91dCAgICAgICAgICB8ICAxMiArLQpzcmMvdGVzdC9yZWdyZXNz L2V4cGVjdGVkL3ByZWRpY2F0ZS5vdXQgICAgICAgIHwgICA4ICstCnNyYy90ZXN0L3JlZ3Jlc3Mv ZXhwZWN0ZWQvcmV0dXJuaW5nLm91dCAgICAgICAgfCAgMjQgKy0Kc3JjL3Rlc3QvcmVncmVzcy9l eHBlY3RlZC9yb3dzZWN1cml0eS5vdXQgICAgICB8IDEzOCArKysrKystLS0tLS0Kc3JjL3Rlc3Qv cmVncmVzcy9leHBlY3RlZC9yb3d0eXBlcy5vdXQgICAgICAgICB8ICAxMiArLQpzcmMvdGVzdC9y ZWdyZXNzL2V4cGVjdGVkL3NlbGVjdF9wYXJhbGxlbC5vdXQgIHwgIDU2ICsrLS0tCnNyYy90ZXN0 L3JlZ3Jlc3MvZXhwZWN0ZWQvc3FsanNvbi5vdXQgICAgICAgICAgfCAgIDQgKy0Kc3JjL3Rlc3Qv cmVncmVzcy9leHBlY3RlZC9zdWJzZWxlY3Qub3V0ICAgICAgICB8IDE3NCArKysrKysrLS0tLS0t LQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3VwZGF0YWJsZV92aWV3cy5vdXQgIHwgIDUyICsr LS0tCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvdXBkYXRlLm91dCAgICAgICAgICAgfCAgIDgg Ky0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC93aW5kb3cub3V0ICAgICAgICAgICB8ICAxMCAr LQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3dpdGgub3V0ICAgICAgICAgICAgIHwgIDIwICst CjM1IGZpbGVzIGNoYW5nZWQsIDgxMCBpbnNlcnRpb25zKCspLCA2NTMgZGVsZXRpb25zKC0pCgo= --===============5141696655879423941==--