Case-sensitivity of table name is broken after an unique index is created.
Posted by: Shigeru Nakagaki
Date: February 18, 2012 12:11AM

Hello

I added "lower_case_table_names=2" to my.ini (MySQL 5.5, Windows 7 64bit)
And I executed sql files.
Then I found that the case-sensitivity was not kept for some tables.
I tested sql and found the source of this trouble.

DROP TABLE IF EXISTS Hoge;
CREATE TABLE Hoge (
id VARCHAR(32) PRIMARY KEY,
foo VARCHAR(32) NOT NULL,
bar VARCHAR(32) NOT NULL
);
/* at this time, table name is 'Hoge' in INFORMATION_SCHEMA.TABLES. */

CREATE UNIQUE INDEX unique_foobar ON Hoge (foo, bar);
/* then, table name is 'hoge' in INFORMATION_SCHEMA.TABLES. */


Is this a bug? Or there is a workaround?

thanks

Shigeru Nakagaki

Options: ReplyQuote


Subject
Views
Written By
Posted
Case-sensitivity of table name is broken after an unique index is created.
6861
February 18, 2012 12:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.