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

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".

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