I am trying to create a function on Azure Database for MariaDB like below:
CREATE FUNCTION hello (s CHAR(20)) RETURNS CHAR(50) DETERMINISTIC RETURN CONCAT('Hello, ',s,'!');
but I am getting the error below:
Error SQL (1419): You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
Azure Database for MySql raises the same error, but we have, on Azure Portal, an option variable "log_bin_trust_function_creators" available to change to active and pass it. MariaDB don't have it available on Azure Portal.
Is there any other solution to enable function creation in Azure Database for MariaDB?
Or is there other way to change "log_bin_trust_function_creators" variable for Azure MariaDB? I tried "SET GLOBAL log_bin_trust_function_creators:=1" but raised:
Erro SQL (1227): Access denied; you need (at least one of) the SUPER privilege(s) for this operation