yql/essentials/tests/sql/suites/action/subquery_orderby0.sql


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

/* syntax version 1 */
/* postgres can not */
define subquery $sub() as
   select * from (values (1,'c'),(1,'a'),(3,'b')) as a(x,y);
end define;

$sub2 = SubqueryOrderBy($sub, []);

process $sub2();

$sub3 = SubqueryOrderBy($sub, ListCreate(Tuple<String,Bool>));

process $sub3();