[SOLVED] ERROR HY000:This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA

[zohab]

hi

 

I am getting following error when i execute trigger

 

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)

 

 

any idea?

thanks in advance.

 

 

[fenway]

This is referring to the decllaration of an SP...

[roshansn]

Go through this link.

 

http://mvnrepository.blogspot.com/2009/08/this-function-has-none-of-deterministic.html

 

It will be help to fix your problem