Re: A transaction question

On Jul 23, 3:42 pm, Christoph Rupp <cruppst...@xxxxxxxxx> wrote:
Hi,

i have a question about two parallel transactions which insert the
same key.

Assume that key A does not yet exist.

T1 Begin
T2 Begin
T1 Insert A
T2 Insert A
T1 Commit
T2 Commit

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

I think MVCC is normally (only) aimed at allowing for better
concurrency between readers and writers (and not amongst writers) and
therefore is inapplicable in this example. ie the transactions would
necessarily be serialised.
.

Relevant Pages

  • Re: A transaction question
    ... Christoph Rupp wrote: ... i have a question about two parallel transactions which insert the ... T2 Commit ... But i also think that in a MVCC database the conflict can only be ...
    (comp.databases.theory)
  • A transaction question
    ... i have a question about two parallel transactions which insert the ... T2 Commit ... But i also think that in a MVCC database the conflict can only be ...
    (comp.databases.theory)