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] MySQL Verification Team
Thank you for the bug report.
[27 Aug 2014 18:58] MySQL Verification Team
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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.