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 1mQDqD-0005y5-AT for pgsql-committers@arkaria.postgresql.org; Tue, 14 Sep 2021 19:11:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mQDqB-0003XC-6g for pgsql-committers@arkaria.postgresql.org; Tue, 14 Sep 2021 19:11:35 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mQDqB-0003X4-13 for pgsql-committers@lists.postgresql.org; Tue, 14 Sep 2021 19:11:35 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mQDq8-0000rB-P2 for pgsql-committers@lists.postgresql.org; Tue, 14 Sep 2021 19:11:34 +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-0001qH-3n 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-0005Ph-Qm for pgsql-committers@lists.postgresql.org; Tue, 14 Sep 2021 19:11:31 +0000 Content-Type: multipart/mixed; boundary="===============6053174995730592463==" 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 --===============6053174995730592463== 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 b20KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9z dGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9lODYzOGQ3OGEyY2I5NGVmYmExMWE1ZGZiZjNlN2Nk NzQ2ZDBhZjNlCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9vcHRp bWl6ZXIvcGxhbi9zZXRyZWZzLmMgICAgfCA3MSArKysrKysrKysrKysrKysrKysrKysrLS0tLS0t LS0tLS0Kc3JjL2luY2x1ZGUvbm9kZXMvcGF0aG5vZGVzLmggICAgICAgICAgIHwgIDQgKysKc3Jj L3Rlc3QvcmVncmVzcy9leHBlY3RlZC9zdWJzZWxlY3Qub3V0IHwgNDAgKysrKysrKysrKysrKysr KysrKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9zdWJzZWxlY3Quc3FsICAgICAgfCAxMiArKysrKysK NCBmaWxlcyBjaGFuZ2VkLCAxMDMgaW5zZXJ0aW9ucygrKSwgMjQgZGVsZXRpb25zKC0pCgo= --===============6053174995730592463==--