Kbase P43068: Workaround for SQL-92 process crash when using multiple derived tables
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
SQL Explorer generates an exception when using multiple derived tables in an ON clause
Error -20217
No database connected. (8934)
Error PANIC - XEC pexpr::setp 1 PID 2704
Column ambiguously specified (7523)
Cannot apply Service Pack 06, for Progress 9.1D
CAUSE:
Bug# 20020225-001 was logged to note the problem SQL has in handling multiple derived tables when ON clauses are used to give joins.
FIX:
To workaround this problem use only 1 derived table, or avoid ON clauses by specifying joins in the WHERE clause.