Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.2.13
-
None
-
Linux, n.a.
Description
Documentation here:
https://mariadb.com/kb/en/library/constraint/
seems to be wrong:
ALTER TABLE t1 ADD CHECK a_greater (a>b);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'a_greater (a>b)' at line 1
Correct is IMHO:
ALTER TABLE t1 ADD CONSTRAINT a_greaterx CHECK (a>b);
Query OK, 0 rows affected (0.10 sec)
Records: 0 Duplicates: 0 Warnings: 0