Multi-column IN clause causes false-positive JOI.001
Bug #999722 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 |
Won't Fix
|
Undecided
|
Unassigned |
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.
To post a comment you must log in.
pt-query-advisor was removed in 2.2. Use pt-query-advisor 2.1 or the online tool: https:/ /tools. percona. com/query- advisor.
This issue has been moved to https:/ /github. com/percona/ query-advisor/ issues/ 10.