Re: [Firebird-devel] Read consistency patch

2018-07-25 Thread liviuslivius
>I don't know if IB's "Change View" really useful feature. Do you have some > expirience\opinon? > > Regards, > Vlad Sadly, no. We have had too many problems with Interbase stability and the worst ever seen paid support (Fortunately, Delphi support works well), that we have not tried to ad

Re: [Firebird-devel] Read consistency patch

2018-07-25 Thread Roman Simakov
ср, 25 июл. 2018 г. в 10:38, liviuslivius : > but from below scenario you can bring the idea > > usage case: > 1. > TR1 insert and update data on TableX and is still active > > 2. > Application do > TR2 start and we get recentCN and remember it as interestingCN > and we do > SELECT * FROM

Re: [Firebird-devel] Read consistency patch

2018-07-25 Thread liviuslivius
> Note: this SELECT may have greater CN then you have stored and it > means on the next step you may receive records already selected here. > You merge algorithm should take it into account. > > Roman Simakov If transaction is in snapshot isolation mode then problem should not exists Firebird

Re: [Firebird-devel] Read consistency patch

2018-07-25 Thread Roman Simakov
ср, 25 июл. 2018 г. в 13:08, liviuslivius : > > > > Note: this SELECT may have greater CN then you have stored and it > > means on the next step you may receive records already selected here. > > You merge algorithm should take it into account. > > > > Roman Simakov > > > If transaction is in snaps

Re: [Firebird-devel] Read consistency patch

2018-07-25 Thread liviuslivius
>>In this case exactly. You wrote about read >>committed transactions so I >>made such notation) ok, yes i have wroted i simplified example about read commited but here snapsot is vital >>One more note about your idea. Engine >>will have to read every record >>in anycase. But maybe expression in

[Firebird-devel] Firebird 3 embedded om iOS

2018-07-25 Thread Svend Meyland Nicolaisen
Hi I am sorry if this has been covered somewhere already, but I would like to know what it would take run Firebird 3 embedded on iOS. Kind regards, Svend Meyland Nicolaisen -- Check out the vibrant tech community on on