yql/essentials/tests/sql/suites/order_by/literal_complex.sql


1
2
3
4
5
6
7
8
9

/* postgres can not */
/* hybridfile can not YQL-17743 */
use plato;

$list = AsList(AsStruct(1 as a, "2" as b, "3" as c), AsStruct(4 as a, "5" as b, "6" as c));

insert into Output
select * from as_table($list)
order by a desc, b, c desc;