statement ok
create table t(id int primary key, v1 int, v2 int, v3 int);

statement ok
create index index_1 on t (v1);

statement ok
create index if not exists index_1 on t (v1);

statement error
create index index_1 on t (v1);

statement ok
create index index_2 on t (v1, v2);

statement ok
create unique index index_3 on t (v2, v3);

statement ok
insert into t values (0, 0, 0, 0);

statement error
insert into t values (1, 1, 0, 0);

query IIII
select * from t;
----
0 0 0 0

statement ok
drop index t.index_1

statement ok
drop index t.index_2

statement error
drop index t.pk_index

statement error
drop index t.index_3

statement ok
drop table t