diff options
| author | Alexander Barkov <bar@mariadb.org> | 2015-09-17 11:05:07 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2015-09-17 11:05:07 +0400 |
| commit | d9b25ae3db8584bde809c0ab3230cbe151fa489b (patch) | |
| tree | cb0ae8c91d4f1bcd614c3c1b2d7847f3ef7a130f /mysql-test/t/sp-error.test | |
| parent | c69cf93bfb3a221d9106f3695aa16e11f7e8b7fb (diff) | |
| download | mariadb-git-d9b25ae3db8584bde809c0ab3230cbe151fa489b.tar.gz | |
MDEV-8466 CAST works differently for DECIMAL/INT vs DOUBLE for empty strings
MDEV-8468 CAST and INSERT work differently for DECIMAL/INT vs DOUBLE for a string with trailing spaces
Diffstat (limited to 'mysql-test/t/sp-error.test')
| -rw-r--r-- | mysql-test/t/sp-error.test | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/t/sp-error.test b/mysql-test/t/sp-error.test index c1a21c8ac85..a47fbe7a372 100644 --- a/mysql-test/t/sp-error.test +++ b/mysql-test/t/sp-error.test @@ -2606,7 +2606,7 @@ delimiter |; CREATE PROCEDURE p1() BEGIN DECLARE c INT DEFAULT 0; - DECLARE CONTINUE HANDLER FOR SQLWARNING SET c = c + 1; + DECLARE CONTINUE HANDLER FOR SQLSTATE '22007' SET c = c + 1; CALL p2(); CALL p3(); CALL p4(); @@ -2641,7 +2641,7 @@ CREATE PROCEDURE p5() CREATE PROCEDURE P6() BEGIN DECLARE c INT DEFAULT 0; - DECLARE CONTINUE HANDLER FOR SQLWARNING SET c = c + 1; + DECLARE CONTINUE HANDLER FOR SQLSTATE '22007' SET c = c + 1; CALL p5(); SELECT c; END| |