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