Subject Re: [Firebird-Architect] Supported transaction isolation levels?
Author Thomas Steinmaurer
Nando,

> TS> Looking through different Firebird related documentations (Helen's book,
> TS> IBP pdf set, ...), it seems that Firebird doesn't support the
> TS> SQL-compliant transaction isolation level "REPEATABLE READ". Is this
> TS> correct?
>
> Boy, Firebird is about the only DBMS that has supported it decently,
> i.e. without blocking writers, since day 0.

I know.


I believe
> isc_tpb_concurrency + isc_tpb_wait is what you're after. BTW that's
> the default setting.

I know.

;-)


The reason why I'm asking is:

- The term "REPEATABLE READ" isn't used in any isolation level related
documents with Firebird/InterBase I've found

- Helen's book says (p. 523): "Mapping to the standard governance of
REPEATABLE READ and SERIALIZABLE is not possible."


So, where is the difference between SNAPSHOT and REPEATABLE READ. ;-)


Thanks,
Thomas