Thomas Steinmaurer wrote:

>
> Not here. ;-)
>
> * Two concurrent isql sessions
> * Both start a read committed transaction

That implies NO_RECORD_VERSION where writers block readers...

> * The first isql session does a SELECT * FROM MYTABLE WITH LOCK
> * The second isql session does a SELECT * FROM MYTABLE (without WITH LOCK).
> * The second session gets blocked

Not a surprise at all, the same for a regular UPDATE.

Try RECORD_VERSION and see the difference :-)


Dmitry