Kbase 38748: SQL-92 process crashes when using multiple derived tables
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/11/2000 |
|
Solution ID: P8748
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
CAUSE:
This is a known issue.
FIX:
The issue is fixed in Progress Version 9.1E and later.
To work around it, use only 1 derived table, or avoid ON clauses by specifying joins in the WHERE clause.