Error Code: 1418 while creating function

Hi Jaycus!

Thanks for reaching out.

Some distributions of MySQL are set to check if a function or procedure wants to modify the data (which is not the case with our function, but MySQL still checks it).

This can be undone by executing this command:

SET GLOBAL log_bin_trust_function_creators = 1;

Try creating the function after that and tell us if it's working.

Hope this helps.
Best,
Martin

Hi Martin,

Yes, it works now. Thank you!

Hi Jaycus!

Thanks for your reply.

Thank you for letting us know you can proceed with the course!

Good luck and please feel free to post another question should you encounter any difficulties. Thank you.

Best,
Martin,
The 365 Team

Working on production databases, this logging will probably be enabled?
How should the function be designed in order to comply with MySQL validations and error handling?

Hi Michael!

Thanks for reaching out (and pointing this out!).

Probably yes, it will, so you'd be just required to add at least one of the following 3 specifications (DETERMINISTIC, NO SQL, READS SQL DATA) in the queries:

DELIMITER $$
CREATE FUNCTION ...
DETERMINISTIC, NO SQL, READS SQL DATA
...

Otherwise, you should be able to remove the logging by executing the following command:

SET GLOBAL log_bin_trust_function_creators = 0;

Hope this helps.Best,
Martin