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 Email Updates:
Status: Verified Impact on me:
None 
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 
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

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

Page generated in 0.053 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.