12 lines
371 B
Text
12 lines
371 B
Text
statement ok
|
|
CREATE TABLE myschema.mytable (one BIGINT NOT NULL, two BIGINT, PRIMARY KEY(one));
|
|
|
|
statement ok
|
|
CREATE INDEX mytable__idx__two ON myschema.mytable (two) NULLS NOT DISTINCT;
|
|
|
|
statement ok
|
|
INSERT INTO myschema.mytable (one, two) VALUES (1, 2);
|
|
|
|
# This would be forbidden by a `UNIQUE` index
|
|
statement ok
|
|
INSERT INTO myschema.mytable (one, two) VALUES (2, 2);
|