SQLite Forum

FTS5 rows not searchable with match
Login
It looks like the 'integrity-check' function compares the contents of the FTS5 index with the contents of the external content table. So in this case it is saying that the contents of the index is inconsistent with the contents of your content table (the view "item_view"). This doesn't seem right to me - internal inconsistencies in data stored by FTS5 itself are corruption, not inconsistency with data stored in an external content table.

With an external content table, querying the FTS5 table using anything other than a full-text query is pretty much the same as querying the external content table directly. FTS5 just passes the query through.

So the contents of your view and the contents of the FTS5 table are inconsistent. How they got that way is unclear - presumably the app modified the tables underlying the view but did not update the FTS5 index, either directly or via the triggers on the view.