Kbase P129335: SQL-92: Error (10713) generated using the IS [NOT] NULL predicate.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/02/2008 |
|
Status: Unverified
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
SYMPTOM(s):
SQL-92: Error (10713) generated using the IS [NOT] NULL predicate.
Syntax error in SQL statement at or about "IS NULL" (10713)
[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Syntax error in SQL statement at or about "IS NULL" (10713)
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Syntax error in SQL statement at or about "IS NOT NULL" (10713)
Executing queries involving the NULL predicate and arithmetical expressions like:
SELECT * FROM PUB.Customer WHERE CustNum + 1 IS NULL;
and
SELECT * FROM PUB.Customer WHERE CustNum * 5 IS NOT NULL;
Syntax error in SQL statement at or about "IS NULL" (10713)
CAUSE:
The original support for the NULL predicate is for column names only. Staring with OpenEdge 10.0B, Progress extended this support to allow most scalar functions to be used with the NULL predicate. The use of arithmetical operators expressions like Custnum + 1, Balance - 1000.99, CreditLimit / 5 or Amount * 0.05 are not supported at this time.
FIX:
Do not use column expressions involving arithmetical operators with the IS [NOT] NULL predicate as these are not supported at this time.