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

10 lines
408 B
Text

statement ok
CREATE TABLE myschema.mytable (mycolumn BIGINT NOT NULL, PRIMARY KEY(mycolumn));
statement error ^Execution error: execution/ddswciqraox8k: create table: table exists already: kanto\.myschema\.mytable$
CREATE TABLE myschema.mytable (mycolumn BIGINT NOT NULL, PRIMARY KEY(mycolumn));
query I
SELECT count(*) FROM kanto.information_schema.tables WHERE table_schema<>'information_schema';
----
1