[Cubridcluster-devs] [Developers] next-key locking

[SourceForge.net <no...@so...>]

The following forum message was posted by wzcsoft at http://sourceforge.net/projects/cubridcluster/forums/forum/1129811/topic/3734606:

I find a technology named \"next-key locking\" used in CUBRID. I have some questions about it.
Suppose an index contains the following value: 1 5 6 7 8 12, a transaction will delete 8, then both 8 and 12 will be locked.
1. I want to know just 8 and 12 be locked or the gap between 8 and 12 aslo be locked?
2. I know don\'t why 12 also be locked. It seems that just lock 8 is enough.