Kbase P122878: SQL query using table / column aliases generates error 13852
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/26/2008 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1A
OpenEdge 10.1B
All Supported Operating Systems
SYMPTOM(s):
Using table / column aliases in a SQL query
Query fails with error 13852
Error: Column reference "T0.C1" is ambiguous. (13852) (State:S1000, Native Code: FFFCCB68)
Query has a format similar to:
SELECT
t0.c0 c1
FROM
(SELECT salesrep c0, RepName c1 FROM salesrep) t0,
(SELECT salesrep c0, RepName c1 FROM salesrep) t1
WHERE
t0.c0 = t1.c0 and t0.c1 = t1.c1
Query executed correctly in Progress 9.1E04
CAUSE:
Bug# OE00145579
FIX:
Option #1
Upgrade to 10.1B01 or higher.
Option #2
Change the alias name of the column listed in the error:
SELECT
t0.c0 NewColumnName
FROM
(SELECT salesrep c0, NewColumnName c1 FROM PUB.salesrep) t0,
(SELECT salesrep c0, NewColumnName c1 FROM PUB.salesrep) t1
WHERE
t0.c0 = t1.c0 and t0.c1 = t1.c1