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: | |
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
[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