we don't currently have an answer for that, other than "be careful what order you do your MERGE statements in" because
MERGE will take a full-table lock even in MVCC mode, and, as you found out, if you do MERGE statements in different
orders in different transactions, you will get a timeout.
We probably need a LOCK TABLE command to make this kind of thing work in MVCC mode for places where it is impossible to
order the MERGE commands consistently.
--
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.