Bug #3128 lower_case_table_names is ignored on Windows XP

• Submitted: 9 Mar 2004 23:39
• Modified: 10 Mar 2004 9:21
• Reporter: Denis Sodol
• Status: Not a Bug
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 4.1.1a-alpha
• OS: Windows (Windows XP)
• Assigned to: Dean Ellis
• CPU Architecture: Any

[9 Mar 2004 23:39] Denis Sodol

Description:
The variable is completely ignored when I'm trying to start the server.
mysqladmin also shows that the variable has the value "ON" instead of a number.
The command lines I tried are below.

C:\Misc\mysql-4.1.1a-alpha\bin>mysqld-nt.exe --console --lower_case_table_names=2              10:35
040310 10:21:52  Warning: Setting lower_case_table_names=1 becasue file system C:\Misc\mysql-4.1.1a-
alpha\data\ is case insensitive

C:\Misc\mysql-4.1.1a-alpha\bin>mysqld-nt.exe --console --lower_case_table_names=0
040310 10:33:33  Warning: Setting lower_case_table_names=1 becasue file system C:\Misc\mysql-4.1.1a-
alpha\data\ is case insensitive

How to repeat:
see description

[10 Mar 2004 9:21] Dean Ellis

lower_case_table_names=2 was added in 4.0.18, which was released after 4.1.1a; support for it exists in 4.1.2 and will of course appear in that release.

[10 Mar 2004 20:49] Denis Sodol

But lower_case_table_names=0 doesn't work, too. It _was_ working in 4.1.0.

C:\Misc\mysql-4.1.1a-alpha\bin>mysqld-nt.exe --console
--lower_case_table_names=0

040310 10:33:33  Warning: Setting lower_case_table_names=1 becasue file
system C:\Misc\mysql-4.1.1a-

alpha\data\ is case insensitive