pt-query-advisor doesn't notice JOI.003
Bug #985577 reported by
Baron Schwartz
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Won't Fix
|
Medium
|
Unassigned |
Bug Description
select distinct A.id 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 A.name, A.id
LIMIT 0,10
This should give a JOI.003 (outer join defeated), but it doesn't.
tags: | added: query-rule |
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/ 3.