Subject Re: [firebird-support] Read-committed was Read Only Transactions
Author Ann W. Harrison
Dmitry Yemanov wrote:
> "Ann W. Harrison" <aharrison@...> wrote:
>>>> Read-committed mode violates the Isolation and Consistency
>>>> properties of transactions
> Formally, I disagree (see above).

OK, then let me restate my principle without reference to
the ACID acronym. A transaction should see a consistent
state of the database, subject only to the changes it makes
itself. Read-committed transactions - and repeatable-read
transactions as defined by the SQL standard - do not meet
that test.

Without that property, it is impossible to run a two-stage
report (e.g. one that includes percent of total) on a active