This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary
This warning is rising because as the default MySQL server supports replication. This means that BINARY LOGGING is turned ON.
So, there is a replication log that contains all the changes that is made to the database.
Unfortunately, MySQL is not checking the statements that are stored in the SPs or UDFs. The server can't say, whether the procedure changes the data in the database or not.
That is why MySQL server asks for the explicit specification of the operations that are performed inside the SP or UDF, if the binary logging is on.
This doesn't mean that the procedure will be prohibited to execute the update statements if it is defined as DETERMINISTIC or READS SQL DATA or NO SQL. The characteristics are advisory only.
So, If you are not replicating your server and the binary logging is on as the default, just turn it off to not receive the warning.
Or, if you are replicating the server then you can:
1. Set the SUPER privileges for your user;
2. Change the system variable for the server like:
mysql> SET GLOBAL log_bin_trust_function_creators = 1 ;
3. Set this variable by using the --log-bin-trust-function-creators=1 option when starting the server.
分享到：
相关推荐
MySQL数据库在开启二进制日志(bin-log)功能后，可能会遇到一个特定的错误：“This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled...”。...
代码如下: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_...
然而，在创建自定义函数时，可能会遇到一些问题，比如“此函数在声明中没有DETERMINISTIC、NO SQL或READS SQL DATA，并且二进制日志已启用”的错误。本文将深入探讨这个错误的原因以及如何解决它。 首先，让我们...
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)
提供的PDF文件"sharp1418-This-function-has-none-of-DETERMINISTIC.pdf"很可能包含了详细步骤或更深入的解释，包括如何检查和修改函数定义，以及二进制日志配置的调整方法。建议阅读这份文档以获取更全面的解决方案...
在MySQL数据库中，当你尝试创建自定义函数或者导入包含自定义函数的SQL文件时，可能会遇到这样一个错误：“his function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary ...
然而，在尝试开启bin-log日志时，用户可能会遇到错误提示：“This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled”。这个错误通常发生在创建...
mysql> delimiter // mysql> CREATE FUNCTION Uf_new_product_id() -> RETURNS VARCHAR(32) ...ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its
This function has none of DETERMINISTIC, NOSQL, 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) ...
错误信息"ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled"提示，存储过程或函数未指定DETERMINISTIC、NO SQL或READS ...
ErrorCode: 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_...
在尝试执行某些SQL函数或存储过程时，可能会遇到错误代码1418：“This function has none of DETERMINISTIC, NOSQL, or READS SQL DATA in its declaration and binary logging is enabled”。 **原因分析**： 此...
然而，在某些情况下，尝试创建或使用自定义函数时，可能会遇到错误提示，例如"ERROR 1418 : This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is ...
当你尝试创建用户定义的函数（UDF），并遇到"ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled"错误，这意味着由于二...
在遇到"ERROR 1418 (HY000): This routine has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled"这样的错误时，意味着在尝试创建或修改存储函数（包括存储过程...