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.

 select ROUTINE_NAME,ROUTINE_TYPE,ROUTINE_SCHEMA from routines;
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

Thread
error on slave.Ananda Kumar25 Jun