pt-query-advisor gives false JOI.003

Bug #937221 reported by Baron Schwartz
6
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

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 t2.id = f.id

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

tags: added: query-rule
Revision history for this message
Daniel Nichter (daniel-nichter) wrote :

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/1.

Changed in percona-toolkit:
status: Confirmed → Won't Fix
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-478

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.