вт, 24 июл. 2018 г. в 13:15, liviuslivius <liviusliv...@poczta.onet.pl>: > > 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
:) tr1 committed BEFORE select in tr2 and in read committed mode MUST see new versions. > > 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 -- Roman Simakov ------------------------------------------------------------------------------ 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
