Kbase P12649: The SQL92 UPPER function generates a syntax error when used within the LIKE predicate
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/23/2007 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Using SQL92
UPPER function does not work with LIKE predicate
[JDBC Progress Driver]:Syntax error (7587)
=== SQL Exception 1 ===
SQLState=42000
ErrorCode=-20003
[JDBC Progress Driver]:Syntax error (7587)
CAUSE:
Bug# 20021030-014
CAUSE:
The Progress SQL92 engine is documented to only support a LIKE predicate in the form of 'column name' LIKE 'string constant'. The use of functions in place of 'string constant' is not currently supported.
FIX:
Upgrade to OpenEdge 10.0A or later