Re: BUG #19081: Inconsistent target rows seen by the UPDATE and INSERT statements within the same transaction

Hi,

Thank you for your explanation. However, for the UPDATE statement “UPDATE t0 SET c1 = 9, c2 = 9 WHERE c2 = 5;” in
transaction2, why does the UPDATE statement in transaction 2 in the first case fail to match the row that was changed
to(5, 5) in the committed transaction 1? In the second case, why does the UPDATE statement in transaction 2 report an
error“could not serialize access due to concurrent update”? 

Best regards,
Ziyu Cui