On 05/29/2016 04:22 AM, Jan Berkel wrote:
I'm getting "database disk image is malformed" errors when running a
query containing OR and ordering by
rank against a FTS5 index:
$ sqlite3
SQLite version 3.13.0 2016-05-18 10:57:30
sqlite> create virtual table foo using fts5(bar);
sqlite> insert into foo values('test');
sqlite> select rowid from foo where foo match 'test' order by rank;
rowid
1
sqlite> select rowid from foo where foo match 'test OR foo' order by
rank;
Error: database disk image is malformed
Thanks for reporting this. As you no doubt surmised, the db is not
corrupt but a bug in FTS5 is causing it to report so. Now fixed here:
http://sqlite.org/src/info/64ca1a835a89fd21
Dan.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
