# Test creating unique index
---
- CreateTable: t (
     id INT NOT NULL PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
     value VARCHAR(255))
---
- Statement: CREATE UNIQUE INDEX t_value ON t(value)
---
- Statement: INSERT INTO t VALUES(1, 'foo')
---
- Statement: INSERT INTO t VALUES(2, 'bar')
---
- Statement: INSERT INTO t VALUES(3, 'foo')
- error: [23501]
...
Add an IT for that.
Add an IT for that.
