diff options
| author |  Adam Chlipala <adamc@hcoop.net> | 2009-04-09 15:30:15 -0400 |
|---|---|---|
| committer | Adam Chlipala <adamc@hcoop.net> | 2009-04-09 15:30:15 -0400 |
| commit | 8f29d5ead0c09b99291f729001e6aabd24d8aa8c (patch) | |
| tree | cbcd34725bd070adeedbc699a79682ccb0dc3867 /tests | |
| parent | 1852c67500474c5170a0b666ca68591dbbc29df3 (diff) | |
CHECK constraints
Diffstat (limited to 'tests')
| -rw-r--r-- | tests/cst.ur | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/tests/cst.ur b/tests/cst.ur index 2db083f7..a0ccf539 100644 --- a/tests/cst.ur +++ b/tests/cst.ur @@ -1,7 +1,11 @@ -table u : {C : int, D : int, E : option int} +table u : {C : int, D : int, E : option int, F : string} PRIMARY KEY C, CONSTRAINT U UNIQUE (C, D), - CONSTRAINT U2 UNIQUE E + CONSTRAINT U2 UNIQUE E, + + CONSTRAINT Pos CHECK D > 0, + CONSTRAINT NoNo CHECK C + D <> 2, + CONSTRAINT Known CHECK F = "_E = 6" table t : {A : int, B : int, C : option int} PRIMARY KEY B, |