Bug #51580 WB on ERR model can create foreign key names largers

• Submitted: 27 Feb 2010 22:17
• Modified: 13 Jul 2013 3:28
• Reporter: jose juarez
• Status: Closed
• Category: MySQL Workbench: Modeling
• Severity: S4 (Feature request)
• Version: 5.2.16 @5249, 5.2.33
• OS: Any
• CPU Architecture: Any
• Tags: error create table, foreign key, foreign key names length

[27 Feb 2010 22:17] jose juarez

Description:
sorry for my english in advance

on ERR model:
Create two tables with large name tables ang create N:M relationship
then is created a foreign key name too large, 

and when you go to Synchronize model or forward enginyering an execute on your server script fails (error can't create table)

feature request:

   - check for foreign key names length when autocreating
   - check posible name collision with others foreign key names.

I think would be a nice feature.

thanks

How to repeat:

on ERR model:
Create two tables with large name tables ang create N:M relationship
then is created a foreign key name too large, 

and when you go to Synchronize model or forward enginyering an execute on your server script fails (error can't create table)

Suggested fix:

   - check for foreign key names length when autocreating
   - check posible name collision with others foreign key names.

[28 Feb 2010 16:16] Valeriy Kravchuk

Thank you for the feature request.

[17 Mar 2011 11:02] Valeriy Kravchuk

Bug #60504 was marked as a duplicate of this one.

[13 Jul 2013 3:28] Alfredo Kojima

This was implemented already ,during 5.2 series