SQLite Forum

FTS5 rows not searchable with match
Login
I propose you create a test case too research your issues. Triggers are part of the transaction - how could they not be?

Data not being searchable even after triggers ran is weird.

We don't use triggers, we manage the FTS data from the application so we have more control. We tried contentless, but it is hard to manage since you need to provide the previous content on every update.

We don't encounter the problems you're seeing, in any case.