>> I'm getting "database disk image is malformed" errors when running a
>> query containing OR and ordering by rank against a FTS5 index:

> What happens when you run
> PRAGMA integrity_check
> on it ?

"ok" (this is  on a transient in-memory db)

$ sqlite3
SQLite version 3.13.0 2016-05-18 10:57:30
Connected to a transient in-memory database.
sqlite>  create virtual table foo using fts5(bar);
sqlite> insert into foo values('test');
sqlite>  select rowid from foo where foo match 'test OR foo' order by
rank;
Error: database disk image is malformed
sqlite> PRAGMA integrity_check;
integrity_check
---------------
ok

      Jan
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to