Kbase P119058: The SQL aggregate functions return the wrong result for a SELECT query that contains a subquery
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/09/2006 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1E
OpenEdge 10.1A
OpenEdge 10.0B
SYMPTOM(s):
The SQL aggregate functions return the wrong result for a SELECT query that contains a subquery
Incorrect result set of SQL-92 query when NOT using GROUP BY
The same SELECT SUM statement with a GROUP BY on one of the fields of WHERE close returns the correct result set
CAUSE:
Bug# 20060712-001
FIX:
Upgrade to:
- 10.1A Service pack 2 or
- 10.1B or