Bug #35265 Export to Alter Script fails to recognize all differences
Submitted: 13 Mar 2008 11:29 Modified: 8 Apr 2008 14:27
Reporter: Jens Bremmekamp Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:5.0.14a Beta OSS OS:Windows (XP SP2)
Assigned to: Vladimir Kolesnikov CPU Architecture:Any
Tags: alter script, diff, export, workbench

[13 Mar 2008 11:29] Jens Bremmekamp 
Description:
When deleting an foreign key relation between two innoDB tables and setting it up again the other way round, the export to "Alter" script wizard only recognizes the removal of the first relationship but not the newly added foreign key.

(On a sidenote all my foreign key relations were duplicated after selecting the input file in the export to "alter" script wizard, too.)

How to repeat:
Set up two innoDB tables in a EERD, create FK relation from table A to table B, export to "Create" script (with "Drop Tables" enabled, don't know if it matter but I had it on).

Delete FK relation, set up new foreign key from B to A, export to "Alter" script. The diff view should only show the removal of the first FK, not the newly created one.
[14 Mar 2008 5:28] Valeriy Kravchuk 
Thank you for a bug report. Verified just as described.
[3 Apr 2008 8:43] Johannes Taxacher 
this works correct now (tested in SVN Rev 2931)
[8 Apr 2008 14:27] MC Brown 
A note has been added to the 5.0.17 changelog: 

When modifying an existing foreign key relationship, the generated ALTER script did not reflect the modification.