Horton

Re: BUG #17614: "variable not found in subplan target lists" on grouping query

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: androiddown_weiwei@hotmail.com
Cc: pgsql-bugs@lists.postgresql.org
Date: 2022-09-15T19:23:30Z
Lists: pgsql-bugs 
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

Commits

  1. In back branches, fix conditions for pullup of FROM-less subqueries.