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] -----------------------------------------------------------------------------
