Subject Re: [Firebird-Architect] Feature request...
Author Ann W. Harrison
At 12:48 PM 5/28/2004, Ivan Prenosil wrote:
> >
> > I would expect sub-transactions to see everything their
> > parent transaction(s) did up until the spawning point,
> > and I would expect parent transactions to see everything
> > their sub-transactions have done once they've committed
> > (rejoining the parent, thus acting as if the parent has performed
> > those actions directly)
>... which would brake the basic behaviour of snapshot transactions.
>The same row read twice could return different values if the sub-transaction
>updated that row and committed in between.

I don't know whether that's true or not. Certainly, a transaction
sees different values in records it updates. If the subtransaction
is really part of the parent, then that's consistent... sort of...