MySQL Bugs: #73745: log_warnings (deprecated) documented default value is 1 instead of 2

Bug #73745	log_warnings (deprecated) documented default value is 1 instead of 2
Submitted:	27 Aug 2014 16:48	Modified:	1 Sep 2014 17:18
Reporter:	Jaime Crespo (OCA)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	5.7	OS:	Any
Assigned to:	Paul DuBois	CPU Architecture:	Any

Description:
Server variable/mysqld option default log_warnings (deprecated) is documented as being 1:
http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_log_warnings 
http://dev.mysql.com/doc/refman/5.7/en/server-options.html#option_mysqld_log-warnings

But it is 2 on 5.7.4 by default:

[jynus@jynus load_data]$ ~/sandboxes/msb_5_7_4/use
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.7.4-m14 MySQL Community Server (GPL)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

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

mysql [localhost] {msandbox} ((none)) > SHOW GLOBAL VARIABLES like 'log_warnings';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_warnings  | 2     |
+---------------+-------+
1 row in set (0.00 sec)

I found this while doing a diff of 5.6 and 5.7 variables: http://dbahire.com/changes-in-configuration-of-global-variables-between-mysql-5-6-20-and-m...

How to repeat:
How to repeat: go to your source code, check that effectively there is a 2 here:

http://bazaar.launchpad.net/~mysql/mysql-server/5.7/view/head:/sql/sys_vars.cc#L1713

Check that there is a 1 here:

http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_log_warnings

:-)

Suggested fix:
1) Finally deprecate log_warnings in 5.7, close this as a WONTFIX (you still have to document it, though, so I prefer #2).

2) Maintain log_warnings even if deprecated and document it as value by default 2.

Thank you for the bug report.

C:\dbs>c:\dbs\5.7\bin\mysql -uroot --port=3570 --prompt="mysql 5.7 > "
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.7.5-m15 Source distribution

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

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

mysql 5.7 > SHOW GLOBAL VARIABLES like 'log_warnings';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_warnings  | 2     |
+---------------+-------+
1 row in set (0.00 sec)

Looks like it changed in 5.7.2

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly.