Now one gets an error if one tries to insert an invalid value via a stored procedure in STRICT mode. (Bug #5907)

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;