Cursor lock and sql command

[Ivan Smahin]

On Jul 30, 2014, at 11:29 AM, François Van Lerberghe <frvanlerberghe at gmail.com> wrote:

> Oooh !?
> If I create a Read and Write locked cursor, another process can modify these
> records with an Update (or even a Delete) command !
> I don't think it's the intended behavior. Do you think the opposite ?
> 

All that stuff were part of transaction system based on locks.
Later, we decide that it is too ancient approach and we are going to implement transactions based on versioning data-pages.
I'm just curious - why do you need to lock that records?

-- 
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com