pt-query-digest doens't distill IF EXISTS correctly

Bug #821690 reported by Daniel Nichter on 2011-08-05
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit
Status tracked in 2.2
2.1
Undecided
Unassigned
2.2
Low
Daniel Nichter

Bug Description

Imported from http://code.google.com/p/maatkit/issues/detail?id=1232

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
Merged into lp:percona-toolkit at revision 586
Daniel Nichter: Approve on 2013-08-03
Brian Fraser (fraserbn) wrote :

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?

Changed in percona-toolkit:
status: New → Confirmed
Baron Schwartz (baron-xaprb) wrote :

it should distill to DROP foo

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
Daniel Nichter (daniel-nichter) wrote :

Fix should handle all instances of "IF [NOT] EXISTS" in all DDL statements (DROP, CREATE, etc.).

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers