Bug #92773 | lower_case_table_names description is badly worded | ||
---|---|---|---|
Submitted: | 13 Oct 2018 3:43 | Modified: | 30 Oct 2018 22:38 |
Reporter: | Guest User | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL for Windows: Installer | Severity: | S3 (Non-critical) |
Version: | 1.4.27.0 | OS: | Windows (10) |
Assigned to: | CPU Architecture: | Any |
[13 Oct 2018 3:43]
Guest User
[13 Oct 2018 3:43]
Guest User
The screenshot
Attachment: Screenshot.png (image/png, text), 25.74 KiB.
[13 Oct 2018 14:10]
MySQL Verification Team
Thank you for the bug report.
[23 Oct 2018 22:16]
Javier TreviƱo
Posted by developer: Updated the help comments in template files for the lower_case_table_names variable. The text matches the online documentation.
[26 Oct 2018 13:21]
Michael B
The same situation seems to be the case for installing mysql 5.6.28. Steps to reproduce: 1. try to install mysql 5.6.28 through Mysql for Windows gui or MysqlInstallerConsole, 2. See that installing hangs on "starting server". 3. Stop installation 4. Check windows logs, see mention of: C:\xplan\mysql\bin\mysqld.exe: Error while setting value '0.0' to 'lower_case_table_names' 5. Change my.ini lower_case_table_names from 0.0 to 0 6. Start server 7. Check windows logs, see mention of: The server option 'lower_case_table_names' is configured to use case sensitive table names but the data directory is on a case-insensitive file system which is an unsupported combination. Please consider either using a case sensitive file system for your data directory or switching to a case-insensitive table name mode. 8. Uncomment lower_case_table_names 9. Start server 10. See that server is started. Expected behaviour: -No lower_case_table_names in my.ini or lower_case_table_names=2. The option has not always been there since previously installation went correctly. Where do the template my.ini's come from and are they adjustable so that we can do automatic installs again through MysqlInstallerConsole of 5.6.28 again? Thanks
[26 Oct 2018 13:23]
Michael B
I may have interpreted the original bug wrong. Will post my issue as a seperate bug.
[30 Oct 2018 22:38]
Christine Cole
Posted by developer: Fixed as of the upcoming MySQL Installer 1.4.28 release, and here's the changelog entry: The templates that MySQL Installer uses to generate the my.ini file now include improved comments for the lower_case_table_names server system variable that can be configured only when initializing the server. On Windows the default value is lower_case_table_names=1. Thank you for the bug report.