pt-query-advisor treats distinct() as a function

[Baron Schwartz]

select distinct (continent), name from world.Country;

Shlomi's description is best: "there is nothing wrong syntactically, but the author of the query might be confused to think that DISTINCT is a function, and that it only works for the 'continent' column, whereas it works for the entire set of columns."

[Daniel Nichter (daniel-nichter)]

To clarify the problem:

$ ./pt-query-advisor --query "select distinct (continent), name from world.Country"

No output because the tool doesn't see the problem as Shlomi describes. So, we need to add a rule/check for this.

[Daniel Nichter (daniel-nichter)]

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

[Shahriyar Rzayev (rzayev-sehriyar)]

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