yql/essentials/tests/sql/suites/pg/multi_usage_cross_join.sql


1
2
3
4
5
6
7
8
9
10
11
12
13

--!syntax_pg

with foo(x) as (
    select 1 as x
)
select count(*) from foo a,foo b 
where a.x=b.x and a.x<2;
    
with foo(x) as (
    select 1 as x
)
select count(*) from foo a,foo b 
where a.x=b.x and a.x>1;