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: 2013-08-07 15:53:32 +0200
From: @mlkersten
To: SQL devs <>
Version: -- development
CC: martin.van.dinther, @njnes
Last updated: 2019-12-05 17:44:10 +0100
Comment 18978
Date: 2013-08-07 15:53:32 +0200
From: @mlkersten
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:22.0) Gecko/20100101 Firefox/22.0
Build Identifier:
Column constraints should lead to a transaction abort and a proper error message.
Reproducible: Always
Steps to Reproduce:
create table ary(x integer check(x >0 and x <2));
insert into ary values(1);
insert into ary values(0);
insert into ary values(2);
insert into ary values(-1);
insert into ary values(3);
drop table ary;
constraint_checking.Bug_3335: removed redundant test;
see also sql/test/BugTracker-2013/Tests/check-constraint.Bug-3335.*
Comment 27453
Date: 2019-12-05 17:44:10 +0100
From: Martin van Dinther <<martin.van.dinther>>
CHECK column constraint clause is no longer allowed as of Nov2019 release.
So SQL statement:
create table ary(x integer check(x >0 and x <2));
will now fail with error:
CONSTRAINT CHECK: check constraints not supported
Date: 2013-08-07 15:53:32 +0200
From: @mlkersten
To: SQL devs <>
Version: -- development
CC: martin.van.dinther, @njnes
Last updated: 2019-12-05 17:44:10 +0100
Comment 18978
Date: 2013-08-07 15:53:32 +0200
From: @mlkersten
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:22.0) Gecko/20100101 Firefox/22.0
Build Identifier:
Column constraints should lead to a transaction abort and a proper error message.
Reproducible: Always
Steps to Reproduce:
create table ary(x integer check(x >0 and x <2));
insert into ary values(1);
insert into ary values(0);
insert into ary values(2);
insert into ary values(-1);
insert into ary values(3);
drop table ary;
Expected Results:
Transaction abort message
Added as test case
Comment 19138
Date: 2013-09-06 15:37:18 +0200
From: MonetDB Mercurial Repository <>
Changeset 29124fc819a5 made by Sjoerd Mullender sjoerd@acm.org in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=29124fc819a5
Changeset description:
Comment 19210
Date: 2013-09-30 10:36:13 +0200
From: MonetDB Mercurial Repository <>
Changeset 9035bcb21e62 made by Stefan Manegold Stefan.Manegold@cwi.nl in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=9035bcb21e62
Changeset description:
Comment 19211
Date: 2013-09-30 10:39:08 +0200
From: MonetDB Mercurial Repository <>
Changeset 798a080e3bee made by Stefan Manegold Stefan.Manegold@cwi.nl in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=798a080e3bee
Changeset description:
Comment 27453
Date: 2019-12-05 17:44:10 +0100
From: Martin van Dinther <<martin.van.dinther>>
CHECK column constraint clause is no longer allowed as of Nov2019 release.
So SQL statement:
create table ary(x integer check(x >0 and x <2));
will now fail with error:
CONSTRAINT CHECK: check constraints not supported
See: https//devmonetdborg/hg/MonetDB?cmd=changeset;node=7c11c29d7774
See also bug #3568 comment 4.
The text was updated successfully, but these errors were encountered: