A transaction question
Date: Wed, 23 Jul 2008 00:42:14 -0700 (PDT)
i have a question about two parallel transactions which insert the same key.
Assume that key A does not yet exist.
T1 Insert A
T2 Insert A
My guess is: "T2 Insert A" is a conflict with the previous insert of T1. But i also think that in a MVCC database the conflict can only be resolved when T2 is committed. What happens then? Does the commit fail, or is A silently overwritten? Or is the typical behaviour in this case implementation-specific?
Thanks for your answers,
Christoph Received on Wed Jul 23 2008 - 02:42:14 CDT