Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Constraint checking without error reporting #3335

Closed
monetdb-team opened this issue Nov 30, 2020 · 0 comments
Closed

Constraint checking without error reporting #3335

monetdb-team opened this issue Nov 30, 2020 · 0 comments
Labels
enhancement New feature or request SQL

Comments

@monetdb-team
Copy link

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:

Added test for bug #3335.

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:

check-constraint.Bug-3335: fixed expected stable output

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:

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

See: https//devmonetdborg/hg/MonetDB?cmd=changeset;node=7c11c29d7774
See also bug #3568 comment 4.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request SQL
Projects
None yet
Development

No branches or pull requests

2 participants