Hello,
I'm just looking for some clarification of the documentation if that's
ok. I did a quick search of the mailing list but couldn't find
anything relevant.
If I run an update query which has a subquery, will the database be
locked before the subquery is run.
I'm thinking something like:
create table x(name text, pos int);
insert into x values ('abc', -1);
update x set pos = 1+max(0,(select max(pos) from x));
If two processes run this at once (with different values for name), am
I right in thinking the lock will occur before the subquery runs,
hence it is impossible for the subquery to return -1 in both processes.
Thanks,
Kevin Martin.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
