Skip to:

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

LP #999722: Multi-column IN clause causes false-positive JOI.001

Description

**Reported in Launchpad by Daniel Nichter last update 13-03-2013 15:18:09

A query like:

SELECT <cols> JOIN <table> ON <col> IN (<col1>, <col2>) WHERE <where>

cause pt-query-advisor to report "JOI.001 - Mixing comma and ANSI joins". It's probably confusing the IN clause for a comma join.

Environment

None

Smart Checklist

Activity

Show:

lpjirasync January 24, 2018 at 6:36 PM

**Comment from Launchpad by: Daniel Nichter on: 13-03-2013 15:18:03

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

Won't Do

Details

Assignee

Reporter

Priority

Labels

Smart Checklist

Created January 24, 2018 at 6:36 PM
Updated February 4, 2018 at 1:51 AM
Resolved January 24, 2018 at 6:36 PM

Flag notifications