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

Dropping column from table that is part of a key fails in 10.2.8

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.2.8
    • N/A
    • Documentation
    • None
    • Docker version 17.06.0-ce, build 02c1d87 running on OSX 10.12.4 (16E195)
      Docker image SHA: 801ba73f78da191339d1cf2acdb98f2ea6fe2d38974e838a4a5f1535563e4ed7

    Description

      In the 10.2.8 update the following script will fail. When testing against 10.2.7 it will not fail indicating a regression between bugfix versions.

      Test Case

      create table X (
        A int,
        b int,
        primary key (A,B)
      );
       
      ALTER TABLE X DROP COLUMN A;
      

      Expected Result

      The column is dropped from the table

      Actual Result

      An error is returned

      [42000][1072] Key column 'A' doesn't exist in table
      

      In 10.2.7 docker, as specified by the sha 8ea33570152349b827d7121b88dc3f44a64e1cc7646cfae01faee4824b9b0007 the above script will work and drop the column.

      Attachments

        Issue Links

          Activity

            People

              greenman Ian Gilfillan
              pathompson Paul Thompson
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.