Kbase P13041: Number of records fetched dependent to the used index.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/12/2003 |
|
Status: Unverified
SYMPTOM(s):
Number of records fetched dependent to the used index.
Opening a QUERY.
FOR ... with a WHERE clause
FIND ... with a WHERE clause
WHERE clause on a field that contains '?' records.
Using two different indexes, one using a field involved in the WHERE clause, one without.
CAUSE:
Bug# 20021106-012.
CAUSE:
If a Record is ? then the condition (Record > value) will be evaluated as '?'.
In this situation the WHERE clause:
WHERE (Record > value)
will be differently evaluated (true - record fetched / false - record not fetched) based on the index used.
FIX:
This is an expected behavior.
In order to avoid this, use an explicit WHERE condition like
WHERE (Order.order-Date > 1/01/1900 = yes)
or
WHERE (Order.order-Date > 1/01/1900 = yes
OR Order.order-Date > 1/01/1900 = ?)
depending of what results you want to pick.