Hi, this is not the same consider:
transaction id=1 exists and is not commited but have modified some records in tableX. you start new transaction id=2 (read commited isolation mode) you commit transaction id=1 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 regards, Karol Bieniaszewski W dniu 2018-07-24 11:27:54 użytkownik Dimitry Sibiryakov <s...@ibphoenix.com> napisał: > 24.07.2018 10:13, liviuslivius wrote: > > It can provide simple way to retrive new records/changes in tables (new > > feature). > > E.g. whe can then do > > SELECT * FROM TABLEX WHERE CN>:SCN; > > You already can do it with RDB$RECORD_VERSION. > > > -- > WBR, SD. > > ------------------------------------------------------------------------------ > 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 > ------------------------------------------------------------------------------ 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
