| Bug #7872 | incorrect handling of lower_case_table_names | ||
|---|---|---|---|
| Submitted: | 13 Jan 2005 13:21 | Modified: | 16 Feb 2005 7:48 |
| Reporter: | bruno haleblian | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Administrator | Severity: | S3 (Non-critical) |
| Version: | 1.0.18 | OS: | Windows (Win XP/2000) |
| Assigned to: | Alfredo Kojima | CPU Architecture: | Any |
[13 Jan 2005 13:26]
bruno haleblian
<checkbox position="1" id="lower_case_table_names" ... is not part of the fix and must be removed
[16 Feb 2005 7:48]
Alfredo Kojima
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.
If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information
about accessing the source trees is available at
http://www.mysql.com/doc/en/Installing_source_tree.html
Description: lower_case_table_names allowed values are 0,1 and 2 (since 4.0.18) but it's still handled as a boolean checkbox in Administrator UI. This is serious because it silently changes the manually-set parameter value. How to repeat: manually add lower_case_table_names=2 in your mi.cnf, then run Administrator to change any other value, and look into your my.ini again... the fix I suggest is just for having it to work but it needs refining : - Default value is platform dependent - Description is shorty. another file has to be patched (transltions or something to get correct comments in my.in file. I may work on this later, justy let me know if interrested. Suggested fix: I've patched .../XML/mysqladmin_startup_variables_description.xml to get it working : replace : <checkbox position="1" id="lower_case_table_names"> <caption>Make table names case insensitive</caption> <default_value>Unchecked</default_value> <description>If set to 1 table names are stored in lowercase on disk and table names will be case-insensitive.</description> </checkbox> with : <dropdownbox position="1" id="lower_case_table_names" version_start="4.0.18"> <caption>Case sensitivity</caption> <default_value>0</default_value> <description>Handles filenames conversion and case comparison for TABLES, DATABASES ans ALIAS (chapter 9.2.2 in current doc)</description> <items> <item>Store FileNames as is=0</item> <item>Store FileNames in lowercase=1</item> <item>Store FileNames as is + lwc comparison=2</item> </items> </dropdownbox> <checkbox position="1" id="lower_case_table_names" version_end="4.0.17">