yt/yql/tests/sql/suites/join/left_join_right_pushdown_optional.yql


1
2
3
4
5
6
7
8
9
10
11
12

PRAGMA FilterPushdownOverJoinOptionalSide;

use plato;

SELECT a.Key AS Key, a.Value AS Value, b.y AS RightValue
FROM Input2 AS a
LEFT JOIN (
    SELECT Fk1 AS x, Value AS y
    FROM Input1
) AS b
ON a.Key == b.x
WHERE b.x >= "Name2";