Subject Basic question on transactions
Author Daniel Albuschat
Hello there,

I have some rather basic questions about transaction semantics.
I haven't put much thoughts on this topic, because it basically
'just worked' for me, but I'd like to understand how things work now.
Imagine the following case:

Transaction -> Start
Select -> Execute (four datasets to fetch)
Select -> Read 2 datasets
Update -> Update 3rd dataset that is not yet fetched from the Select
Transaction -> CommitRetaining
Select -> Read next dataset

Does select read the updated values for the 3rd dataset?
It should, imho, since it's the context of the same transaction.

And how does these kind of scenarious behave with inserts?
I'm a bit puzzled as to how 'isolated' a select is.

Daniel Albuschat
eat(this); // delicious suicide