> > 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