> > you do
> > SELECT * from tableX where RDB$RECORD_VERSION>2
> >
> > above select will not see data commited by transaction id=1 because
> > it modify records before tr2 start
> > and tr1 is commited after tr2 start
> 
> :) tr1 committed BEFORE select in tr2 and in read committed mode MUST
> see new versions.
> 

> Roman Simakov
> 

No, in above select you have RDB$RECORD_VERSION>2 
Tr1 have RDB$RECORD_VERSION=1

regards,
Karol Bieniaszewski


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to