pt-query-digest doens't distill IF EXISTS correctly
Bug #821690 reported by
Daniel Nichter
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Percona Toolkit moved to https://jira.percona.com/projects/PT |
Fix Released
|
Low
|
Daniel Nichter | ||
| 2.1 |
Won't Fix
|
Undecided
|
Unassigned | ||
| 2.2 |
Fix Released
|
Low
|
Daniel Nichter | ||
Bug Description
Imported from http://
This mostly affect pt-query-digest. "DROP TABLE IF EXIST foo" distills incorrectly to "DROP TABLE IF".
Related branches
lp:~percona-toolkit-dev/percona-toolkit/fix-pqd-distill-bug-821690
- Daniel Nichter: Approve
-
Diff: 94 lines (+26/-15)4 files modifiedbin/pt-query-digest (+1/-0)
lib/QueryRewriter.pm (+2/-0)
t/lib/QueryRewriter.t (+14/-0)
t/pt-query-digest/processlist.t (+9/-15)
Revision history for this message
| Brian Fraser (fraserbn) wrote | #1 |
| Changed in percona-toolkit: | |
| status: | New → Confirmed |
Revision history for this message
| Baron Schwartz (baron-xaprb) wrote | #2 |
| Changed in percona-toolkit: | |
| milestone: | none → 2.2.5 |
| summary: |
- IF EXISTS doesn't distill correctly + pt-query-digest doens't distill IF EXISTS correctly |
Revision history for this message
| Daniel Nichter (daniel-nichter) wrote | #3 |
Revision history for this message
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #4 |
To post a comment you must log in.
This is obviously wrong, but it's not clear to me what the correct behavior ought to be. Should it distill to anything different than the original?