yt/yql/tests/sql/suites/column_order/select_limit_offset.yql


1
2
3
4
5
6
7
8
9

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

select * from Input order by key limit 1 offset 3;
select * from Input order by value limit 0 offset 3;
select * from Input limit 0;