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