1418 (HY000) at line 10185: 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)

1418 (HY000) at line 10185: 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)

Comment

0

Execute the following in the MySQL console: SET GLOBAL log_bin_trust_function_creators = 1; Add the following to the mysql.ini configuration file: log_bin_trust_function_creators = 1;

Popularity 7/10 Helpfulness 7/10 Language whatever

Source: stackoverflow.com

Tags: declaration less line sql whatever

Share

Link to this answer
Share Copy Link

Contributed on Aug 22 2023

Victorious Vicuña

0 Answers  Avg Quality 2/10

---

Closely Related Answers

Error Code: 1418. This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled

Comment

1

#For temporary (safe) solution CREATE FUNCTION f2() RETURNS CHAR(36) CHARACTER SET utf8 /*ADD HERE */ READS SQL DATA DETERMINISTIC BEGIN .... #For permanent solution SET @@global.log_bin_trust_function_creators := 1; #This disables the binary log when creating functions

Popularity 7/10 Helpfulness 6/10 Language sql

Source: Grepper

Tags: declaration sql

Share

Link to this answer
Share Copy Link

Contributed on Jul 23 2023

Ayoni02

0 Answers  Avg Quality 2/10

---