Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7563

Support CHECK constraint as in (or close to) SQL Standard

    Details

      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

            Activity

              People

              • Assignee:
                monty Michael Widenius
                Reporter:
                serg Sergei Golubchik
              • Votes:
                11 Vote for this issue
                Watchers:
                15 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: