Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.1.23, 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL)
-
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
- relates to
-
MDEV-12801 "Create table like" statement ignores capitalization
-
- Confirmed
-
- links to