Bug #85610 Add deprecation warning to MySQL 5.7 for show_compatibility_56

• Submitted: 24 Mar 2017 15:05
• Modified: 30 Mar 2017 5:59
• Reporter: Simon Mudd (OCA)
• Status: Verified
• Category: MySQL Server: Options
• Severity: S4 (Feature request)
• Version: 5.7
• OS: Any
• CPU Architecture: Any
• Tags: 5.7, 8.0.1, deprecation, show_compatibility_56

[24 Mar 2017 15:05] Simon Mudd

Description:
On startup of 8.0.1 after upgrading from 5.7.17 I noticed the server failed.
This worked in 8.0.0.

The reason being I had the following configuration setting show_compatibility_56=1 in /etc/my.cnf.

How to repeat:
Startup of 8.0.1 shows:

2017-03-24T14:25:41.001315Z 3 [ERROR] /usr/sbin/mysqld: Unknown system variable 'show_compatibility_56'

and the server aborts the startup.

I previously had the setting show_compatibility_56=1 (in MySQL 5.7.17)

Suggested fix:
Please add to future 5.7 releases the following warning to make people aware of this deprecation if the variable is used.

WARNING: system variable show_compatibility_56 is deprecated and is not supported in MySQL 8.0 and later.

[30 Mar 2017 5:59] MySQL Verification Team

Hello Simon,

Thank you for the report and feedback!

Thanks,
Umesh