pt-query-advisor doesn't notice JOI.003

Bug #985577 reported by Baron Schwartz on 2012-04-19
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit

Bug Description

select distinct from tab_a A
left join tab_b B on A.col_1=B.col_2
left join tab_c C on B.col_3=C.col_4
where B.col_2='xyz' and C.col_3='111'
group by,
LIMIT 0,10

This should give a JOI.003 (outer join defeated), but it doesn't.

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