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
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
Attachments
Issue Links
- relates to
-
MDEV-12800 Table name gets converted to lower case when dropping an index
-
- Confirmed
-