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 routine definitions." >It is a doubt.What do the "deterninistic" option do? > >You ever gave me the follow example: >--------------------------------------------- >create procedure unsafe_sp() >begin > if @@server_id=2 then > drop databaseaccounting; > enf if; >end >--------------------------------------------- >This is a non-deterninistic procedure. > >In your word,The procedure can work in master and slave without any warning >.But the procedure should produce different results on master and slave if >master has server_id=1 and slave has server_id=2. > >If i add "deterninistic" option in the procedure.As follow: >--------------------------------------------- >create procedure unsafe_sp() >DETERMINISTIC >begin > if @@server_id=2 then > drop databaseaccounting; > enf if; >end >--------------------------------------------- > >In your word,syntax check doesn't find the error and the procedure be executed >without warning,too.And the different result also produce in the master and >slave. > >What ever "DETERMINISTIC" option do? -- 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]
