--- Paul DuBois <[EMAIL PROTECTED]> wrote:
> 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
>
Thanks for the quick response! I have filed this
under bug #16501.
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]
