I tried the following on a table and I was not able to reproduce the problem:
Begin work; Update some rows in table t ; Select * from t; Commit work;
I also did an update to the same table outside of a transaction and I was not able to reproduce the problem either.
I tried the following on a table and I was not able to reproduce the problem:
Begin work;
Update some rows in table t ;
Select * from t;
Commit work;
I also did an update to the same table outside of a transaction and I was not able to reproduce the problem either.