Kbase P120040: SQL92 View/Table columns referenced in an ON clause cause Memory allocation failed at 1712
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/24/2007 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1A
SYMPTOM(s):
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Insufficient Memory
Memory allocation failed at 1712 in E:/vobs_sql/sql/src/rds/psr_bld1.cxx.
SQLState=HY000 ErrorCode=-211023
Using INNER JOIN with ON clause
The same query worked in Progress V9
Using alias names matching the column names
SQL92
FIX:
Option #1
Upgrade to 10.1B01 or later
Option #2
For inner joins, predicates in the ON clause may be moved to the WHERE clause, and the query will remain equivalent and work OR use a different alias name