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

use plato;

pragma config.flags('OptimizerFlags', 'MemberNthOverFlatMap');
pragma yt.MapJoinLimit="1m";


$t1 = select k1, v1 from Input1;
$t2 = select k2, v2, u2 as renamed from Input2;

select
     a.*,
     b.v2,
from $t1 as a left join any $t2 as b on a.k1 = b.k2;