Kbase P2418: Records are retrieved that are different from the selection criteria
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
SYMPTOM(s):
Records are retrieved that are different from the selection criteria
The indexed field in the record does not match the index bracketing.
Key field in record is not the same as the index value.
Records are read with NO-LOCK
FOR EACH tableA WHERE fieldA = <keyValue> NO-LOCK returns records where fieldA is NOT equal to <keyValue>
CAUSE:
Because the code is using NO-LOCK, there is no guarantee at all regarding the overall consistency of data being read.
Please refer to Progress Solution P7789 for more information about NO-LOCK reads.
FIX:
The only way to guarantee that a record is 100% consistent is to read it SHARE-LOCK.