Bug #67642 to many keys specified
Submitted: 19 Nov 2012 22:22 Modified: 20 Dec 2012 18:53
Reporter: Peter Volk (Basic Quality Contributor) Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: Migration Severity:S2 (Serious)
Version:5.2.44 CE OS:Windows
Assigned to: CPU Architecture:Any
Tags: Migration MSSQL

[19 Nov 2012 22:22] Peter Volk
Description:
When migrating a table with a very wide key then the workbench creates an invalid create table statement instead of issuing a warning during reverse engineering. 

How to repeat:
1. Create a table with 18 columns in a MSSQL database. 
2. use the migration feature of the workbench to migrate this table
3. After the source system is analysed the system creates an invalid create table statement since MySQL does not support the creation of indexes with more than 16 columns

Suggested fix:
Send a warning to the user during source system analysis that the migration will fail.
[20 Nov 2012 18:53] MySQL Verification Team
Thank you for the bug report. Please provide the create table sql command for the MSSQL which migration tool failed to migrate. Thanks.
[21 Dec 2012 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".