Bug #4344 Stored procedure which drops itself causes crash
Submitted: 30 Jun 2004 15:35 Modified: 29 Jul 2004 17:48
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.1-alpha-debug OS:Linux (SuSE 8.2)
Assigned to: Bugs System CPU Architecture:Any

[30 Jun 2004 15:35] Peter Gulutzan 
Description:
If I call a stored procedure which drops itself, the server crashes. 
 

How to repeat:
mysql> create procedure p () drop procedure p; 
Query OK, 0 rows affected (0.00 sec) 
 
mysql> call p(); 
ERROR 1298 (42000): PROCEDURE  does not exist 
 
mysql> show procedure status; 
ERROR 2006 (HY000): MySQL server has gone away
[29 Jul 2004 17:48] Per-Erik Martin 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html