Thanks for the report. There are a couple of cases now caught in the 'delete' command instead of later on: [](https://sqlite.org/src/info/b79f19edfd33c2a7) Really though, this sort of thing corrupts the index. The docs say: > If the values "inserted" into the text columns as part of a 'delete' command are not the same as those currently stored within the table, the results may be unpredictable. The extended error code should be SQLITE_CORRUPT_VTAB. Dan.