15 lines
438 B
Text
15 lines
438 B
Text
statement ok
|
|
CREATE TABLE myschema.mytable (one BIGINT NOT NULL, two BIGINT, PRIMARY KEY(one));
|
|
|
|
statement ok
|
|
CREATE UNIQUE INDEX mytable__idx__two ON myschema.mytable (two) NULLS NOT DISTINCT;
|
|
|
|
statement ok
|
|
INSERT INTO myschema.mytable (one, two) VALUES (1, 2);
|
|
|
|
statement ok
|
|
DELETE FROM myschema.mytable;
|
|
|
|
# This can now succeed since the conflicting row was removed.
|
|
statement ok
|
|
INSERT INTO myschema.mytable (one, two) VALUES (2, 2);
|