yql/essentials/tests/sql/suites/column_order/union_all.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

/* postgres can not */
/* syntax version 1 */
pragma OrderedColumns;

select 1 as z, 2 as y, 3 as x
union all
select 1 as z, 2 as y
union all
select 1 as z;

select 1 as z, 2 as y, 3 as x
union all
select 1 as z, 2 as y
union all
select 1 as a;