List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:November 7 2007 6:10pm
Subject:Re: Problems with create procedure
View as plain text  
Marc

>ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or
>READS SQL DATA in its declaration and binary logging is enabled (you *might*
>want to use the less safe log_bin_trust_function_creators variable)

It has to do with whether the fnc is deterministic and how its results might replicate.
Since the controls implied by these attributes are not in fact implemented, the simplest
solution is 

SET GLOBAL log_bin_trust_routine_creators=1;

PB


-----

Pau Marc Munoz Torres wrote:
> Hi
>
>  I'm working with mysql 5.0.24a-log trying to create a procedure as is
> indicated at mysql web page
>
> and i get the following error before "delimiter ;"
>
> mysql> delimiter //
>
> mysql> CREATE FUNCTION hello (s CHAR(20)) RETURNS CHAR(50)
>     -> RETURN CONCAT('Hello, ',s,'!');
>     -> //
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> delimiter ;
>
>
>
> and i get the following error before "delimiter ;"
>
> ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or
> READS SQL DATA in its declaration and binary logging is enabled (you *might*
> want to use the less safe log_bin_trust_function_creators variable)
>
> Can some body tell me what should I do?
>
> thanks
>
> Pau
>
>
>   
> ------------------------------------------------------------------------
>
> No virus found in this incoming message.
> Checked by AVG Free Edition. 
> Version: 7.5.503 / Virus Database: 269.15.24/1115 - Release Date: 11/7/2007 9:21 AM
>   

Thread
Problems with create procedurePau Marc Munoz Torres7 Nov
  • Re: Problems with create procedurePeter Brawley7 Nov