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

Fail to drop CHECK constraint

    XMLWordPrintable

Details

    • Bug
    • Status: In Review (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.4, 10.11.2, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10, 10.11
    • 10.4, 10.5, 10.6, 10.11
    • Server
    • None

    Description

      Run the following statements, you will see the last statement fails to drop the CHECK constraint, and reports an error ` Can't DROP CONSTRAINT `c1`; check that it exists`

      DROP TABLE IF EXISTS t0;
      CREATE TABLE t0 (c1 INT CHECK ( c1 > 0 ));
      SELECT CONSTRAINT_NAME, TABLE_NAME, CONSTRAINT_TYPE FROM information_schema.TABLE_CONSTRAINTS WHERE TABLE_NAME = 't0' AND TABLE_SCHEMA = 'test';
      ALTER TABLE t0 DROP CONSTRAINT c1;
      

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              John Jove John Jove
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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