yql/essentials/tests/sql/suites/select_op/select_op_precedence.sql


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

    (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));


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


    (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));