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

[27 Aug 2014 16:48] Jaime Crespo
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.
[27 Aug 2014 18:56] Miguel Solorzano
Thank you for the bug report.
[27 Aug 2014 18:58] Miguel Solorzano
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)
[1 Sep 2014 17:11] Paul Dubois
Looks like it changed in 5.7.2
[1 Sep 2014 17:18] 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.