You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Date: 2016-03-01 16:36:30 +0100
From: Robin Cijvat <<robin.cijvat>>
To: SQL devs <>
Version: 11.21.5 (Jul2015)
CC: @njnes
Last updated: 2016-03-25 09:59:43 +0100
Comment 21847
Date: 2016-03-01 16:36:30 +0100
From: Robin Cijvat <<robin.cijvat>>
User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.63 Safari/537.36
Build Identifier:
When a table references multiple other tables via mandatory (not null) foreign key constraints, and you try to insert a tuple that misses one of the two, the error message can state the wrong constraint name.
Reproducible: Always
Steps to Reproduce:
1.Open mclient and execute the following
create table t1 (
a int primary key
);
create table t2 (
b int primary key
);
create table t3 (
a int not null references t1 (a),
b int not null references t2 (b)
);
insert into t1 values (1);
insert into t2 values (1);
insert into t3 (b) values (1);
Date: 2016-03-01 16:36:30 +0100
From: Robin Cijvat <<robin.cijvat>>
To: SQL devs <>
Version: 11.21.5 (Jul2015)
CC: @njnes
Last updated: 2016-03-25 09:59:43 +0100
Comment 21847
Date: 2016-03-01 16:36:30 +0100
From: Robin Cijvat <<robin.cijvat>>
User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.63 Safari/537.36
Build Identifier:
When a table references multiple other tables via mandatory (not null) foreign key constraints, and you try to insert a tuple that misses one of the two, the error message can state the wrong constraint name.
Reproducible: Always
Steps to Reproduce:
1.Open mclient and execute the following
create table t1 (
a int primary key
);
create table t2 (
b int primary key
);
create table t3 (
a int not null references t1 (a),
b int not null references t2 (b)
);
insert into t1 values (1);
insert into t2 values (1);
insert into t3 (b) values (1);
Actual Results:
INSERT INTO: FOREIGN KEY constraint 't3.t3_b_fkey' violated
Expected Results:
INSERT INTO: FOREIGN KEY constraint 't3.t3_a_fkey' violated
Comment 21917
Date: 2016-03-16 15:56:21 +0100
From: MonetDB Mercurial Repository <>
Changeset c108eba2d5a4 made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=c108eba2d5a4
Changeset description:
Comment 21918
Date: 2016-03-16 16:09:47 +0100
From: @njnes
Fixed by checking the keys in the proper order
Comment 21973
Date: 2016-03-25 09:59:43 +0100
From: @sjoerdmullender
Jul2015-SP3 has been released.
The text was updated successfully, but these errors were encountered: