Kbase P12045: SQL92 Java Exception 'Column not found/specified' when evaluating an SQL query
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/11/2008 |
|
Status: Verified
SYMPTOM(s):
SQL Exception "Column not found/specified" when evaluating an SQL query
=== SQL Exception 1 ===
SQLState=42S22
ErrorCode=-20006
[JDBC Progress Driver]:Column not found/specified (7520)
Column not found/specified (7520)
FACT(s) (Environment):
Linux Intel
Progress 9.1D
OpenEdge SQL Category: JDBC Drivers
CAUSE:
Bug# 20021031-012
CAUSE:
The error is caused by the usage of aliases in the ORDER BY clause that refer to functions/scalar operations
FIX:
Upgrade to Progress 9.1D08 or higher