MySQL Bugs: #48707: MySQL Migration Toolkit copies only a part of long identifiers names

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

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.

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