MySQL Bugs: #37574: Forward Engineer SQL CREATE script does not reflect changes in the model

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:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	5.0.22/5.0.23	OS:	Windows (Vista Home Premium)
Assigned to:	Vladimir Kolesnikov	CPU Architecture:	Any
Tags:	create, export, forward engineer, script, SQL

Description:
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

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.

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

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.

Thank you for the feedback.

fix goes into next release (5.0.24)

An entry was added to the 5.0.24 changelog:

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