2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
set global log_bin_trust_function_creators=0;
8
set binlog_format=STATEMENT;
9
create function fn16456()
12
return unix_timestamp();
14
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)
15
set global log_bin_trust_function_creators=1;
16
create function fn16456()
19
return unix_timestamp();
21
set global log_bin_trust_function_creators=0;
22
set binlog_format=ROW;
26
set binlog_format=STATEMENT;
28
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)
29
drop function fn16456;