Bug #116621 log_bin_trust_function_creators is not marked "deprecated" in 8.4 Doc

• Submitted: 12 Nov 2:28
• Modified: 12 Nov 5:34
• Reporter: Tsubasa Tanaka (OCA)
• Status: Verified
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 8.4
• OS: Any
• CPU Architecture: Any

[12 Nov 2:28] Tsubasa Tanaka

Description:
log_bin_trust_function_creators option had been deprecated at 8.0.34.

https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html#sysvar_log_bin...

But 8.4 series doesn't have "depreacated" field.

https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html#sysvar_log_bin...

How to repeat:
See https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html#sysvar_log_bin...

Suggested fix:
Add "deprecated" field and/or description.

mysql --help --verbose is correctly describing it is deprecated.

```
mysqld --help --verbose
..
  --log-bin-trust-function-creators
                      If set to FALSE (the default), then when --log-bin is
                      used, creation of a stored function (or trigger) is
                      allowed only to users having the SUPER privilege and only
                      if this stored function (trigger) may not break binary
                      logging. Note that if ALL connections to this server
                      ALWAYS use row-based binary logging, the security issues
                      do not exist and the binary logging cannot break, so you
                      can safely set this to TRUE. This variable is deprecated
                      and will be removed in a future version.
..
```

[12 Nov 5:34] MySQL Verification Team

Hello tanaka-San,

Thank you for the report and feedback.

regards,
Umesh

[12 Nov 9:02] Edward Gilmore

Posted by developer:
 
This is not a bug. The Deprecated field is present in the table for the 8.4 version as in the 8.0 version.
The only difference is that the deprecated field for 8.4 does not contain the version number, as it was deprecated in a previous release series.

Thank you for the report.