ydb/yt/yql/tests/sql/suites/join/mergejoin_force_align3.sql

/* syntax version 1 */
/* postgres can not */

USE plato;

pragma yt.JoinMergeTablesLimit="100";
pragma yt.JoinMergeForce;

insert into @t1
select (1, 1u) as k1, 100u as v1;

insert into @t2
select (1u, 1) as k2, 100 as v2;


commit;

select * from @t1 as a join @t2 as b on a.k1 = b.k2 and a.v1 = b.v2;