Bug #75951 SHOW GLOBAL VARIABLES WHERE not deprecated in embedded

• Submitted: 18 Feb 2015 10:00
• Modified: 26 Mar 2015 20:56
• Reporter: Magnus Blåudd
• Status: Closed
• Category: MySQL Server: Errors
• Severity: S3 (Non-critical)
• Version: 5.7.6
• OS: Any
• CPU Architecture: Any

[18 Feb 2015 10:00] Magnus Blåudd

Description:
The command SHOW GLOBAL VARIABLES WHERE is marked as deprecated in 5.7. This causes a deprecation warning to be shown when a query with that command is run.

However when the embedded mysqld is used no such warning is returned. Are we going to keep the command in embedded?

It might be something related to the test tools but since not even a subsequent SHOW WARNINGS shows the warning, it must be something else.

How to repeat:
$> mtr show_global_variables_deprecated
SHOW GLOBAL VARIABLES WHERE Variable_name LIKE "abc";
Variable_name	Value
Warnings:
Warning	1287	'SHOW GLOBAL VARIABLES WHERE' is deprecated and will be removed in a future release. Please use performance_schema.global_variables instead
SHOW WARNINGS;
Level	Code	Message
Warning	1287	'SHOW GLOBAL VARIABLES WHERE' is deprecated and will be removed in a future release. Please use performance_schema.global_variables instead

$> mtr show_global_variables_deprecated --embedded
SHOW GLOBAL VARIABLES WHERE Variable_name LIKE "abc";
Variable_name	Value
SHOW WARNINGS;
Level	Code	Message

Attaching the show_global_variables_deprecated.test

Suggested fix:
Show deprecation warning also for embedded mysqld(i.e libmysqld)

[26 Mar 2015 20:56] Paul DuBois

Noted in 5.7.7, 5.8.0 changelogs.

For the embedded server, proper deprecation warning were not produced
for SHOW VARIABLES and SHOW STATUS statements that included a WHERE
clause.