ydb/yt/yql/tests/sql/suites/column_order/insert_tmp.sql

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

insert into @tmp
select * from Input order by subkey, key;
commit;

select * from @tmp order by subkey, key;

insert into @tmp with truncate
select key, value, subkey from Input order by subkey, key;

select * from @tmp order by subkey, key;
commit;
select * from @tmp order by subkey, key;