BUG #17614: "variable not found in subplan target lists" on grouping query
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
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