Debian Codegraph @

mysql-test/suite/rpl/t/rpl_row_sp010.test

raw
1 #############################################################################
2 # Original Author: JBM #
3 # Original Date: Aug/18/2005 #
4 # Update: 08/29/2005 remove sleep added master pos save and sync #
5 #############################################################################
6 #TEST: Taken and modfied from http://bugs.mysql.com/bug.php?id=11126 #
7 #############################################################################
8
9 # Includes
10 -- source include/have_binlog_format_row.inc
11 -- source include/master-slave.inc
12
13
14 # Begin clean up test section
15 connection master;
16 --disable_warnings
17 DROP PROCEDURE IF EXISTS test.p1;
18 DROP PROCEDURE IF EXISTS test.p2;
19 DROP PROCEDURE IF EXISTS test.p3;
20 DROP PROCEDURE IF EXISTS test.p4;
21 DROP TABLE IF EXISTS test.t1;
22 DROP TABLE IF EXISTS test.t2;
23
24
25 # Begin test section 1
26 delimiter |;
27 CREATE PROCEDURE test.p1()
28 BEGIN
29 INSERT INTO test.t1 VALUES(2);
30 END|
31 CREATE PROCEDURE test.p2()
32 BEGIN
33 DROP TEMPORARY TABLE IF EXISTS test.t1;
34 CREATE TEMPORARY TABLE test.t1 (a int, PRIMARY KEY(a));
35 INSERT INTO test.t1 VALUES(1);
36 CALL test.p1();
37 END|
38 delimiter ;|
39 CALL test.p2();
40 SELECT * FROM test.t1 ORDER BY a;
41
42 sync_slave_with_master;
43 show tables;
44
45 connection master;
46 delimiter |;
47 CREATE PROCEDURE test.p3()
48 BEGIN
49 INSERT INTO test.t2 VALUES(7);
50 END|
51 CREATE PROCEDURE test.p4()
52 BEGIN
53 DROP TABLE IF EXISTS test.t2;
54 CREATE TABLE test.t2 (a int, PRIMARY KEY(a));
55 INSERT INTO test.t2 VALUES(6);
56 CALL test.p3();
57 END|
58 delimiter ;|
59 CALL test.p4();
60 SELECT * FROM test.t2 ORDER BY a;
61
62 sync_slave_with_master;
63 SELECT * FROM test.t2 ORDER BY a;
64
65 # Cleanup
66 connection master;
67 #show binlog events;
68 DROP PROCEDURE IF EXISTS test.p1;
69 DROP PROCEDURE IF EXISTS test.p2;
70 DROP PROCEDURE IF EXISTS test.p3;
71 DROP PROCEDURE IF EXISTS test.p4;
72 DROP TABLE IF EXISTS test.t1;
73 DROP TABLE IF EXISTS test.t2;
74 sync_slave_with_master;
75
76 # End of 5.0 test case
77 --source include/rpl_end.inc