Kbase P128171: Error 7484 when running select statement with EXISTS function
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/11/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
SYMPTOM(s):
Operation not implemented when running select statement with EXISTS function
Error: Sorry, operation not implemented yet (7484) (State:S1000, Native Code: FFFFB1C8)
The problem happens when referring a field from the main SELECT in the sub-select of a WHERE clause, which contains two (or more) EXISTS functions with an OR operator between them.
CAUSE:
OpenEdge SQL handles sub-queries by transforming them (un-nesting the sub-query) into joins. The un-nesting algorithms in SQL do not support EXISTS predicates which are OR'd together and which contain references to the "outer query".
FIX:
Adjust query to avoid unsupported statements