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 6:44	Modified:	1 Aug 2008 18:26
Reporter:	Lee Johnson
Status:	Closed
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	5.0.22/5.0.23	OS:	Microsoft Windows (Vista Home Premium)
Assigned to:	Bugs System	Target Version:
Tags:	export, forward engineer, SQL, create, script
Triage:	D2 (Serious)

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.