Re: Assert failure in CTE inlining with view and correlated subquery - Mailing list pgsql-hackers

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

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