1
Fork 0
kantodb/testdata/sql/insert_conflict_primary_key.slt

15 lines
395 B
Text

statement ok
CREATE TABLE mytable (one BIGINT NOT NULL, two BIGINT NOT NULL, PRIMARY KEY(one));
statement ok
INSERT INTO mytable (one, two) VALUES (1, 2), (2, 2);
# TODO better error
statement error ^Execution error: execution/7kcekn13r9cwn: insert record: table_id=3: conflict on primary key$
INSERT INTO mytable (one, two) VALUES (1, 3);
query I rowsort
SELECT * FROM mytable;
----
1 2
2 2