MySQL Bugs: #36978: in "export SQL" feature triggers block placed below inserting data

Bug #36978	in "export SQL" feature triggers block placed below inserting data
Submitted:	26 May 2008 17:13	Modified:	4 Jun 2008 13:54
Reporter:	Dmitry Medvedev
Status:	QA review
Category:	MySQL Workbench	Severity:	S4 (Feature request)
Version:	5.0.21	OS:	Microsoft Windows (XP SP3)
Assigned to:	Bugs System	Target Version:
Tags:	triggers, export
Triage:	D5 (Feature request)

View
Add Comment
Files
Developer
Edit Submission
View Progress Log

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.

Thank you for the bug report.

we'll add options to control export of these parts. it might be even wanted that standard
inserts are not influenced by triggers.

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.