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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #17614: "variable not found in subplan target lists" on grouping query
Дата
Msg-id 3419783.1663269810@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #17614: "variable not found in subplan target lists" on grouping query  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
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



В списке pgsql-bugs по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #17615: Getting error while inserting records in the table: invalid byte sequence for encoding "UTF8": 0xae
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #17615: Getting error while inserting records in the table: invalid byte sequence for encoding "UTF8": 0xae