diff options
author | malff/marcsql@weblab.(none) <> | 2007-03-14 15:36:11 -0600 |
---|---|---|
committer | malff/marcsql@weblab.(none) <> | 2007-03-14 15:36:11 -0600 |
commit | 62247621b0de5ed676873909c7ea49a0b77ee0a5 (patch) | |
tree | 4cfbf7f3bbb30d7fad0e2abfd590ae5a06fdcd3f /mysql-test/t/sp-error.test | |
parent | 53d4592fa8ccb60f5c5dcf1a4003a757cfbd81c2 (diff) | |
parent | f87899c50e89d18944c351b52dd40fbb09b598d9 (diff) | |
download | mariadb-git-62247621b0de5ed676873909c7ea49a0b77ee0a5.tar.gz |
Merge weblab.(none):/home/marcsql/TREE/mysql-5.0-runtime
into weblab.(none):/home/marcsql/TREE/mysql-5.1-26503-merge
Diffstat (limited to 'mysql-test/t/sp-error.test')
-rw-r--r-- | mysql-test/t/sp-error.test | 68 |
1 files changed, 68 insertions, 0 deletions
diff --git a/mysql-test/t/sp-error.test b/mysql-test/t/sp-error.test index 6dc94869f04..e5de4a570cb 100644 --- a/mysql-test/t/sp-error.test +++ b/mysql-test/t/sp-error.test @@ -2068,6 +2068,74 @@ drop function bug20701; # +# Bug#26503 (Illegal SQL exception handler code causes the server to crash) +# + +delimiter //; + +--error ER_SP_LILABEL_MISMATCH +create procedure proc_26503_error_1() +begin +retry: + repeat + begin + declare continue handler for sqlexception + begin + iterate retry; + end + + select "do something"; + end + until true end repeat retry; +end// + +--error ER_SP_LILABEL_MISMATCH +create procedure proc_26503_error_2() +begin +retry: + repeat + begin + declare continue handler for sqlexception + iterate retry; + + select "do something"; + end + until true end repeat retry; +end// + +--error ER_SP_LILABEL_MISMATCH +create procedure proc_26503_error_3() +begin +retry: + repeat + begin + declare continue handler for sqlexception + begin + leave retry; + end + + select "do something"; + end + until true end repeat retry; +end// + +--error ER_SP_LILABEL_MISMATCH +create procedure proc_26503_error_4() +begin +retry: + repeat + begin + declare continue handler for sqlexception + leave retry; + + select "do something"; + end + until true end repeat retry; +end// + +delimiter ;// + +# # BUG#NNNN: New bug synopsis # #--disable_warnings |