Re: [sqlite] BUG: FTS5 query containing OR + order by rank

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 i

Re: [sqlite] BUG: FTS5 query containing OR + order by rank

>> 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

Re: [sqlite] BUG: FTS5 query containing OR + order by rank

On 28 May 2016, at 10:22pm, 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: What happens when you run PRAGMA integrity_check on it ? Simon.

[sqlite] BUG: FTS5 query containing OR + order by rank

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 f