12 lines
456 B
Text
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
|