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

            Transition Time In Source Status Execution Times
            Sergei Golubchik made transition -
            Open In Progress
            		150d 36m 1
            Sergei Golubchik made transition -
            Closed Stalled
            		117d 6h 27m 1
            Sergei Golubchik made transition -
            Stalled In Progress
            		19d 1h 10m 1
            Sergei Golubchik made transition -
            In Progress Stalled
            		1h 31m 2
            Sergei Golubchik made transition -
            Stalled Closed
            		8d 16h 36m 2

            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.