Percona Server with XtraDB

thread_statistics is a reserved word in 5.5

Reported by Alexey Kopytov on 2012-05-09
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server
Low
Vlad Lesin
5.5
Low
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.

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
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers