Version: MySQL v. 3.23.40 (Windows NT)
Hello,
I would like MySQL to preserve the case of my table names and therefore I have set
lower_case_table_names=0 in my configuration. I use Windows NT.
This works fine for CREATE TABLE statements but the moment I use a ALTER TABLE
statement the name of the table will be converted to lowercase. My conclusion is that
CREATE TABLE respects lower_case_table_names but ALTER TABLE does not and this seems
like a bug to me?
See example:
mysql> create table MyTable (x char(1));
mysql> show tables from test;
+----------------+
| Tables_in_test |
+----------------+
| MyTable |
+----------------+
mysql> alter table MyTable add (y char(1));
mysql> show tables from test;
+----------------+
| Tables_in_test |
+----------------+
| mytable |
+----------------+
If this is not a bug how do I then get MySQL to be case-preserving for the table names?
Hope somebody can help.
Lars Bruun Hansen
Denmark
