Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-1913

LP #997036: thread_statistics is a reserved word in 5.5

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Alexey Kopytov last update 12-09-2013 17:59:50

      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.

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: