Bug #39088 triggers calling procedures fails on insert

• Submitted: 28 Aug 2008 11:16
• Modified: 13 Oct 2008 15:31
• Reporter: moi meme
• Status: Closed
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 5.0.24/5.0.25
• OS: Any
• CPU Architecture: Any

[28 Aug 2008 11:16] moi meme

Description:
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.