summaryrefslogtreecommitdiff
path: root/mysql-test/suite/rpl/t/rpl_trigger.test
diff options
context:
space:
mode:
authorAlfranio Correia <alfranio.correia@sun.com>2009-12-17 00:09:52 +0000
committerAlfranio Correia <alfranio.correia@sun.com>2009-12-17 00:09:52 +0000
commit9a51ad2c541d6fe93b82a09d334278dd1170e780 (patch)
treee7d2073fc03c4d483a2006572c2db6a9fdee7ec1 /mysql-test/suite/rpl/t/rpl_trigger.test
parent25ecb311168dba7cdb5a07713743d5baf595a93c (diff)
parent8dc0091c214271fbcbe4ae9a0b0d6de5c78fae6e (diff)
downloadmariadb-git-9a51ad2c541d6fe93b82a09d334278dd1170e780.tar.gz
merging from 5.1 to rep+2 starting at gca(5.1, next-mr) == build@mysql.com-20091208092611-pbno5awyb0v38hs7
Fixed conflicts in: - binlog.binlog_unsafe - rpl.rpl_slow_query_log
Diffstat (limited to 'mysql-test/suite/rpl/t/rpl_trigger.test')
-rw-r--r--mysql-test/suite/rpl/t/rpl_trigger.test10
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/t/rpl_trigger.test b/mysql-test/suite/rpl/t/rpl_trigger.test
index a7547a14433..e296da01bad 100644
--- a/mysql-test/suite/rpl/t/rpl_trigger.test
+++ b/mysql-test/suite/rpl/t/rpl_trigger.test
@@ -5,6 +5,8 @@
--source include/have_binlog_format_mixed_or_statement.inc
--source include/master-slave.inc
+CALL mtr.add_suppression("Statement may not be safe to log in statement format.");
+
--disable_warnings
DROP TABLE IF EXISTS t1;
DROP TABLE IF EXISTS t2;
@@ -91,7 +93,11 @@ end
|
delimiter ;|
+# The trigger causes a warning for unsafe statement when
+# binlog_format=statement since it uses get_lock.
+--disable_warnings
insert into t1 set a = now();
+--enable_warnings
select a=b && a=c from t1;
let $time=`select a from t1`;
@@ -137,7 +143,11 @@ disconnect con2;
truncate table t1;
drop trigger t1_first;
+# The trigger causes a warning for unsafe statement when
+# binlog_format=statement since it uses get_lock.
+--disable_warnings
insert into t1 values ("2003-03-03","2003-03-03","2003-03-03"),(bug12480(),bug12480(),bug12480()),(now(),now(),now());
+--enable_warnings
select a=b && a=c from t1;
drop function bug12480;