Kbase P92791: A SQL-92 statement produces syntax error depending on the order of the search condition.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/08/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
FACT(s) (Environment):
OpenEdge 10.0A
FACT(s) (Environment):
OpenEdge 10.0B
SYMPTOM(s):
A SQL-92 statement produces syntax error depending on the order of the search condition.
Using a query expression on the left side of a compare operator.
Using a query expression in a WHERE clause.
Syntax error (7587)
Syntax error in SQL statement at or about "" (10713)
CAUSE:
This behavior is a current limit of Progress SQL-92. The Progress SQL-92 grammar is defined to allow the query expression only on the right side of the compare operator.
CAUSE:
Enhancement request# 20040825-002
FIX:
Put the query expression on the right side of the compare operator. The following illustrates this with an example:
- Instead of:
(SELECT SUM(Price) FROM pub.orderline WHERE ordernum = O.ordernum) > 100;
- Use:
100 < (SELECT SUM(Price) FROM pub.orderline WHERE ordernum = O.ordernum);