Re: [sqlite] Database corruption with fts table after closing/reopening the database

2012-02-10 Thread Simon Slavin
On 10 Feb 2012, at 11:01am, Julien LF wrote: >> Did you try surrounding them strings with single quotes, instead ? > > I got the same problem using single quotes. > However the machine I was performing those tests on is a vmware virtual > machine. > Performing the same steps on physical hardwar

Re: [sqlite] Database corruption with fts table after closing/reopening the database

2012-02-10 Thread Julien LF
> Did you try surrounding them strings with single quotes, instead ? I got the same problem using single quotes. However the machine I was performing those tests on is a vmware virtual machine. Performing the same steps on physical hardware (identical os & sqlite version) worked fine, so I guess t

Re: [sqlite] Database corruption with fts table after closing/reopening the database

2012-02-10 Thread Kevin Benson
On Fri, Feb 10, 2012 at 5:20 AM, Julien LF wrote: > Hello, > > I'm testing the fts extensions and experiencing a 'database disk image > is malformed' problem that I can reproduce the following way: > - Create a database > - Open the database to insert/update rows. 'match' queries work at this > p

[sqlite] Database corruption with fts table after closing/reopening the database

2012-02-10 Thread Julien LF
Hello, I'm testing the fts extensions and experiencing a 'database disk image is malformed' problem that I can reproduce the following way: - Create a database - Open the database to insert/update rows. 'match' queries work at this point - Close the database - Open the database. 'match' queries st