[MDEV-12800] Table name gets converted to lower case when dropping an index Created: 2017-05-15  Updated: 2020-12-01

Status: Confirmed
Project: MariaDB Server
Component/s: Platform Windows, Server
Affects Version/s: 5.5, 10.0, 10.1, 10.1.23, 10.2
Fix Version/s: 10.2

Type: Bug Priority: Major
Reporter: Martin Niemeier Assignee: Unassigned
Resolution: Unresolved Votes: 1
Labels: upstream
Environment:

Windows 7, 64Bit,
lower_case_table_names=2,
Engine=MyISAM,
MariaDB 10.1.23


Issue Links:
Relates
relates to MDEV-12801 "Create table like" statement ignores... Confirmed

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



 Comments   
Comment by Elena Stepanova [ 2017-05-18 ]

Thanks for the report.

Reproducible on all of MariaDB 5.5-10.2 and MySQL 5.5-5.7.

Generated at Thu Feb 08 08:00:34 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.