Re: error 1418 when creating stored procedure using mysql 5.0.6

2005-06-06 Thread James Black
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Here are two of the stored procedures I tried, as I had forgotten to send that with my query. I am hoping that the stored procedure will now work, as it hasn't since mysql 5.0.1. Thanx for any help. CREATE PROCEDURE assignItem ( user CHAR(15), ri

re: error 1418 when creating stored procedure using mysql 5.0.6

2005-06-06 Thread SGreen
James Black <[EMAIL PROTECTED]> wrote on 06/06/2005 12:33:40 PM: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > I am curious what has changed in 5.0.6 that leds to this error: > ERROR 1418: This routine is declared to be non-deterministic and to > modify data and binary logging is enabled >

re: error 1418 when creating stored procedure using mysql 5.0.6

2005-06-06 Thread James Black
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I am curious what has changed in 5.0.6 that leds to this error: ERROR 1418: This routine is declared to be non-deterministic and to modify data and binary logging is enabled What should I be looking at changing in my CREATE PROCEDURE call to enable