Kbase P128812: SQL-92: Error (7484) using a GROUP BY clause with MINUS operator.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/6/2008 |
|
Status: Unverified
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
OpenEdge Category: SQL
SYMPTOM(s):
SQL-92: Error (7484) using a GROUP BY clause with MINUS operator.
SQL-92: Error (7484) using a GROUP BY clause with INTERSECT operator.
Executing a MINUS or INTERSECT operation where the first component query has a GROUP BY clause.
CAUSE:
The use of the GROUP BY clause in the first component query of a set differencing operation like MINUS or INTERSECT is not currently supported.
FIX:
The use of the GROUP BY clause ONLY in the last component query of a set differencing operation.