MySQL Bugs: #52239: Wrong datatype specified for log

Bug #52239	Wrong datatype specified for log_output in docs
Submitted:	20 Mar 2010 5:26	Modified:	22 Mar 2010 15:39
Reporter:	Shlomi Noach (OCA)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	>= 5.1	OS:	Any
Assigned to:	Paul DuBois	CPU Architecture:	Any
Tags:	log_output

Description:
On:
http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_log_output

Describing the log_output variable, under "Permitted values", it is stated that the data type for this variable is enumeration.
However, it is actually a SET, as it allows for multiple values.

How to repeat:
How to repeat? Refresh the web page in your browser ;)

Suggested fix:
Change documented data type to SET

Though, the '' value is disallowed.
So this is actually in between ENUM and SET.

Thank you for the problem report.

77-52-28-202:5.1 openxs$ bin/mysql -uroot test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.46-debug Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> set global log_output='FILE,TABLE';
Query OK, 0 rows affected (0.00 sec)

mysql> show global variables like '%output%';
+---------------+------------+
| Variable_name | Value      |
+---------------+------------+
| log_output    | FILE,TABLE |
+---------------+------------+
1 row in set (0.00 sec)

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.

"set" is more correct because multiple values are allowed.