On 6/6/2013 6:04 PM, Jerry Krinock wrote:
• Launch Process 2. • Launch Process 1. • Add a record in Process 1. Possibly does not COMMIT. • Launch Process 3. • In Process 3, run the query, then terminate. New record is PRESENT. • In Process 2, open database, run the query, checkpoint, and close. New record is ABSENT.
One possibility: Process 2 already has a connection, that has a pending read transaction (and so doesn't observe the concurrent write). Shared cache is enabled. The new connection then also effectively sees the same open read transaction.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users