Bug #34729 | CREATE TRIGGER does not look at log_bin_trust_function_creators | ||
---|---|---|---|
Submitted: | 21 Feb 2008 14:55 | Modified: | 22 Feb 2008 8:51 |
Reporter: | Gertjan Oude Lohuis | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Documentation | Severity: | S3 (Non-critical) |
Version: | 5.0.45 | OS: | Linux |
Assigned to: | Paul DuBois | CPU Architecture: | Any |
[21 Feb 2008 14:55]
Gertjan Oude Lohuis
[21 Feb 2008 21:25]
Paul DuBois
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products. log_bin_trust_function_creators does not apply to triggers. Revising the relevant passage to say this: Triggers are similar to stored functions, so the preceding remarks regarding functions also apply to triggers with the following exceptions: log_bin_trust_function_creators does not apply to triggers and does not affect the privileges required for CREATE TRIGGER. Also, CREATE TRIGGER does not have an optional DETERMINISTIC characteristic, so triggers are assumed to be always deterministic. However, this assumption might in some cases be invalid. For example, the UUID() function is non-deterministic (and does not replicate). You should be careful about using such functions in triggers.
[22 Feb 2008 8:51]
Gertjan Oude Lohuis
Thanks, although I'd rather seen you pointing out my mistake, because I'd like to be able to offer my users triggers :-).