rpl_get_lock.result 401 Bytes
Newer Older
unknown's avatar
unknown committed
1 2 3 4 5 6 7
slave stop;
reset master;
reset slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
slave start;
create table t1(n int);
insert into t1 values(get_lock("lock",2));
8 9 10 11 12 13
select get_lock("lock",2);
get_lock("lock",2)
1
select release_lock("lock");
release_lock("lock")
1
unknown's avatar
unknown committed
14
select get_lock("lock",3);
unknown's avatar
unknown committed
15 16
get_lock("lock",3)
1
unknown's avatar
unknown committed
17
select * from t1;
unknown's avatar
unknown committed
18 19
n
1
unknown's avatar
unknown committed
20 21 22
select check_lock("lock");
check_lock("lock")
1
unknown's avatar
unknown committed
23
drop table t1;