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 1rrQt5-000aXs-Cv for pgsql-committers@arkaria.postgresql.org; Mon, 01 Apr 2024 23:16:24 +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 1rrQt3-002gEx-PQ for pgsql-committers@arkaria.postgresql.org; Mon, 01 Apr 2024 23:16:22 +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 1rrQt3-002gEp-DZ for pgsql-committers@lists.postgresql.org; Mon, 01 Apr 2024 23:16:22 +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.94.2) (envelope-from ) id 1rrQt1-0002ns-8V for pgsql-committers@lists.postgresql.org; Mon, 01 Apr 2024 23:16:20 +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=j7Wkz24UQ7lfIfEtFO6Oz+Sk6/fZv1k1WKQEk+TgryU=; b=EbLg0Snon4H9W9z/uyp0ZCzNNZ p4wxmh6K8Ik4/MPsS65YjKXfrQKcHcxHSW2P9s6rrQP3TXP+iqmHsZ7DrbS0NVrPXah/guqpeyEjd YkeTh6BWgoZTTVQDeknBziSHCbvb65BVmBc9o6poVc24TZGXzKPjGUWrMd+thzYGIjXng5xnBn5l7 H5fxgWivhzV0prcj+qcFl5bcvqd5rxCXhK3VidzZvs420Dxgx3gExj0Yg9m0K8aMH3eam+QSwL4I+ rhJWrOZAZhgympy5934u4WbNrmG7Vb9puJ0yGjmqXjpmVGibTalbDOELPhzHHc3IeLYZu6RF1ZqGo eu+4KJjw==; Received: from gemulon.postgresql.org ([72.32.157.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 1rrQt0-0007mP-BP for pgsql-committers@lists.postgresql.org; Mon, 01 Apr 2024 23:16:18 +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 1rrQsz-0002uC-IM for pgsql-committers@lists.postgresql.org; Mon, 01 Apr 2024 23:16:18 +0000 Content-Type: multipart/mixed; boundary="===============0447030514613789323==" MIME-Version: 1.0 From: David Rowley To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix assert failure when planning setop subqueries with CTEs X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 01 Apr 2024 23:16:18 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0447030514613789323== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IGFzc2VydCBmYWlsdXJlIHdoZW4gcGxhbm5pbmcgc2V0b3Agc3VicXVlcmllcyB3aXRoIENU RXMKCjY2YzAxODVhMyBhZGp1c3RlZCB0aGUgVU5JT04gcGxhbm5lciB0byByZXF1ZXN0IHRoYXQg dW5pb24gY2hpbGQgcXVlcmllcwpwcm9kdWNlIFBhdGhzIGNvcnJlY3RseSBvcmRlcmVkIHRvIGlt cGxlbWVudCB0aGUgVU5JT04gYnkgd2F5IG9mCk1lcmdlQXBwZW5kIGZvbGxvd2VkIGJ5IFVuaXF1 ZS4gIFRoZSBjb2RlIHRoZXJlIG1hZGUgYSBiYWQgYXNzdW1wdGlvbgp0aGF0IGlmIHRoZSByb290 LT5wYXJlbnRfcm9vdC0+cGFyc2UgaGFkIHNldE9wZXJhdGlvbnMgc2V0IHRoYXQgdGhlCnF1ZXJ5 IG11c3QgYmUgdGhlIGNoaWxkIHN1YnF1ZXJ5IG9mIGEgc2V0IG9wZXJhdGlvbi4gIFRoYXQncyBu b3QgdHJ1ZQp3aGVuIGl0IGNvbWVzIHRvIHBsYW5uaW5nIGEgbm9uLWlubGluZWQgQ1RFIHdoaWNo IGlzIHBhcmVudGVkIGJ5IGEgc2V0Cm9wZXJhdGlvbi4gIFRoaXMgY2F1c2VzIGlzc3VlcyBhcyB0 aGUgQ1RFJ3MgdGFyZ2V0bGlzdCBoYXMgbm8KcmVxdWlyZW1lbnQgdG8gbWF0Y2ggdXAgdG8gdGhl IFNldE9wZXJhdGlvblN0bXQncyBncm91cENsYXVzZXMKCkZpeCB0aGlzIGJ5IGFkZGluZyBhIG5l dyBwYXJhbWV0ZXIgdG8gYm90aCBzdWJxdWVyeV9wbGFubmVyKCkgYW5kCmdyb3VwaW5nX3BsYW5u ZXIoKSB0byBleHBsaWNpdGx5IHBhc3MgdGhlIFNldE9wZXJhdGlvblN0bXQgb25seSB3aGVuCnBs YW5uaW5nIHNldCBvcGVyYXRpb24gY2hpbGQgc3VicXVlcmllcy4KClRoYW5rIHlvdSB0byBUb20g TGFuZSBmb3IgaGVscGluZyB0byByYXRpb25hbGl6ZSB0aGUgZGVjaXNpb24gb24gdGhlCmJlc3Qg ZnVuY3Rpb24gc2lnbmF0dXJlIGZvciBzdWJxdWVyeV9wbGFubmVyKCkuCgpSZXBvcnRlZC1ieTog QWxleGFuZGVyIExha2hpbgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzI0MmZjN2M2 LWE4YWEtMmRhZi1hYzRjLTBhMjMxZTI2MTljMUBnbWFpbC5jb20KCkJyYW5jaAotLS0tLS0KbWFz dGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0 ZGlmZi9kNWQyMjA1YzhkZGM2NjcwZmE4NzQ3NGUxNzJmZGZhYjE2MmI3YTczCgpNb2RpZmllZCBG aWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGF0aC9hbGxwYXRocy5j ICB8ICA1ICsrLS0tCnNyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL3BsYW5uZXIuYyAgIHwgMzkg KysrKysrKysrKysrKysrKysrLS0tLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIv cGxhbi9zdWJzZWxlY3QuYyB8IDE1ICsrKysrKy0tLS0tLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVy L3ByZXAvcHJlcHVuaW9uLmMgfCAxNCArKysrKysrKy0tLS0Kc3JjL2luY2x1ZGUvb3B0aW1pemVy L3BsYW5uZXIuaCAgICAgICAgfCAgMyArKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC91bmlv bi5vdXQgICAgfCAxNCArKysrKysrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwvdW5pb24uc3Fs ICAgICAgICAgfCAxMSArKysrKysrKysrCjcgZmlsZXMgY2hhbmdlZCwgNjYgaW5zZXJ0aW9ucygr KSwgMzUgZGVsZXRpb25zKC0pCgo= --===============0447030514613789323==--