summaryrefslogtreecommitdiffstats
path: root/yt/yql/tests/sql/suites/join/left_join_right_pushdown_simple.yql
blob: e1c15a8d523e3e76b4aa8fb5371e5ae2083813cd (plain) (blame)
1
2
3
4
5
6
7
8
9
PRAGMA DisableSimpleColumns;
PRAGMA FilterPushdownOverJoinOptionalSide;

use plato;
SELECT *
FROM Input2 AS a
LEFT JOIN Input3 AS b
ON a.value == b.value
WHERE b.value >= "ddd";