Bug #39088 triggers calling procedures fails on insert
Submitted: 28 Aug 2008 11:16 Modified: 13 Oct 2008 15:31
Reporter: moi meme Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.0.24/5.0.25 OS:Any
Assigned to: CPU Architecture:Any

[28 Aug 2008 11:16] moi meme
When having a trigger calling a procedure,
if an insert activate the trigger before the procedure
was declared, trigger fails.

The generation order of Workbench export is:
* tables / triggers / inserts
* procedure

So it is buggy.

How to repeat:
create a table T1.
create a procedure P1.
create a trigger G1 on T1 that calls P1.
create an insert on T1 that will trigger G1.
make an sql export.
try to execute the script.

Suggested fix:
simply export procedures first.
[28 Aug 2008 12:29] MySQL Verification Team
Thank you for the bug report. Could you please provide a project file test case?. Thanks in advance.
[4 Sep 2008 6:22] Lars Monecke
I think it is same problem as i described in http://bugs.mysql.com/bug.php?id=39211. So you can use that mwb file
[28 Sep 2008 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[1 Oct 2008 12:05] moi meme
I added a exemple file, but the bug report have been close !?
[4 Oct 2008 17:46] MySQL Verification Team
Thank you for the feedback.
[8 Oct 2008 16:40] Johannes Taxacher
this has been fixed. fix will be in 5.0.26
[13 Oct 2008 15:31] Tony Bedford
An entry was added to the 5.0.26 changelog:

Exported SQL code containing a trigger that called a procedure would fail when an INSERT activated the trigger.