Bug #36978 in "export SQL" feature triggers block placed below inserting data
Submitted: 26 May 2008 15:13 Modified: 25 Jun 2010 9:32
Reporter: Dmitry Medvedev Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S4 (Feature request)
Version:5.0.21 OS:Windows (XP SP3)
Assigned to: Vladimir Kolesnikov CPU Architecture:Any
Tags: export, triggers

[26 May 2008 15:13] Dmitry Medvedev 
Description:
When using "Export SQL CREATE Script" feature, in result file there is "CREATE TRIGGER" block below "INSERT" block. So triggers will not work when data inserted.

How to repeat:
Create table with Triggers (CREATE TRIGGER tr_name AFTER INSERT ON...) and Inserts.

Suggested fix:
Place triggers above inserts.
[27 May 2008 23:48] MySQL Verification Team 
Thank you for the bug report.
[2 Jun 2008 12:11] Johannes Taxacher 
we'll add options to control export of these parts. it might be even wanted that standard inserts are not influenced by triggers.
[4 Jun 2008 11:54] Vladimir Kolesnikov 
triggers code has been moved to be above the inserts block. We will consider adding it the way it was initially as an option into a future WB release.
[25 Jun 2010 9:32] Mike Lischke 
Fix already released.