Debian Codegraph @

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

raw
1 #Want to skip this test from daily Valgrind execution
2 --source include/no_valgrind_without_big.inc
3
4 --source include/have_binlog_format_mixed_or_row.inc
5 --source include/set_privilege_checks_user_as_system_user.inc
6 --source include/master-slave.inc
7
8 # Set the default connection to 'master'
9
10 --vertical_results
11
12 let $engine_type= 'innodb';
13
14 ######## Creat Table Section #########
15 use test;
16
17 eval CREATE TABLE test.regular_tbl(id MEDIUMINT NOT NULL AUTO_INCREMENT,
18 dt TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON
19 UPDATE CURRENT_TIMESTAMP, user CHAR(255), uuidf LONGBLOB,
20 fkid MEDIUMINT, filler VARCHAR(255),
21 PRIMARY KEY(id)) ENGINE=$engine_type;
22
23 eval CREATE TABLE test.bykey_tbl(id MEDIUMINT NOT NULL AUTO_INCREMENT,
24 dt TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
25 CURRENT_TIMESTAMP, user CHAR(255), uuidf LONGBLOB,
26 fkid MEDIUMINT, filler VARCHAR(255),
27 PRIMARY KEY(id)) ENGINE=$engine_type
28 PARTITION BY KEY(id) partitions 5;
29
30 eval CREATE TABLE test.byrange_tbl(id MEDIUMINT NOT NULL AUTO_INCREMENT,
31 dt TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
32 CURRENT_TIMESTAMP, user CHAR(255), uuidf LONGBLOB,
33 fkid MEDIUMINT, filler VARCHAR(255),
34 PRIMARY KEY(id)) ENGINE=$engine_type
35 PARTITION BY RANGE(id)
36 SUBPARTITION BY hash(id) subpartitions 2
37 (PARTITION pa1 values less than (10),
38 PARTITION pa2 values less than (20),
39 PARTITION pa3 values less than (30),
40 PARTITION pa4 values less than (40),
41 PARTITION pa5 values less than (50),
42 PARTITION pa6 values less than (60),
43 PARTITION pa7 values less than (70),
44 PARTITION pa8 values less than (80),
45 PARTITION pa9 values less than (90),
46 PARTITION pa10 values less than (100),
47 PARTITION pa11 values less than MAXVALUE);
48
49 ######## Create SPs, Functions, Views and Triggers Section ##############
50
51 delimiter |;
52 CREATE PROCEDURE test.proc_norm()
53 BEGIN
54 DECLARE ins_count INT DEFAULT 1000;
55 DECLARE del_count INT;
56 DECLARE cur_user VARCHAR(255);
57 DECLARE local_uuid VARCHAR(255);
58 DECLARE local_time TIMESTAMP;
59
60 SET local_time= NOW();
61 SET cur_user= CURRENT_USER();
62 SET local_uuid= UUID();
63
64 WHILE ins_count > 0 DO
65 INSERT INTO test.regular_tbl VALUES (NULL, NOW(), USER() , UUID(),
66 ins_count,'Going to test MBR for MySQL');
67 SET ins_count = ins_count - 1;
68 END WHILE;
69
70 SELECT MAX(id) FROM test.regular_tbl INTO del_count;
71 WHILE del_count > 0 DO
72 DELETE FROM test.regular_tbl WHERE id = del_count;
73 SET del_count = del_count - 2;
74 END WHILE;
75 END|
76
77 CREATE PROCEDURE test.proc_bykey()
78 BEGIN
79 DECLARE ins_count INT DEFAULT 1000;
80 DECLARE del_count INT;
81 DECLARE cur_user VARCHAR(255);
82 DECLARE local_uuid VARCHAR(255);
83 DECLARE local_time TIMESTAMP;
84
85 SET local_time= NOW();
86 SET cur_user= CURRENT_USER();
87 SET local_uuid= UUID();
88
89 WHILE ins_count > 0 DO
90 INSERT INTO test.bykey_tbl VALUES (NULL, NOW(), USER() , UUID(),
91 ins_count,'Going to test MBR for MySQL');
92 SET ins_count = ins_count - 1;
93 END WHILE;
94
95 SELECT MAX(id) FROM test.bykey_tbl INTO del_count;
96 WHILE del_count > 0 DO
97 DELETE FROM test.bykey_tbl WHERE id = del_count;
98 SET del_count = del_count - 2;
99 END WHILE;
100 END|
101
102 CREATE PROCEDURE test.proc_byrange()
103 BEGIN
104 DECLARE ins_count INT DEFAULT 1000;
105 DECLARE del_count INT;
106 DECLARE cur_user VARCHAR(255);
107 DECLARE local_uuid VARCHAR(255);
108 DECLARE local_time TIMESTAMP;
109
110 SET local_time= NOW();
111 SET cur_user = CURRENT_USER();
112 SET local_uuid=UUID();
113
114 WHILE ins_count > 0 DO
115 INSERT INTO test.byrange_tbl VALUES (NULL, NOW(), USER(), UUID(),
116 ins_count,'Going to test MBR for MySQL');
117 SET ins_count = ins_count - 1;
118 END WHILE;
119
120 SELECT MAX(id) FROM test.byrange_tbl INTO del_count;
121 WHILE del_count > 0 DO
122 DELETE FROM test.byrange_tbl WHERE id = del_count;
123 SET del_count = del_count - 2;
124 END WHILE;
125 END|
126
127 delimiter ;|
128
129 ############ Finish Setup Section ###################
130
131
132 ############ Test Section ###################
133
134 CALL test.proc_norm();
135 SELECT count(*) as "Master regular" FROM test.regular_tbl;
136 CALL test.proc_bykey();
137 SELECT count(*) as "Master bykey" FROM test.bykey_tbl;
138 CALL test.proc_byrange();
139 SELECT count(*) as "Master byrange" FROM test.byrange_tbl;
140
141 --source include/sync_slave_sql_with_master.inc
142 connection slave;
143 show create table test.byrange_tbl;
144 SELECT count(*) "Slave norm" FROM test.regular_tbl;
145 SELECT count(*) "Slave bykey" FROM test.bykey_tbl;
146 SELECT count(*) "Slave byrange" FROM test.byrange_tbl;
147
148 ###### CLEAN UP SECTION ##############
149
150 connection master;
151 DROP PROCEDURE test.proc_norm;
152 DROP PROCEDURE test.proc_bykey;
153 DROP PROCEDURE test.proc_byrange;
154 DROP TABLE test.regular_tbl;
155 DROP TABLE test.bykey_tbl;
156 DROP TABLE test.byrange_tbl;
157
158 --source include/rpl_end.inc