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


1
2
3
4
5
6
7
8
9

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

$sub2 = SubqueryAssumeOrderBy($sub, [("x",true)]);

process $sub2();