Changeset: de7cc94af449 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=de7cc94af449 Added Files: sql/test/BugTracker-2020/Tests/wrong-key-error.Bug-6983.test Branch: mtest Log Message:
add one more test diffs (27 lines): diff --git a/sql/test/BugTracker-2020/Tests/wrong-key-error.Bug-6983.test b/sql/test/BugTracker-2020/Tests/wrong-key-error.Bug-6983.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/wrong-key-error.Bug-6983.test @@ -0,0 +1,22 @@ +statement ok +start transaction + +statement ok +create table a (id int primary key) + +statement ok +insert into a values (1) + +statement ok +create table b (id int primary key) + +statement ok +create table c (a int references a(id), b int references b(id)) + +statement error 40002!INSERT INTO: FOREIGN KEY constraint 'c.c_b_fkey' violated +insert into c (a, b) values (1, 2) + +statement ok +rollback + + _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
