Error Code: 1418.
Opened this issue · 1 comments
Ran into this error while running the included SQL file CREATE DEFINER=
dayzhivemind@
%FUNCTION
generateUID(
instint) RETURNS bigint(20) BEGIN DECLARE Min BIGINT DEFAULT 10000000; DECLARE Max BIGINT DEFAULT 99999999; DECLARE UID BIGINT DEFAULT 0; WHILE (UID = 0) DO SET UID = ROUND(Min + RAND() * (Max - Min)); IF (UID IN (SELECT ObjectUID FROM object_data WHERE CharacterID = 0 AND Instance = inst)) THEN SET UID = 0; END IF; END WHILE; RETURN UID; END Error Code: 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) 0.000 sec
Ive pushed a commit (hash bec07f624711f796f91208184641f767837927fc) to resolve this error.