Debian Codegraph @

mysql-test/suite/binlog/r/binlog_sf.result

raw
1 set global log_bin_trust_function_creators=0;
2 set binlog_format=STATEMENT;
3 create function fn16456()
4 returns int
5 begin
6 return unix_timestamp();
7 end|
8 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)
9 set global log_bin_trust_function_creators=1;
10 create function fn16456()
11 returns int
12 begin
13 return unix_timestamp();
14 end|
15 set global log_bin_trust_function_creators=0;
16 set binlog_format=ROW;
17 select fn16456();
18 fn16456()
19 timestamp
20 set binlog_format=STATEMENT;
21 select fn16456();
22 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)
23 drop function fn16456;
24 set global log_bin_trust_function_creators=0;
25 create function fn16456()
26 returns int deterministic
27 begin
28 return unix_timestamp();
29 end|
30 set binlog_format=ROW;
31 select fn16456();
32 fn16456()
33 timestamp
34 set binlog_format=STATEMENT;
35 select fn16456();
36 fn16456()
37 timestamp
38 drop function fn16456;
39 set global log_bin_trust_function_creators=0;
40 create function fn16456()
41 returns int no sql
42 begin
43 return unix_timestamp();
44 end|
45 set binlog_format=ROW;
46 select fn16456();
47 fn16456()
48 timestamp
49 set binlog_format=STATEMENT;
50 select fn16456();
51 fn16456()
52 timestamp
53 drop function fn16456;
54 set global log_bin_trust_function_creators=0;
55 create function fn16456()
56 returns int reads sql data
57 begin
58 return unix_timestamp();
59 end|
60 set binlog_format=ROW;
61 select fn16456();
62 fn16456()
63 timestamp
64 set binlog_format=STATEMENT;
65 select fn16456();
66 fn16456()
67 timestamp
68 drop function fn16456;