75 lines
2.3 KiB
Plaintext
75 lines
2.3 KiB
Plaintext
create function fn16456_1() returns int return 1;
|
|
set global log_bin_trust_function_creators=0;
|
|
set binlog_format=STATEMENT;
|
|
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;
|
|
create function fn16456()
|
|
returns int
|
|
begin
|
|
return unix_timestamp();
|
|
end|
|
|
set global log_bin_trust_function_creators=0;
|
|
set binlog_format='ROW';
|
|
select fn16456();
|
|
fn16456()
|
|
timestamp
|
|
set binlog_format=STATEMENT;
|
|
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;
|
|
create function fn16456()
|
|
returns int deterministic
|
|
begin
|
|
return unix_timestamp();
|
|
end|
|
|
set binlog_format='ROW';
|
|
select fn16456();
|
|
fn16456()
|
|
timestamp
|
|
set binlog_format=STATEMENT;
|
|
select fn16456();
|
|
fn16456()
|
|
timestamp
|
|
drop function fn16456;
|
|
set global log_bin_trust_function_creators=0;
|
|
create function fn16456()
|
|
returns int no sql
|
|
begin
|
|
return unix_timestamp();
|
|
end|
|
|
set binlog_format='ROW';
|
|
select fn16456();
|
|
fn16456()
|
|
timestamp
|
|
set binlog_format=STATEMENT;
|
|
select fn16456();
|
|
fn16456()
|
|
timestamp
|
|
drop function fn16456;
|
|
set global log_bin_trust_function_creators=0;
|
|
create function fn16456()
|
|
returns int reads sql data
|
|
begin
|
|
return unix_timestamp();
|
|
end|
|
|
set binlog_format='ROW';
|
|
select fn16456();
|
|
fn16456()
|
|
timestamp
|
|
set binlog_format=STATEMENT;
|
|
select fn16456();
|
|
fn16456()
|
|
timestamp
|
|
drop function fn16456;
|