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

Dropping primary key column from versioned table always fails with 1072

    XMLWordPrintable

    Details

      Description

      Example code:

      CREATE TABLE abc (a INT NOT NULL, b INT NOT NULL, PRIMARY KEY (b)) WITH SYSTEM VERSIONING;

      We now have a table with one primary key. Dropping column 'a' is no problem, but dropping column 'b' always fails with error code 1072.

      SET SESSION system_versioning_alter_history=KEEP; 
      ALTER TABLE abc DROP COLUMN b;

        Attachments

          Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25327 Unexpected ER_DUP_ENTRY upon dropping PK column from system-versioned table

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11114 Cannot drop column referenced by CHECK constraint

          • 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

            Activity

              People

              Assignee:
              midenok Aleksey Midenkov
              Reporter:
              user2180613 Remy Fox
              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.