yql/essentials/tests/sql/suites/select_yql/join_implicit_using_unknown_key.yql


1
2
3
4
5
6

/* custom error: Unknown column: b in correlation name: y */
PRAGMA YqlSelect = 'force';

SELECT * FROM (VALUES (1, 2)) AS x (a, cx)
JOIN (VALUES (1, 3)) AS y (a, cy)
ON x.a == y.a AND x.b == y.b;