Conversion locks
Description
into an index.
Exclusive range, exclusive resource lock; used when updating a key in a range.
other locks obtained on overlapping keys and ranges.
Yes
Yes
No
Yes
Yes
Yes
No
Yes
No
No
Yes
No
Yes
No
No
No
No
No
No
Yes
No
Yes
Yes
No
Yes
Yes
No
No
Yes
No
No
Yes
No
No
No
Yes
Yes
Yes
No
No
Yes
No
No
No
No
No
No
No
No
Conversion locks are created when a key-range lock overlaps another lock.
7
Note
The internal
lock mode is compatible with all other lock modes.
ノ
ノ
RangeI
Null
RangeI-
N
RangeX
X
RangeX-
X
S
U
X
RangeS-S
RangeS-U
RangeI-N
RangeX-X
S
U
X
RangeS-S
RangeS-U
RangeI-N
RangeX-X
S
RangeI-N
RangeI-S
U
RangeI-N
RangeI-U
Null