Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

LP #937221: pt-query-advisor gives false JOI.003

Description

**Reported in Launchpad by Baron Schwartz last update 13-03-2013 14:57:26

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.

Environment

None

Smart Checklist

Activity

Show:

lpjirasync January 24, 2018 at 3:16 PM

**Comment from Launchpad by: Daniel Nichter on: 13-03-2013 14:57:16

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.

Won't Do

Details

Assignee

Reporter

Priority

Labels

Smart Checklist

Created January 24, 2018 at 3:15 PM
Updated February 3, 2018 at 9:26 PM
Resolved January 24, 2018 at 3:16 PM

Flag notifications