1
Fork 0
kantodb/testdata/sql/insert_different_column_order.slt

11 lines
243 B
Text

statement ok
CREATE TABLE kanto.myschema.mytable (a BIGINT NOT NULL, b BIGINT NOT NULL);
statement ok
INSERT INTO kanto.myschema.mytable (b, a) VALUES (42, 2), (13, 1);
query I rowsort
SELECT a, b FROM kanto.myschema.mytable;
----
1 13
2 42