Re: Write skew anmalies are found in SERIALIZABLE isolation

We have wrong statements in the last email.

"If each transaction only read one item with secondary index and write another item with primary index, write skew anomalies are more ( -> less) likely to occur."

"At last, we run the same join SQL, and more ( -> less) anomalies can be found. The corresponding test program is Test2.java."

There are less anomalies can be found in the second situation using Test2.java.

And some mistakes in our test programs have been fixed.

Best regards ,

Shuyan Zhang, ECNU

------------------ Original ------------------

 

On Thu, Oct 3, 2019 at 9:18 AM 张舒燕 <51184501183@stu.ecnu.edu.cn> wrote:
> When we set the isolation level to SERIALIZABLE, we observed some wirte skew anmalies.

What version of PostgreSQL did you test? Does this bug affect all versions?

--
Peter Geoghegan