Search/index bug?

[jda]

Hi Ruslan,

I've just found the following odd behavior with the latest 2.1fc release:

1. Do an indexed search like this;

select 
id,hit,uniqueID,authors,thedate,title,editors,keywords,authorsSortMethod,thedateSortMethod 
from thereferences where (left(notes, 4)='test')

Get, say, 5 hits.

2. Now, delete the word "test" from the notes field in *one* record.

3. Repeat the search -> 0 hits!

Reindexing does no good.

4. Close and reopen database, and the same search now -> 4 hits 
(correct result).

Any ideas what might be going on?

Thanks,

Jon