Debian Codegraph @

mysql-test/suite/rpl/r/rpl_row_tbl_metadata.result

raw
1 include/master-slave.inc
2 [connection master]
3 DROP TABLE IF EXISTS `t1`;
4 ### TABLE with field_metadata_size == 290
5 CREATE TABLE `t1` (
6 `c1` int(11) NOT NULL AUTO_INCREMENT,
7 `c2` varchar(30) NOT NULL,
8 `c3` varchar(30) DEFAULT NULL,
9 `c4` varchar(30) DEFAULT NULL,
10 `c5` varchar(30) DEFAULT NULL,
11 `c6` varchar(30) DEFAULT NULL,
12 `c7` varchar(30) DEFAULT NULL,
13 `c8` varchar(30) DEFAULT NULL,
14 `c9` varchar(30) DEFAULT NULL,
15 `c10` varchar(30) DEFAULT NULL,
16 `c11` varchar(30) DEFAULT NULL,
17 `c12` varchar(30) DEFAULT NULL,
18 `c13` varchar(30) DEFAULT NULL,
19 `c14` varchar(30) DEFAULT NULL,
20 `c15` varchar(30) DEFAULT NULL,
21 `c16` varchar(30) DEFAULT NULL,
22 `c17` varchar(30) DEFAULT NULL,
23 `c18` varchar(30) DEFAULT NULL,
24 `c19` varchar(30) DEFAULT NULL,
25 `c20` varchar(30) DEFAULT NULL,
26 `c21` varchar(30) DEFAULT NULL,
27 `c22` varchar(30) DEFAULT NULL,
28 `c23` varchar(30) DEFAULT NULL,
29 `c24` varchar(30) DEFAULT NULL,
30 `c25` varchar(30) DEFAULT NULL,
31 `c26` varchar(30) DEFAULT NULL,
32 `c27` varchar(30) DEFAULT NULL,
33 `c28` varchar(30) DEFAULT NULL,
34 `c29` varchar(30) DEFAULT NULL,
35 `c30` varchar(30) DEFAULT NULL,
36 `c31` varchar(30) DEFAULT NULL,
37 `c32` varchar(30) DEFAULT NULL,
38 `c33` varchar(30) DEFAULT NULL,
39 `c34` varchar(30) DEFAULT NULL,
40 `c35` varchar(30) DEFAULT NULL,
41 `c36` varchar(30) DEFAULT NULL,
42 `c37` varchar(30) DEFAULT NULL,
43 `c38` varchar(30) DEFAULT NULL,
44 `c39` varchar(30) DEFAULT NULL,
45 `c40` varchar(30) DEFAULT NULL,
46 `c41` varchar(30) DEFAULT NULL,
47 `c42` varchar(30) DEFAULT NULL,
48 `c43` varchar(30) DEFAULT NULL,
49 `c44` varchar(30) DEFAULT NULL,
50 `c45` varchar(30) DEFAULT NULL,
51 `c46` varchar(30) DEFAULT NULL,
52 `c47` varchar(30) DEFAULT NULL,
53 `c48` varchar(30) DEFAULT NULL,
54 `c49` varchar(30) DEFAULT NULL,
55 `c50` varchar(30) DEFAULT NULL,
56 `c51` varchar(30) DEFAULT NULL,
57 `c52` varchar(30) DEFAULT NULL,
58 `c53` varchar(30) DEFAULT NULL,
59 `c54` varchar(30) DEFAULT NULL,
60 `c55` varchar(30) DEFAULT NULL,
61 `c56` varchar(30) DEFAULT NULL,
62 `c57` varchar(30) DEFAULT NULL,
63 `c58` varchar(30) DEFAULT NULL,
64 `c59` varchar(30) DEFAULT NULL,
65 `c60` varchar(30) DEFAULT NULL,
66 `c61` varchar(30) DEFAULT NULL,
67 `c62` varchar(30) DEFAULT NULL,
68 `c63` varchar(30) DEFAULT NULL,
69 `c64` varchar(30) DEFAULT NULL,
70 `c65` varchar(30) DEFAULT NULL,
71 `c66` varchar(30) DEFAULT NULL,
72 `c67` varchar(30) DEFAULT NULL,
73 `c68` varchar(30) DEFAULT NULL,
74 `c69` varchar(30) DEFAULT NULL,
75 `c70` varchar(30) DEFAULT NULL,
76 `c71` varchar(30) DEFAULT NULL,
77 `c72` varchar(30) DEFAULT NULL,
78 `c73` varchar(30) DEFAULT NULL,
79 `c74` varchar(30) DEFAULT NULL,
80 `c75` varchar(30) DEFAULT NULL,
81 `c76` varchar(30) DEFAULT NULL,
82 `c77` varchar(30) DEFAULT NULL,
83 `c78` varchar(30) DEFAULT NULL,
84 `c79` varchar(30) DEFAULT NULL,
85 `c80` varchar(30) DEFAULT NULL,
86 `c81` varchar(30) DEFAULT NULL,
87 `c82` varchar(30) DEFAULT NULL,
88 `c83` varchar(30) DEFAULT NULL,
89 `c84` varchar(30) DEFAULT NULL,
90 `c85` varchar(30) DEFAULT NULL,
91 `c86` varchar(30) DEFAULT NULL,
92 `c87` varchar(30) DEFAULT NULL,
93 `c88` varchar(30) DEFAULT NULL,
94 `c89` varchar(30) DEFAULT NULL,
95 `c90` varchar(30) DEFAULT NULL,
96 `c91` varchar(30) DEFAULT NULL,
97 `c92` varchar(30) DEFAULT NULL,
98 `c93` varchar(30) DEFAULT NULL,
99 `c94` varchar(30) DEFAULT NULL,
100 `c95` varchar(30) DEFAULT NULL,
101 `c96` varchar(30) DEFAULT NULL,
102 `c97` varchar(30) DEFAULT NULL,
103 `c98` varchar(30) DEFAULT NULL,
104 `c99` varchar(30) DEFAULT NULL,
105 `c100` varchar(30) DEFAULT NULL,
106 `c101` varchar(30) DEFAULT NULL,
107 `c102` varchar(30) DEFAULT NULL,
108 `c103` varchar(30) DEFAULT NULL,
109 `c104` varchar(30) DEFAULT NULL,
110 `c105` varchar(30) DEFAULT NULL,
111 `c106` varchar(30) DEFAULT NULL,
112 `c107` varchar(30) DEFAULT NULL,
113 `c108` varchar(30) DEFAULT NULL,
114 `c109` varchar(30) DEFAULT NULL,
115 `c110` varchar(30) DEFAULT NULL,
116 `c111` varchar(30) DEFAULT NULL,
117 `c112` varchar(30) DEFAULT NULL,
118 `c113` varchar(30) DEFAULT NULL,
119 `c114` varchar(30) DEFAULT NULL,
120 `c115` varchar(30) DEFAULT NULL,
121 `c116` varchar(30) DEFAULT NULL,
122 `c117` varchar(30) DEFAULT NULL,
123 `c118` varchar(30) DEFAULT NULL,
124 `c119` varchar(30) DEFAULT NULL,
125 `c120` varchar(30) DEFAULT NULL,
126 `c121` varchar(30) DEFAULT NULL,
127 `c122` varchar(30) DEFAULT NULL,
128 `c123` varchar(30) DEFAULT NULL,
129 `c124` varchar(30) DEFAULT NULL,
130 `c125` varchar(30) DEFAULT NULL,
131 `c126` varchar(30) DEFAULT NULL,
132 `c127` varchar(30) DEFAULT NULL,
133 `c128` varchar(30) DEFAULT NULL,
134 `c129` varchar(30) DEFAULT NULL,
135 `c130` varchar(30) DEFAULT NULL,
136 `c131` varchar(30) DEFAULT NULL,
137 `c132` varchar(30) DEFAULT NULL,
138 `c133` varchar(30) DEFAULT NULL,
139 `c134` varchar(30) DEFAULT NULL,
140 `c135` varchar(30) DEFAULT NULL,
141 `c136` varchar(30) DEFAULT NULL,
142 `c137` varchar(30) DEFAULT NULL,
143 `c138` varchar(30) DEFAULT NULL,
144 `c139` varchar(30) DEFAULT NULL,
145 `c140` varchar(30) DEFAULT NULL,
146 `c141` varchar(30) DEFAULT NULL,
147 `c142` varchar(30) DEFAULT NULL,
148 `c143` varchar(30) DEFAULT NULL,
149 `c144` varchar(30) DEFAULT NULL,
150 `c145` varchar(30) DEFAULT NULL,
151 `c146` varchar(30) DEFAULT NULL,
152 PRIMARY KEY (`c1`)
153 ) ENGINE=InnoDB CHARSET=latin1;
154 LOCK TABLES `t1` WRITE;
155 INSERT INTO `t1`(c2) VALUES ('1');
156 FLUSH LOGS;
157 connection slave;
158 connection master;
159 ### assertion: the slave replicated event successfully and tables match
160 include/diff_tables.inc [master:t1, slave:t1]
161 DROP TABLE `t1`;
162 connection master;
163 connection slave;
164 connection master;
165 === Using mysqlbinlog to detect failure. Before the patch mysqlbinlog would find a corrupted event, thence would fail.
166 include/rpl_reset.inc
167 connection master;
168 ### action: generating several tables with different metadata
169 ### sizes (resorting to perl)
170 ### testing table with 249 field metadata size.
171 ### testing table with 250 field metadata size.
172 ### testing table with 251 field metadata size.
173 ### testing table with 252 field metadata size.
174 ### testing table with 253 field metadata size.
175 ### testing table with 254 field metadata size.
176 ### testing table with 255 field metadata size.
177 ### testing table with 256 field metadata size.
178 ### testing table with 257 field metadata size.
179 ### testing table with 258 field metadata size.
180 connection slave;
181 connection master;
182 FLUSH LOGS;
183 ### assertion: the slave replicated event successfully and tables match for t10
184 include/diff_tables.inc [master:t10, slave:t10]
185 connection master;
186 connection slave;
187 connection master;
188 ### assertion: the slave replicated event successfully and tables match for t9
189 include/diff_tables.inc [master:t9, slave:t9]
190 connection master;
191 connection slave;
192 connection master;
193 ### assertion: the slave replicated event successfully and tables match for t8
194 include/diff_tables.inc [master:t8, slave:t8]
195 connection master;
196 connection slave;
197 connection master;
198 ### assertion: the slave replicated event successfully and tables match for t7
199 include/diff_tables.inc [master:t7, slave:t7]
200 connection master;
201 connection slave;
202 connection master;
203 ### assertion: the slave replicated event successfully and tables match for t6
204 include/diff_tables.inc [master:t6, slave:t6]
205 connection master;
206 connection slave;
207 connection master;
208 ### assertion: the slave replicated event successfully and tables match for t5
209 include/diff_tables.inc [master:t5, slave:t5]
210 connection master;
211 connection slave;
212 connection master;
213 ### assertion: the slave replicated event successfully and tables match for t4
214 include/diff_tables.inc [master:t4, slave:t4]
215 connection master;
216 connection slave;
217 connection master;
218 ### assertion: the slave replicated event successfully and tables match for t3
219 include/diff_tables.inc [master:t3, slave:t3]
220 connection master;
221 connection slave;
222 connection master;
223 ### assertion: the slave replicated event successfully and tables match for t2
224 include/diff_tables.inc [master:t2, slave:t2]
225 connection master;
226 connection slave;
227 connection master;
228 ### assertion: the slave replicated event successfully and tables match for t1
229 include/diff_tables.inc [master:t1, slave:t1]
230 connection master;
231 connection slave;
232 connection master;
233 ### assertion: check that binlog is not corrupt. Using mysqlbinlog to
234 ### detect failure. Before the patch mysqlbinlog would find
235 ### a corrupted event, thence would fail.
236 include/rpl_end.inc