diff options
| author | unknown <pem@mysql.com> | 2005-11-23 11:56:53 +0100 |
|---|---|---|
| committer | unknown <pem@mysql.com> | 2005-11-23 11:56:53 +0100 |
| commit | b118282377a7b80b8d50b996d896bd5424d5d52e (patch) | |
| tree | 7ca8eb3c54bc1d029f63f069d01992739288eb36 /mysql-test/t/sp.test | |
| parent | 0026b6f46e550ff8f8c874f55272d15f4a19f3ac (diff) | |
| download | mariadb-git-b118282377a7b80b8d50b996d896bd5424d5d52e.tar.gz | |
Fixed BUG#13729 Stored procedures: packet error after exception handled
Don't set thd->is_fatal_error in sql_update for duplicate key errors.
mysql-test/r/sp.result:
New test case for BUG#13729.
mysql-test/r/sp_trans.result:
New test case for BUG#14840.
mysql-test/t/sp.test:
New test case for BUG#13729.
mysql-test/t/sp_trans.test:
New test case for BUG#14840.
sql/sql_update.cc:
Don't set thd->is_fatal_error if it's a duplicate key error.
Diffstat (limited to 'mysql-test/t/sp.test')
| -rw-r--r-- | mysql-test/t/sp.test | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/mysql-test/t/sp.test b/mysql-test/t/sp.test index 5ad2b9287aa..8fa3ae46de4 100644 --- a/mysql-test/t/sp.test +++ b/mysql-test/t/sp.test @@ -4595,6 +4595,33 @@ call bug14845()| drop procedure bug14845| # +# BUG#13729: Stored procedures: packet error after exception handled +# +--disable_warnings +drop procedure if exists bug13729| +drop table if exists t3| +--enable_warnings + +create table t3 (s1 int, primary key (s1))| + +insert into t3 values (1),(2)| + +create procedure bug13729() +begin + declare continue handler for sqlexception select 55; + + update t3 set s1 = 1; +end| + +call bug13729()| +# Used to cause Packets out of order +select * from t3| + +drop procedure bug13729| +drop table t3| + + +# # BUG#NNNN: New bug synopsis # #--disable_warnings |