SQLite Forum

SQLite FTS5 table with 7 rows has _fts_docsize table with 9,141 rows
Login
I can confirm that using `PRAGMA recursive_triggers=on;` appears to fix this issue - running the script no longer adds ten new records to the `licenses_fts_docsize` table.

This leaves me with a smaller problem: I now have a whole bunch of tables with enormous amounts of obsolete data in their `*_fts_docsize` tables. I'll write myself a utility for cleaning those up, probably by running something like this:

```
delete from licenses_fts_docsize
where rowid not in (select rowid from licenses_fts)
```