MySQL Bugs: #40913: Generate inserts not taking table exclusions into account

Bug #40913	Generate inserts not taking table exclusions into account
Submitted:	21 Nov 2008 3:58	Modified:	7 Aug 2009 14:56
Reporter:	Tony Wang	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.0.27 OSS, Revision 3318	OS:	Windows (XP)
Assigned to:		CPU Architecture:	Any
Tags:	CHECKED, forward engineer, inserts

Description:
The generate insert statements for tables option for the Forward Engineer to SQL Script does not take into account which tables are included/excluded in the SQL Export Filters.  All insert statements are generated including those for tables that have been excluded in the export filters.

How to repeat:
Create a schema with multiple tables.  Add inserts for the tables.  Use the Forward Engineer to SQL Script and have Generate inserts for tables selected in the options.  Next add one of the tables that have inserts into the exclusion masks for tables.

Suggested fix:
Check tables exclusion masks before generating insert statements for each table

Thank you for a bug report. Verifeid just as described.

Bug: http://bugs.mysql.com/bug.php?id=42713 has been marked as duplicate of this one.

Unable to repeat anymore with latest 5.2 version.

this has been fixed for 5.1 and is included in 5.1.16

An entry was added to the 5.1.16 changelog:

In the Forward Engineer SQL CREATE Script wizard, the Generate INSERT Statements for Tables option did not take into account which tables were excluded in the SQL Export Filters. All insert statements were generated, including those for tables that had been excluded in the export filters.