Re: IS_USED_LOCK does not appear to work

[Paul DuBois]

At 16:14 -0800 1/13/06, Darth Vader wrote:

IS_USED_LOCK does not return the correct connection
identifier in the following scenario (this is MySQL
4.1.11-2):

Open two connections to MySQL (note the connection
identifiers).
Run the following statements, in order:
On connection 1:
    SELECT GET_LOCK('42',600);

On connection 2:
    SELECT IS_USED_LOCK('42');
    SELECT GET_LOCK('42',600);

On connection 1:
    SELECT RELEASE_LOCK('42');
    SELECT IS_USED_LOCK('42');

On my system, the last IS_USED_LOCK returns the wrong
connection identifier.  You will see on connection 2
that the lock was successfully obtained after released
from connection 1, but the lock is reported to be in
use by connection 1 still.

Is this a bug, or am I missing something?

It certainly seems to be contrary to the manual.  Please file
a bug report at http://bugs.mysql.com.  Thanks!

--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]