Debian Codegraph @

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

raw
1 create function fn16456_1() returns int return 1;
2 set global log_bin_trust_function_creators=0;
3 Warnings:
4 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
5 set binlog_format=STATEMENT;
6 Warnings:
7 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
8 create function fn16456()
9 returns int
10 begin
11 return unix_timestamp();
12 end|
13 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)
14 alter function fn16456_1 comment "fails" contains SQL;
15 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)
16 alter function fn16456_1 MODIFIES SQL DATA;
17 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)
18 drop function fn16456_1;
19 set global log_bin_trust_function_creators=1;
20 Warnings:
21 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
22 create function fn16456()
23 returns int
24 begin
25 return unix_timestamp();
26 end|
27 set global log_bin_trust_function_creators=0;
28 Warnings:
29 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
30 set binlog_format='ROW';
31 Warnings:
32 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
33 select fn16456();
34 fn16456()
35 timestamp
36 set binlog_format=STATEMENT;
37 Warnings:
38 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
39 select fn16456();
40 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)
41 drop function fn16456;
42 set global log_bin_trust_function_creators=0;
43 Warnings:
44 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
45 create function fn16456()
46 returns int deterministic
47 begin
48 return unix_timestamp();
49 end|
50 set binlog_format='ROW';
51 Warnings:
52 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
53 select fn16456();
54 fn16456()
55 timestamp
56 set binlog_format=STATEMENT;
57 Warnings:
58 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
59 select fn16456();
60 fn16456()
61 timestamp
62 drop function fn16456;
63 set global log_bin_trust_function_creators=0;
64 Warnings:
65 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
66 create function fn16456()
67 returns int no sql
68 begin
69 return unix_timestamp();
70 end|
71 set binlog_format='ROW';
72 Warnings:
73 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
74 select fn16456();
75 fn16456()
76 timestamp
77 set binlog_format=STATEMENT;
78 Warnings:
79 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
80 select fn16456();
81 fn16456()
82 timestamp
83 drop function fn16456;
84 set global log_bin_trust_function_creators=0;
85 Warnings:
86 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
87 create function fn16456()
88 returns int reads sql data
89 begin
90 return unix_timestamp();
91 end|
92 set binlog_format='ROW';
93 Warnings:
94 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
95 select fn16456();
96 fn16456()
97 timestamp
98 set binlog_format=STATEMENT;
99 Warnings:
100 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
101 select fn16456();
102 fn16456()
103 timestamp
104 drop function fn16456;
105 Warnings:
106 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
107 Warnings:
108 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.