MySQL：ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA

环境

mysql> select version();
+-----------+
| version() |
+-----------+
| 8.0.16    |
+-----------+

定义函数

-- 最简单的函数
create function foo() returns int
return 10;

报错

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)

原因：

如果我们开启了 bin-log, 我们就必须为我们的function指定一个参数

解决办法：

set global log_bin_trust_function_creators = 1;

参考 ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS