MySQL Forums
Forum List  »  Stored Procedures

Re: I am getting error while creating functions?
Posted by: Peter Brawley
Date: January 03, 2006 10:08AM

See the discussion at http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html. Stored procs and funcs raise replication issues. Very roughly, if the func is DETERMINISTIC, declare it so, otherwise the simplest option is often to simply...

SET log_bin_trust_function_creators=TRUE;

which essentially lets MySQL off the hook for replication anomalies that may arise from running the func.

PB

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: I am getting error while creating functions?
1269
January 03, 2006 10:08AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.