Re: [sqlite] Error or Crash using OR in MATCH clause

nedy <danielk1...@gmail.com> To: <sqlite-users@mailinglists.sqlite.org> Sent: 7/21/2016 12:01 PM Subject: Re: [sqlite] Error or Crash using OR in MATCH clause On 07/21/2016 11:16 PM, Julian Dohmen wrote: > I am encountering errors or crashes when using FTS5 an

Re: [sqlite] Error or Crash using OR in MATCH clause

On 07/21/2016 11:16 PM, Julian Dohmen wrote: I am encountering errors or crashes when using FTS5 and MATCH expressions involving OR combined with ORDER BY rank = Thanks for the detailed report. I think this one was fixed a couple of weeks after 3.13 was released:

Re: [sqlite] Error or Crash using OR in MATCH clause

st <sqlite-users@mailinglists.sqlite.org> Sent: 7/21/2016 11:45 AM Subject: Re: [sqlite] Error or Crash using OR in MATCH clause On 21 Jul 2016, at 5:16pm, Julian Dohmen <jdoh...@companioncorp.com> wrote: > SELECT * FROM VTest WHERE VTest MATCH 'wrinkle in time OR a

Re: [sqlite] Error or Crash using OR in MATCH clause

On 21 Jul 2016, at 5:16pm, Julian Dohmen wrote: > SELECT * FROM VTest WHERE VTest MATCH 'wrinkle in time OR a wrinkle in time' > ORDER BY rank; > ERROR > Error: database disk image is malformed What is the result of PRAGMA integrity_check ? Simon.

[sqlite] Error or Crash using OR in MATCH clause

I am encountering errors or crashes when using FTS5 and MATCH expressions involving  OR combined with  ORDER BY rank = Simplest example [using SQLite program]: --- DROP TABLE IF EXISTS VTest; CREATE virtual TABLE VTest USING