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:
Category:MySQL Server: General Severity:S4 (Feature request)
Version:5.1+ OS:Any
Assigned to: CPU Architecture:Any

[6 Oct 2006 3:24] Morgan Tocker
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.