Hi, I think you are right, but it also depends on the storage engine and settings.
Regards, Thomas On Tuesday, February 14, 2017, <vraimax2...@gmail.com> wrote: > Hi! > > I investigated SQL command "merge" in multi-transactional environment. It > seems to me that invocation of merge in one READ_COMMITTED transaction > blocks other transactions that try to execute 'merge' for the same row till > the first transaction is committed. Is it correct? > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to h2-database+unsubscr...@googlegroups.com > <javascript:_e(%7B%7D,'cvml','h2-database%2bunsubscr...@googlegroups.com');> > . > To post to this group, send email to h2-database@googlegroups.com > <javascript:_e(%7B%7D,'cvml','h2-database@googlegroups.com');>. > Visit this group at https://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
