summaryrefslogtreecommitdiff
path: root/mysql-test/t/signal.test
diff options
context:
space:
mode:
authorNirbhay Choubey <nirbhay@mariadb.com>2017-01-18 11:44:47 -0500
committerNirbhay Choubey <nirbhay@mariadb.com>2017-01-18 11:44:47 -0500
commita3a91332d006fd39a32e1f6d4663e11515ea944b (patch)
tree560c152c9f8146a4c1bcd52ad2a2fa454be48aec /mysql-test/t/signal.test
parent2805baf06c31dac21604148ec089300461790e3d (diff)
downloadmariadb-git-bb-10.2-mdev7635.final.tar.gz
MDEV-7635: Update tests to adapt to the new default sql_modebb-10.2-mdev7635.savedbb-10.2-mdev7635.final
Diffstat (limited to 'mysql-test/t/signal.test')
-rw-r--r--mysql-test/t/signal.test12
1 files changed, 7 insertions, 5 deletions
diff --git a/mysql-test/t/signal.test b/mysql-test/t/signal.test
index 31bc7bc9633..cdb5796f1da 100644
--- a/mysql-test/t/signal.test
+++ b/mysql-test/t/signal.test
@@ -1346,6 +1346,7 @@ end $$
call test_signal() $$
drop procedure test_signal $$
+SET sql_mode= '' $$
create procedure test_signal()
begin
DECLARE aaax VARCHAR(65);
@@ -1400,6 +1401,7 @@ end $$
call test_signal() $$
drop procedure test_signal $$
+set sql_mode = DEFAULT $$
# Test that HANDLER can catch conditions raised by SIGNAL
@@ -1785,7 +1787,7 @@ begin
select "after RESIGNAL";
end;
- insert into t_warn set a= 9999999999999999;
+ insert ignore into t_warn set a= 9999999999999999;
end $$
call test_resignal() $$
@@ -1904,7 +1906,7 @@ begin
select "after RESIGNAL";
end;
- insert into t_warn set a= 9999999999999999;
+ insert ignore into t_warn set a= 9999999999999999;
end $$
call test_resignal() $$
@@ -2171,7 +2173,7 @@ begin
select "after RESIGNAL";
end;
- insert into t_warn set a= 9999999999999999;
+ insert ignore into t_warn set a= 9999999999999999;
end $$
call test_resignal() $$
@@ -2188,7 +2190,7 @@ begin
select "after RESIGNAL";
end;
- insert into t_warn set a= 9999999999999999;
+ insert ignore into t_warn set a= 9999999999999999;
end $$
--error 5555
@@ -2207,7 +2209,7 @@ begin
select "after RESIGNAL";
end;
- insert into t_warn set a= 9999999999999999;
+ insert ignore into t_warn set a= 9999999999999999;
end $$
--error 5555