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

11 lines
245 B
Text

statement ok
CREATE TABLE kanto.myschema.mytable (mycolumn BIGINT NOT NULL, PRIMARY KEY(mycolumn));
statement ok
INSERT INTO kanto.myschema.mytable (mycolumn) VALUES (42), (13);
query I rowsort
SELECT * FROM kanto.myschema.mytable;
----
13
42