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

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: androiddown_weiwei(at)hotmail(dot)com
Subject: BUG #17614: "variable not found in subplan target lists" on grouping query
Date: 2022-09-15 12:35:33
Message-ID: 17614-8ec20c85bdecaa2a@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17614
Logged by: Wei Wei
Email address: androiddown_weiwei(at)hotmail(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Rosinger 2022-09-15 14:43:26 unexpected results when attempting to define and use column with data type SERIAL
Previous Message David G. Johnston 2022-09-14 13:44:49 Re: CVE-2022-2625