Contrainte CHECK non respectée
Salut,
c sans doute tres bete mais je n´arrive pas a implementer un check dans une table exemple....
Code:
1 2 3 4 5 6 7 8 9 10 11
|
mysql> CREATE TABLE foo (
-> id serial PRIMARY KEY,
-> price integer NOT NULL CHECK (price = 1 OR price = 2 OR price = 3)
-> );
Query OK, 0 rows affected (0.01 sec)
mysql> INSERT INTO foo (price) VALUES (3);
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO foo (price) VALUES (0);
Query OK, 1 row affected (0.00 sec) |
il ne devrait pas accepter la derniere insertion insertion...bizarre no?8O