Horton

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

The Post Office <noreply@postgresql.org>

View thread View on postgr.es
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: androiddown_weiwei@hotmail.com
Date: 2022-09-15T12:35:33Z
Lists: pgsql-bugs 
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

Commits

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