Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 CREATE PROCEDURE test.p1(IN i INT)
4 BEGIN
5 DECLARE CONTINUE HANDLER FOR sqlexception BEGIN END;
6 DROP TABLE IF EXISTS test.t1;
7 CREATE TABLE test.t1 (num INT,PRIMARY KEY(num))ENGINE=INNODB;
8 START TRANSACTION;
9 INSERT INTO test.t1 VALUES(i);
10 savepoint t1_save;
11 INSERT INTO test.t1 VALUES (14);
12 ROLLBACK to savepoint t1_save;
13 COMMIT;
14 END|
15 CALL test.p1(12);
16 SELECT * FROM test.t1;
17 num
18 12
19 connection slave;
20 SELECT * FROM test.t1;
21 num
22 12
23 connection master;
24 CALL test.p1(13);
25 SELECT * FROM test.t1;
26 num
27 13
28 connection slave;
29 SELECT * FROM test.t1;
30 num
31 13
32 connection master;
33 DROP PROCEDURE test.p1;
34 DROP TABLE test.t1;
35 include/rpl_end.inc