On 9/30/19 4:28 AM, Gwendal Roué wrote: > According to > http://dbmsmusings.blogspot.com/2019/06/correctness-anomalies-under.html, > SNAPSHOT ISOLATION is stronger than REPEATABLE READ, in that it prevents > "phantom reads" ( > http://dbmsmusings.blogspot.com/2019/05/introduction-to-transaction-isolation.html). > I think SQLite prevents phantom reads, and so we actually get actual > SNAPSHOT ISOLATION (as written in https://www.sqlite.org/isolation.html).
Based on a bit of research with things like https://en.wikipedia.org/wiki/Snapshot_isolation Snapshot Isolation appears to be a Term of Art, not a Standardized Term so it can be forgiven if it isn't used in the documentation. Also, it seems to imply non-serialized writes, which SQLite does NOT provide, so isn't even really applicable. -- Richard Damon _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
