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

Cannot drop column referenced by CHECK constraint

Details

    Description

      If a column check is defined as a separate constraint (not as a part of a column definition), the column cannot be dropped:

      MariaDB [test]> create table t1 (a int, b int, check(a>0));
      		 
      Query OK, 0 rows affected (0.63 sec)
      		 
       
      		 
      MariaDB [test]> show create table t1 \G
      		 
      *************************** 1. row ***************************
      		 
             Table: t1
      		 
      Create Table: CREATE TABLE `t1` (
      		 
        `a` int(11) DEFAULT NULL,
      		 
        `b` int(11) DEFAULT NULL,
      		 
        CONSTRAINT `CONSTRAINT_1` CHECK (a>0)
      		 
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1
      		 
      1 row in set (0.00 sec)
      		 
       
      		 
      MariaDB [test]> alter table t1 drop column a;
      		 
      ERROR 1054 (42S22): Unknown column 'a' in 'virtual column function'

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14738 Replication breaks when dropping a column of a combined primary key (with a confusing error message)

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Confirmed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13508 ALTER TABLE that renames columns and CHECK constraints

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-7563 Support CHECK constraint as in (or close to) SQL Standard

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13613 Dropping column from table that is part of a key fails in 10.2.8

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21097 Incorrect error message when trying to delete column which is part of unique key constraint

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24690 Dropping primary key column from versioned table always fails with 1072

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            elenst Elena Stepanova created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            serg Sergei Golubchik made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            serg Sergei Golubchik made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.2.5 [ 22117 ]
            Fix Version/s 10.2 [ 14601 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Resolution Fixed [ 1 ]
            Status Closed [ 6 ] Stalled [ 10000 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.2.5 [ 22117 ]
            serg Sergei Golubchik made changes -
            Summary Cannot drop column referenced by CHECK constraint: Unknown column 'a' in 'virtual column function' Cannot drop column referenced by CHECK constraint
            serg Sergei Golubchik made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            serg Sergei Golubchik made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Fix Version/s 10.2.8 [ 22544 ]
            Fix Version/s 10.2 [ 14601 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            marko Marko Mäkelä made changes -
            elenst Elena Stepanova made changes -
            alice Alice Sherepa made changes -
            midenok Aleksey Midenkov made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 78049 ] MariaDB v4 [ 151111 ]

            People

              serg Sergei Golubchik
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.