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


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23

PRAGMA FilterPushdownOverJoinOptionalSide;
pragma config.flags("OptimizerFlags", "FilterPushdownOverJoinOptionalSideIgnoreOnlyKeys");

$t1_data = AsList(
    AsStruct(0 AS k1),
    AsStruct(1 AS k1),
    AsStruct(2 AS k1),
    AsStruct(3 AS k1),
);

$t2_data = AsList(
    AsStruct(2 AS k2),
    AsStruct(3 AS k2),
    AsStruct(4 AS k2),
    AsStruct(5 AS k2),
);

SELECT *
FROM AS_TABLE($t1_data) AS t1
LEFT JOIN AS_TABLE($t2_data) AS t2
ON t1.k1 == t2.k2
WHERE t2.k2 < 10
;