Kbase P16366: COMPILE ... XREF does not report WHOLE-INDEX search on temp-table
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/12/2010 |
|
Status: Verified
SYMPTOM(s):
Using the COMPILE ... XREF option.
Compiled procedure has SEARCH reference (FIND statement, FOR EACH .... etc.) on temp-table.
Search is a WHOLE-INDEX search.
WHOLE-INDEX search is not reported in the XREF information.
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.0x
OpenEdge 10.1x
All Supported Operating Systems
OpenEdge Category: Language (4GL/ABL)
CAUSE:
Bug# OE00085093
FIX:
Upgrade to OpenEdge 10.1C01 or later
Upgrade to OpenEdge 10.2A or later
Workaround:
To check if a WHOLE-INDEX search is performed on a temp-table:
1. Create a query with the WHERE clause that matches the search reference.
2. Get the handle to the query.
3. Message the INDEX-INFORMATION attribute of the handle.
The first entry of the INDEX-INFORMATION will be WHOLE-INDEX if the operation has to scan the entire index.