aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/column_order/select_plain.sql
blob: b495924f3d42defc8084831c11f3aba10bc2fb42 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
/* postgres can not */
/* syntax version 1 */
use plato;
pragma OrderedColumns;

select * from Input order by subkey;
select * without key from Input order by subkey;

select a.* from Input as a order by a.subkey;
select a.* without key from Input as a order by a.subkey;

select 1 as z, 2 as x, a.* from Input as a order by a.subkey;
select 1 as z, 2 as x, a.* without key from Input as a order by a.subkey;

select 1 as c, 2 as b, 3 as a;