jeudi 19 mars 2015

External content in FTS4 SQLITE

I have a VIEW view_for_search_unit and a FTS4 table FTS_table_search_unit. I inserted data from view_for_search_unit into the FTS table using this command:



INSERT INTO FTS_table_search_unit(docId, name, description)
SELECT id, name, description FROM view_for_search_unit


After I check data in FTS table using this:



SELECT *FROM FTS_table_search_unit


it has 1000 perfect records(I use fake data). However, when I use the MATCH function in FTS:



SELECT * FROM FTS_table_search_unit WHERE FTS_table_search_unit MATCH 's*'


I retrieve 1000 records but all columns in the result are NULL. What is the problem? I can't understand because there is data in FTS_table_search_unit.


Aucun commentaire:

Enregistrer un commentaire