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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: androiddown_weiwei(at)hotmail(dot)com
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #17614: "variable not found in subplan target lists" on grouping query
Date: 2022-09-15 19:23:30
Message-ID: 3419783.1663269810@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PG Bug reporting form <noreply(at)postgresql(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2022-09-15 19:33:25 Re: BUG #17615: Getting error while inserting records in the table: invalid byte sequence for encoding "UTF8": 0xae
Previous Message PG Bug reporting form 2022-09-15 16:24:13 BUG #17615: Getting error while inserting records in the table: invalid byte sequence for encoding "UTF8": 0xae