On 19 Jan 2018, at 4:46pm, Deon Brewis <[email protected]> wrote: > If you start with: > INSERT INTO Woz(Foo, Bar) Values(1,1) > > And a (normal) writer thread updates the 2 columns: > UPDATE Woz SET Foo=2, Bar=2 > > Can a read_uncommitted thread read the value from the row as: > Foo=1, Bar=2 > ?
No. The very least you can get is statement-level consistency. If that PRAGMA is on you might get (!,1) or (2,2), you just can’t predict which you’ll get. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
