Horton

Thread

Commits

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

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

    The Post Office <noreply@postgresql.org> — 2022-09-15T12:35:33Z

    The following bug has been logged on the website:

Bug reference:      17614
Logged by:          Wei Wei
Email address:      androiddown_weiwei@hotmail.com
PostgreSQL version: 11.17
Operating system:   Linux ubuntu 5.4.0-125-generic
Description:        

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

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

    Tom Lane <tgl@sss.pgh.pa.us> — 2022-09-15T19:23:30Z

    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