Thanks a lot!
-----Original Message----- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 27, 2006 2:26 PM To: SQLite Subject: [sqlite] Re: Does SELECT cover uncommitted INSERTS? Rafael Buchbinder <rafi-OQlTx/[EMAIL PROTECTED]> wrote: > Does a SELECT query return rows from uncommitted inserts on same > sqlite3 handle (and same thread) ? Yes. The transaction sees any changes it itself has made. > I assume it does not do that when BEGIN; INSERT ...; END; is done on a > distinct sqlite3 handle (and different thread). Since SQLite employs a single writer/many readers lock, it's simply impossible for SELECT to execute on one connection while a writer transaction is still open on another connection. So the question is moot. Igor Tandetnik ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
