MySQL Bugs: #9731: lower-case-table-names does not work as expected/documented

Bug #9731	lower-case-table-names does not work as expected/documented
Submitted:	7 Apr 2005 21:02	Modified:	8 May 2005 21:09
Reporter:	Raymond DeRoo	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	4.1.11	OS:	Windows (Windows)
Assigned to:		CPU Architecture:	Any

Description:
lower-case-table-names with a value of either 1 or 2 does not work as expected or stated in the manual, http://dev.mysql.com/doc/mysql/en/server-system-variables.html. At no point is a case insensitive match returned.

How to repeat:
C:\Program Files\MySQL\MySQL Server 4.1\bin>start mysqld-nt --console --standalone --lower-case-table-names=1

c:\mysql\bin>mysql -uroot ray
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.11-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create table UmYhT (id int);
Query OK, 0 rows affected (0.08 sec)

mysql> show tables;
+---------------+
| Tables_in_ray |
+---------------+
| umyht         |
+---------------+
1 row in set (0.00 sec)

mysql> show variables like "%case%";
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| lower_case_file_system | OFF   |
| lower_case_table_names | 1     |
+------------------------+-------+
2 rows in set (0.00 sec)

mysql> exit
Bye

c:\mysql\bin>mysqladmin shutdown -uroot

c:\mysql\bin>mysql -uroot ray
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.11-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create table MMnnMM (id int);
Query OK, 0 rows affected (0.08 sec)

mysql> show variables like "%case%";
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| lower_case_file_system | ON    |
| lower_case_table_names | 2     |
+------------------------+-------+
2 rows in set (0.00 sec)

mysql> show tables;
+---------------+
| Tables_in_ray |
+---------------+
| MMnnMM        |
| umyht         |
+---------------+
2 rows in set (0.00 sec)

mysql>

Looks like a duplicate of http://bugs.mysql.com/9761

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".