← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/suite/rpl/r/rpl_sf.result

  • Committer: brian
  • Date: 2008-06-25 05:29:13 UTC
  • Revision ID: brian@localhost.localdomain-20080625052913-6upwo0jsrl4lnapl
clean slate

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/rpl/r/rpl_sf.result
 
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: Slave running with --log-slave-updates must use row-based binary logging to be able to replicate row-based binary log events
 
23
drop function fn16456;