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

Bug #821690 reported by Daniel Nichter on 2011-08-05
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to
Fix Released
Daniel Nichter
Won't Fix
Fix Released
Daniel Nichter

Bug Description

Imported from

This mostly affect pt-query-digest. "DROP TABLE IF EXIST foo" distills incorrectly to "DROP TABLE IF".

Related branches

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

Percona now uses JIRA for bug reports so this bug report is migrated to:

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

Other bug subscribers