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


1
2
3
4
5
6
7
8
9
10

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

values (1,2), (3,4);

select * from (values (1,2), (3,4));
select * from (values (1,2), (3,4)) as t(b,c);
select * from (values (1,2,3,4), (5,6,7,8)) as t(b,c,a);