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 1tOOeo-0063mA-P3 for pgsql-committers@arkaria.postgresql.org; Thu, 19 Dec 2024 22:06:11 +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 1tOOeo-000dCo-2Y for pgsql-committers@arkaria.postgresql.org; Thu, 19 Dec 2024 22:06:09 +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 1tOObq-000b9i-RD for pgsql-committers@lists.postgresql.org; Thu, 19 Dec 2024 22:03:06 +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.94.2) (envelope-from ) id 1tOObm-000eRS-Uh for pgsql-committers@lists.postgresql.org; Thu, 19 Dec 2024 22:03:05 +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 1tOObl-001MTy-AE for pgsql-committers@lists.postgresql.org; Thu, 19 Dec 2024 22:03:01 +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 1tOObk-000PxK-Ge for pgsql-committers@lists.postgresql.org; Thu, 19 Dec 2024 22:03:01 +0000 Content-Type: multipart/mixed; boundary="===============7790930451072151210==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Convert SetOp to read its inputs as outerPlan and innerPlan. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 19 Dec 2024 22:03:01 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7790930451072151210== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Q29udmVydCBTZXRPcCB0byByZWFkIGl0cyBpbnB1dHMgYXMgb3V0ZXJQbGFuIGFuZCBpbm5lclBs YW4uCgpUaGUgb3JpZ2luYWwgZGVzaWduIGZvciBzZXQgb3BlcmF0aW9ucyBpbnZvbHZlZCBhcHBl bmRpbmcgdGhlIHR3bwppbnB1dCByZWxhdGlvbnMgaW50byBvbmUgYW5kIGFkZGluZyBhIGZsYWcg Y29sdW1uIHRoYXQgYWxsb3dzCmRpc3Rpbmd1aXNoaW5nIHdoaWNoIHNpZGUgZWFjaCByb3cgY2Ft ZSBmcm9tLiAgVGhlbiB0aGUgU2V0T3Agbm9kZQpwcmllcyB0aGVtIGFwYXJ0IGFnYWluIGJhc2Vk IG9uIHRoZSBmbGFnLiAgVGhpcyBpcyBiaXphcnJlLiAgVGhlCm9ubHkgYXBwYXJlbnQgcmVhc29u IHRvIGRvIGl0IGlzIHRoYXQgd2hlbiBzb3J0aW5nLCB3ZSdkIG9ubHkgbmVlZApvbmUgU29ydCBu b2RlIG5vdCB0d28uICBCdXQgc2luY2Ugc29ydGluZyBpcyBhdCBsZWFzdCBPKE4gbG9nIE4pLApz b3J0aW5nIGFsbCB0aGUgZGF0YSBpcyBhY3R1YWxseSB3b3JzZSB0aGFuIHNvcnRpbmcgZWFjaCBz aWRlCnNlcGFyYXRlbHkgLS0tIHBsdXMsIHdlIGhhdmUgbm8gY2hhbmNlIG9mIHRha2luZyBhZHZh bnRhZ2Ugb2YKcHJlc29ydGVkIGlucHV0LiAgT24gdG9wIG9mIHRoYXQsIGFkZGluZyB0aGUgZmxh ZyBjb2x1bW4gZnJlcXVlbnRseQpyZXF1aXJlcyBhbiBhZGRpdGlvbmFsIHByb2plY3Rpb24gc3Rl cCB0aGF0IGFkZHMgY3ljbGVzLCBhbmQgdGhlbgp0aGUgQXBwZW5kIG5vZGUgaXNuJ3QgZnJlZSBl aXRoZXIuICBMZXQncyBnZXQgcmlkIG9mIGFsbCBvZiB0aGF0CmFuZCBtYWtlIHRoZSBTZXRPcCBu b2RlIGhhdmUgdHdvIHNlcGFyYXRlIGNoaWxkcmVuLCB1c2luZyB0aGUKZXhpc3Rpbmcgb3V0ZXJQ bGFuL2lubmVyUGxhbiBpbmZyYXN0cnVjdHVyZS4KClRoaXMgaW5pdGlhbCBwYXRjaCByZS1pbXBs ZW1lbnRzIG5vZGVTZXRvcC5jIGFuZCBkb2VzIGEgYmFyZSBtaW5pbXVtCm9mIHdvcmsgb24gdGhl IHBsYW5uZXIgc2lkZSB0byBnZW5lcmF0ZSBjb3JyZWN0bHktc2hhcGVkIHBsYW5zLgpJbiBwYXJ0 aWN1bGFyLCBJJ3ZlIHRyaWVkIG5vdCB0byBjaGFuZ2UgdGhlIGNvc3QgZXN0aW1hdGVzIGhlcmUs CnNvIHRoYXQgdGhlIHZpc2libGUgY2hhbmdlcyBpbiB0aGUgcmVncmVzc2lvbiB0ZXN0IHJlc3Vs dHMgd2lsbCBvbmx5Cmludm9sdmUgcmVtb3ZhbCBvZiB1c2VsZXNzIHByb2plY3Rpb24gc3RlcHMg YW5kIG5vdCBhbnkgY2hhbmdlcyBpbgp3aGV0aGVyIHRvIHVzZSBzb3J0ZWQgdnMgaGFzaGVkIG1v ZGUuCgpGb3IgU09SVEVEIG1vZGUsIHdlIGNvbWJpbmUgc3VjY2Vzc2l2ZSBpZGVudGljYWwgdHVw bGVzIGZyb20gZWFjaAppbnB1dCBpbnRvIGdyb3VwcywgYW5kIHRoZW4gbWVyZ2Utam9pbiB0aGUg Z3JvdXBzLiAgVGhlIHR1cGxlCmNvbXBhcmlzb25zIG5vdyB1c2UgU29ydFN1cHBvcnQgaW5zdGVh ZCBvZiBzaW1wbGUgZXF1YWxpdHksIGJ1dAp0aGUgZ3JvdXAtZm9ybWF0aW9uIHBhcnQgc2hvdWxk IGludm9sdmUgcm91Z2hseSB0aGUgc2FtZSBudW1iZXIgb2YKdHVwbGUgY29tcGFyaXNvbnMgYXMg YmVmb3JlLiAgVGhlIGNyb3NzLWNvbXBhcmlzb25zIGJldHdlZW4gbGVmdCBhbmQKcmlnaHQgZ3Jv dXBzIHByb2JhYmx5IGFkZCB0byB0aGF0LCBidXQgSSdtIG5vdCBzdXJlIHRvIHF1YW50aWZ5IGhv dwptYW55IG1vcmUgY29tcGFyaXNvbnMgd2UgbWlnaHQgbmVlZC4KCkZvciBIQVNIRUQgbW9kZSwg bm9kZVNldG9wJ3MgbG9naWMgaXMgYWxtb3N0IHRoZSBzYW1lIGFzIGJlZm9yZSwKanVzdCByZWZh Y3RvcmVkIGludG8gdHdvIHNlcGFyYXRlIGxvb3BzIGluc3RlYWQgb2Ygb25lIGxvb3AgdGhhdApo YXMgYW4gYXNzdW1wdGlvbiB0aGF0IGl0IHdpbGwgc2VlIGFsbCB0aGUgbGVmdC1oYW5kIGlucHV0 cyBmaXJzdC4KCkluIGJvdGggbW9kZXMsIEkgYWRkZWQgZWFybHktZXhpdCBsb2dpYyB0byBub3Qg Ym90aGVyIHJlYWRpbmcgdGhlCnJpZ2h0LWhhbmQgcmVsYXRpb24gaWYgdGhlIGxlZnQtaGFuZCBp bnB1dCBpcyBlbXB0eSwgc2luY2UgbmVpdGhlcgpJTlRFUlNFQ1Qgbm9yIEVYQ0VQVCBtb2RlcyBj YW4gcHJvZHVjZSBhbnkgb3V0cHV0IGlmIHRoZSBsZWZ0IGlucHV0CmlzIGVtcHR5LiAgVGhpcyBj b3VsZCBoYXZlIGJlZW4gZG9uZSBiZWZvcmUgaW4gdGhlIGhhc2hlZCBtb2RlLCBidXQKbm90IGlu IHNvcnRlZCBtb2RlLiAgU29ydGVkIG1vZGUgY2FuIGFsc28gc3RvcCBhcyBzb29uIGFzIGl0IGV4 aGF1c3RzCnRoZSBsZWZ0IGlucHV0OyBhbnkgcmVtYWluaW5nIHJpZ2h0LWhhbmQgdHVwbGVzIGNh bm5vdCBoYXZlIG1hdGNoZXMuCgpBbHNvLCB0aGlzIHBhdGNoIGFkZHMgc29tZSBpbmZyYXN0cnVj dHVyZSBmb3IgZGV0ZWN0aW5nIHdoZXRoZXIKY2hpbGQgcGxhbiBub2RlcyBhbGwgb3V0cHV0IHRo ZSBzYW1lIHR5cGUgb2YgdHVwbGUgdGFibGUgc2xvdC4KSWYgdGhleSBkbywgdGhlIGhhc2ggdGFi bGUgbG9naWMgY2FuIHVzZSBzbGlnaHRseSBtb3JlIGVmZmljaWVudApjb2RlIGJhc2VkIG9uIGFz c3VtaW5nIHRoYXQgdGhhdCdzIHRoZSBpbnB1dCBzbG90IHR5cGUgaXQgd2lsbCBzZWUuCldlJ2xs IG1ha2UgdXNlIG9mIHRoYXQgaW5mcmFzdHJ1Y3R1cmUgaW4gb3RoZXIgcGxhbiBub2RlIHR5cGVz IGxhdGVyLgoKUGF0Y2ggYnkgbWU7IHRoYW5rcyB0byBSaWNoYXJkIEd1byBhbmQgRGF2aWQgUm93 bGV5IGZvciByZXZpZXcuCgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzE4NTAxMzgu MTczMTU0OTYxMUBzc3MucGdoLnBhLnVzCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwot LS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvMjc2Mjc5Mjk1 MjhlMjRhNTQ3ZDEwNThhNTQ0NGIzNTQ5MTA1N2E1NgoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0t LS0tLS0Kc3JjL2JhY2tlbmQvZXhlY3V0b3IvZXhlY1V0aWxzLmMgICAgICAgIHwgIDQzICsrKwpz cmMvYmFja2VuZC9leGVjdXRvci9ub2RlU2V0T3AuYyAgICAgICAgfCA1MzcgKysrKysrKysrKysr KysrKysrLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL1JFQURNRSAgICAgICAg ICAgIHwgICAyICstCnNyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL2NyZWF0ZXBsYW4uYyB8ICA4 MSArKy0tLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcHJlcC9wcmVwdW5pb24uYyAgfCAxNTYgKysr KysrLS0tLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvdXRpbC9wYXRobm9kZS5jICAgfCAgNTAgKy0t CnNyYy9pbmNsdWRlL2V4ZWN1dG9yL2V4ZWN1dG9yLmggICAgICAgICB8ICAgMyArCnNyYy9pbmNs dWRlL25vZGVzL2V4ZWNub2Rlcy5oICAgICAgICAgICB8ICAzMSArLQpzcmMvaW5jbHVkZS9ub2Rl cy9wYXRobm9kZXMuaCAgICAgICAgICAgfCAgIDkgKy0Kc3JjL2luY2x1ZGUvbm9kZXMvcGxhbm5v ZGVzLmggICAgICAgICAgIHwgIDE5ICstCnNyYy9pbmNsdWRlL29wdGltaXplci9wYXRobm9kZS5o ICAgICAgICB8ICAgNyArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3N1YnNlbGVjdC5vdXQg fCAgMjAgKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC91bmlvbi5vdXQgICAgIHwgMjU0ICsr KysrKystLS0tLS0tLQpzcmMvdGVzdC9yZWdyZXNzL3NxbC91bmlvbi5zcWwgICAgICAgICAgfCAg IDYgKwpzcmMvdG9vbHMvcGdpbmRlbnQvdHlwZWRlZnMubGlzdCAgICAgICAgfCAgIDIgKwoxNSBm aWxlcyBjaGFuZ2VkLCA2OTYgaW5zZXJ0aW9ucygrKSwgNTI0IGRlbGV0aW9ucygtKQoK --===============7790930451072151210==--