Debian Codegraph @

mysql-test/suite/engines/funcs/r/rpl_sf.result

raw
1 include/master-slave.inc
2 [connection master]
3 set global log_bin_trust_function_creators=0;
4 set binlog_format=STATEMENT;
5 create function fn16456()
6 returns int
7 begin
8 return unix_timestamp();
9 end|
10 ERROR HY000: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
11 set global log_bin_trust_function_creators=1;
12 create function fn16456()
13 returns int
14 begin
15 return unix_timestamp();
16 end|
17 set global log_bin_trust_function_creators=0;
18 set binlog_format=ROW;
19 select fn16456();
20 fn16456()
21 timestamp
22 set binlog_format=STATEMENT;
23 select fn16456();
24 ERROR HY000: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
25 drop function fn16456;
26 include/rpl_end.inc