Hello.
At least, some notes we have at:
http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html
Currently, the DETERMINISTIC characteristic is accepted, but not yet
used by the optimizer. However, if binary logging is enabled, this
characteristic affects whether MySQL accepts
warning,too.And the different result also produce in the master and
slave.
What ever DETERMINISTIC option do?
- Original Message -
From: Gleb Paharenko [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, December 16, 2005 5:38 PM
Subject: (瑞星提示-此邮件可能是垃圾邮件)Re: use deterministic within
Hello.
In the example,routine_body is non-deterministic.But the function
defined DETERNINISTIC.Do mysql throw a exception in creating process?
In my opinion, it shouldn't, but you can check this by yourself.
I want to say,if i my funciton is a non-deterministic function.But i
Hello.
In my opinion, master shouldn't have any problems, but slave can have
different data than master.
What would happen if i call a non-deterministic function that have been
declared deterministic.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This
:44 PM
Subject: Re: use deterministic within procedure
Hello.
In my opinion, master shouldn't have any problems, but slave can have
different data than master.
What would happen if i call a non-deterministic function that have been
declared deterministic.
--
For technical
, 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
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
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?