Re: Inconsistent behavior in serializable snapshot

2018-03-11 Thread Kuntal Ghosh
On Sun, Mar 11, 2018 at 7:52 PM, Kuntal Ghosh wrote: > Hello hackers, > > While working on serializable transaction isolation, I've noticed some > strange behavior in the first permutation mentioned in > isolation/specs/read-only-anomaly-2.spec file. > > setup > { > CREATE TABLE bank_account (

Inconsistent behavior in serializable snapshot

2018-03-11 Thread Kuntal Ghosh
Hello hackers, While working on serializable transaction isolation, I've noticed some strange behavior in the first permutation mentioned in isolation/specs/read-only-anomaly-2.spec file. setup { CREATE TABLE bank_account (id TEXT PRIMARY KEY, balance DECIMAL NOT NULL); INSERT INTO bank_a