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.

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