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 1mQDqF-0005yM-VZ for pgsql-committers@arkaria.postgresql.org; Tue, 14 Sep 2021 19:11:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mQDqE-0003z1-Va for pgsql-committers@arkaria.postgresql.org; Tue, 14 Sep 2021 19:11:38 +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 1mQDqE-0003yI-Pr for pgsql-committers@lists.postgresql.org; Tue, 14 Sep 2021 19:11:38 +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 1mQDqB-0006mG-L8 for pgsql-committers@lists.postgresql.org; Tue, 14 Sep 2021 19:11:38 +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 1mQDq8-0001qI-2T for pgsql-committers@lists.postgresql.org; Tue, 14 Sep 2021 19:11:32 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mQDq7-0005Pi-RE for pgsql-committers@lists.postgresql.org; Tue, 14 Sep 2021 19:11:31 +0000 Content-Type: multipart/mixed; boundary="===============7282159003667203389==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix planner error with multiple copies of an AlternativeSubPlan. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 14 Sep 2021 19:11:31 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7282159003667203389== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHBsYW5uZXIgZXJyb3Igd2l0aCBtdWx0aXBsZSBjb3BpZXMgb2YgYW4gQWx0ZXJuYXRpdmVT dWJQbGFuLgoKSXQncyBwb3NzaWJsZSBmb3IgdXMgdG8gY29weSBhbiBBbHRlcm5hdGl2ZVN1YlBs YW4gZXhwcmVzc2lvbiBub2RlCmludG8gbXVsdGlwbGUgcGxhY2VzLCBmb3IgZXhhbXBsZSB0aGUg c2NhbiBxdWFscyBvZiBzZXZlcmFsCnBhcnRpdGlvbiBjaGlsZHJlbi4gIFRoZW4gaXQncyBwb3Nz aWJsZSB0aGF0IHdlIGNob29zZSBhIGRpZmZlcmVudApvbmUgb2YgdGhlIGFsdGVybmF0aXZlcyBh cyBvcHRpbWFsIGluIGVhY2ggcGxhY2UuICBDb21taXQgNDFlZmI4MzQwCmZhaWxlZCB0byBjb25z aWRlciB0aGlzIHNjZW5hcmlvLCBzbyBpdHMgYXR0ZW1wdCB0byByZW1vdmUgInVudXNlZCIKc3Vi cGxhbnMgY291bGQgcmVtb3ZlIHN1YnBsYW5zIHRoYXQgd2VyZSBzdGlsbCB1c2VkIGVsc2V3aGVy ZS4KCkZpeCBieSBkZWxheWluZyB0aGUgcmVtb3ZhbCBsb2dpYyB1bnRpbCB3ZSd2ZSBleGFtaW5l ZCBhbGwgdGhlCkFsdGVybmF0aXZlU3ViUGxhbnMgaW4gYSBnaXZlbiBxdWVyeSBsZXZlbC4gIChU aGlzIGRvZXMgYXNzdW1lIHRoYXQKQWx0ZXJuYXRpdmVTdWJQbGFucyBjb3VsZG4ndCBnZXQgY29w aWVkIHRvIG90aGVyIHF1ZXJ5IGxldmVscywgYnV0CmZvciB0aGUgZm9yZXNlZWFibGUgZnV0dXJl IHRoYXQncyBmaW5lOyBjZiBxdWFsX2lzX3B1c2hkb3duX3NhZmUuKQoKUGVyIHJlcG9ydCBmcm9t IFJhamt1bWFyIFJhZ2h1d2Fuc2hpLiAgQmFjay1wYXRjaCB0byB2MTQKd2hlcmUgdGhlIGZhdWx0 eSBsb2dpYyBjYW1lIGluLgoKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9DQUtjdXg2 PT1PM05OWkMzYloycHJSWXYzY2ptM19adzFHZnptT2pFVnFZTjRqdWIyK1FAbWFpbC5nbWFpbC5j b20KCkJyYW5jaAotLS0tLS0KUkVMXzE0X1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8v Z2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvMjlhYTBjZTM2MWQxNmE3OWU0ZWJmNzU2 MWNiYjE2ZWQxZDBlMjIxMQoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tl bmQvb3B0aW1pemVyL3BsYW4vc2V0cmVmcy5jICAgIHwgNzEgKysrKysrKysrKysrKysrKysrKysr Ky0tLS0tLS0tLS0tCnNyYy9pbmNsdWRlL25vZGVzL3BhdGhub2Rlcy5oICAgICAgICAgICB8ICA0 ICsrCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvc3Vic2VsZWN0Lm91dCB8IDQwICsrKysrKysr KysrKysrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwvc3Vic2VsZWN0LnNxbCAgICAgIHwgMTIg KysrKysrCjQgZmlsZXMgY2hhbmdlZCwgMTAzIGluc2VydGlvbnMoKyksIDI0IGRlbGV0aW9ucygt KQoK --===============7282159003667203389==--