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

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 5.5, 10.0, 10.1, 10.1.23, 10.2
    • 10.2
    • Platform Windows, Server
    • 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

              Unassigned Unassigned
              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.