Bug #33169 mysqld --help : lowercase_table-name bad advice
Submitted: 12 Dec 2007 15:40 Modified: 12 Dec 2007 18:21
Reporter: Carsten Pedersen Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DML Severity:S3 (Non-critical)
Version:5.1.22 OS:Windows
Assigned to: CPU Architecture:Any

[12 Dec 2007 15:40] Carsten Pedersen
Description:
running mysqld --help, I get

--lower_case_table_names[=#]
  If set to 1 table names are stored in lowercase on disk
  and table names will be case-insensitive.  Should be set
  to 2 if you are using a case insensitive file system

Two Problems here:

1) Tells me what happens if I set l_c_t_n=1, then proceeds to advice me to set it to 2 (I'm on Windows) without offering any explanation as to why. Explanation should be provided.

2) Reading the docs, setting l_c_t_n=2 is in fact inadvisable if you may expect to move the server installation to another platform in the future.

How to repeat:
run mysqld --help

Suggested fix:
(1) Explain what settings =0 and =2 do; (2) don't advise a setting of =1.
[12 Dec 2007 15:41] Carsten Pedersen
Suggested fix should of course be:

(1) Explain what settings =0 and =2 do; (2) don't advise a setting of =2.
[12 Dec 2007 18:21] Valeriy Kravchuk
Thank you for a bug report. Verified just as described.
[13 Dec 2007 12:06] Peter Laursen
IMHO opinion this does not matter much as long as this bug
http://bugs.mysql.com/bug.php?id=20356

... is still open! And has been for about 2 years!

'lower_case_table_names' worked properly with MySQL 4.0.  Starting from 4.1 it never did!