Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.0.26, 10.0, 10.1, 10.2.10, 10.2, 10.3, 10.4
-
Windows 10 64bit MyISAM engine.
Description
The table name in the sql file generated by mysqldump is in lowercase. This only happens if the command arguments include a table name. If run without specifying a table the case of the table names is preserved.
From looking at logs, it appears as if earlier versions used "show tables like ..." and the later versions use "select from information_schema.tables where table_name = ....".
Interestingly there is a different result between like and =
MariaDB [daves]> select table_name from information_schema.tables where table_schema = database() and table_name like 'BouncyCaps'; |
+------------+ |
| table_name |
|
+------------+ |
| BouncyCaps |
|
+------------+ |
1 row in set (0.00 sec) |
 |
MariaDB [daves]>
|
MariaDB [daves]> select table_name from information_schema.tables where table_schema = database() and table_name = 'BouncyCaps'; |
+------------+ |
| table_name |
|
+------------+ |
| bouncycaps |
|
+------------+ |
1 row in set (0.00 sec) |
Attachments
Issue Links
- relates to
-
-
- Confirmed
-