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 | f4227a1adad5be299eb80dc4e5baab4ea46169b1 (patch) | |
| tree | cbcd34725bd070adeedbc699a79682ccb0dc3867 /tests/cst.ur | |
| parent | da10cbf6f232203ba7c798906ba8101078e2a9c9 (diff) | |
CHECK constraints
Diffstat (limited to 'tests/cst.ur')
| -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, |