2
# We explicitly whether or not a connection
4
SET @lock_name="release_lock_test";
6
# We should now obtain the lock
7
SELECT get_lock(@lock_name);
8
SELECT if ((is_used_lock(@lock_name) = CONNECTION_ID()), "YES", "NO");
9
SELECT release_lock(@lock_name);
10
# Lock should now be un-owned
11
SELECT is_used_lock(@lock_name);
12
SELECT release_lock(@lock_name);