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:
None 
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
Description:
The my.ini file generated by the installer has a badly worded lower_case_table_names summary.

How to repeat:
Look at the my.ini after installation and look for the areas indicated in the screenshot. MySQL 8 only - this was not available in 5.7 or older.

Suggested fix:
Implement the annotated suggestions.
[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.