summaryrefslogtreecommitdiff
path: root/mysql-test/t/trigger.test
diff options
context:
space:
mode:
authorbell@sanja.is.com.ua <>2005-07-30 09:24:51 +0300
committerbell@sanja.is.com.ua <>2005-07-30 09:24:51 +0300
commitec3396aab34b4609f256ac48ce9b05549ea753bb (patch)
tree2520f50a0dc9bb070e2db388a5d98b01ea94e452 /mysql-test/t/trigger.test
parent4a0d64af89e8eae92a884619e0d1319b297545ae (diff)
downloadmariadb-git-ec3396aab34b4609f256ac48ce9b05549ea753bb.tar.gz
postmerge-fix
Diffstat (limited to 'mysql-test/t/trigger.test')
-rw-r--r--mysql-test/t/trigger.test6
1 files changed, 1 insertions, 5 deletions
diff --git a/mysql-test/t/trigger.test b/mysql-test/t/trigger.test
index 17f2e85f2e8..7bf8b1a4e2b 100644
--- a/mysql-test/t/trigger.test
+++ b/mysql-test/t/trigger.test
@@ -617,7 +617,7 @@ drop table t1;
set sql_mode='ansi';
create table t1 ("t1 column" int);
create trigger t1_bi before insert on t1 for each row set new."t1 column" = 5;
-set sql_mode=default;
+set sql_mode="";
insert into t1 values (0);
# create trigger with different sql_mode
create trigger t1_af after insert on t1 for each row set @a=10;
@@ -626,8 +626,6 @@ select * from t1;
select @a;
--replace_column 6 #
show triggers;
---replace_column 17 #
-select * from information_schema.triggers;
drop table t1;
# check that rigger preserve sql_mode during execution
set sql_mode="traditional";
@@ -643,6 +641,4 @@ set sql_mode=default;
show create table t1;
--replace_column 6 #
show triggers;
---replace_column 17 #
-select * from information_schema.triggers;
drop table t1;