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


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36

PRAGMA YqlSelect = 'auto';

$data = (
    SELECT
        a,
        b
    FROM (
        VALUES
            (1, 11),
            (2, 22),
            (3, 33),
    ) AS x (
        a,
        b
    )
);

SELECT
    x.a AS a,
    b,
    d
FROM
    $data AS x
JOIN (
    VALUES
        (1, [111]),
        (2, [222]),
        (3, [333])
) AS y (
    a,
    c
)
    FLATTEN LIST BY c AS d
ON
    x.a == y.a
;