Kbase P118242: SQL: Error (7520) qualifying a field alias with its table alias in an SQL query.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/10/2008 |
|
Status: Unverified
SYMPTOM(s):
SQL: Error (7520) qualifying a field alias with its table alias in an SQL query.
=== SQL Exception 1 ===
SQLState=42S22
ErrorCode=-20006
[JDBC Progress Driver]:Column not found/specified (7520)
If a query references a field using both a table and a column alias as in:
my_table_alias.my_column_alias
then the query fails with Column not found/specified error.
Executing a query similar to:
SELECT
TableAliasName.CustNum AS FieldAliasName
FROM
PUB.Customer TableAliasName
WHERE
TableAliasName.FieldAliasName > 10;
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.1E04 Service Pack
OpenEdge 10.1A01 Service Pack
OpenEdge 10.1A02 Service Pack
CAUSE:
Bug# OE00131802
CAUSE:
This is a regression bug specific to Progress 9.1E04, OpenEdge 10.1A01 and OpenEdge 10.1A01 Service Packs only.
FIX:
Upgrade to OpenEdge 10.1C or later. If upgrading to OpenEdge 10.1C or later is not feasible, then rewrite the query in one of the following two forms:
SELECT
TableAlias.CustNum AS FieldAlias
FROM
PUB.Customer TableAlias
WHERE
FieldAlias > 10;
or
SELECT
TableAlias.CustNum AS FieldAlias
FROM
PUB.Customer TableAlias
WHERE
TableAlias.CustNum > 10;