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
