[sqlite] FTS3 phantom token?...

[Shopsland gmail]

Hi,
Mining my fts3 table stemmed with Porter I found that there is a 'phantom'
token indexed by fts3.

When I issue this query:

   select title from fts_news where fts_news match 'ined'

I got about 700 rows that do not have the word 'ined' in any form (ie: ined
or inedible).

If I issue those queries:

select title from fts_news where title like 'ined%'
select title from fts_news where title like '% ined%'

Not a single row is returned.

I have optimized the fts3 index with:

SELECT optimize(fts_news) FROM fts_news LIMIT 1;

And did a vacuum but the phantom token 'ined' is not deleted.

Can anyone confirm this?

Jochi Martínez
www.bfreenews.com
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users