Re: [sqlite] Problem with vacuum when count_changes=1

2011-09-30 Thread Reg Server
Filip Navara writes: > > On Fri, Sep 30, 2011 at 2:21 PM, Reg Server wrote: > [snip] > > I don't have Mac but I tried mentioned steps using sqlite3.exe using both > > versions 3.7.8 and 3.7.5. It crashed every time. > > > > I'm don't know wher

Re: [sqlite] Problem with vacuum when count_changes=1

2011-09-30 Thread Reg Server
Simon Slavin writes: > > > On 30 Sep 2011, at 11:09am, Filip Navara wrote: > > > Reproduced with the following steps: > > > >> sqlite3 test.db > > pragma count_changes=1; > > create table a (a); > > vacuum; > > > > (SQLite 3.7.8 on Windows) > > On my Mac > > SQLite version 3.7.5 > Enter ".

[sqlite] Problem with vacuum when count_changes=1

2011-09-30 Thread Reg Server
Hi all, I am trying to update our application to use latest SQLite library. In many places of the code we were using data returned from INSERT, UPDATE, DELETE commands when count_changes pragma is set to 1. First thing I noticed is that this pragma is now deprecated. But, it still works correc