Changeset: 7b5630309f11 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/7b5630309f11 Added Files: sql/test/2024/Tests/check.test Modified Files: sql/test/2024/Tests/All Branch: check Log Message:
add tests for check constraint diffs (32 lines): diff --git a/sql/test/2024/Tests/All b/sql/test/2024/Tests/All --- a/sql/test/2024/Tests/All +++ b/sql/test/2024/Tests/All @@ -1,2 +1,3 @@ groupby_primary_key_project_unique_key distinct_from +check diff --git a/sql/test/2024/Tests/check.test b/sql/test/2024/Tests/check.test new file mode 100644 --- /dev/null +++ b/sql/test/2024/Tests/check.test @@ -0,0 +1,20 @@ +statement ok +create table bar (i int, j int CHECK (j > 0)); + +statement ok +insert into bar values (1,10), (2, 20), (3, 30); + +statement error +update bar set j = -30 where i = 3; + +statement error +update bar set j = -j; + +statement error +insert into bar values (4, -40); + +statement ok +insert into bar select * from bar + +statement error +insert into bar select 4, -40; _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
