Bug #75980 performance_schema.global_variables mystery deprecation warning
Submitted: 20 Feb 2015 12:16 Modified: 24 Mar 2015 17:43
Reporter: Magnus Blåudd Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Performance Schema Severity:S3 (Non-critical)
Version:5.7.6 OS:Any
Assigned to: Marc ALFF CPU Architecture:Any

[20 Feb 2015 12:16] Magnus Blåudd
Description:
Tried to convert one SHOW GLOBAL VARIABLES to use the new performance_schema.global_variables and then a mystery deprecation warning pops up complaining about sql_log_bin. 

How to repeat:
set global SHOW_COMPATIBILITY_56 = OFF;
SELECT *
FROM performance_schema.global_variables
WHERE Variable_name LIKE 'something';
VARIABLE_NAME	VARIABLE_VALUE
Warnings:
Warning	1287	'@@global.sql_log_bin' is deprecated and will be removed in a future release. Please use the constant 1 (since @@global.sql_log_bin is always equal to 1) instead
set global SHOW_COMPATIBILITY_56 = ON;

Suggested fix:
Don't show deprecation warning for sql_log_bin when querying  performance_schema.global_variables.
[24 Mar 2015 17:43] Paul DuBois
Noted in 5.7.8, 5.8.0 changelogs.

Selecting from the Performance Schema global_variables table resulted
in a sprurious warning about the sql_log_bin system variable.
[26 Mar 2015 13:34] Paul DuBois
Noted in 5.7.7 (not 5.7.8) changelog.