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

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.2.8
    • Fix Version/s: N/A
    • Component/s: Documentation
    • Labels:
      None
    • Environment:
      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

              • Assignee:
                greenman Ian Gilfillan
                Reporter:
                pathompson Paul Thompson
              • Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: