Bug #90715 MySQL Installer should have an option to specify lower_case_table_names
Submitted: 2 May 2018 8:38 Modified: 15 May 2018 15:48
Reporter: Peter Laursen (Basic Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL for Windows: Installer Severity:S2 (Serious)
Version:1.4.25.0 (current) OS:Windows
Assigned to: CPU Architecture:Any

[2 May 2018 8:38] Peter Laursen 
Description:
With refernece to this report https://bugs.mysql.com/bug.php?id=90695 where the conclusion was that "So "lower_case_table_names" needs to be set together with --initialize", this option is missing in the MySQL installer for Windows 

How to repeat:
1) Install MySQL 8.0 using the Installer
2) CREATE and USE some database
3) CREATE TABLE `MYSQL`( `id` INT );
4) SHOW TABLES -- displays the table as 'mysql'

"Camel Case" is widely used by Windows users in order to make scripts more readable an confirm with an organizatiuon's guidelines of lettercase use in code.

Suggested fix:
Add the option to the installer to initialize with lower_case_table_names setting supported on Windows ("1" and "2" according to https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html).
[2 May 2018 8:39] Peter Laursen 
This could be a 'showstopper' for upgrading users, BTW.
[2 May 2018 8:56] Peter Laursen 
an confirm with an organizatiuon's guidelines

>>

and *conform* with an organization's guidelines 
(obviously)
[2 May 2018 10:39] Chiranjeevi Battula 
Hello Peter,

Thank you for the bug report.
Verified based on internal discussion with dev's.

Thanks,
Chiranjeevi.
[2 May 2018 11:23] Peter Laursen 
Actually this option could be there when installing all server versions. Even if not necessary, it is still convenient.
[10 May 2018 20:33] Rafael Antonio Bedoy Torres 
Posted by developer:
 
Fixed on 1.4.26 build 1
[15 May 2018 15:48] Christine Cole 
Posted by developer:
 
Fixed as of the upcoming MySQL Installer 1.4.26 release, and here's the changelog entry:

The lower_case_table_names option now can be set with different values
during the server configuration (see Advanced Options). The default value
stores table names in lowercase on disk and comparisons are not case
sensitive.

Thank you for the bug report.