Status: Confirmed (View Workflow)
Affects Version/s: 5.5, 10.0, 10.1, 10.1.23, 10.2
Environment:Windows 7, 64Bit,
I am running a MariaDB server on Windows with lower_case_table_names=2 (i.e. names are stored as declared, but compared in lowercase).
If I create a new table using the "CREATE TABLE LIKE" statement, the capitalization
of the target table name is ignored and the lower case spelling is used instead.
The following two SQL statements reproduce the issue:
CREATE TABLE `TestTable` (`TestColumn` INT NULL, INDEX `TestIndex` (`TestColumn`)) ENGINE=MyISAM;
CREATE TABLE `AnotherTable` LIKE `TestTable`;
After execution, the second table is called "anothertable" in the database, not "AnotherTable" as expected.
Might be related to MDEV-12800