SQLite Forum

SQLite FTS5 table with 7 rows has _fts_docsize table with 9,141 rows
Login
Thanks - that's really useful. I didn't know about `recursive_triggers`.

I just noticed that the triggers are operating on `rowid` but the `license` table has a text primary key, so I'm thinking maybe that could be part of the problem:

```
CREATE TABLE [licenses] (
   [key] TEXT PRIMARY KEY,
   [name] TEXT,
   [spdx_id] TEXT,
   [url] TEXT,
   [node_id] TEXT
);
```