Bug #23039 feature request: lower_case_table_names should default to 2 on all OS'es
Submitted: 6 Oct 2006 3:24 Modified: 7 Oct 2006 9:59
Reporter: Morgan Tocker Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: General Severity:S4 (Feature request)
Version:5.1+ OS:Any
Assigned to: CPU Architecture:Any
Triage: Triaged: D5 (Feature request)

[6 Oct 2006 3:24] Morgan Tocker
Description:
On Windows (or operating systems that do not have case sensitive filesystems), MySQL defaults to creating tables in lower case.  On Linux, the default is case sensitive.

Is there a reason why the defaults on all operating systems don't have lower_case_table_names=2?  If this behaviour was changed, it would mean fewer compatibility issues for novice users in replication, etc.

It may mean a small performance hit, but that could be reversed by setting lower_case_table_names back to something else in an options file.

How to repeat:
See Description.
[7 Oct 2006 9:59] Valeriy Kravchuk
Thank you for a reasonable feature request.