pt-query-advisor false positive on RES.001

Reported by Baron Schwartz on 2012-02-16
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit
Low
Brian Fraser

Bug Description

select name, population, count(*) from world.Country group by name, population

has no non-deterministic group-by.

Daniel Nichter (daniel-nichter) wrote :

The code probably doesn't treat "count(*)" specially. It probably treats it as a normal column like "name" and "population".

Changed in percona-toolkit:
status: New → Confirmed
tags: added: query-rule
Baron Schwartz (baron-xaprb) wrote :

Another example from a user:

SELECT ID_organization,ToNalog,ID_nachtype, COUNT(*) as Cnt
FROM buh_provodka_zp
GROUP BY ID_organization,ToNalog,ID_nachtype
HAVING Cnt>1
ORDER BY Cnt DESC

Brian Fraser (fraserbn) on 2012-11-07
Changed in percona-toolkit:
assignee: nobody → Brian Fraser (fraserbn)
status: Confirmed → In Progress
Brian Fraser (fraserbn) on 2012-11-09
Changed in percona-toolkit:
milestone: none → 2.1.7
Changed in percona-toolkit:
milestone: 2.1.7 → 2.1.8
Changed in percona-toolkit:
importance: Undecided → Low
Brian Fraser (fraserbn) on 2012-12-05
Changed in percona-toolkit:
status: In Progress → Fix Committed
Changed in percona-toolkit:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers