Kbase P12041: SQL92 Java Exception 'Column ambiguously specified' when evaluating an SQL query
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/25/2008 |
|
Status: Verified
SYMPTOM(s):
SQL Exception "Column ambiguously specified" when evaluating an SQL query
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-20009
[JDBC Progress Driver]:Column ambiguously specified (7523)
Column ambiguously specified (7523)
FACT(s) (Environment):
Linux Intel
Progress 9.1D
OpenEdge SQL Category: JDBC Drivers
CAUSE:
Bug# 20021031-013
CAUSE:
The error is caused by using aliases in the ORDER BY clause that refer to functions/scalar operations in a selection list cause
FIX:
Upgrade to Progress 9.1D08 or higher