MySQL Tutorial This function has none of deterministic
This function has none of the deterministic, no SQL, or reads SQL data in the its declaration and binary logging are 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>