well, if stmt1 is a write transaction, it would aquire an exclusive lock. if stmt2 is a read transaction, it would fail acquiring a shared lock since the exclusive lock is not released. . unless sqlite decides to 'downgrade' the exclusive lock to a 'shared' lock.
Sreekumar On Feb 6, 2012 7:07 PM, "Igor Tandetnik" <[email protected]> wrote: > Sreekumar TP <[email protected]> wrote: > > Why is this treated as a a single transaction? > > Well, because that's how SQLite works. Why shouldn't it be? > -- > Igor Tandetnik > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
