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
