yql/essentials/tests/sql/suites/select_op/select_op_precedence_named_node.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

$t1 = (
    (SELECT * FROM (VALUES (1), (2)) AS t (x))
UNION
    (SELECT * FROM (VALUES (2), (3)) AS t (x))
    INTERSECT
    (SELECT * FROM (VALUES (3)) AS t (x))
);


$t2 = (
(SELECT * FROM (VALUES (3)) AS t (x))
UNION
(SELECT * FROM (VALUES (2)) AS t (x))
EXCEPT
(SELECT * FROM (VALUES (3)) AS t (x))
);

$t3 = (
    (SELECT * FROM (VALUES (1)) AS t (x))
UNION
    (SELECT * FROM (VALUES (2)) AS t (x))
    INTERSECT
    (SELECT * FROM (VALUES (2), (3)) AS t (x))
EXCEPT
    (SELECT * FROM (VALUES (3)) AS t (x))
UNION
    (SELECT * FROM (VALUES (4), (3)) AS t (x))
EXCEPT
    (SELECT * FROM (VALUES (4)) AS t (x))
);

SELECT * FROM $t1;
SELECT * FROM $t2;
SELECT * FROM $t3;