summaryrefslogtreecommitdiff
path: root/mysql-test/r/strict.result
diff options
context:
space:
mode:
authorunknown <monty@mysql.com>2005-04-05 00:32:48 +0300
committerunknown <monty@mysql.com>2005-04-05 00:32:48 +0300
commitae25f8df6ef53276d2051f193ed6e247da375e4d (patch)
tree47a17106234067aa3cb031e4d92f9f332e28ce59 /mysql-test/r/strict.result
parentd17aebaa101c241968e6fe466f141f8682fb14e6 (diff)
downloadmariadb-git-ae25f8df6ef53276d2051f193ed6e247da375e4d.tar.gz
Now one gets an error if one tries to insert an invalid value via a stored procedure in STRICT mode. (Bug #5907)
client/mysqldump.c: Changed some function and variable names to MySQL syntax Fixed indentation for last few pushes (No logic changes) mysql-test/r/strict.result: Test for bug #5907 (Traditional mode: invalid value can be inserted via a stored procedure) mysql-test/t/strict.test: Test for bug #5907 (Traditional mode: invalid value can be inserted via a stored procedure) sql/sql_base.cc: More comments sql/sql_error.cc: Ensure that PS gives error for invalid values in 'strict' mode
Diffstat (limited to 'mysql-test/r/strict.result')
-rw-r--r--mysql-test/r/strict.result12
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/strict.result b/mysql-test/r/strict.result
index 6f332b4e087..c4d860c5c77 100644
--- a/mysql-test/r/strict.result
+++ b/mysql-test/r/strict.result
@@ -1173,4 +1173,16 @@ col1
0000-00-00 00:00:00
NULL
drop table t1;
+create table t1 (col1 tinyint);
+drop procedure if exists t1;
+Warnings:
+Note 1305 PROCEDURE t1 does not exist
+create procedure t1 () begin declare exit handler for sqlexception
+select'a'; insert into t1 values (200); end;|
+call t1();
+ERROR 22003: Out of range value adjusted for column 'col1' at row 1
+select * from t1;
+col1
+drop procedure t1;
+drop table t1;
set sql_mode=@org_mode;