Bug #48707 MySQL Migration Toolkit copies only a part of long identifiers names
Submitted: 11 Nov 2009 23:09 Modified: 11 Nov 2009 23:14
Reporter: Gian Franco Zabarino Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Migration Toolkit Severity:S2 (Serious)
Version:1.1.17 OS:Windows (XP SP3)
Assigned to: CPU Architecture:Any
Tags: migration toolkit cut identifier name key convert migrate

[11 Nov 2009 23:09] Gian Franco Zabarino
Description:
The MySQL Migration Toolkit cut long identifiers names, I have a +200 tables MS SQL 2005 DB, with a lot of keys whose identifiers are very long, for example, 41 characters. For a key named "acCartasDePorte__porLocalidadDestinatario", when it convert the name to the new MySQL DB, it only shows "acCartasDePorte__porLocalidadDe". I found out that the maximum length of a key identifier is 64 bytes, so I don't understand why this is happening. I can fix the names that comes with duplicate key error, but there are a lot that don't throw any error at all, and yet they are cut. 

I'm using MySQL 5.1.30-community

How to repeat:
Try to create a sample DB in MS SQL Server 2005, with a key name as mentioned above, and try to migrate it to a MySQL Server with MySQL Migration Toolkit.

Suggested fix:
I think that the maximum length of a identifier should be as documented, someone should take a look at that part of the code of MySQL Migration Toolkit.
[11 Nov 2009 23:16] MySQL Verification Team
Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

http://bugs.mysql.com/bug.php?id=48706