> If I do a BEGIN, SELECT1 and at that point a writer does BEGIN > IMMEDIATE, SELECT3, UPDATE, COMMIT, and then I continue with SELECT2 > COMMIT, will SELECT1 and SELECT2 have a consistent view of the > database > unaffected by the UPDATE in the middle. In other words, is the > Readers > view of how far up the WAL it is allowed to look get controlled by the > BEGIN ... COMMIT bracket rather than just the individual SELECTS it is > performing.
SELECT1 and SELECT2 will see a consistent snapshot. SELECT2 will not see any data committed after the read transaction has been started. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
