1 #############################################################################
2 # TEST: SP that creates table, starts tranaction inserts. Save point, insert#
3 # rollback to save point and then commits. #
4 #############################################################################
6 -- source include/have_binlog_format_row.inc
7 -- source include/master-slave.inc
11 eval CREATE PROCEDURE test.p1(IN i INT)
13 DECLARE CONTINUE HANDLER FOR sqlexception BEGIN END;
14 DROP TABLE IF EXISTS test.t1;
15 CREATE TABLE test.t1 (num INT,PRIMARY KEY(num))ENGINE=$engine_type;
17 INSERT INTO test.t1 VALUES(i);
19 INSERT INTO test.t1 VALUES (14);
20 ROLLBACK to savepoint t1_save;
25 let $message=< ---- Master selects-- >;
26 --source include/show_msg.inc
28 SELECT * FROM test.t1;
31 let $message=< ---- Slave selects-- >;
32 --source include/show_msg.inc
33 sync_slave_with_master;
34 SELECT * FROM test.t1;
36 let $message=< ---- Master selects-- >;
37 --source include/show_msg.inc
40 SELECT * FROM test.t1;
42 let $message=< ---- Slave selects-- >;
43 --source include/show_msg.inc
44 sync_slave_with_master;
45 SELECT * FROM test.t1;
51 DROP PROCEDURE test.p1;
54 # End of 5.0 test case
55 --source include/rpl_end.inc