Sergey,
Was you able to reproduce the behavior? I did not.
>Hi Fabio,
>
>It looks like a bug to me. The result shouldn't depend on the presence of the index. IOW, result shouldn't vary regardless if query is optimazible or not.
>
>>Hi,
>>
>>on SELECT i can have not equal result if i have or not have a index.
>>
>>
>>CREATE CURSOR myCur (f1 c(2))
>>INSERT INTO myCur VALUES ('A ')
>>SELECT * FROM myCur WHERE f1=='A '
>>SELECT myCur
>>INDEX on f1 TAG tag1
>>* Next line:
>>* On VFP6SP5/VFP7SP1 it found record
>>* On VFP8 it not found record
>>SELECT * FROM myCur WHERE f1=='A '
>>
>>
>>Fabio