Bug #51506 Foreign key data type does not update

• Submitted: 25 Feb 2010 14:15
• Modified: 23 Jun 2013 2:26
• Reporter: Mary Ramirez
• Status: Duplicate
• Category: MySQL Workbench: Modeling
• Severity: S3 (Non-critical)
• Version: 5.1.18
• OS: Windows (XP)
• CPU Architecture: Any

[25 Feb 2010 14:15] Mary Ramirez

Description:
What I did:
Once the model was created, I changed the primary key data type.

What I wanted to happen:
All foreigns key updated to the new data type.

Whatactually happened:
The foreigns key were no updated, I had to delete the relations and create them again.

How to repeat:
Create 2 tables.
Assing Primary Key.
Create a relation between the tables.
Change the primary key data type on the source table.

Suggested fix:
Once the primary key data type is changed, update all relations with this table.

[25 Feb 2010 14:47] MySQL Verification Team

Thank you for the bug report.

[25 Feb 2010 18:08] Johannes Taxacher

theres no feature like that in WB that updates details like this.
we will keep that as feature request.
This could be solved by writing a lua/python module which does such updates on demand.

[23 Jun 2013 2:26] Alfredo Kojima

Duplicate of request/bug#38801