aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/join/late_mergejoin_on_empty.sql
blob: b0dd13c10dcc18d5dd540a2b0bec6d41d5f77f9a (plain) (blame)
1
2
3
4
5
6
7
8
use plato;
PRAGMA DisableSimpleColumns;
pragma yt.JoinMergeTablesLimit="100";

select * from
(select * from Input where key < "020") as a
left only join (select subkey from Input where key < "010") as b on a.subkey = b.subkey
join /*+ merge() */ (select key, value from Input) as c on a.key = c.key