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
• Status: Closed
• 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.