Bug #22192 Table names forced to lowercase
Submitted: 9 Sep 2006 12:53 Modified: 12 Sep 2006 8:30
Reporter: Dan Kloke (Candidate Quality Contributor) Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Migration Toolkit Severity:S3 (Non-critical)
Version:1.0.25 OS:Windows (Win2000)
Assigned to: CPU Architecture:Any
Tags: table name case upper lower uppercase lowercase

[9 Sep 2006 12:53] Dan Kloke 
Description:
Table names seem to be forced to lowercase during migrations. This can break queries and stored procedures.

How to repeat:
Create a table whose name contains uppercase characters:

create table TeSt (id integer unsigned auto_increment not null, primary key id(id), txt varchar(45));

Migrate the table (MySQL to MySQL). The migrated table is named "test".

Suggested fix:
Don't change the case of table names during migration script creation.
[12 Sep 2006 8:30] Sveta Smirnova 
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Read also http://dev.mysql.com/doc/refman/5.0/en/name-case-sensitivity.html