Debian Codegraph @

mysql-test/suite/rpl/r/rpl_row_sp003.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 DROP PROCEDURE IF EXISTS test.p1;
5 DROP PROCEDURE IF EXISTS test.p2;
6 DROP TABLE IF EXISTS test.t1;
7 CREATE TABLE test.t1(a INT,PRIMARY KEY(a))ENGINE=INNODB;
8 CREATE PROCEDURE test.p1()
9 BEGIN
10 INSERT INTO test.t1 VALUES (4);
11 SELECT get_lock("test", 100);
12 UPDATE test.t1 set a=a+4 WHERE a=4;
13 END|
14 CREATE PROCEDURE test.p2()
15 BEGIN
16 UPDATE test.t1 SET a=a+1;
17 END|
18 SELECT get_lock("test", 200);
19 get_lock("test", 200)
20 1
21 connection master1;
22 CALL test.p1();
23 connection master;
24 CALL test.p2();
25 SELECT release_lock("test");
26 release_lock("test")
27 1
28 connection master1;
29 get_lock("test", 100)
30 1
31 SELECT release_lock("test");
32 release_lock("test")
33 1
34 connection master;
35 SELECT * FROM test.t1;
36 a
37 5
38 connection slave;
39 connection slave;
40 SELECT * FROM test.t1;
41 a
42 5
43 connection master;
44 DROP TABLE IF EXISTS test.t1;
45 CREATE TABLE test.t1(a INT,PRIMARY KEY(a))ENGINE=INNODB;
46 CALL test.p2();
47 CALL test.p1();
48 get_lock("test", 100)
49 1
50 SELECT release_lock("test");
51 release_lock("test")
52 1
53 SELECT * FROM test.t1;
54 a
55 8
56 connection slave;
57 connection slave;
58 SELECT * FROM test.t1;
59 a
60 8
61 connection master;
62 DROP PROCEDURE IF EXISTS test.p1;
63 DROP PROCEDURE IF EXISTS test.p2;
64 DROP TABLE IF EXISTS test.t1;
65 connection slave;
66 include/rpl_end.inc