Subject Re: [firebird-support] SELECT WITH LOCK, WAIT transaction, deadlock
Author Gabor Boros
2016. 04. 28. 14:55 keltezéssel, Dimitry Sibiryakov sd@...
[firebird-support] írta:
> 28.04.2016 13:41, Gabor Boros gaborboros@... [firebird-support] wrote:
>> The message is:
>> deadlock
>> update conflicts with concurrent update
>> concurrent transaction number is ...
>
> That's an expected behavior.

Are you sure?

In the language reference for "isc_tpb_read_committed + isc_tpb_wait" I
see this: "Update conflict exceptions can never be raised by an explicit
lock statement in this TPB mode."

http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-dml-select.html#fblangref25-dml-with-lock

Gabor