Debian Codegraph @

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

raw
1 ##################################################################
2 # rpl_row_wide_table
3 #
4 # This test verifies that the table with number of attributes more
5 # than 250 is replicated.
6 # Related bugs:
7 # Bug #42977 RBR logs for rows with more than 250 column results
8 # in corrupt binlog
9 ##################################################################
10
11 -- source include/master-slave.inc
12 -- source include/have_binlog_format_row.inc
13
14 --disable_warnings
15 DROP TABLE IF EXISTS t300;
16 --enable_warnings
17
18 connection master;
19
20 create table t300 (
21 f1 int,
22 f2 int,
23 f3 int,
24 f4 int,
25 f5 int,
26 f6 int,
27 f7 int,
28 f8 int,
29 f9 int,
30 f10 int,
31 f11 int,
32 f12 int,
33 f13 int,
34 f14 int,
35 f15 int,
36 f16 int,
37 f17 int,
38 f18 int,
39 f19 int,
40 f20 int,
41 f21 int,
42 f22 int,
43 f23 int,
44 f24 int,
45 f25 int,
46 f26 int,
47 f27 int,
48 f28 int,
49 f29 int,
50 f30 int,
51 f31 int,
52 f32 int,
53 f33 int,
54 f34 int,
55 f35 int,
56 f36 int,
57 f37 int,
58 f38 int,
59 f39 int,
60 f40 int,
61 f41 int,
62 f42 int,
63 f43 int,
64 f44 int,
65 f45 int,
66 f46 int,
67 f47 int,
68 f48 int,
69 f49 int,
70 f50 int,
71 f51 int,
72 f52 int,
73 f53 int,
74 f54 int,
75 f55 int,
76 f56 int,
77 f57 int,
78 f58 int,
79 f59 int,
80 f60 int,
81 f61 int,
82 f62 int,
83 f63 int,
84 f64 int,
85 f65 int,
86 f66 int,
87 f67 int,
88 f68 int,
89 f69 int,
90 f70 int,
91 f71 int,
92 f72 int,
93 f73 int,
94 f74 int,
95 f75 int,
96 f76 int,
97 f77 int,
98 f78 int,
99 f79 int,
100 f80 int,
101 f81 int,
102 f82 int,
103 f83 int,
104 f84 int,
105 f85 int,
106 f86 int,
107 f87 int,
108 f88 int,
109 f89 int,
110 f90 int,
111 f91 int,
112 f92 int,
113 f93 int,
114 f94 int,
115 f95 int,
116 f96 int,
117 f97 int,
118 f98 int,
119 f99 int,
120 f100 int,
121 f101 int,
122 f102 int,
123 f103 int,
124 f104 int,
125 f105 int,
126 f106 int,
127 f107 int,
128 f108 int,
129 f109 int,
130 f110 int,
131 f111 int,
132 f112 int,
133 f113 int,
134 f114 int,
135 f115 int,
136 f116 int,
137 f117 int,
138 f118 int,
139 f119 int,
140 f120 int,
141 f121 int,
142 f122 int,
143 f123 int,
144 f124 int,
145 f125 int,
146 f126 int,
147 f127 int,
148 f128 int,
149 f129 int,
150 f130 int,
151 f131 int,
152 f132 int,
153 f133 int,
154 f134 int,
155 f135 int,
156 f136 int,
157 f137 int,
158 f138 int,
159 f139 int,
160 f140 int,
161 f141 int,
162 f142 int,
163 f143 int,
164 f144 int,
165 f145 int,
166 f146 int,
167 f147 int,
168 f148 int,
169 f149 int,
170 f150 int,
171 f151 int,
172 f152 int,
173 f153 int,
174 f154 int,
175 f155 int,
176 f156 int,
177 f157 int,
178 f158 int,
179 f159 int,
180 f160 int,
181 f161 int,
182 f162 int,
183 f163 int,
184 f164 int,
185 f165 int,
186 f166 int,
187 f167 int,
188 f168 int,
189 f169 int,
190 f170 int,
191 f171 int,
192 f172 int,
193 f173 int,
194 f174 int,
195 f175 int,
196 f176 int,
197 f177 int,
198 f178 int,
199 f179 int,
200 f180 int,
201 f181 int,
202 f182 int,
203 f183 int,
204 f184 int,
205 f185 int,
206 f186 int,
207 f187 int,
208 f188 int,
209 f189 int,
210 f190 int,
211 f191 int,
212 f192 int,
213 f193 int,
214 f194 int,
215 f195 int,
216 f196 int,
217 f197 int,
218 f198 int,
219 f199 int,
220 f200 int,
221 f201 int,
222 f202 int,
223 f203 int,
224 f204 int,
225 f205 int,
226 f206 int,
227 f207 int,
228 f208 int,
229 f209 int,
230 f210 int,
231 f211 int,
232 f212 int,
233 f213 int,
234 f214 int,
235 f215 int,
236 f216 int,
237 f217 int,
238 f218 int,
239 f219 int,
240 f220 int,
241 f221 int,
242 f222 int,
243 f223 int,
244 f224 int,
245 f225 int,
246 f226 int,
247 f227 int,
248 f228 int,
249 f229 int,
250 f230 int,
251 f231 int,
252 f232 int,
253 f233 int,
254 f234 int,
255 f235 int,
256 f236 int,
257 f237 int,
258 f238 int,
259 f239 int,
260 f240 int,
261 f241 int,
262 f242 int,
263 f243 int,
264 f244 int,
265 f245 int,
266 f246 int,
267 f247 int,
268 f248 int,
269 f249 int,
270 f250 int,
271 f251 int,
272 f252 int,
273 f253 int,
274 f254 int,
275 f255 int,
276 f256 int,
277 f257 int,
278 f258 int,
279 f259 int,
280 f260 int,
281 f261 int,
282 f262 int,
283 f263 int,
284 f264 int,
285 f265 int,
286 f266 int,
287 f267 int,
288 f268 int,
289 f269 int,
290 f270 int,
291 f271 int,
292 f272 int,
293 f273 int,
294 f274 int,
295 f275 int,
296 f276 int,
297 f277 int,
298 f278 int,
299 f279 int,
300 f280 int,
301 f281 int,
302 f282 int,
303 f283 int,
304 f284 int,
305 f285 int,
306 f286 int,
307 f287 int,
308 f288 int,
309 f289 int,
310 f290 int,
311 f291 int,
312 f292 int,
313 f293 int,
314 f294 int,
315 f295 int,
316 f296 int,
317 f297 int,
318 f298 int,
319 f299 int,
320 f300 int,
321 primary key (f1));
322
323 insert into t300 set f1= 1;
324
325 --source include/sync_slave_sql_with_master.inc
326
327 #
328 # prove that slave processed the create as well as the insert
329 #
330 eval select f300 from t300;
331 select count(*) as one from t300;
332
333 --echo *** Cleanup ***
334 connection master;
335 DROP TABLE t300;
336
337 # END of Test Case
338
339 --source include/rpl_end.inc