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

Table name gets converted to lower case when dropping an index

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Confirmed (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 5.5, 10.0, 10.1, 10.1.23, 10.2
    • Fix Version/s: 10.2
    • Component/s: Platform Windows, Server
    • Labels:
    • Environment:
      Windows 7, 64Bit,
      lower_case_table_names=2,
      Engine=MyISAM,
      MariaDB 10.1.23

      Description

      On a MariaDB server on Windows with lower_case_table_names=2 (i.e. names are stored as declared, but compared in lowercase), table names get converted to lowercase when dropping an index. The following two SQL statements reproduce the issue:

      CREATE TABLE `TestTable` (`TestColumn` INT NULL, INDEX `TestIndex` (`TestColumn`)) ENGINE=MyISAM;
      DROP INDEX `TestIndex` ON `TestTable`;

      After the first line is executed, a table called "TestTable" exists.
      After the second line is executed, the table is renamed to "testtable".

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              mniemeier Martin Niemeier
              Votes:
              1 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.