Debian Codegraph @

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

raw
1 #############################################################################
2 # Original Author: JBM #
3 # Original Date: Aug/14/2005 #
4 #############################################################################
5 # Test: This test contains two sp that create and drop tables, insert and #
6 # updated data and uses the NOW() function. #
7 #############################################################################
8
9
10 # Includes
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 TABLE IF EXISTS test.t2;
20 DROP TABLE IF EXISTS test.t1;
21 DROP TABLE IF EXISTS test.t3;
22 --enable_warnings
23 # End of cleanup
24
25 # Begin test section 1
26
27 delimiter |;
28 CREATE PROCEDURE test.p1()
29 BEGIN
30 CREATE TABLE IF NOT EXISTS test.t1(a INT,PRIMARY KEY(a));
31 CREATE TABLE IF NOT EXISTS test.t2(a INT,PRIMARY KEY(a));
32 INSERT INTO test.t1 VALUES (4),(2),(1),(3);
33 UPDATE test.t1 SET a=a+4 WHERE a=4;
34 INSERT INTO test.t2 (a) SELECT t1.a FROM test.t1;
35 UPDATE test.t1 SET a=a+4 WHERE a=8;
36 CREATE TABLE IF NOT EXISTS test.t3(n MEDIUMINT NOT NULL AUTO_INCREMENT, f FLOAT, d DATETIME, PRIMARY KEY(n));
37 END|
38 CREATE PROCEDURE test.p2()
39 BEGIN
40 DROP TABLE IF EXISTS test.t1;
41 DROP TABLE IF EXISTS test.t2;
42 INSERT INTO test.t3 VALUES(NULL,11111111.233333,NOW());
43 END|
44 delimiter ;|
45
46 CALL test.p1();
47 SELECT * FROM test.t1 ORDER BY a;
48 SELECT * FROM test.t2 ORDER BY a;
49 sync_slave_with_master;
50 SELECT * FROM test.t1 ORDER BY a;
51 SELECT * FROM test.t2 ORDER BY a;
52
53 connection master;
54 CALL test.p2();
55 USE test;
56 SHOW TABLES;
57 #SELECT * FROM test.t3;
58 sync_slave_with_master;
59 USE test;
60 SHOW TABLES;
61 #SELECT * FROM test.t3;
62
63 connection master;
64 CALL test.p1();
65 SELECT * FROM test.t1 ORDER BY a;
66 SELECT * FROM test.t2 ORDER BY a;
67 #SELECT * FROM test.t3;
68 sync_slave_with_master;
69 SELECT * FROM test.t1 ORDER BY a;
70 SELECT * FROM test.t2 ORDER BY a;
71 #SELECT * FROM test.t3;
72
73 --exec $MYSQL_DUMP --compact --order-by-primary --skip-extended-insert --no-create-info test > $MYSQLTEST_VARDIR/tmp/sp004_master.sql
74 --exec $MYSQL_DUMP_SLAVE --compact --order-by-primary --skip-extended-insert --no-create-info test > $MYSQLTEST_VARDIR/tmp/sp004_slave.sql
75
76 # Cleanup
77 connection master;
78 #show binlog events;
79 DROP PROCEDURE IF EXISTS test.p1;
80 DROP PROCEDURE IF EXISTS test.p2;
81 DROP TABLE IF EXISTS test.t1;
82 DROP TABLE IF EXISTS test.t2;
83 DROP TABLE IF EXISTS test.t3;
84 sync_slave_with_master;
85
86 # If the test fails, you will need to diff the dumps to see why.
87
88 diff_files $MYSQLTEST_VARDIR/tmp/sp004_master.sql $MYSQLTEST_VARDIR/tmp/sp004_slave.sql;
89
90
91 # End of 5.0 test case
92 --source include/rpl_end.inc