List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:June 25 2007 7:30am
Subject:error on slave.
View as plain text  
Hi All,
I set this parameters on master & slave
SET GLOBAL log_bin_trust_function_creators = 1;
Then i applied a script that creates procedure and function. It got created
on master, but on slave i am getting below error and procedure and function
are not getting created on slave.

Empty set (0.00 sec)
'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)' on query. Default database:
'reports1'. Query: 'CREATE DEFINER=`user`@`%` FUNCTION `next_day`(dt date,
dn varchar(10)) RETURNS date

error on slave.Ananda Kumar25 Jun