MySQL Bugs: #11561: create trigger accepts sp call in definition fails when run

Bug #11561	create trigger accepts sp call in definition fails when run
Submitted:	25 Jun 2005 5:30	Modified:	25 Jun 2005 12:44
Reporter:	Paul McArdle	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: User-defined functions ( UDF )	Severity:	S3 (Non-critical)
Version:	5.0.7-beta-standard for pc-linux-gnu on	OS:	Linux (red hat 9)
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
you can create a trigger that calls a stored proc, references returned val in FOR EACH ROW bit and is accepted by the server.

How to repeat:
when you insert a row into the table eith the trigger you get error table not locked.

Suggested fix:
advise when trying to create trigger.

Hi, Paul!

Thank you for your interest in MySQL!

This is duplicate of bug #9909 "Triggers: Can Create Triggers which calls Stored Procedures". See http://bugs.mysql.com/bug.php?id=9909 for more info.