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 1noJ6k-0007cJ-1b for pgsql-bugs@arkaria.postgresql.org; Tue, 10 May 2022 06:12:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1noJ6i-0005Nz-BK for pgsql-bugs@arkaria.postgresql.org; Tue, 10 May 2022 06:12:28 +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 1noEHN-00024g-9R for pgsql-bugs@lists.postgresql.org; Tue, 10 May 2022 01:03:09 +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 1noEHK-0001z6-AX for pgsql-bugs@lists.postgresql.org; Tue, 10 May 2022 01:03: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=1OZKKnVfcKR1MUxTmDeMjl3vCuvPIMtWywgjVajMaTg=; b=b4XL8jVPZ4wMx3Bc9NoJKbmeqU H4okZT0QukGe3Mtbo4ElQLRWTS+wa9Lh79Dd4nZZVZ/mGC4t/iXtL997Lj110eo6QXJq13k9mLsDm ++i1RKgJo+38j9YJIAdrdpL/IV56u+rRn/Fp6uOl4o35sUlyu59MEnl0lcDwF1sio7eP5JTZXAzwJ G0KdY5h2x4YlaMVpdL3TvtfrcTFYylb5h6pAz4WJ/+VKRfAQk6IUnesSwze0FoLG1IcCJ6r373QKW bHQA/WgQD8qN2tVedce2uOXjdu8wezdOrO8s5gtpv8nu5XvCLMO40n1VdRnG/oiOFmq7cEX7J0XNk XQTA9A/w==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1noEHI-0007Qq-Uu for pgsql-bugs@lists.postgresql.org; Tue, 10 May 2022 01:03:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1noEHH-003B8z-B7 for pgsql-bugs@lists.postgresql.org; Tue, 10 May 2022 01:03:01 +0000 Content-Type: multipart/mixed; boundary="===============7622902918571618324==" MIME-Version: 1.0 Subject: BUG #17479: "plan should not reference subplan's variable" when calling `grouping` on result of subquery To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: sully@msully.net Reply-To: sully@msully.net, pgsql-bugs@lists.postgresql.org Date: Tue, 10 May 2022 01:02:35 +0000 Message-ID: <17479-6260deceaf0ad304@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 --===============7622902918571618324== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzQ3OQpMb2dnZWQgYnk6ICAgICAgICAgIE1pY2hhZWwgSi4gU3VsbGl2 YW4KRW1haWwgYWRkcmVzczogICAgICBzdWxseUBtc3VsbHkubmV0ClBvc3RncmVTUUwgdmVyc2lv bjogMTQuMgpPcGVyYXRpbmcgc3lzdGVtOiAgIExpbnV4CkRlc2NyaXB0aW9uOiAgICAgICAgCgpU aGUgZm9sbG93aW5nIHF1ZXJ5IHByb2R1Y2VzICJwbGFuIHNob3VsZCBub3QgcmVmZXJlbmNlIHN1 YnBsYW4ncwp2YXJpYWJsZSINCg0KY3JlYXRlIHRhYmxlIENhcmQgKGlkIHV1aWQpOw0KDQpTRUxF Q1QNCiAgICAtLSBUaGlzIGxpbmUgY2F1c2VzICJ2YXJpYWJsZSBub3QgZm91bmQgaW4gc3VicGxh biB0YXJnZXQgbGlzdCINCiAgICAtLSBncm91cGluZyhyZXMuY250KQ0KICAgIC0tIFRoaXMgbGlu ZSBjYXVzZXMgInBsYW4gc2hvdWxkIG5vdCByZWZlcmVuY2Ugc3VicGxhbidzIHZhcmlhYmxlIg0K ICAgKFNFTEVDVCBncm91cGluZyhyZXMuY250KSkNCkZST00gQ2FyZA0KQ1JPU1MgSk9JTiBMQVRF UkFMDQooU0VMRUNUDQogICAgKFNFTEVDVCBDYXJkLmlkKSBBUyBjbnQNCikgQVMgcmVzDQpHUk9V UCBCWQ0KICAgIHJlcy5jbnQNCg0KQXMgdGhlIGNvbW1lbnQgc2F5cywgYSBzbGlnaHQgY2hhbmdl IGluc3RlYWQgZXJyb3JzIHdpdGggInZhcmlhYmxlIG5vdCBmb3VuZAppbiBzdWJwbGFuIHRhcmdl dCBsaXN0Ii4KCg== --===============7622902918571618324==--