From: Tom Lane <tgl@sss.pgh.pa.us>
To: androiddown_weiwei@hotmail.com
cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17614: "variable not found in subplan target lists" on
 grouping query
In-reply-to: <17614-8ec20c85bdecaa2a@postgresql.org>
References: <17614-8ec20c85bdecaa2a@postgresql.org>
Comments: In-reply-to PG Bug reporting form <noreply@postgresql.org>
	message dated "Thu, 15 Sep 2022 12:35:33 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <3419782.1663269810.1@sss.pgh.pa.us>
Date: Thu, 15 Sep 2022 15:23:30 -0400
Message-ID: <3419783.1663269810@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/3419783.1663269810%40sss.pgh.pa.us>
Precedence: bulk

PG Bug reporting form <noreply@postgresql.org> writes:
> The problem is reproducible with following sql:
> ```
> 	SELECT
> 		sp2.spf_id 
> 	FROM
> 		information_schema.sql_parts AS sp
> 		CROSS JOIN LATERAL ( SELECT sizing_id FROM information_schema.sql_sizing )
> AS ss
> 		CROSS JOIN LATERAL ( SELECT sp.feature_id AS spf_id ) AS sp2
> 	GROUP BY
> 		CUBE ( sp2.spf_id )
> ```
> but seems having been fixed since 12.0

Yeah, it's a bug in code that we actually removed in v12
(so the fix was kind of accidental).  Repaired, thanks
for the report!

			regards, tom lane