Have you run integrity checks on the database file ( https://www.sqlite.org/pragma.html#pragma_integrity_check) and on the FTS4 tables (https://www.sqlite.org/fts3.html#integcheck)? Do they all look correct?
On Wed, Dec 24, 2014 at 2:40 PM, Peter Truskier <ptrusk...@gmail.com> wrote: > I have an sqlite database in which I've created a virtual table using > FTS4. For nearly a year, we've been using it to do full text searching with > no problem. > > The database contains a table of products (tblProducts) with columns id, > SKU, itemDesc, etc. > > The virtual table is created like this: > > CREATE VIRTUAL TABLE tblFTSProducts USING fts4(content="tblProducts", > SKU, itemDesc) > > A couple of days ago, full text searches (using "MATCH") suddenly stopped > working - always returning an empty recordset with no error. The data in > the virtual table appears to be correct. > > If I do a query on the virtual table like this: > > SELECT * FROM tblFTSProducts WHERE itemDesc LIKE '%inches%', > > I get a valid recordset containing the expected records. But, if I do this: > > SELECT * FROM tblFTSProducts WHERE tblFTSProducts MATCH 'inches', > > I get an empty recordset. > > I've checked the integrity of the database, and it is reported to be good. > I've tried dropping and re-creating the virtual table, and still get the > same behavior. > > Does anyone have any suggestion for what might suddenly cause this > behavior after working for moths and months? > > Thanks, and happy holidays! > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
