Kbase P119287: Oracle DataServer in 10.0B05 service pack generates different SQL than in 10.0B03 service pack
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/07/2007 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1E
OpenEdge 10.0B
OpenEdge 10.1A
Oracle DataServer
SYMPTOM(s):
Oracle DataServer in 10.0B05 service pack generates different SQL than in 10.0B03 service pack
Find statement with where clauses
The where clause contains "if... then..." conditions
In 10.0B03 and before service packs, the query translates into SQL with where clause
In 10.0B05, the query does not contain where clause
Oracle optimizer will not use index for retrieval of records, it does a full table scan (FTS), when "where" clause is not present
The Problem also occurs in 9.1E03 and later service pack.
The problem also occurs in 10.1A01 and later service pack.
CAUSE:
Bug # OE00133238
FIX:
The bug is fixed in 10.1B01
FIX:
The bug is a regression introduced by another bug fix in 9.1E03, 10.0B05 and 10.1A01
The bug is only present when there is "if... then..." condition in where clause. To work around the issue, remove the "if... then.." condition in "where" clause. For details, please reference notes section.
Another workaround would be to downgrade to versions before 9.1E03, 10.0B05 or 10.1A01 but those versions would not have bug fixes for the original issue referenced in Solution P106756 as well as other cumulative bug fixes introduced in these service packs.