Bug #7047 Stored procedure crash if alter procedure
Submitted: 6 Dec 2004 19:20 Modified: 20 Apr 2005 17:24
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.3-alpha-debug OS:Linux (SUSE 9.2)
Assigned to: Per-Erik Martin CPU Architecture:Any

[6 Dec 2004 19:20] Peter Gulutzan 
Description:
If, in a CREATE PROCEDURE statement, I have an ALTER PROCEDURE statement, 
and the ALTER PROCEDURE statement isn't syntactically correct, 
and the ALTER PROCEDURE and CREATE PROCEDURE refer to the same thing, 
then when I call the procedure, MySQL crashes. 
 

How to repeat:
mysql> create procedure p4 () alter procedure p4; 
Query OK, 0 rows affected (0.00 sec) 
 
mysql> call p4(); 
ERROR 2013 (HY000): Lost connection to MySQL server during query
[6 Dec 2004 19:43] MySQL Verification Team 
Thank you for the bug report.
[20 Apr 2005 16:21] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/24170