Bug #64110 WB requires a separate option for the index names much like the FK pattern

• Submitted: 23 Jan 2012 13:00
• Modified: 23 Jan 2012 15:00
• Reporter: Karsten Wutzke
• Status: Verified
• Category: MySQL Workbench: Modeling
• Severity: S4 (Feature request)
• Version: 5.2.37
• OS: Any
• CPU Architecture: Any

[23 Jan 2012 13:00] Karsten Wutzke

Description:
In newer MySQL versions it's no longer possible to have the same names for foreign keys and indexes. Please see

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

and the respective forum reference:

http://forums.mysql.com/read.php?10,507796,507796

As such, it's no longer possible to reliably derive index names from the FK pattern given in the options, e.g. when using plugins like

http://www.kawoolutions.com/Projects/Constraint_Name_Generator

and others.

How to repeat:
see desc

Suggested fix:
Add an option like the FK pattern that would use "idx" or similar instead of "fk" as prefixes/suffixes.

[23 Jan 2012 15:00] Valeriy Kravchuk

Thank you for the feature request.