Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
11.2.2
-
None
-
Windows 10 Pro x64
Description
I have "lower_case_table_names=2" in my.ini. When I create a table and specify its columns, the table is created with my requested capitalization. But when I create a table using "LIKE", the table is created an all lowercase name. In both cases, the columns have the correct case.
Run this script:
CREATE TABLE TestTableA (`ID` INT PRIMARY KEY,`Name` VARCHAR(255)); |
CREATE TABLE TestTableB LIKE TestTableA; |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_NAME LIKE 'TestTable%'; |
DESCRIBE TestTableA;
|
DESCRIBE TestTableB;
|
The result says:
+------------+
|
| TABLE_NAME |
|
+------------+
|
| TestTableA |
|
| testtableb |
|
+------------+
|
+-------+--------------+------+-----+---------+-------+
|
| Field | Type | Null | Key | Default | Extra |
|
+-------+--------------+------+-----+---------+-------+
|
| ID | int(11) | NO | PRI | NULL | |
|
| Name | varchar(255) | YES | | NULL | |
|
+-------+--------------+------+-----+---------+-------+
|
+-------+--------------+------+-----+---------+-------+
|
| Field | Type | Null | Key | Default | Extra |
|
+-------+--------------+------+-----+---------+-------+
|
| ID | int(11) | NO | PRI | NULL | |
|
| Name | varchar(255) | YES | | NULL | |
|
+-------+--------------+------+-----+---------+-------+
|
