pt-query-advisor doesn't warn on a mixture of aggregates and columns in a non-GROUP-BY query

Bug #933467 reported by Baron Schwartz on 2012-02-16
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to
Won't Fix

Bug Description

select continent, group_concat(name) from world.Country

should be RES.001 because if there is an aggregate function and no GROUP BY, then it's an implicit GROUP BY.

Changed in percona-toolkit:
status: New → Confirmed
tags: added: query-rule
Daniel Nichter (daniel-nichter) wrote :

pt-query-advisor was removed in 2.2. Use pt-query-advisor 2.1 or the online tool:

This issue has been moved to

Changed in percona-toolkit:
status: Confirmed → Won't Fix

Percona now uses JIRA for bug reports so this bug report is migrated to:

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

Other bug subscribers