Subject Re: [firebird-support] SELECT WITH LOCK, WAIT transaction, deadlock
Author Ann Harrison
On Thu, Apr 28, 2016 at 11:39 AM, Ann Harrison <aharrison@...> wrote:

A lot of stuff including: 

In ancient history, even in read-committed mode, Firebird blocked transactions from updating records if the most recent version was created by a concurrent transaction.  At the time, we considered anyone who liked inconsistency not worth worrying much about.  It was a long time ago.  

Or maybe not.  I mentioned this thread to Jim who's creating yet another databases thirty-plus years after InterBase.  His reaction?  "Read committed is flawed in premise.   You can reach any conclusion from a flawed premise."  

Cheers,

Ann