| 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
| 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 |