Skip to:

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

LP #933465: pt-query-advisor false positive on RES.001

Description

**Reported in Launchpad by Baron Schwartz last update 14-01-2013 22:18:27

select name, population, count from world.Country group by name, population

has no non-deterministic group-by.

Environment

None

Smart Checklist

Activity

Show:

lpjirasync January 24, 2018 at 5:14 PM

**Comment from Launchpad by: Baron Schwartz on: 02-04-2012 10:38:17

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

lpjirasync January 24, 2018 at 5:14 PM

**Comment from Launchpad by: Daniel Nichter on: 17-02-2012 17:56:08

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

Done

Details

Assignee

Reporter

Priority

Labels

Smart Checklist

Created January 24, 2018 at 5:14 PM
Updated January 24, 2018 at 5:14 PM
Resolved January 24, 2018 at 5:14 PM