OQ143037

This column list is not valid for GROUP BY/aggregate functions.

Reason:

A column list is invalid for one of the following reasons:

When a SELECT statement contains a GROUP BY clause and/or aggregate functions, the column list can list only columns or aggregate functions that are specified as GROUP BY columns.
When a column is included in a column list but not in an expression, the column must be a GROUP BY column.
When an expression is included in the column list, the expression (or its components) must be in the GROUP BY specification.

For example:

SELECT QTY FRO ORDER GROUP BY QTY              (valid)
SELECT ITEM FROM ORDER GROUP BY QTY            (invalid)
SELECT TOTAL(ITEM) FROM ORDER GROUP BY QTY     (valid)
SELECT QTY*7 FROM ORDER GROUP BY QTY*7         (valid)
SELECT QTY*7 FROM ORDER GROUP BY QTY*9         (invalid)
SELECT QTY*PRICE FROM ORDER GROUP BY QTY,PRICE (valid)
SELECT QTY*PRICE FROM ORDER GROUP BY QTY       (invalid)

Module:

OLQSSCAN

Severity: