Kbase P126886: SQL-92: Error (7641) using a function in the GROUP BY clause.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/11/2007 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
Progress 9.1x
OpenEdge 10.0x
OpenEdge 10.1A
SYMPTOM(s):
SQL-92: Error (7641) using a function in the GROUP BY clause.
Non-group-by expression in select clause (7641)
Executing an SQL-92 query similar to:
SELECT
YEAR(InvoiceDate),
MONTH(InvoiceDate),
SUM(amount)
FROM
PUB.invoice
GROUP BY
YEAR(InvoiceDate),MONTH(InvoiceDate)
FIX:
OpenEdge support for functions in the GROUP BY clause started in 10.1A01. This support is a Progress SQL-92 extension. Upgrade to OpenEdge 10.1A01 or higher if you need support of scalar expressions in the GROUP BY clause.