Bug #47063 Bug using the Foward Engineer SQL ALTER Script

• Submitted: 2 Sep 2009 13:07
• Modified: 26 Nov 2009 11:52
• Reporter: Juergen Cramer
• Status: Closed
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 5.2.2 Alpha
• OS: Windows (Windows XP SP3)
• Assigned to: Alexander Musienko
• CPU Architecture: Any
• Tags: alter script

[2 Sep 2009 13:07] Juergen Cramer

Description:
There is a bug creating a Forward Engineer SQL ALTER Script and the same in Synchronize with SQL Create Script. These functions finds differences in some SQL Create Scripts to MySQL Workbench files although the SQL Create Script is is generated by the same Workbench file.
This bug could be find in older Workbench Version too.

How to repeat:
- Load the Workbench File that I provide into the MySQL Workbench. 
- Export the forward engineer create script
- Export directly the Forward Engineer SQL ALTER Script.
- You will find that the alter script wants to change some tables although they are the same.

[4 Sep 2009 12:51] Susanne Ebrecht

Verified as described

[25 Nov 2009 12:17] Johannes Taxacher

fixed in repository. will be included in 5.2.9

[26 Nov 2009 11:52] Tony Bedford

An entry has been added to the 5.2.9 changelog:

Running the Forward Engineer an ALTER Script wizard resulted in an ALTER script that dictated changes were required to tables, even in the case where no such changes were necessary.