RELEASE_ALL_LOCKS()

Purpose

This function releases all named locks held by the current session and returns the number of locks successfully released.

Syntax

RELEASE_ALL_LOCKS()

Purpose

Parameters

None.

Return value

The number of locks successfully released. If the current session does not hold any locks, the return value is 0.

Examples

Release all named locks held by the current session.

obclient [(none)]> SELECT RELEASE_ALL_LOCKS();

The result set is as follows:

+---------------------+
| RELEASE_ALL_LOCKS() |
+---------------------+
|                   1 |
+---------------------+
1 row in set

The return value is 1, indicating that one named lock was held by the current session and was successfully released.