pt-query-advisor gives false JOI.003

Bug #937221 reported by Baron Schwartz on 2012-02-20
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit

Bug Description

JOI.003 does not apply to this query:

select f FROM t1
  inner join t2 using (c)
  left outer join t2 as aliased using(c)
where =

That is because the WHERE is against the t2 table, not the "aliased" table which is left joined.

tags: added: query-rule
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
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers