diff options
author | Alfranio Correia <alfranio.correia@sun.com> | 2009-12-17 00:09:52 +0000 |
---|---|---|
committer | Alfranio Correia <alfranio.correia@sun.com> | 2009-12-17 00:09:52 +0000 |
commit | 9a51ad2c541d6fe93b82a09d334278dd1170e780 (patch) | |
tree | e7d2073fc03c4d483a2006572c2db6a9fdee7ec1 /mysql-test/suite/rpl/t/rpl_trigger.test | |
parent | 25ecb311168dba7cdb5a07713743d5baf595a93c (diff) | |
parent | 8dc0091c214271fbcbe4ae9a0b0d6de5c78fae6e (diff) | |
download | mariadb-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.test | 10 |
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; |