On Mon, Aug 15, 2022 at 8:53 AM jian he wrote:
> select * from
> (
> (select 2 as v )
> union all
> (select 3 as v)
> ) as q1
> cross join lateral
> ( (select * from
> ((select 4 as v) union all
> (select 5 as v)) as q3
> )
> union all
> (select q1.v)
> ) as q2;
select * from
(
(select 2 as v )
union all
(select 3 as v)
) as q1
cross join lateral
( (select * from
((select 4 as v) union all
(select 5 as v)) as q3
)
union all
(select q1.v)
) as q2;
I thought q1 will be materialized as a constant set and will be equivalent
