Debian Codegraph @

mysql-test/suite/engines/funcs/r/rpl_get_lock.result

raw
1 include/master-slave.inc
2 [connection master]
3 SET GLOBAL LOG_WARNINGS=4;
4 create table t1(n int);
5 insert into t1 values(get_lock("lock",2));
6 disconnect master;
7 connection master1;
8 select get_lock("lock",2);
9 get_lock("lock",2)
10 1
11 select release_lock("lock");
12 release_lock("lock")
13 1
14 connection slave;
15 select get_lock("lock",3);
16 get_lock("lock",3)
17 1
18 select * from t1;
19 n
20 1
21 select is_free_lock("lock"), is_used_lock("lock") = connection_id();
22 is_free_lock("lock") is_used_lock("lock") = connection_id()
23 0 1
24 explain extended select is_free_lock("lock"), is_used_lock("lock");
25 id select_type table type possible_keys key key_len ref rows filtered Extra
26 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used
27 Warnings:
28 Note 1003 select is_free_lock('lock') AS `is_free_lock("lock")`,is_used_lock('lock') AS `is_used_lock("lock")`
29 select is_free_lock("lock2");
30 is_free_lock("lock2")
31 1
32 select is_free_lock(NULL);
33 is_free_lock(NULL)
34 NULL
35 connection master1;
36 drop table t1;
37 connection slave;
38 connection default;
39 include/rpl_end.inc