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) Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Options Severity:S4 (Feature request)
Version:5.7 OS:Any
Assigned to: CPU Architecture:Any
Tags: 5.7, 8.0.1, deprecation, show_compatibility_56

[24 Mar 2017 15:05] Simon Mudd
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!