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


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

/* custom error: argument must depend on exactly one JOIN input */
SELECT
    x.a,
    x.b,
    y.a,
    y.b
FROM (
    VALUES
        (1U, 1U)
) AS x (
    a,
    b
)
JOIN (
    VALUES
        (1U, 1U)
) AS y (
    a,
    b
)
ON
    x.a + 1 == (y.a + ListLength([x.b]))
;