1
Fork 0
kantodb/testdata/sql/unimplemented/unimplemented_create_table_as_select.slt

12 lines
456 B
Text

# See also unimplemented_sql/cirnphk69igxy which is a later-stage catch for the same syntax.
statement error ^External error: unimplemented_sql/nuqha5e3r7g6h: CREATE TABLE AS SELECT$
CREATE TABLE myschema.mytable (mycolumn BIGINT NOT NULL, PRIMARY KEY(mycolumn)) AS SELECT 42;
#statement ok
#CREATE TABLE myschema.mytable (mycolumn BIGINT NOT NULL, PRIMARY KEY(mycolumn)) AS SELECT 42;
#
#query I rowsort
#SELECT * FROM kanto.myschema.mytable;
#----
#42