Kbase P165098: SQL: Insufficient Memory error in Z:/vobs_sql/sql/src/rds/opt_anl2.cxx executing a query.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/25/2010 |
|
Status: Unverified
SYMPTOM(s):
SQL: Insufficient Memory error in Z:/vobs_sql/sql/src/rds/opt_anl2.cxx executing a query.
Error: Insufficient Memory. Memory allocation failed at 3206 in Z:/vobs_sql/sql/src/rds/opt_anl2.cxx. Contact Progress Technical Support (State:S1000, Native Code: FFFCC7B1)
Query contains an aliased UNION
Query raising the error:
SELECT
TableAlias1.Field1,
TableAlias1.Field2,
TableAlias1.Field3,
TableAlias1.Field4,
TableAlias1.Field5,
TableAlias1.Field6,
TableAlias1.Field7,
CASE
WHEN TableAlias1.Field7 = TableAlias2.FieldAlias1
THEN TableAlias2.DIR
END AS DIR
FROM PUB.JOURNAL TableAlias1,
(
SELECT ObjectEUID FieldAlias1, 'inn' FieldAlias2 FROM PUB.Table1 WHERE Field8 IN ('2219')
UNION
SELECT ObjectEUID FieldAlias1, 'out' FieldAlias2 FROM PUB.Table1 WHERE Field8 IN ('2220')
) TableAlias2
WHERE
TableAlias1.MESSAGECODEIDX = 1002 AND
(TableAlias1.Field2 IN ('2004'))AND
TableAlias1.Field7 = TableAlias2.FieldAlias1 AND
TableAlias1.Field2 > '0' AND
TableAlias1.Field2 < 'z'
ORDER BY
TableAlias1.Field3,
TableAlias1.Field2,
TableAlias1.Field4,
TableAlias1.Field5
FACT(s) (Environment):
The same query ran without error under 9.1D
Windows
OpenEdge 10.2A
CAUSE:
Bug# OE00175855
FIX:
Upgrade to OpenEdge 10.2A01 or later.