ydb/yql/essentials/tests/sql/suites/pg/select_join_left_one.sql

--!syntax_pg
select * from (values (1,2),(3,4)) as a(x,y)
left join (values (1,2),(2,5)) as b(u,v)
on a.x = 1;

select * from (values (1,2),(3,4)) as a(x,y)
left join (values (1,2),(2,5)) as b(u,v)
on a.x = 0;

select * from (values (1,2),(3,4)) as a(x,y)
left join (values (1,2),(2,5)) as b(u,v)
on b.u = 1;

select * from (values (1,2),(3,4)) as a(x,y)
left join (values (1,2),(2,5)) as b(u,v)
on b.u = 0;