Kbase P103665: Inconsistent results returning from FIND LAST and USE-INDEX with Oracle DataServer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/27/2005 |
|
Status: Unverified
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
Inconsistent results returning from FIND LAST and USE-INDEX with Oracle DataServer
Record returned is not the same as using FOR LAST and FIND LAST but using USE-INDEX with the same index
Schema holder has being manually maintained
CAUSE:
Table has 2 indices with duplicated INDEX-NUM values
FIX:
Dump the table definition using Data Dictionary and fix the INDEX-NUM values, making sure that the values are unique. Load the table containing the modification.