thread_statistics is a reserved word in 5.5

Bug #997036 reported by Alexey Kopytov on 2012-05-09
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to
Fix Released
Vlad Lesin
Fix Released
Vlad Lesin

Bug Description

In PS 5.5 thread_statistics is a reserved word. Which means you have to quote it when using the system variable with the same name:

mysql> set global thread_statistics=1;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'thread_statistics=1' at line 1

mysql> set global `thread_statistics`=1;
Query OK, 0 rows affected (0.00 sec)

5.1 is not affected, the bug was introduced when porting userstat.patch to 5.5.

Related branches

Vlad Lesin (vlad-lesin) wrote :

And there is no test which would check "thread_statistics" variable for set. "thread_statistics_basic.test" just select that variable.

tags: added: userstat

Percona now uses JIRA for bug reports so this bug report is migrated to:

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers