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?
Thanks,
Brian
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
