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)

set global log_bin_trust_function_creators = 1;