aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/union_all/union_all_incompatible.sql
blob: b506121c94f88c34f82a725c432cab65f42229fd (plain) (blame)
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
select key from
(
    select key, subkey from
    (
        select 1 as key, "foo" as subkey
        union all
        select 2 as key, "bar" as subkey
        union all
        select 3 as key, 123 as subkey
    )
)
order by key;


select key from
(
    select * from
    (
        select 4 as key, "baz" as subkey
        union all
        select 5 as key, "goo" as subkey
        union all
        select 6 as key, 456 as subkey
    )
)
order by key;