Bug #97666 Contribution by Facebook: Respect capability flags that specify variable values

• Submitted: 16 Nov 2019 16:51
• Modified: 22 Jan 14:51
• Reporter: FBContrib Admin
• Status: Closed
• Category: MySQL Server: Security: Privileges
• Severity: S3 (Non-critical)
• Version: 8.0.13
• OS: Any
• CPU Architecture: Any

[16 Nov 2019 16:51] FBContrib Admin

Description:
Background innformation provided by Facebook:
This resolves https://bugs.mysql.com/bug.php?id=97091.

If a connection is established with the CLIENT_INTERACTIVE flag set, COM_RESET_CONNECTION fails to set wait_timeout to interactive_timeout. This violates the expectation that CLIENT_INTERACTIVE instructs MySQL to set wait_timeout = interactive_timeout following COM_RESET_CONNECTION. 
Use case:

We have clients establishing connections with client_interactive expecting to have the connection be kept alive for interactive_timeout seconds. Instead they experience errors rather than having a live and healthy connection to use following execution of COM_RESET_CONNECTION and then waiting less than interactive_timeout seconds.

Repo: https://github.com/mysql/mysql-server
Patch on top of 8.0.13: https://github.com/mysql/mysql-server/commit/e4924f36486f971f8a04252e01c803457a2c72f7

How to repeat:
See description

Suggested fix:
See contribution code attached

[22 Jan 14:50] Omer Barnir

This contribution from Facebook fixes issue reported in bug#97091.
Thanks for Facebook for the contribution