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

Impossible to drop primary key in certain circumstances

Details

    Description

      Dropping primary key in some cases fails because of foreign constraints on the table of the primary key, which makes no sense.

      Test case:

      create table test_a (id int primary key);
      		 
      create table test_b (id int primary key);
      		 
      create table test_a_b (a int not null,
      		 
                             b int not null,
      		 
                             constraint ref_a foreign key (a) references test_a (id),
      		 
                             constraint ref_b foreign key (b) references test_b (id));
      		 
      alter table test_a_b add constraint a_b_pk primary key (a, b);
      		 
      alter table test_a_b drop primary key;

      Note that the first four statements succeed, which means that both states without and with primary key on `test_a_b` are consistent. However, the last statement fails. In other words, the database doesn't let me to go from one consistent state to another.

      Attachments

        Issue Links

          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-16417 Store Foreign Key metadata outside of InnoDB

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17187 table doesn't exist in engine after ALTER other tables with CONSTRAINTs

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

          Activity

            Ascending order - Click to sort in descending order
            doublep Paul Pogonyshev created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Component/s Storage Engine - InnoDB [ 10129 ]
            Fix Version/s N/A [ 14700 ]
            Assignee Marko Mäkelä [ marko ]
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            serg Sergei Golubchik made changes -
            Fix Version/s N/A [ 14700 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 10.5 [ 23123 ]
            serg Sergei Golubchik made changes -
            Assignee Marko Mäkelä [ marko ] Oleksandr Byelkin [ sanja ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 89200 ] MariaDB v4 [ 140909 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.3 [ 22126 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.4 [ 22408 ]

            People

              sanja Oleksandr Byelkin
              doublep Paul Pogonyshev
              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.