2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
DROP DATABASE IF EXISTS db1;
10
CREATE TABLE db1.t1 (a INT) ENGINE=InnoDB;
11
CREATE TABLE db1.t2 (s CHAR(255)) ENGINE=MyISAM;
12
include/stop_slave.inc
14
CREATE PROCEDURE db1.p1 ()
16
INSERT INTO t1 VALUES (1);
17
INSERT INTO t1 VALUES (2);
18
INSERT INTO t1 VALUES (3);
19
INSERT INTO t1 VALUES (4);
20
INSERT INTO t1 VALUES (5);
22
CREATE PROCEDURE db1.p2 ()
24
INSERT INTO t1 VALUES (6);
25
INSERT INTO t1 VALUES (7);
26
INSERT INTO t1 VALUES (8);
27
INSERT INTO t1 VALUES (9);
28
INSERT INTO t1 VALUES (10);
29
INSERT INTO t2 VALUES ('executed db1.p2()');
31
INSERT INTO db1.t2 VALUES ('before call db1.p1()');
36
INSERT INTO db1.t2 VALUES ('after call db1.p1()');
49
start slave until master_log_file='master-bin.000001', master_log_pos=MASTER_POS;
51
# If we got non-zero here, then we're suffering BUG#43263
53
SELECT 0 as 'Must be 0';
67
INSERT INTO db1.t2 VALUES ('before call db1.p2()');
71
INSERT INTO db1.t2 VALUES ('after call db1.p2()');
87
start slave until master_log_file='master-bin.000001', master_log_pos=MASTER_POS;
89
# If we got non-zero here, then we're suffering BUG#43263
91
SELECT 0 as 'Must be 0';
101
SELECT * from db1.t2;