Re: Assert failure in CTE inlining with view and correlated subquery

Поиск
Список
Период
Сортировка
От Richard Guo
Тема Re: Assert failure in CTE inlining with view and correlated subquery
Дата
Msg-id CAMbWs498tSxj0eiR13JvgYq=hPjwqG086_Fo8X34ESp4OQHDug@mail.gmail.com
обсуждение исходный текст
Ответ на Assert failure in CTE inlining with view and correlated subquery  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Ответы Re: Assert failure in CTE inlining with view and correlated subquery  (Richard Guo <guofenglinux@gmail.com>)
Список pgsql-hackers

On Thu, Apr 21, 2022 at 5:33 AM Tomas Vondra <tomas.vondra@enterprisedb.com> wrote:

it seems there's something wrong with CTE inlining when there's a view
containing a correlated subquery referencing the CTE. 

BTW, seems view is not a necessary condition to reproduce this issue.
For instance:

create table t (a int, b int);

explain (costs off) select a from
(
    with t_cte as (select a, b from t)
    select
        a,
        (select b from t_cte where t_cte.a = t.a) AS t_sub
    from t
) sub;

Thanks
Richard

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

Предыдущее
От: Richard Guo
Дата:
Сообщение: Re: Assert failure in CTE inlining with view and correlated subquery
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Checking pgwin32_is_junction() errors