diff options
author | unknown <monty@mysql.com> | 2005-04-05 00:32:48 +0300 |
---|---|---|
committer | unknown <monty@mysql.com> | 2005-04-05 00:32:48 +0300 |
commit | ae25f8df6ef53276d2051f193ed6e247da375e4d (patch) | |
tree | 47a17106234067aa3cb031e4d92f9f332e28ce59 /mysql-test/r/strict.result | |
parent | d17aebaa101c241968e6fe466f141f8682fb14e6 (diff) | |
download | mariadb-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.result | 12 |
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; |