SQLite Forum

Timeline
Login

1 forum post by user rustdanielb

2021-09-13
16:03 Post: DB with Fts4 passes integrity check, but throws SQLITE_CORRUPT_VTAB (database disk malformed) whenever column is queried (artifact: 9a21637983 user: rustdanielb)

I have a db(456 MB) that has Fts4 attached. I am using a custom build of Sqlite 3.35.5. The db passes a pragma integrity check.

I can do a SELECT * FROM {fts virtual table} and it returns all the data found on the table just fine. However, when I query any column of that same table, I get a SQLITE_CORRUPT_VTAB (database disk malformed) error. Returning any built-in FTS functions such as match_info or snippet fails; however, if I call custom functions that I have added to my sqlite build, they work fine.

What is causing these issues to occur? Thanks!