thread_statistics is a reserved word in 5.5
Bug #997036 reported by
Alexey Kopytov
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Low
|
Vlad Lesin | ||
| 5.5 |
Fix Released
|
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_
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_
mysql> set global `thread_
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
lp:~vlad-lesin/percona-server/issue-21170-ssl_connections_counting
- Alexey Kopytov (community): Approve
-
Diff: 295 lines (+127/-3)8 files modifiedPercona-Server/mysql-test/r/percona_ssl_connections_count.result (+21/-0)
Percona-Server/mysql-test/suite/sys_vars/r/thread_statistics_basic.result (+3/-0)
Percona-Server/mysql-test/suite/sys_vars/t/thread_statistics_basic.test (+3/-0)
Percona-Server/mysql-test/t/percona_ssl_connections_count.test (+79/-0)
Percona-Server/sql/sql_connect.cc (+10/-2)
Percona-Server/sql/sql_show.cc (+6/-1)
Percona-Server/sql/sql_yacc.yy (+1/-0)
Percona-Server/sql/structs.h (+4/-0)
Revision history for this message
| Vlad Lesin (vlad-lesin) wrote | #1 |
| tags: | added: userstat |
Revision history for this message
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #2 |
To post a comment you must log in.
And there is no test which would check "thread_statistics" variable for set. "thread_