Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
Compatibility-1
Description
Support CHECK constraint as in (or close to) SQL Standard.
The following syntaxes will be supported (they are already supported by the current MariaDB parser, but does nothing):
As part of column definition:
CREATE TABLE t1 (a int check (A > 10));
As an independent constraint:
CREATE TABLE t1 (a int, constraint `A` CHECK (A > 10));
ALTER TABLE DROP CONSTRAINT `A`;
Attachments
Issue Links
- causes
-
MDEV-16331 Support instant DROP CHECK CONSTRAINT
- Closed
- is part of
-
MDEV-10137 Providing compatibility to other databases
- Open
- relates to
-
MDEV-11114 Cannot drop column referenced by CHECK constraint
- Closed
-
MDEV-11115 CHECK constraints are not shown in I_S.TABLE_CONSTRAINTS
- Closed
-
MDEV-11117 CHECK constraint fails on intermediate step of ALTER
- Closed
-
MDEV-12890 constraint name in column constraints
- Confirmed
-
MDEV-17323 Backport INFORMATION_SCHEMA.CHECK_CONSTRAINTS to 10.2
- Closed
-
MDEV-13596 CHECK constraints disallow NULL to pass through, violating SQL
- Closed