Bug #37574 Forward Engineer SQL CREATE script does not reflect changes in the model
Submitted: 23 Jun 2008 4:44 Modified: 1 Aug 2008 16:26
Reporter: Lee Johnson Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench Severity:S2 (Serious)
Version:5.0.22/5.0.23 OS:Microsoft Windows (Vista Home Premium)
Assigned to: Vladimir Kolesnikov CPU Architecture:Any
Tags: create, export, forward engineer, script, SQL
Triage: D2 (Serious)

[23 Jun 2008 4:44] Lee Johnson
I made a change to a table in the schema and then saved the file. I then File>>Export>>Forward Engineer SQL CREATE script and save that file.

When I look at the sql script that is generated the changes are not reflected and the new sql script reflects the old model.

If I close Workbench and re-open it, the changes I made are there.  If I again try to Forward Engineer an SQL script the new script that is generated again reflects an older model (the one before the changes).  Again, I checked the model and the new changes are there.

How to repeat:
1) Create a model and save it
2) Export a Forward Engineer SQL Create script
3) Make a change to the model and save it
4) Export a Forward Engineer SQL Create script
5) Note that the new SQL script does not reflect the new model
[23 Jun 2008 5:21] Valeriy Kravchuk
Thank you for a problem report. What exact change to the model do you mean at step 3? If I add new table, for example, new CREATE script will contain it.
[23 Jun 2008 5:39] Lee Johnson
Here are a few changes that I made that are reflected in the model but not in the Create script:

changed the default value in a few columns
changed the foreign key name
changed the table comment
[24 Jun 2008 12:44] Miguel Solorzano
Thank you for the feedback. I can't repeat with my own model, could you please provide the model file which you are having this problem. Thanks in advance.
[2 Jul 2008 16:52] Miguel Solorzano
Thank you for the feedback.
[29 Jul 2008 16:17] Johannes Taxacher
fix goes into next release (5.0.24)
[1 Aug 2008 16:26] Tony Bedford
An entry was added to the 5.0.24 changelog:

Forward Engineer SQL CREATE Script did not reflect changes made to the model.