Multi-column IN clause causes false-positive JOI.001

Bug #999722 reported by Daniel Nichter on 2012-05-15
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to
Won't Fix

Bug Description

A query like:

SELECT <cols> JOIN <table> ON <col> IN (<col1>, <col2>) WHERE <where>

cause pt-query-advisor to report "JOI.001 - Mixing comma and ANSI joins". It's probably confusing the IN clause for a comma join.

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: Confirmed → Won't Fix

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