yql/essentials/tests/sql/suites/column_order/align_publish.sql


1
2
3
4
5
6
7
8
9
10

PRAGMA OrderedColumns;
USE plato;

INSERT INTO @table1 WITH TRUNCATE (a, c, b) VALUES ('1', '2', '3');
COMMIT;

INSERT INTO Output WITH TRUNCATE 
SELECT x.c AS d, x.b AS b, json('{}') AS a
FROM @table1 AS x
ORDER BY d