MySQL Bugs: #96002: 'variable log_bin_trust_function

Bug #96002	'variable log_bin_trust_function_creators' -variable is "hidden".
Submitted:	26 Jun 2019 12:36	Modified:	2 Sep 2019 10:25
Reporter:	Peter Laursen (Basic Quality Contributor)	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Options	Severity:	S3 (Non-critical)
Version:	8.0 - probably any recent	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
The ''variable log_bin_trust_function_creators' variable is explained here
https://dev.mysql.com/doc/refman/8.0/en/stored-programs-logging.html

.. but not listed here
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html

Additionally SHOW VARIABLES does not list this variable, but it can be set with SET GLOBAL statement.

(BTW: this report is a 'spin-off' from https://bugs.mysql.com/bug.php?id=95988)

How to repeat:
1)
SHOW VARIABLES LIKE 'variable log_bin_trust_function_creators'; -- empty set
SET GLOBAL log_bin_trust_function_creators = 1; -- success
SET GLOBAL log_bin_trust_function_creators = 0; -- success

2) Read https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html, search for 'variable log_bin_trust_function_creators' and find nothing.

Suggested fix:
1) Add this particular and possible other affected variables to the output from SHOW VARIABLES 
2)as well as document them here https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html

Further I think the docs page should mention from when the default setting changed from "0" to"1" (what seems to be the case in some 8.0.x version)

Fixed synopsis.

Hi Peter,
Thank you for your bug report.

I agree with you that this is a minor bug in SHOW VARIABLES and in our Documentation.

Verified as reported.

Works for me ;-)

mysql> show global variables like 'log_bin_trust_function_creators';
+---------------------------------+-------+
| Variable_name                   | Value |
+---------------------------------+-------+
| log_bin_trust_function_creators | OFF   |
+---------------------------------+-------+
1 row in set (0.01 sec)

mysql> select @@log_bin_trust_function_creators;
+-----------------------------------+
| @@log_bin_trust_function_creators |
+-----------------------------------+
|                                 0 |
+-----------------------------------+
1 row in set (0.00 sec)

mysql> select version();
+-----------+
| version() |
+-----------+
| 8.0.17    |
+-----------+
1 row in set (0.00 sec)

report wrote:  SHOW VARIABLES LIKE 'variable log_bin_trust_function_creators'; -- empty set

yes, because that's a typo.

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

Closing, based on Shane's comments and a review from the Docs team.

Note - MTR sets this variable to 1 in a .cnf file, so if you start the server using that framework, it will indeed show as 1.

"Server Option, System Variable, and Status Variable Reference":

https://dev.mysql.com/doc/refman/8.0/en/server-option-variable-reference.html

Thank you, folks .....