Bug #11784 log_bin_trust_routine_creators isn't described in the manual
Submitted: 6 Jul 2005 21:22 Modified: 11 Jul 2005 14:01
Reporter: Gleb Paharenko Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.0.7 OS:Linux (Linux)
Assigned to: Stefan Hinz CPU Architecture:Any

[6 Jul 2005 21:22] Gleb Paharenko
Description:
I didn't find the explanation of  log_bin_trust_routine_creators system variable

How to repeat:
Try to find it in the manual

Suggested fix:
Add this variable to 
  http://dev.mysql.com/doc/mysql/en/server-system-variables.html
[7 Jul 2005 0:13] MySQL Verification Team
I just found the below 2 mentions in the Manual:

#

Error: 1418 SQLSTATE: HY000 (ER_BINLOG_UNSAFE_ROUTINE)

Message: This routine is declared to be non-deterministic and to modify data and binary logging is enabled (you *might* want to use the less safe log_bin_trust_routine_creators variable)
#

Error: 1419 SQLSTATE: HY000 (ER_BINLOG_CREATE_ROUTINE_NEED_SUPER)

Message: You do not have SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_routine_creators variable)
[7 Jul 2005 7:33] Gleb Paharenko
Yes, I've found it in the errors before reporting. Really - I've got one of that errors. However, in my opinion, the error-codes page not a good place for explaining system variables. But I could be wrong :)
[11 Jul 2005 14:01] Stefan Hinz
The variable is mentioned in two places now:
http://dev.mysql.com/doc/mysql/en/server-options.html
http://dev.mysql.com/doc/mysql/en/stored-procedure-logging.html