Milan Kříž wrote: > So does it mean that the full-text search is not performed for the following > query at all? > > SELECT docId FROM ftsTable WHERE ftsTable MATCH 'a*' AND rowId IN (20,21, 22, > 23) > > SCAN TABLE ftsTable VIRTUAL TABLE INDEX 1: > EXECUTE LIST SUBQUERY 1
No, it means that you are using a different version. (In any case, it is not possible to execute MATCH without the FTS index.) > what does the 'EXECUTE LIST SUBQUERY 1' mean? It's how the "rowid IN (...)" is implemented. Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
