Dmytro Bogovych wrote:
I'm trying to run simple update on the following table
CREATE TABLE tree
(
parent INTEGER,
child INTEGER,
number INTEGER,
children INTEGER
)
The query itself:
update TREE set number = number + 1 where child = ? and parent = ? and
number > ?
During execution of this query the following func is called:
static int sqlite3pager_opentemp(char *zFile, OsFile *fd)
from pager.c and temporary file is created in my temp directory.
Unable to reproduce. I put a breakpoint on sqlite3pager_opentemp()
and did lots of UPDATEs in the style shown, but no temporary file
was ever opened.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
