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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.056 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.