pt-query-advisor treats distinct() as a function
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."
|Changed in percona-toolkit:|
|status:||Confirmed → Won't Fix|