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.96) (envelope-from ) id 1vU4of-00GUIC-1f for pgsql-bugs@arkaria.postgresql.org; Fri, 12 Dec 2025 15:12:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vU4oe-008OmJ-19 for pgsql-bugs@arkaria.postgresql.org; Fri, 12 Dec 2025 15:12:21 +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.96) (envelope-from ) id 1vU088-007Wa6-1Q for pgsql-bugs@lists.postgresql.org; Fri, 12 Dec 2025 10:12:09 +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 1vU086-000K3I-0n for pgsql-bugs@lists.postgresql.org; Fri, 12 Dec 2025 10:12:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=A6WKDnnqv32McSJ0XreM/x1CfqRoNnE4yNOTHVQ69+8=; b=n5rMXWQxybkrZF2ILx4sKKnq5t GqVjEzBa9bGZRt1I/j+4JwzXQmPgzhkBJSPylAw6DZ4vbYCvnHSN0tXjXgaiFIWNQrT/JCiWtfMKg S27p7wT82Mo3FcTcOOim7sGYLilO8dSF7Jo5v9NeVIJjjQajhvFbE4RaPlAuNZtWOLHq7naJezcDY hhzfQ3Cl3sdqTswvDp4Xv4kA4Isnz0nE5FIaan4edNDlNRaDBXMwCmuVHa97PuQaaPutjD05zBQdf aEID9NNDMdiWnsxkzQcYr+RoA3QaDx4g70o1NcvkTaJwnQPIkMvra0bEUtwVQy8jRauVPAxjqk91A QhIkogew==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vU085-000p0y-0S for pgsql-bugs@lists.postgresql.org; Fri, 12 Dec 2025 10:12:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vU082-001diV-2T for pgsql-bugs@lists.postgresql.org; Fri, 12 Dec 2025 10:12:03 +0000 Content-Type: multipart/mixed; boundary="===============5430420038772291681==" MIME-Version: 1.0 Subject: BUG #19353: Error XX000 if referencing expanded array in grouping set: variable not found in subplan target list To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: marian.muller@serli.com Reply-To: marian.muller@serli.com, pgsql-bugs@lists.postgresql.org Date: Fri, 12 Dec 2025 10:11:15 +0000 Message-ID: <19353-aaa179bba986a19b@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5430420038772291681== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTM1MwpMb2dnZWQgYnk6ICAgICAgICAgIE1hcmlhbiBNVUxMRVIgUkVC RVlST0wKRW1haWwgYWRkcmVzczogICAgICBtYXJpYW4ubXVsbGVyQHNlcmxpLmNvbQpQb3N0Z3Jl U1FMIHZlcnNpb246IDE4LjEKT3BlcmF0aW5nIHN5c3RlbTogICBMaW51eApEZXNjcmlwdGlvbjog ICAgICAgIAoKSGksCgpMZXQgbWUgc3RhcnQgYnkgdGhhbmtpbmcgeW91IGZvciBwcm92aWRpbmcg c3VjaCBhIGdyZWF0IHRvb2whCgpBZnRlciB1cGdyYWRpbmcgdG8gUG9zdGdyZXMgMTggSSd2ZSBj b21lIGFjcm9zcyBhbiBlcnJvciBJIHdhc24ndCBnZXR0aW5nCmJlZm9yZWhhbmQuIEhlcmUncyBh IG1pbmltYWwgd2F5IHRvIHJlcHJvZHVjZSB0aGUgaXNzdWUsIHRoYXQgdXNlZCB0byB3b3JrCndl bGwgaW4gUG9zdGdyZXMgMTIgYW5kIDE3IGF0IGxlYXN0LgoKVGFibGUgYW5kIGRhdGE6CmBgYApj cmVhdGUgdGFibGUgaXRlbXMgKAogIGlkICAgICAgdmFyY2hhcigyNTUpIHByaW1hcnkga2V5LAog IGJyYW5kcyAgdmFyY2hhciBhcnJheSwKICBtYXJrZXRzIHZhcmNoYXIgYXJyYXkKKTsKaW5zZXJ0 IGludG8gaXRlbXMgdmFsdWVzICgnSXRlbTEnLCAne0JyYW5kIEEsQnJhbmQgQn0nLCAne01hcmtl dCBBfScpOwppbnNlcnQgaW50byBpdGVtcyB2YWx1ZXMgKCdJdGVtMicsICd7QnJhbmQgQn0nLCAn e01hcmtldCBCLE1hcmtldCBBfScpOwppbnNlcnQgaW50byBpdGVtcyB2YWx1ZXMgKCdJdGVtMycs ICd7QnJhbmQgQSxCcmFuZCBDfScsICd7TWFya2V0IEJ9Jyk7CmBgYAoKV2hlbiBxdWVyeWluZyB0 aGlzIHRhYmxlIHVzaW5nIGdyb3VwaW5nIHNldHMsIEkgZ2V0IGFuIGludGVybmFsIGVycm9yIGFz CnNvb24gYXMgdGhlIGdyb3VwaW5nIHNldHMgcmVmZXJlbmNlIGFuIGV4cGFuZGVkIGFycmF5LCBm b3IgaW5zdGFuY2UgdGhpcwpxdWVyeSB3b3JrczoKYGBgClNFTEVDVCBicmFuZHMsIG1hcmtldHMs IGNvdW50KGRpc3RpbmN0IGlkKSBjb3VudApGUk9NIGl0ZW1zCkdST1VQIEJZIEdST1VQSU5HIFNF VFMgKGJyYW5kcywgbWFya2V0cywgKCkpCk9SREVSIEJZIGJyYW5kcyBhc2MsIG1hcmtldHMgYXNj OwpgYGAKCkJ1dCB0aGlzIG9uZSB0cmlnZ2VycyBhbiBlcnJvcjoKYGBgClNFTEVDVCBicmFuZHMs IHVubmVzdChtYXJrZXRzKSBhcyBtYXJrZXQsIGNvdW50KGRpc3RpbmN0IGlkKSBjb3VudApGUk9N IGl0ZW1zCkdST1VQIEJZIEdST1VQSU5HIFNFVFMgKGJyYW5kcywgbWFya2V0LCAoKSkKT1JERVIg QlkgYnJhbmRzIGFzYywgbWFya2V0IGFzYzsKYGBgCgpUaGlzIGdpdmVzIG1lIHRoZSBmb2xsb3dp bmcgZXJyb3Igb24gdGhlIGxhdGVzdCByZWxlYXNlIChQb3N0Z3JlU1FMIDE4LjEgb24KeDg2XzY0 LXBjLWxpbnV4LWdudSwgY29tcGlsZWQgYnkgZ2NjIChHQ0MpIDE1LjIuMSAyMDI1MTExMiwgNjQt Yml0KToKYGBgCkVSUk9SOiAgWFgwMDA6IHZhcmlhYmxlIG5vdCBmb3VuZCBpbiBzdWJwbGFuIHRh cmdldCBsaXN0CkxPQ0FUSU9OOiAgZml4X3VwcGVyX2V4cHJfbXV0YXRvciwgc2V0cmVmcy5jOjMz MTQKYGBgCgpJJ3ZlIGNvbmZpcm1lZCB0aGUgZXJyb3Igc3RpbGwgZXhpc3RzIHdpdGggYSB2YW5p bGxhIGZyZXNobHktY29tcGlsZWQKUG9zdGdyZXMgKFBvc3RncmVTUUwgMTlkZXZlbCBvbiB4ODZf NjQtcGMtbGludXgtZ251LCBjb21waWxlZCBieSBnY2MgKEdDQykKMTUuMi4xIDIwMjUxMTEyLCA2 NC1iaXQgOyBsYXRlc3QgY29tbWl0IGF0IHRoZSB0aW1lOiBiNjVmMWFkKToKYGBgCjIwMjUtMTIt MTIgMTA6Mzk6NTEuMTUxIENFVCBbMzQ3MDA0XSBFUlJPUjogIHZhcmlhYmxlIG5vdCBmb3VuZCBp biBzdWJwbGFuCnRhcmdldCBsaXN0CjIwMjUtMTItMTIgMTA6Mzk6NTEuMTUxIENFVCBbMzQ3MDA0 XSBTVEFURU1FTlQ6ICBTRUxFQ1QgYnJhbmRzLAp1bm5lc3QobWFya2V0cykgYXMgbWFya2V0LCBj b3VudChkaXN0aW5jdCBpZCkgY291bnQKICAgICAgICBGUk9NIGl0ZW1zCiAgICAgICAgR1JPVVAg QlkgR1JPVVBJTkcgU0VUUyAoYnJhbmRzLCBtYXJrZXQsICgpKQogICAgICAgIE9SREVSIEJZIGJy YW5kcyBhc2MsIG1hcmtldCBhc2M7CkVSUk9SOiAgWFgwMDA6IHZhcmlhYmxlIG5vdCBmb3VuZCBp biBzdWJwbGFuIHRhcmdldCBsaXN0CkxPQ0FUSU9OOiAgZml4X3VwcGVyX2V4cHJfbXV0YXRvciwg c2V0cmVmcy5jOjMzMzUKYGBgCgpXaGlsZSB0aGlzIHF1ZXJ5IHVzZWQgdG8gd29yayBpbiBwcmV2 aW91cyB2ZXJzaW9ucywgSSdtIHVuc3VyZSBmcm9tIHRoZQpkb2N1bWVudGF0aW9uIHdoZXRoZXIg aXQgaXMgZXhwZWN0ZWQgdG8gd29yayBvciBub3QuCgpNeSBwbGF0Zm9ybSBpcyBHTlUvTGludXgg KHVwLXRvLWRhdGUgTWFuamFybyksIGtlcm5lbCA2LjE2LjgsIG9uIHg4Nl82NC4KSSd2ZSBhbHNv IGV4cGVyaWVuY2VkIHRoZSBlcnJvciBvbiBhIGNsb3VkLWhvc3RlZCBQb3N0Z3JlcyBpbnN0YW5j ZS4KCkkndmUgdHJpZWQgdG8gYmUgZXhoYXVzdGl2ZSBidXQgd2lsbCBnbGFkbHkgcHJvdmlkZSBt b3JlIGluZm9ybWF0aW9uIGlmCm5lY2Vzc2FyeS4KClRoYW5rcy4KCg== --===============5430420038772291681==--