Re: IS_USED_LOCK does not appear to work

2006-01-13 Thread Darth Vader
--- 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

Re: IS_USED_LOCK does not appear to work

2006-01-13 Thread 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_L

IS_USED_LOCK does not appear to work

2006-01-13 Thread Darth Vader
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