Bug #81697 MySQL CLI WARNINGS should goto stderr

• Submitted: 2 Jun 2016 18:37
• Modified: 3 Jun 2016 8:38
• Reporter: John Cesario
• Status: Verified
• Category: MySQL Server: Command-line Clients
• Severity: S3 (Non-critical)
• Version: 5.7, 5.7.12
• OS: Any
• CPU Architecture: Any

[2 Jun 2016 18:37] John Cesario

Description:
MySQL CLI does not send warnings to stderr, this is unexpected as well as inconsistent with the various perl and shell utilities also shipped with mysql.

this is not WARNINGS as reported by mysqld from queries, but WARNINGS from the CLI itself.

How to repeat:
> mysql --version
mysql  Ver 14.14 Distrib 5.7.12, for Linux (x86_64) using  EditLine wrapper

> cat ~/.my.cnf
[client]
ssl                = true

> mysql --version 1>/dev/null
>

> mysql --version 2>/dev/null
WARNING: --ssl is deprecated and will be removed in a future version. Use --ssl-mode instead.
mysql  Ver 14.14 Distrib 5.7.12, for Linux (x86_64) using  EditLine wrapper

Suggested fix:
WARNINGS should goto stderr for all mysql CLI utilities

[2 Jun 2016 23:56] Chris Giard

Potential partial fix

Attachment: 0005-Fix-Bug-81697.patch (application/octet-stream, text), 1.61 KiB.

[3 Jun 2016 8:38] MySQL Verification Team

Hello John Cesario,

Thank you for the report.

Thanks,
Umesh

[3 Jun 2016 8:44] MySQL Verification Team

In order to submit contributions you must first sign the Oracle Contribution Agreement (OCA). For additional information please check http://www.oracle.com/technetwork/community/oca-486395.html.
If you have any questions, please contact the MySQL community team.