Problème Fonction

[Aurélien FURON]

Alors toujours dans ma requête j'ai le message suivant lors de l'exécution:

CREATE FUNCTION `DateReserveePar` (

sDate VARCHAR( 10 ) ,
nNumVilla TINYINT( 4 )
) RETURNS varchar( 1000 ) NOT DETERMINISTICSQL SECURITY DEFINER COMMENT '' BEGIN DECLARE nbRes int DEFAULT 0;

DECLARE CHECKDATE DATE;

DECLARE sRes VARCHAR( 1000 ) DEFAULT '';

SET CHECKDATE = str_to_date( sDate, '%d/%m/%Y' ) ;

SELECT COUNT( * )
INTO nbRes
FROM reservations r, clients c
WHERE r.`NumClient` = c.`NumClient`
AND NumVilla = nNumVilla
AND r.Deldate IS NULL
AND CHECKDATE
BETWEEN DateDeb
AND (
DateFin - INTERVAL 1
DAY
);

IF nbRes >0 THEN SELECT concat( r.`Confirme` , SUBSTR(
c.`Prenom` , 1, 1
), '. ', substr(
c.`Nom` , 1, 1
), '.' )
INTO sRes
FROM reservations r, clients c
WHERE r.`NumClient` = c.`NumClient`
AND NumVilla = nNumVilla
AND r.Deldate IS NULL
AND CHECKDATE
BETWEEN DateDeb
AND (
DateFin - INTERVAL 1
DAY
);

END IF ;

RETURN sRes;

END |

MySQL a répondu:

#1418 - 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)

Une tite aide please ?