MySQL Bugs: #46168: Forward engineer create script not producing insert statements for new tables

Bug #46168	Forward engineer create script not producing insert statements for new tables
Submitted:	14 Jul 2009 14:00	Modified:	3 Aug 2009 8:57
Reporter:	Brian Sims	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.1.16	OS:	Windows
Assigned to:	Assigned Account	CPU Architecture:	Any
Tags:	create script, inserts

Description:
File, export, export, forward engineer create script is not producing insert statements for tables created after upgrading to version 5.1.16 from version 5.0.30.  It is doing all the inserts that I have checked that were created prior to version 5.1.16.

How to repeat:
upgrade a database from 5.0.30 to 5.1.16.  Create a new table and add inserts into the table definition.  Forward engineer the create script with the create inserts option checked.  Run script in gui client or use wordpad to manually scan script for inserts for the new table.

forward create script not producing insert statements

Attachment: forward create script not producing insert statements.doc (application/msword, text), 132.50 KiB.

tables created before 5.1.16 where I have added columns to the table in 5.1.16 are producing the new insert statements correctly.

Thank you for the problem report. Sorry, but I can not repeat the behavior described. I had created a model with WB 5.0.30, added one table and inserted 2 rows. Then I had saved the model, moved it to another machine and opened with WB 5.1.16 there. I had added another table with a couple of rows inserted and generated forward engineer script ("Generate INSERT Statements for Tables" was checked, surely). I see inserts for both tables. 

What am I doing wrong? Please, send problematic .mwb file created with WB 5.0.30 and detailed instruction what to do next to repeat the problem.

I'm attaching a zip file that has a stripped down mwb file from version 5.0.30, the create script from it, the new 5.1.16 version with the two added tables and inserts, the create script from that showing there are no inserts for the two new tables even though you will see inserts in the table insert tab.  There is also a word document where I captured screenshots throughout the process.

Verified just as described on your model file nnerp_20090708_ver5_0_30_stripped_ver5116.mwb uploaded. INSERT statements for 2 new tables, Channels and PlantChannelOperations, are present in .mwb file but are not added to the script generated during forward engineering.

Fixed in 5.1.17 and 5.2.2
http://bugs.mysql.com/bug.php?id=45920