diff options
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/strict.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/strict.test b/mysql-test/t/strict.test index 9d4befb9743..b5d234b7bea 100644 --- a/mysql-test/t/strict.test +++ b/mysql-test/t/strict.test @@ -1032,6 +1032,21 @@ select * from t1; drop table t1; # +# Test of inserting an invalid value via a stored procedure (Bug #5907) +# +create table t1 (col1 tinyint); +drop procedure if exists t1; +delimiter |; +create procedure t1 () begin declare exit handler for sqlexception +select'a'; insert into t1 values (200); end;| +delimiter ;| +--error 1264 +call t1(); +select * from t1; +drop procedure t1; +drop table t1; + +# # Restore mode # set sql_mode=@org_mode; |