thanks. I have read the links with you said. But i have a question,too. What would happen if i call a non-deterministic function that have been declared deterministic.
----- Original Message ----- From: "Gleb Paharenko" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Wednesday, December 14, 2005 6:19 PM Subject: Re: use deterministic within procedure > Hello. > > This not a complete answer for your questions, but you can find a lot of > useful information from it (I hope). This procedure should produce > different results on master and slave if master has server_id=1 and > slave has server_id=2: > > mysql> delimiter // > mysql> CREATE PROCEDURE unsafe_sp () > -> BEGIN > -> IF @@server_id=2 THEN DROP DATABASE accounting; END IF; > -> END; > -> // > mysql> delimiter ; > mysql> CALL unsafe_sp(); > > I've taken this procedure from: > http://dev.mysql.com/doc/refman/5.0/en/stored-procedure-logging.html > > Example of non-deterministic data modifications you can find here as well: > http://dev.mysql.com/doc/refman/5.0/en/open-bugs.html > > You can check by your self if it is possible to replicate functions > which was declared NOT DETERMINISTIC. > > > > > >I have read the replicate document in reference manual.But i have some > >question. > > >1.If a deterministic storeprocedure only use in replication? > >2.If a procedure within replication must be deterministic? > >3.When a procedure result is non-deterministic?Can i get a example? > > > > > wangxu wrote: > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.NET http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET > <___/ www.mysql.com > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
