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

MyISAM allows CHECK constraint violation in ALTER TABLE

Details

    Description

      The test case added in
      MDEV-12389 ADD CHECK leaves an orphaned .par file
      fails in an unexpected way in 10.2.
      For InnoDB, the statement

      ALTER TABLE t1 ADD CHECK(b IN (0,1));
      

      fails as expected, because the column contains the values 0 and 10. However, MyISAM accepts the invalid constraint and only enforces it on subsequent DML operations.

      Attachments

        Issue Links

          Activity

            There are no comments yet on this issue.

            People

              serg Sergei Golubchik
              marko Marko Mäkelä
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.