1 # Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
2 source include/master-slave.inc;
5 let $oblf=`select @@SESSION.BINLOG_FORMAT`;
6 let $otfc=`select @@log_bin_trust_function_creators`;
8 set global log_bin_trust_function_creators=0;
12 # fail *on definition*
14 set binlog_format=STATEMENT;
17 --error ER_BINLOG_UNSAFE_ROUTINE
18 create function fn16456()
21 return unix_timestamp();
27 # force in definition, so we can see whether we fail on call
29 set global log_bin_trust_function_creators=1;
32 create function fn16456()
35 return unix_timestamp();
39 set global log_bin_trust_function_creators=0;
43 # allow funcall in RBR
45 set binlog_format=ROW;
47 --replace_column 1 timestamp
54 set binlog_format=STATEMENT;
56 --error ER_BINLOG_UNSAFE_ROUTINE
63 drop function fn16456;
66 eval set binlog_format=$oblf;
67 eval set global log_bin_trust_function_creators=$otfc;