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 PROCEDURE IF EXISTS test.p1;
8
DROP TABLE IF EXISTS test.t1;
9
CREATE PROCEDURE test.p1(IN i INT)
11
DECLARE CONTINUE HANDLER FOR sqlexception BEGIN END;
12
DROP TABLE IF EXISTS test.t1;
13
CREATE TABLE test.t1 (num INT,PRIMARY KEY(num))ENGINE=INNODB;
15
INSERT INTO test.t1 VALUES(i);
17
INSERT INTO test.t1 VALUES (14);
18
ROLLBACK to savepoint t1_save;
22
< ---- Master selects-- >
23
-------------------------
26
Note 1051 Unknown table 't1'
27
SELECT * FROM test.t1;
31
< ---- Slave selects-- >
32
------------------------
33
SELECT * FROM test.t1;
37
< ---- Master selects-- >
38
-------------------------
40
SELECT * FROM test.t1;
44
< ---- Slave selects-- >
45
------------------------
46
SELECT * FROM test.t1;
49
DROP PROCEDURE IF EXISTS test.p1;
50
DROP TABLE IF EXISTS test.t1;