Bug #76641 Inconsistent quoting of @@session.proxy_user

• Submitted: 9 Apr 2015 14:34
• Reporter: Todd Farmer (OCA)
• Status: Verified
• Category: MySQL Server: Security: Privileges
• Severity: S3 (Non-critical)
• Version: 5.7.7
• OS: Any
• CPU Architecture: Any

[9 Apr 2015 14:34] Todd Farmer

Description:
The @@session.proxy_user variable is quoted in ways inconsistent with the output from USER() and CURRENT_USER():

mysql> SELECT USER(), CURRENT_USER(), @@session.proxy_user;
+-------------------+----------------------+-----------------------+
| USER()            | CURRENT_USER()       | @@session.proxy_user  |
+-------------------+----------------------+-----------------------+
| admin_1@localhost | proxy_base@localhost | 'admin_1'@'localhost' |
+-------------------+----------------------+-----------------------+
1 row in set (0.00 sec)

It's not readily apparent why this inconsistency exists.

How to repeat:
See above.

Suggested fix:
Explain the reasons behind the quoting, and/or make consistent with USER() and CURRENT_USER() output.