On Fri, 10 Sep 2004 15:58:24 -0400, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
OK. My workaround trick didn't work afterall. Looks like you are stuck with a temporary file when doing an UPDATE or a mass INSERT inside a transaction.
yes. update may be very simple. See the following log:
SQLite version 3.0.6 Enter ".help" for instructions sqlite> create table ITEMS2(children INTEGER, refcount INTEGER); sqlite> insert into ITEMS2(children, refcount) values(1,2); sqlite> insert into ITEMS2(children, refcount) values(2,3); sqlite> insert into ITEMS2(children, refcount) values(3,4); sqlite> insert into ITEMS2(children, refcount) values(4,5); sqlite> insert into ITEMS2(children, refcount) values(5,6); sqlite> select ROWID from ITEMS2; 1 2 3 4 5 sqlite> begin ...> ; sqlite> update ITEMS2 set children=0 where ROWID=3; -- breakpoint triggering here -- sqlite> commit;
The OR COMMIT(ROLLBACK) options give me the same results.
-- With best regards, Dmytro Bogovych
