table.slt

# Create a table.
statement ok
create table ddl_t (v1 int not null);

statement ok
explain select v1 from ddl_t;

# Create another table with duplicated name.
statement error
create table ddl_t (v2 int not null);

# Drop the table.
statement ok
drop table ddl_t;

# Drop it again.
statement error
drop table ddl_t;

# Create another table with the same name.
statement ok
create table ddl_t (v2 int not null);

statement ok
explain select v2 from ddl_t;

# Create a mview on top of it.
statement ok
create materialized view ddl_mv as select v2 from ddl_t;

statement ok
explain select v2 from ddl_t;

# Create a mview with duplicated name.
statement error
create materialized view ddl_mv as select v2 from ddl_t;

# Drop the table before dropping the mview.
statement error
drop table ddl_t;

# We're not allowed to drop the mview using `DROP TABLE`.
statement error
drop table ddl_mv;

# Drop the mview.
statement ok
drop materialized view ddl_mv;

# Drop it again.
statement error
drop materialized view ddl_mv;

# We're not allowed to drop the table using `DROP MATERIALIZED VIEW`.
statement error
drop materialized view ddl_t;

# Now, we can drop the base table.
statement ok
drop table ddl_t;

# Create table concludes struct column.
statement ok
create table st (v1 int, v2 struct<v1 int, v2 struct<v1 int, v2 int>>);

statement ok
drop table st

# We test the case sensitivity of table name and column name.
statement ok
create table t1 (v1 int);

statement ok
drop table T1;

statement ok
create table T1 (v1 int);

statement ok
drop table t1;

statement ok
create table "T1" (v1 int);

# Since we have not really bound the columns in the insert statement
# this test case cannot be enabled.
# statement error
# insert into "T1" ("V1") values (1);

statement error
drop table t1;

statement error
drop table T1;

statement ok
drop table "T1";

statement ok
create table "T2" ("V1" int);

# Since we have not really bound the columns in the insert statement
# this test case cannot be enabled.
# statement error
# insert into "T2" (V1) values (1);

statement ok
insert into "T2" ("V1") values (1);

statement error
create tabke C1 (c1 varchar(5));