pt-query-advisor parses text within comments

Bug #821695 reported by Daniel Nichter on 2011-08-05
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit
Brian Fraser

Bug Description

Imported from

Quoting the original:

While checking for rule 'STA.001', the tool seems to blindly scan the query for the pattern '!=', and reports it even if it appears in comments, thus incorrectly reporting that the query has a non standard operation.

e.g. A STA.001 note is generated for the query:
/* use <> instead of != */ SELECT a.col FROM table as a WHERE a.col2 = 20

Brian Fraser (fraserbn) on 2012-03-08
Changed in percona-toolkit:
status: New → Confirmed
Brian Fraser (fraserbn) on 2012-12-04
Changed in percona-toolkit:
assignee: nobody → Brian Fraser (fraserbn)
status: Confirmed → In Progress
Daniel Nichter (daniel-nichter) wrote :

pt-query-advisor was removed in 2.2. Use pt-query-advisor 2.1 or the online tool:

This issue has been moved to

Changed in percona-toolkit:
status: In Progress → Won't Fix
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers