Details
Major
Description
Test case for MySQL "Bug#21317: SHOW CREATE DATABASE does not obey to lower_case_table_names" fails in 10.0.
Test diff attached. Please try to apply test case as is unless it is applicable.
Gliffy Diagrams
Attachments
Issue Links
- is part of
-
MDEV-4784 merge test cases from 5.6
-
- Stalled
-
- links to
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
lower_case_table_names should work identically for directories as it does for file names.
This means that the proposed patch is wrong, as for lower_case_table_names=1 the database should be shown in lower case.
Now fixed in my tree. Will merge it to 10.0 ASAP
Other things fixed by same patch:
SHOW CREATE DATABASE will now show correct information, even if you have two databases with same characters but mixed case (like foo and FOO).
SELECT DATABASE() will not convert the database name to lower case if lower_case_table_names=2
Sergei pushed this into 10.0, but we got some failing test for this, so there is more to fix.
Will target to enable this for next 10.0 release
Michael Widenius, let's create a new issue for whatever new failures you have found.
I'm not sure the fix is correct and not even what is the bug here. The bug report talks about lower_case_table_names=2, the test case is for lower_case_table_names=1, code change (in 5.6) deals with both. It's not obvious that for lower_case_table_names=1 the letter case should be preserved in SHOW.