Mysql tutorial this function has none of deterministic
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)
Ysql> show variables like '% func % ';
+ --------------------------------- + ------- +
| Variable_name | value |
+ --------------------------------- + ------- +
| Log_bin_trust_function_creators | off |
+ --------------------------------- + ------- +
1 row in set (0.00 sec)
Mysql> set global log_bin_trust_function_creators = 1;
Query OK, 0 rows affected (0.00 sec)
Mysql> show variables like '% func % ';
+ --------------------------------- + ------- +
| Variable_name | value |
+ --------------------------------- + ------- +
| Log_bin_trust_function_creators | on |
+ --------------------------------- + ------- +
1 row in set (0.00 sec)
Mysql>