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

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


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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: CVE-2022-2625
Следующее
От: Michael Rosinger
Дата:
Сообщение: unexpected results when attempting to define and use column with data type SERIAL