yql/essentials/tests/sql/suites/join/join_left_cbo.sql


1
2
3
4
5
6
7
8

use plato;

pragma CostBasedOptimizer="PG";

select i1.value, i2.value
from Input1 as i1
left join Input2 as i2 on i1.key=i2.key
order by i1.value, i2.value;