Bug #4904 Stored procedure crash if continue handler for HY000 errors
Submitted: 5 Aug 2004 0:45 Modified: 6 Aug 2004 15:35
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.2-alpha-debug OS:Linux (SuSE 8.2)
Assigned to: Per-Erik Martin CPU Architecture:Any

[5 Aug 2004 0:45] Peter Gulutzan 
Description:
Stored procedures with DECLARE CONTINUE handlers generally work, for example I've 
tried them with sqlstate = '23000' and they're okay. But for sqlstate = 'HY000', the 
procedure doesn't finish. 
 

How to repeat:
mysql> drop table if exists t// 
Query OK, 0 rows affected (0.00 sec) 
 
mysql> create procedure pix () begin declare continue handler for sqlstate 'HY000' begin 
end; create table t2 as select * from t; end;// 
Query OK, 0 rows affected (0.00 sec) 
 
mysql> call pix()//
[6 Aug 2004 3:02] MySQL Verification Team 
Verified against latest BK 5.0 tree.
[6 Aug 2004 15:35] 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