Debian Codegraph @

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

raw
1 include/rpl_init.inc [topology=1->2->3]
2 connection server_1;
3 connection server_2;
4 connection server_3;
5 connection server_1;
6 CON: 'server_1', IMG: 'NOBLOB', RESTART SLAVE: 'N'
7 connection server_1;
8 SET SESSION binlog_row_image= 'NOBLOB';
9 SET GLOBAL binlog_row_image= 'NOBLOB';
10 FLUSH TABLES;
11 SHOW VARIABLES LIKE 'binlog_row_image';
12 Variable_name Value
13 binlog_row_image NOBLOB
14 CON: 'server_2', IMG: 'NOBLOB', RESTART SLAVE: 'Y'
15 connection server_2;
16 SET SESSION binlog_row_image= 'NOBLOB';
17 SET GLOBAL binlog_row_image= 'NOBLOB';
18 include/stop_slave.inc
19 include/start_slave.inc
20 FLUSH TABLES;
21 SHOW VARIABLES LIKE 'binlog_row_image';
22 Variable_name Value
23 binlog_row_image NOBLOB
24 CON: 'server_3', IMG: 'NOBLOB', RESTART SLAVE: 'Y'
25 connection server_3;
26 SET SESSION binlog_row_image= 'NOBLOB';
27 SET GLOBAL binlog_row_image= 'NOBLOB';
28 include/stop_slave.inc
29 include/start_slave.inc
30 FLUSH TABLES;
31 SHOW VARIABLES LIKE 'binlog_row_image';
32 Variable_name Value
33 binlog_row_image NOBLOB
34 connection server_1;
35 ### engines: MyISAM, MyISAM, MyISAM
36 connection server_1;
37 connection server_1;
38 SET SQL_LOG_BIN=0;
39 connection server_2;
40 SET SQL_LOG_BIN=0;
41 connection server_3;
42 SET SQL_LOG_BIN=0;
43 ****** TEST: One Composite NOT NULL Unique key with holes in master, but NULLABLE on first slave
44 connection server_1;
45 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= MyISAM;;
46 connection server_2;
47 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= MyISAM;;
48 connection server_3;
49 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= MyISAM;;
50 connection server_1;
51 SET SQL_LOG_BIN=1;
52 connection server_2;
53 SET SQL_LOG_BIN=1;
54 connection server_3;
55 SET SQL_LOG_BIN=1;
56 connection server_1;
57 INSERT INTO t VALUES (1, '1', '1', '1' );
58 INSERT INTO t VALUES (4, '4', '4', '4' );
59 INSERT INTO t VALUES (7, '7', '7', '7' );
60 INSERT INTO t VALUES (9, '9', '9', NULL );
61 INSERT INTO t VALUES (2, '1', '2', '2' );
62 INSERT INTO t VALUES (3, '1', '3', '2' );
63 include/rpl_sync.inc
64 connection server_1;
65 UPDATE t SET c4 = '7';
66 UPDATE t SET c4 = '5' WHERE c1 = 1;
67 UPDATE t SET c2 = '5' WHERE c1 = 1;
68 UPDATE t SET c1 = '5' WHERE c1 = 1;
69 UPDATE t SET c4 = '8' WHERE c2 = '4';
70 UPDATE t SET c1 = '8' WHERE c2 = '4';
71 UPDATE t SET c2 = '8' WHERE c2 = '4';
72 UPDATE t SET c3 = '0' WHERE c4 = NULL;
73 UPDATE t SET c2 = '0' WHERE c4 = '0';
74 UPDATE t SET c2 = '2' WHERE c4 = '2';
75 include/rpl_sync.inc
76 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
77 connection server_1;
78 DELETE FROM t WHERE c1 = 7;
79 DELETE FROM t WHERE c1 = 8;
80 DELETE FROM t;
81 include/rpl_sync.inc
82 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
83 connection server_1;
84 DROP TABLE t;
85 include/rpl_sync.inc
86 connection server_1;
87 SET SQL_LOG_BIN=0;
88 connection server_2;
89 SET SQL_LOG_BIN=0;
90 connection server_3;
91 SET SQL_LOG_BIN=0;
92 ****** TEST: One Composite NOT NULL Unique key with holes
93 connection server_1;
94 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= MyISAM;;
95 connection server_2;
96 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= MyISAM;;
97 connection server_3;
98 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= MyISAM;;
99 connection server_1;
100 SET SQL_LOG_BIN=1;
101 connection server_2;
102 SET SQL_LOG_BIN=1;
103 connection server_3;
104 SET SQL_LOG_BIN=1;
105 connection server_1;
106 INSERT INTO t VALUES (1, '1', '1', '1' );
107 INSERT INTO t VALUES (4, '4', '4', '4' );
108 INSERT INTO t VALUES (7, '7', '7', '7' );
109 INSERT INTO t VALUES (9, '9', '9', NULL );
110 INSERT INTO t VALUES (2, '1', '2', '2' );
111 INSERT INTO t VALUES (3, '1', '3', '2' );
112 include/rpl_sync.inc
113 connection server_1;
114 UPDATE t SET c4 = '7';
115 UPDATE t SET c4 = '5' WHERE c1 = 1;
116 UPDATE t SET c2 = '5' WHERE c1 = 1;
117 UPDATE t SET c1 = '5' WHERE c1 = 1;
118 UPDATE t SET c4 = '8' WHERE c2 = '4';
119 UPDATE t SET c1 = '8' WHERE c2 = '4';
120 UPDATE t SET c2 = '8' WHERE c2 = '4';
121 UPDATE t SET c3 = '0' WHERE c4 = NULL;
122 UPDATE t SET c2 = '0' WHERE c4 = '0';
123 UPDATE t SET c2 = '2' WHERE c4 = '2';
124 include/rpl_sync.inc
125 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
126 connection server_1;
127 DELETE FROM t WHERE c1 = 7;
128 DELETE FROM t WHERE c1 = 8;
129 DELETE FROM t;
130 include/rpl_sync.inc
131 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
132 connection server_1;
133 DROP TABLE t;
134 include/rpl_sync.inc
135 connection server_1;
136 SET SQL_LOG_BIN=0;
137 connection server_2;
138 SET SQL_LOG_BIN=0;
139 connection server_3;
140 SET SQL_LOG_BIN=0;
141 ****** TEST: One Composite Primary Key with holes
142 connection server_1;
143 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c3)) engine= MyISAM;;
144 connection server_2;
145 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c3)) engine= MyISAM;;
146 connection server_3;
147 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c3)) engine= MyISAM;;
148 connection server_1;
149 SET SQL_LOG_BIN=1;
150 connection server_2;
151 SET SQL_LOG_BIN=1;
152 connection server_3;
153 SET SQL_LOG_BIN=1;
154 connection server_1;
155 INSERT INTO t VALUES (1, '1', '1', '1' );
156 INSERT INTO t VALUES (4, '4', '4', '4' );
157 INSERT INTO t VALUES (7, '7', '7', '7' );
158 INSERT INTO t VALUES (9, '9', '9', NULL );
159 INSERT INTO t VALUES (2, '1', '2', '2' );
160 INSERT INTO t VALUES (3, '1', '3', '2' );
161 include/rpl_sync.inc
162 connection server_1;
163 UPDATE t SET c4 = '7';
164 UPDATE t SET c4 = '5' WHERE c1 = 1;
165 UPDATE t SET c2 = '5' WHERE c1 = 1;
166 UPDATE t SET c1 = '5' WHERE c1 = 1;
167 UPDATE t SET c4 = '8' WHERE c2 = '4';
168 UPDATE t SET c1 = '8' WHERE c2 = '4';
169 UPDATE t SET c2 = '8' WHERE c2 = '4';
170 UPDATE t SET c3 = '0' WHERE c4 = NULL;
171 UPDATE t SET c2 = '0' WHERE c4 = '0';
172 UPDATE t SET c2 = '2' WHERE c4 = '2';
173 include/rpl_sync.inc
174 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
175 connection server_1;
176 DELETE FROM t WHERE c1 = 7;
177 DELETE FROM t WHERE c1 = 8;
178 DELETE FROM t;
179 include/rpl_sync.inc
180 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
181 connection server_1;
182 DROP TABLE t;
183 include/rpl_sync.inc
184 connection server_1;
185 SET SQL_LOG_BIN=0;
186 connection server_2;
187 SET SQL_LOG_BIN=0;
188 connection server_3;
189 SET SQL_LOG_BIN=0;
190 ****** TEST: One Composite Unique key with holes
191 connection server_1;
192 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= MyISAM;;
193 connection server_2;
194 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= MyISAM;;
195 connection server_3;
196 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= MyISAM;;
197 connection server_1;
198 SET SQL_LOG_BIN=1;
199 connection server_2;
200 SET SQL_LOG_BIN=1;
201 connection server_3;
202 SET SQL_LOG_BIN=1;
203 connection server_1;
204 INSERT INTO t VALUES (1, '1', '1', '1' );
205 INSERT INTO t VALUES (4, '4', '4', '4' );
206 INSERT INTO t VALUES (7, '7', '7', '7' );
207 INSERT INTO t VALUES (9, '9', '9', NULL );
208 INSERT INTO t VALUES (2, '1', '2', '2' );
209 INSERT INTO t VALUES (3, '1', '3', '2' );
210 include/rpl_sync.inc
211 connection server_1;
212 UPDATE t SET c4 = '7';
213 UPDATE t SET c4 = '5' WHERE c1 = 1;
214 UPDATE t SET c2 = '5' WHERE c1 = 1;
215 UPDATE t SET c1 = '5' WHERE c1 = 1;
216 UPDATE t SET c4 = '8' WHERE c2 = '4';
217 UPDATE t SET c1 = '8' WHERE c2 = '4';
218 UPDATE t SET c2 = '8' WHERE c2 = '4';
219 UPDATE t SET c3 = '0' WHERE c4 = NULL;
220 UPDATE t SET c2 = '0' WHERE c4 = '0';
221 UPDATE t SET c2 = '2' WHERE c4 = '2';
222 include/rpl_sync.inc
223 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
224 connection server_1;
225 DELETE FROM t WHERE c1 = 7;
226 DELETE FROM t WHERE c1 = 8;
227 DELETE FROM t;
228 include/rpl_sync.inc
229 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
230 connection server_1;
231 DROP TABLE t;
232 include/rpl_sync.inc
233 connection server_1;
234 SET SQL_LOG_BIN=0;
235 connection server_2;
236 SET SQL_LOG_BIN=0;
237 connection server_3;
238 SET SQL_LOG_BIN=0;
239 ****** TEST: One Composite key with holes
240 connection server_1;
241 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c3)) engine= MyISAM;;
242 connection server_2;
243 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c3)) engine= MyISAM;;
244 connection server_3;
245 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c3)) engine= MyISAM;;
246 connection server_1;
247 SET SQL_LOG_BIN=1;
248 connection server_2;
249 SET SQL_LOG_BIN=1;
250 connection server_3;
251 SET SQL_LOG_BIN=1;
252 connection server_1;
253 INSERT INTO t VALUES (1, '1', '1', '1' );
254 INSERT INTO t VALUES (4, '4', '4', '4' );
255 INSERT INTO t VALUES (7, '7', '7', '7' );
256 INSERT INTO t VALUES (9, '9', '9', NULL );
257 INSERT INTO t VALUES (2, '1', '2', '2' );
258 INSERT INTO t VALUES (3, '1', '3', '2' );
259 include/rpl_sync.inc
260 connection server_1;
261 UPDATE t SET c4 = '7';
262 UPDATE t SET c4 = '5' WHERE c1 = 1;
263 UPDATE t SET c2 = '5' WHERE c1 = 1;
264 UPDATE t SET c1 = '5' WHERE c1 = 1;
265 UPDATE t SET c4 = '8' WHERE c2 = '4';
266 UPDATE t SET c1 = '8' WHERE c2 = '4';
267 UPDATE t SET c2 = '8' WHERE c2 = '4';
268 UPDATE t SET c3 = '0' WHERE c4 = NULL;
269 UPDATE t SET c2 = '0' WHERE c4 = '0';
270 UPDATE t SET c2 = '2' WHERE c4 = '2';
271 include/rpl_sync.inc
272 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
273 connection server_1;
274 DELETE FROM t WHERE c1 = 7;
275 DELETE FROM t WHERE c1 = 8;
276 DELETE FROM t;
277 include/rpl_sync.inc
278 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
279 connection server_1;
280 DROP TABLE t;
281 include/rpl_sync.inc
282 connection server_1;
283 SET SQL_LOG_BIN=0;
284 connection server_2;
285 SET SQL_LOG_BIN=0;
286 connection server_3;
287 SET SQL_LOG_BIN=0;
288 ****** TEST: One Composite Primary Key
289 connection server_1;
290 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c2)) engine= MyISAM;;
291 connection server_2;
292 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c2)) engine= MyISAM;;
293 connection server_3;
294 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c2)) engine= MyISAM;;
295 connection server_1;
296 SET SQL_LOG_BIN=1;
297 connection server_2;
298 SET SQL_LOG_BIN=1;
299 connection server_3;
300 SET SQL_LOG_BIN=1;
301 connection server_1;
302 INSERT INTO t VALUES (1, '1', '1', '1' );
303 INSERT INTO t VALUES (4, '4', '4', '4' );
304 INSERT INTO t VALUES (7, '7', '7', '7' );
305 INSERT INTO t VALUES (9, '9', '9', NULL );
306 INSERT INTO t VALUES (2, '1', '2', '2' );
307 INSERT INTO t VALUES (3, '1', '3', '2' );
308 include/rpl_sync.inc
309 connection server_1;
310 UPDATE t SET c4 = '7';
311 UPDATE t SET c4 = '5' WHERE c1 = 1;
312 UPDATE t SET c2 = '5' WHERE c1 = 1;
313 UPDATE t SET c1 = '5' WHERE c1 = 1;
314 UPDATE t SET c4 = '8' WHERE c2 = '4';
315 UPDATE t SET c1 = '8' WHERE c2 = '4';
316 UPDATE t SET c2 = '8' WHERE c2 = '4';
317 UPDATE t SET c3 = '0' WHERE c4 = NULL;
318 UPDATE t SET c2 = '0' WHERE c4 = '0';
319 UPDATE t SET c2 = '2' WHERE c4 = '2';
320 include/rpl_sync.inc
321 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
322 connection server_1;
323 DELETE FROM t WHERE c1 = 7;
324 DELETE FROM t WHERE c1 = 8;
325 DELETE FROM t;
326 include/rpl_sync.inc
327 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
328 connection server_1;
329 DROP TABLE t;
330 include/rpl_sync.inc
331 connection server_1;
332 SET SQL_LOG_BIN=0;
333 connection server_2;
334 SET SQL_LOG_BIN=0;
335 connection server_3;
336 SET SQL_LOG_BIN=0;
337 ****** TEST: One Primary key
338 connection server_1;
339 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1)) engine= MyISAM;;
340 connection server_2;
341 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1)) engine= MyISAM;;
342 connection server_3;
343 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1)) engine= MyISAM;;
344 connection server_1;
345 SET SQL_LOG_BIN=1;
346 connection server_2;
347 SET SQL_LOG_BIN=1;
348 connection server_3;
349 SET SQL_LOG_BIN=1;
350 connection server_1;
351 INSERT INTO t VALUES (1, '1', '1', '1' );
352 INSERT INTO t VALUES (4, '4', '4', '4' );
353 INSERT INTO t VALUES (7, '7', '7', '7' );
354 INSERT INTO t VALUES (9, '9', '9', NULL );
355 INSERT INTO t VALUES (2, '1', '2', '2' );
356 INSERT INTO t VALUES (3, '1', '3', '2' );
357 include/rpl_sync.inc
358 connection server_1;
359 UPDATE t SET c4 = '7';
360 UPDATE t SET c4 = '5' WHERE c1 = 1;
361 UPDATE t SET c2 = '5' WHERE c1 = 1;
362 UPDATE t SET c1 = '5' WHERE c1 = 1;
363 UPDATE t SET c4 = '8' WHERE c2 = '4';
364 UPDATE t SET c1 = '8' WHERE c2 = '4';
365 UPDATE t SET c2 = '8' WHERE c2 = '4';
366 UPDATE t SET c3 = '0' WHERE c4 = NULL;
367 UPDATE t SET c2 = '0' WHERE c4 = '0';
368 UPDATE t SET c2 = '2' WHERE c4 = '2';
369 include/rpl_sync.inc
370 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
371 connection server_1;
372 DELETE FROM t WHERE c1 = 7;
373 DELETE FROM t WHERE c1 = 8;
374 DELETE FROM t;
375 include/rpl_sync.inc
376 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
377 connection server_1;
378 DROP TABLE t;
379 include/rpl_sync.inc
380 connection server_1;
381 SET SQL_LOG_BIN=0;
382 connection server_2;
383 SET SQL_LOG_BIN=0;
384 connection server_3;
385 SET SQL_LOG_BIN=0;
386 ****** TEST: One Composite Unique key
387 connection server_1;
388 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c2)) engine= MyISAM;;
389 connection server_2;
390 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c2)) engine= MyISAM;;
391 connection server_3;
392 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c2)) engine= MyISAM;;
393 connection server_1;
394 SET SQL_LOG_BIN=1;
395 connection server_2;
396 SET SQL_LOG_BIN=1;
397 connection server_3;
398 SET SQL_LOG_BIN=1;
399 connection server_1;
400 INSERT INTO t VALUES (1, '1', '1', '1' );
401 INSERT INTO t VALUES (4, '4', '4', '4' );
402 INSERT INTO t VALUES (7, '7', '7', '7' );
403 INSERT INTO t VALUES (9, '9', '9', NULL );
404 INSERT INTO t VALUES (2, '1', '2', '2' );
405 INSERT INTO t VALUES (3, '1', '3', '2' );
406 include/rpl_sync.inc
407 connection server_1;
408 UPDATE t SET c4 = '7';
409 UPDATE t SET c4 = '5' WHERE c1 = 1;
410 UPDATE t SET c2 = '5' WHERE c1 = 1;
411 UPDATE t SET c1 = '5' WHERE c1 = 1;
412 UPDATE t SET c4 = '8' WHERE c2 = '4';
413 UPDATE t SET c1 = '8' WHERE c2 = '4';
414 UPDATE t SET c2 = '8' WHERE c2 = '4';
415 UPDATE t SET c3 = '0' WHERE c4 = NULL;
416 UPDATE t SET c2 = '0' WHERE c4 = '0';
417 UPDATE t SET c2 = '2' WHERE c4 = '2';
418 include/rpl_sync.inc
419 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
420 connection server_1;
421 DELETE FROM t WHERE c1 = 7;
422 DELETE FROM t WHERE c1 = 8;
423 DELETE FROM t;
424 include/rpl_sync.inc
425 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
426 connection server_1;
427 DROP TABLE t;
428 include/rpl_sync.inc
429 connection server_1;
430 SET SQL_LOG_BIN=0;
431 connection server_2;
432 SET SQL_LOG_BIN=0;
433 connection server_3;
434 SET SQL_LOG_BIN=0;
435 ****** TEST: One Unique key
436 connection server_1;
437 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1)) engine= MyISAM;;
438 connection server_2;
439 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1)) engine= MyISAM;;
440 connection server_3;
441 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1)) engine= MyISAM;;
442 connection server_1;
443 SET SQL_LOG_BIN=1;
444 connection server_2;
445 SET SQL_LOG_BIN=1;
446 connection server_3;
447 SET SQL_LOG_BIN=1;
448 connection server_1;
449 INSERT INTO t VALUES (1, '1', '1', '1' );
450 INSERT INTO t VALUES (4, '4', '4', '4' );
451 INSERT INTO t VALUES (7, '7', '7', '7' );
452 INSERT INTO t VALUES (9, '9', '9', NULL );
453 INSERT INTO t VALUES (2, '1', '2', '2' );
454 INSERT INTO t VALUES (3, '1', '3', '2' );
455 include/rpl_sync.inc
456 connection server_1;
457 UPDATE t SET c4 = '7';
458 UPDATE t SET c4 = '5' WHERE c1 = 1;
459 UPDATE t SET c2 = '5' WHERE c1 = 1;
460 UPDATE t SET c1 = '5' WHERE c1 = 1;
461 UPDATE t SET c4 = '8' WHERE c2 = '4';
462 UPDATE t SET c1 = '8' WHERE c2 = '4';
463 UPDATE t SET c2 = '8' WHERE c2 = '4';
464 UPDATE t SET c3 = '0' WHERE c4 = NULL;
465 UPDATE t SET c2 = '0' WHERE c4 = '0';
466 UPDATE t SET c2 = '2' WHERE c4 = '2';
467 include/rpl_sync.inc
468 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
469 connection server_1;
470 DELETE FROM t WHERE c1 = 7;
471 DELETE FROM t WHERE c1 = 8;
472 DELETE FROM t;
473 include/rpl_sync.inc
474 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
475 connection server_1;
476 DROP TABLE t;
477 include/rpl_sync.inc
478 connection server_1;
479 SET SQL_LOG_BIN=0;
480 connection server_2;
481 SET SQL_LOG_BIN=0;
482 connection server_3;
483 SET SQL_LOG_BIN=0;
484 ****** TEST: One Composite key
485 connection server_1;
486 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c2)) engine= MyISAM;;
487 connection server_2;
488 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c2)) engine= MyISAM;;
489 connection server_3;
490 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c2)) engine= MyISAM;;
491 connection server_1;
492 SET SQL_LOG_BIN=1;
493 connection server_2;
494 SET SQL_LOG_BIN=1;
495 connection server_3;
496 SET SQL_LOG_BIN=1;
497 connection server_1;
498 INSERT INTO t VALUES (1, '1', '1', '1' );
499 INSERT INTO t VALUES (4, '4', '4', '4' );
500 INSERT INTO t VALUES (7, '7', '7', '7' );
501 INSERT INTO t VALUES (9, '9', '9', NULL );
502 INSERT INTO t VALUES (2, '1', '2', '2' );
503 INSERT INTO t VALUES (3, '1', '3', '2' );
504 include/rpl_sync.inc
505 connection server_1;
506 UPDATE t SET c4 = '7';
507 UPDATE t SET c4 = '5' WHERE c1 = 1;
508 UPDATE t SET c2 = '5' WHERE c1 = 1;
509 UPDATE t SET c1 = '5' WHERE c1 = 1;
510 UPDATE t SET c4 = '8' WHERE c2 = '4';
511 UPDATE t SET c1 = '8' WHERE c2 = '4';
512 UPDATE t SET c2 = '8' WHERE c2 = '4';
513 UPDATE t SET c3 = '0' WHERE c4 = NULL;
514 UPDATE t SET c2 = '0' WHERE c4 = '0';
515 UPDATE t SET c2 = '2' WHERE c4 = '2';
516 include/rpl_sync.inc
517 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
518 connection server_1;
519 DELETE FROM t WHERE c1 = 7;
520 DELETE FROM t WHERE c1 = 8;
521 DELETE FROM t;
522 include/rpl_sync.inc
523 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
524 connection server_1;
525 DROP TABLE t;
526 include/rpl_sync.inc
527 connection server_1;
528 SET SQL_LOG_BIN=0;
529 connection server_2;
530 SET SQL_LOG_BIN=0;
531 connection server_3;
532 SET SQL_LOG_BIN=0;
533 ******* TEST: One key
534 connection server_1;
535 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1)) engine= MyISAM;;
536 connection server_2;
537 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1)) engine= MyISAM;;
538 connection server_3;
539 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1)) engine= MyISAM;;
540 connection server_1;
541 SET SQL_LOG_BIN=1;
542 connection server_2;
543 SET SQL_LOG_BIN=1;
544 connection server_3;
545 SET SQL_LOG_BIN=1;
546 connection server_1;
547 INSERT INTO t VALUES (1, '1', '1', '1' );
548 INSERT INTO t VALUES (4, '4', '4', '4' );
549 INSERT INTO t VALUES (7, '7', '7', '7' );
550 INSERT INTO t VALUES (9, '9', '9', NULL );
551 INSERT INTO t VALUES (2, '1', '2', '2' );
552 INSERT INTO t VALUES (3, '1', '3', '2' );
553 include/rpl_sync.inc
554 connection server_1;
555 UPDATE t SET c4 = '7';
556 UPDATE t SET c4 = '5' WHERE c1 = 1;
557 UPDATE t SET c2 = '5' WHERE c1 = 1;
558 UPDATE t SET c1 = '5' WHERE c1 = 1;
559 UPDATE t SET c4 = '8' WHERE c2 = '4';
560 UPDATE t SET c1 = '8' WHERE c2 = '4';
561 UPDATE t SET c2 = '8' WHERE c2 = '4';
562 UPDATE t SET c3 = '0' WHERE c4 = NULL;
563 UPDATE t SET c2 = '0' WHERE c4 = '0';
564 UPDATE t SET c2 = '2' WHERE c4 = '2';
565 include/rpl_sync.inc
566 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
567 connection server_1;
568 DELETE FROM t WHERE c1 = 7;
569 DELETE FROM t WHERE c1 = 8;
570 DELETE FROM t;
571 include/rpl_sync.inc
572 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
573 connection server_1;
574 DROP TABLE t;
575 include/rpl_sync.inc
576 connection server_1;
577 SET SQL_LOG_BIN=0;
578 connection server_2;
579 SET SQL_LOG_BIN=0;
580 connection server_3;
581 SET SQL_LOG_BIN=0;
582 ******* TEST: No keys
583 connection server_1;
584 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1)) engine= MyISAM;;
585 connection server_2;
586 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1)) engine= MyISAM;;
587 connection server_3;
588 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1)) engine= MyISAM;;
589 connection server_1;
590 SET SQL_LOG_BIN=1;
591 connection server_2;
592 SET SQL_LOG_BIN=1;
593 connection server_3;
594 SET SQL_LOG_BIN=1;
595 connection server_1;
596 INSERT INTO t VALUES (1, '1', '1', '1' );
597 INSERT INTO t VALUES (4, '4', '4', '4' );
598 INSERT INTO t VALUES (7, '7', '7', '7' );
599 INSERT INTO t VALUES (9, '9', '9', NULL );
600 INSERT INTO t VALUES (2, '1', '2', '2' );
601 INSERT INTO t VALUES (3, '1', '3', '2' );
602 include/rpl_sync.inc
603 connection server_1;
604 UPDATE t SET c4 = '7';
605 UPDATE t SET c4 = '5' WHERE c1 = 1;
606 UPDATE t SET c2 = '5' WHERE c1 = 1;
607 UPDATE t SET c1 = '5' WHERE c1 = 1;
608 UPDATE t SET c4 = '8' WHERE c2 = '4';
609 UPDATE t SET c1 = '8' WHERE c2 = '4';
610 UPDATE t SET c2 = '8' WHERE c2 = '4';
611 UPDATE t SET c3 = '0' WHERE c4 = NULL;
612 UPDATE t SET c2 = '0' WHERE c4 = '0';
613 UPDATE t SET c2 = '2' WHERE c4 = '2';
614 include/rpl_sync.inc
615 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
616 connection server_1;
617 DELETE FROM t WHERE c1 = 7;
618 DELETE FROM t WHERE c1 = 8;
619 DELETE FROM t;
620 include/rpl_sync.inc
621 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
622 connection server_1;
623 DROP TABLE t;
624 include/rpl_sync.inc
625 ### engines: MyISAM, MyISAM, InnoDB
626 connection server_1;
627 connection server_1;
628 SET SQL_LOG_BIN=0;
629 connection server_2;
630 SET SQL_LOG_BIN=0;
631 connection server_3;
632 SET SQL_LOG_BIN=0;
633 ****** TEST: One Composite NOT NULL Unique key with holes in master, but NULLABLE on first slave
634 connection server_1;
635 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= MyISAM;;
636 connection server_2;
637 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= MyISAM;;
638 connection server_3;
639 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= InnoDB;;
640 connection server_1;
641 SET SQL_LOG_BIN=1;
642 connection server_2;
643 SET SQL_LOG_BIN=1;
644 connection server_3;
645 SET SQL_LOG_BIN=1;
646 connection server_1;
647 INSERT INTO t VALUES (1, '1', '1', '1' );
648 INSERT INTO t VALUES (4, '4', '4', '4' );
649 INSERT INTO t VALUES (7, '7', '7', '7' );
650 INSERT INTO t VALUES (9, '9', '9', NULL );
651 INSERT INTO t VALUES (2, '1', '2', '2' );
652 INSERT INTO t VALUES (3, '1', '3', '2' );
653 include/rpl_sync.inc
654 connection server_1;
655 UPDATE t SET c4 = '7';
656 UPDATE t SET c4 = '5' WHERE c1 = 1;
657 UPDATE t SET c2 = '5' WHERE c1 = 1;
658 UPDATE t SET c1 = '5' WHERE c1 = 1;
659 UPDATE t SET c4 = '8' WHERE c2 = '4';
660 UPDATE t SET c1 = '8' WHERE c2 = '4';
661 UPDATE t SET c2 = '8' WHERE c2 = '4';
662 UPDATE t SET c3 = '0' WHERE c4 = NULL;
663 UPDATE t SET c2 = '0' WHERE c4 = '0';
664 UPDATE t SET c2 = '2' WHERE c4 = '2';
665 include/rpl_sync.inc
666 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
667 connection server_1;
668 DELETE FROM t WHERE c1 = 7;
669 DELETE FROM t WHERE c1 = 8;
670 DELETE FROM t;
671 include/rpl_sync.inc
672 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
673 connection server_1;
674 DROP TABLE t;
675 include/rpl_sync.inc
676 connection server_1;
677 SET SQL_LOG_BIN=0;
678 connection server_2;
679 SET SQL_LOG_BIN=0;
680 connection server_3;
681 SET SQL_LOG_BIN=0;
682 ****** TEST: One Composite NOT NULL Unique key with holes
683 connection server_1;
684 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= MyISAM;;
685 connection server_2;
686 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= MyISAM;;
687 connection server_3;
688 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= InnoDB;;
689 connection server_1;
690 SET SQL_LOG_BIN=1;
691 connection server_2;
692 SET SQL_LOG_BIN=1;
693 connection server_3;
694 SET SQL_LOG_BIN=1;
695 connection server_1;
696 INSERT INTO t VALUES (1, '1', '1', '1' );
697 INSERT INTO t VALUES (4, '4', '4', '4' );
698 INSERT INTO t VALUES (7, '7', '7', '7' );
699 INSERT INTO t VALUES (9, '9', '9', NULL );
700 INSERT INTO t VALUES (2, '1', '2', '2' );
701 INSERT INTO t VALUES (3, '1', '3', '2' );
702 include/rpl_sync.inc
703 connection server_1;
704 UPDATE t SET c4 = '7';
705 UPDATE t SET c4 = '5' WHERE c1 = 1;
706 UPDATE t SET c2 = '5' WHERE c1 = 1;
707 UPDATE t SET c1 = '5' WHERE c1 = 1;
708 UPDATE t SET c4 = '8' WHERE c2 = '4';
709 UPDATE t SET c1 = '8' WHERE c2 = '4';
710 UPDATE t SET c2 = '8' WHERE c2 = '4';
711 UPDATE t SET c3 = '0' WHERE c4 = NULL;
712 UPDATE t SET c2 = '0' WHERE c4 = '0';
713 UPDATE t SET c2 = '2' WHERE c4 = '2';
714 include/rpl_sync.inc
715 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
716 connection server_1;
717 DELETE FROM t WHERE c1 = 7;
718 DELETE FROM t WHERE c1 = 8;
719 DELETE FROM t;
720 include/rpl_sync.inc
721 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
722 connection server_1;
723 DROP TABLE t;
724 include/rpl_sync.inc
725 connection server_1;
726 SET SQL_LOG_BIN=0;
727 connection server_2;
728 SET SQL_LOG_BIN=0;
729 connection server_3;
730 SET SQL_LOG_BIN=0;
731 ****** TEST: One Composite Primary Key with holes
732 connection server_1;
733 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c3)) engine= MyISAM;;
734 connection server_2;
735 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c3)) engine= MyISAM;;
736 connection server_3;
737 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c3)) engine= InnoDB;;
738 connection server_1;
739 SET SQL_LOG_BIN=1;
740 connection server_2;
741 SET SQL_LOG_BIN=1;
742 connection server_3;
743 SET SQL_LOG_BIN=1;
744 connection server_1;
745 INSERT INTO t VALUES (1, '1', '1', '1' );
746 INSERT INTO t VALUES (4, '4', '4', '4' );
747 INSERT INTO t VALUES (7, '7', '7', '7' );
748 INSERT INTO t VALUES (9, '9', '9', NULL );
749 INSERT INTO t VALUES (2, '1', '2', '2' );
750 INSERT INTO t VALUES (3, '1', '3', '2' );
751 include/rpl_sync.inc
752 connection server_1;
753 UPDATE t SET c4 = '7';
754 UPDATE t SET c4 = '5' WHERE c1 = 1;
755 UPDATE t SET c2 = '5' WHERE c1 = 1;
756 UPDATE t SET c1 = '5' WHERE c1 = 1;
757 UPDATE t SET c4 = '8' WHERE c2 = '4';
758 UPDATE t SET c1 = '8' WHERE c2 = '4';
759 UPDATE t SET c2 = '8' WHERE c2 = '4';
760 UPDATE t SET c3 = '0' WHERE c4 = NULL;
761 UPDATE t SET c2 = '0' WHERE c4 = '0';
762 UPDATE t SET c2 = '2' WHERE c4 = '2';
763 include/rpl_sync.inc
764 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
765 connection server_1;
766 DELETE FROM t WHERE c1 = 7;
767 DELETE FROM t WHERE c1 = 8;
768 DELETE FROM t;
769 include/rpl_sync.inc
770 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
771 connection server_1;
772 DROP TABLE t;
773 include/rpl_sync.inc
774 connection server_1;
775 SET SQL_LOG_BIN=0;
776 connection server_2;
777 SET SQL_LOG_BIN=0;
778 connection server_3;
779 SET SQL_LOG_BIN=0;
780 ****** TEST: One Composite Unique key with holes
781 connection server_1;
782 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= MyISAM;;
783 connection server_2;
784 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= MyISAM;;
785 connection server_3;
786 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= InnoDB;;
787 connection server_1;
788 SET SQL_LOG_BIN=1;
789 connection server_2;
790 SET SQL_LOG_BIN=1;
791 connection server_3;
792 SET SQL_LOG_BIN=1;
793 connection server_1;
794 INSERT INTO t VALUES (1, '1', '1', '1' );
795 INSERT INTO t VALUES (4, '4', '4', '4' );
796 INSERT INTO t VALUES (7, '7', '7', '7' );
797 INSERT INTO t VALUES (9, '9', '9', NULL );
798 INSERT INTO t VALUES (2, '1', '2', '2' );
799 INSERT INTO t VALUES (3, '1', '3', '2' );
800 include/rpl_sync.inc
801 connection server_1;
802 UPDATE t SET c4 = '7';
803 UPDATE t SET c4 = '5' WHERE c1 = 1;
804 UPDATE t SET c2 = '5' WHERE c1 = 1;
805 UPDATE t SET c1 = '5' WHERE c1 = 1;
806 UPDATE t SET c4 = '8' WHERE c2 = '4';
807 UPDATE t SET c1 = '8' WHERE c2 = '4';
808 UPDATE t SET c2 = '8' WHERE c2 = '4';
809 UPDATE t SET c3 = '0' WHERE c4 = NULL;
810 UPDATE t SET c2 = '0' WHERE c4 = '0';
811 UPDATE t SET c2 = '2' WHERE c4 = '2';
812 include/rpl_sync.inc
813 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
814 connection server_1;
815 DELETE FROM t WHERE c1 = 7;
816 DELETE FROM t WHERE c1 = 8;
817 DELETE FROM t;
818 include/rpl_sync.inc
819 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
820 connection server_1;
821 DROP TABLE t;
822 include/rpl_sync.inc
823 connection server_1;
824 SET SQL_LOG_BIN=0;
825 connection server_2;
826 SET SQL_LOG_BIN=0;
827 connection server_3;
828 SET SQL_LOG_BIN=0;
829 ****** TEST: One Composite key with holes
830 connection server_1;
831 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c3)) engine= MyISAM;;
832 connection server_2;
833 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c3)) engine= MyISAM;;
834 connection server_3;
835 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c3)) engine= InnoDB;;
836 connection server_1;
837 SET SQL_LOG_BIN=1;
838 connection server_2;
839 SET SQL_LOG_BIN=1;
840 connection server_3;
841 SET SQL_LOG_BIN=1;
842 connection server_1;
843 INSERT INTO t VALUES (1, '1', '1', '1' );
844 INSERT INTO t VALUES (4, '4', '4', '4' );
845 INSERT INTO t VALUES (7, '7', '7', '7' );
846 INSERT INTO t VALUES (9, '9', '9', NULL );
847 INSERT INTO t VALUES (2, '1', '2', '2' );
848 INSERT INTO t VALUES (3, '1', '3', '2' );
849 include/rpl_sync.inc
850 connection server_1;
851 UPDATE t SET c4 = '7';
852 UPDATE t SET c4 = '5' WHERE c1 = 1;
853 UPDATE t SET c2 = '5' WHERE c1 = 1;
854 UPDATE t SET c1 = '5' WHERE c1 = 1;
855 UPDATE t SET c4 = '8' WHERE c2 = '4';
856 UPDATE t SET c1 = '8' WHERE c2 = '4';
857 UPDATE t SET c2 = '8' WHERE c2 = '4';
858 UPDATE t SET c3 = '0' WHERE c4 = NULL;
859 UPDATE t SET c2 = '0' WHERE c4 = '0';
860 UPDATE t SET c2 = '2' WHERE c4 = '2';
861 include/rpl_sync.inc
862 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
863 connection server_1;
864 DELETE FROM t WHERE c1 = 7;
865 DELETE FROM t WHERE c1 = 8;
866 DELETE FROM t;
867 include/rpl_sync.inc
868 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
869 connection server_1;
870 DROP TABLE t;
871 include/rpl_sync.inc
872 connection server_1;
873 SET SQL_LOG_BIN=0;
874 connection server_2;
875 SET SQL_LOG_BIN=0;
876 connection server_3;
877 SET SQL_LOG_BIN=0;
878 ****** TEST: One Composite Primary Key
879 connection server_1;
880 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c2)) engine= MyISAM;;
881 connection server_2;
882 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c2)) engine= MyISAM;;
883 connection server_3;
884 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c2)) engine= InnoDB;;
885 connection server_1;
886 SET SQL_LOG_BIN=1;
887 connection server_2;
888 SET SQL_LOG_BIN=1;
889 connection server_3;
890 SET SQL_LOG_BIN=1;
891 connection server_1;
892 INSERT INTO t VALUES (1, '1', '1', '1' );
893 INSERT INTO t VALUES (4, '4', '4', '4' );
894 INSERT INTO t VALUES (7, '7', '7', '7' );
895 INSERT INTO t VALUES (9, '9', '9', NULL );
896 INSERT INTO t VALUES (2, '1', '2', '2' );
897 INSERT INTO t VALUES (3, '1', '3', '2' );
898 include/rpl_sync.inc
899 connection server_1;
900 UPDATE t SET c4 = '7';
901 UPDATE t SET c4 = '5' WHERE c1 = 1;
902 UPDATE t SET c2 = '5' WHERE c1 = 1;
903 UPDATE t SET c1 = '5' WHERE c1 = 1;
904 UPDATE t SET c4 = '8' WHERE c2 = '4';
905 UPDATE t SET c1 = '8' WHERE c2 = '4';
906 UPDATE t SET c2 = '8' WHERE c2 = '4';
907 UPDATE t SET c3 = '0' WHERE c4 = NULL;
908 UPDATE t SET c2 = '0' WHERE c4 = '0';
909 UPDATE t SET c2 = '2' WHERE c4 = '2';
910 include/rpl_sync.inc
911 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
912 connection server_1;
913 DELETE FROM t WHERE c1 = 7;
914 DELETE FROM t WHERE c1 = 8;
915 DELETE FROM t;
916 include/rpl_sync.inc
917 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
918 connection server_1;
919 DROP TABLE t;
920 include/rpl_sync.inc
921 connection server_1;
922 SET SQL_LOG_BIN=0;
923 connection server_2;
924 SET SQL_LOG_BIN=0;
925 connection server_3;
926 SET SQL_LOG_BIN=0;
927 ****** TEST: One Primary key
928 connection server_1;
929 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1)) engine= MyISAM;;
930 connection server_2;
931 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1)) engine= MyISAM;;
932 connection server_3;
933 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1)) engine= InnoDB;;
934 connection server_1;
935 SET SQL_LOG_BIN=1;
936 connection server_2;
937 SET SQL_LOG_BIN=1;
938 connection server_3;
939 SET SQL_LOG_BIN=1;
940 connection server_1;
941 INSERT INTO t VALUES (1, '1', '1', '1' );
942 INSERT INTO t VALUES (4, '4', '4', '4' );
943 INSERT INTO t VALUES (7, '7', '7', '7' );
944 INSERT INTO t VALUES (9, '9', '9', NULL );
945 INSERT INTO t VALUES (2, '1', '2', '2' );
946 INSERT INTO t VALUES (3, '1', '3', '2' );
947 include/rpl_sync.inc
948 connection server_1;
949 UPDATE t SET c4 = '7';
950 UPDATE t SET c4 = '5' WHERE c1 = 1;
951 UPDATE t SET c2 = '5' WHERE c1 = 1;
952 UPDATE t SET c1 = '5' WHERE c1 = 1;
953 UPDATE t SET c4 = '8' WHERE c2 = '4';
954 UPDATE t SET c1 = '8' WHERE c2 = '4';
955 UPDATE t SET c2 = '8' WHERE c2 = '4';
956 UPDATE t SET c3 = '0' WHERE c4 = NULL;
957 UPDATE t SET c2 = '0' WHERE c4 = '0';
958 UPDATE t SET c2 = '2' WHERE c4 = '2';
959 include/rpl_sync.inc
960 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
961 connection server_1;
962 DELETE FROM t WHERE c1 = 7;
963 DELETE FROM t WHERE c1 = 8;
964 DELETE FROM t;
965 include/rpl_sync.inc
966 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
967 connection server_1;
968 DROP TABLE t;
969 include/rpl_sync.inc
970 connection server_1;
971 SET SQL_LOG_BIN=0;
972 connection server_2;
973 SET SQL_LOG_BIN=0;
974 connection server_3;
975 SET SQL_LOG_BIN=0;
976 ****** TEST: One Composite Unique key
977 connection server_1;
978 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c2)) engine= MyISAM;;
979 connection server_2;
980 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c2)) engine= MyISAM;;
981 connection server_3;
982 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c2)) engine= InnoDB;;
983 connection server_1;
984 SET SQL_LOG_BIN=1;
985 connection server_2;
986 SET SQL_LOG_BIN=1;
987 connection server_3;
988 SET SQL_LOG_BIN=1;
989 connection server_1;
990 INSERT INTO t VALUES (1, '1', '1', '1' );
991 INSERT INTO t VALUES (4, '4', '4', '4' );
992 INSERT INTO t VALUES (7, '7', '7', '7' );
993 INSERT INTO t VALUES (9, '9', '9', NULL );
994 INSERT INTO t VALUES (2, '1', '2', '2' );
995 INSERT INTO t VALUES (3, '1', '3', '2' );
996 include/rpl_sync.inc
997 connection server_1;
998 UPDATE t SET c4 = '7';
999 UPDATE t SET c4 = '5' WHERE c1 = 1;
1000 UPDATE t SET c2 = '5' WHERE c1 = 1;
1001 UPDATE t SET c1 = '5' WHERE c1 = 1;
1002 UPDATE t SET c4 = '8' WHERE c2 = '4';
1003 UPDATE t SET c1 = '8' WHERE c2 = '4';
1004 UPDATE t SET c2 = '8' WHERE c2 = '4';
1005 UPDATE t SET c3 = '0' WHERE c4 = NULL;
1006 UPDATE t SET c2 = '0' WHERE c4 = '0';
1007 UPDATE t SET c2 = '2' WHERE c4 = '2';
1008 include/rpl_sync.inc
1009 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1010 connection server_1;
1011 DELETE FROM t WHERE c1 = 7;
1012 DELETE FROM t WHERE c1 = 8;
1013 DELETE FROM t;
1014 include/rpl_sync.inc
1015 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1016 connection server_1;
1017 DROP TABLE t;
1018 include/rpl_sync.inc
1019 connection server_1;
1020 SET SQL_LOG_BIN=0;
1021 connection server_2;
1022 SET SQL_LOG_BIN=0;
1023 connection server_3;
1024 SET SQL_LOG_BIN=0;
1025 ****** TEST: One Unique key
1026 connection server_1;
1027 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1)) engine= MyISAM;;
1028 connection server_2;
1029 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1)) engine= MyISAM;;
1030 connection server_3;
1031 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1)) engine= InnoDB;;
1032 connection server_1;
1033 SET SQL_LOG_BIN=1;
1034 connection server_2;
1035 SET SQL_LOG_BIN=1;
1036 connection server_3;
1037 SET SQL_LOG_BIN=1;
1038 connection server_1;
1039 INSERT INTO t VALUES (1, '1', '1', '1' );
1040 INSERT INTO t VALUES (4, '4', '4', '4' );
1041 INSERT INTO t VALUES (7, '7', '7', '7' );
1042 INSERT INTO t VALUES (9, '9', '9', NULL );
1043 INSERT INTO t VALUES (2, '1', '2', '2' );
1044 INSERT INTO t VALUES (3, '1', '3', '2' );
1045 include/rpl_sync.inc
1046 connection server_1;
1047 UPDATE t SET c4 = '7';
1048 UPDATE t SET c4 = '5' WHERE c1 = 1;
1049 UPDATE t SET c2 = '5' WHERE c1 = 1;
1050 UPDATE t SET c1 = '5' WHERE c1 = 1;
1051 UPDATE t SET c4 = '8' WHERE c2 = '4';
1052 UPDATE t SET c1 = '8' WHERE c2 = '4';
1053 UPDATE t SET c2 = '8' WHERE c2 = '4';
1054 UPDATE t SET c3 = '0' WHERE c4 = NULL;
1055 UPDATE t SET c2 = '0' WHERE c4 = '0';
1056 UPDATE t SET c2 = '2' WHERE c4 = '2';
1057 include/rpl_sync.inc
1058 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1059 connection server_1;
1060 DELETE FROM t WHERE c1 = 7;
1061 DELETE FROM t WHERE c1 = 8;
1062 DELETE FROM t;
1063 include/rpl_sync.inc
1064 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1065 connection server_1;
1066 DROP TABLE t;
1067 include/rpl_sync.inc
1068 connection server_1;
1069 SET SQL_LOG_BIN=0;
1070 connection server_2;
1071 SET SQL_LOG_BIN=0;
1072 connection server_3;
1073 SET SQL_LOG_BIN=0;
1074 ****** TEST: One Composite key
1075 connection server_1;
1076 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c2)) engine= MyISAM;;
1077 connection server_2;
1078 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c2)) engine= MyISAM;;
1079 connection server_3;
1080 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c2)) engine= InnoDB;;
1081 connection server_1;
1082 SET SQL_LOG_BIN=1;
1083 connection server_2;
1084 SET SQL_LOG_BIN=1;
1085 connection server_3;
1086 SET SQL_LOG_BIN=1;
1087 connection server_1;
1088 INSERT INTO t VALUES (1, '1', '1', '1' );
1089 INSERT INTO t VALUES (4, '4', '4', '4' );
1090 INSERT INTO t VALUES (7, '7', '7', '7' );
1091 INSERT INTO t VALUES (9, '9', '9', NULL );
1092 INSERT INTO t VALUES (2, '1', '2', '2' );
1093 INSERT INTO t VALUES (3, '1', '3', '2' );
1094 include/rpl_sync.inc
1095 connection server_1;
1096 UPDATE t SET c4 = '7';
1097 UPDATE t SET c4 = '5' WHERE c1 = 1;
1098 UPDATE t SET c2 = '5' WHERE c1 = 1;
1099 UPDATE t SET c1 = '5' WHERE c1 = 1;
1100 UPDATE t SET c4 = '8' WHERE c2 = '4';
1101 UPDATE t SET c1 = '8' WHERE c2 = '4';
1102 UPDATE t SET c2 = '8' WHERE c2 = '4';
1103 UPDATE t SET c3 = '0' WHERE c4 = NULL;
1104 UPDATE t SET c2 = '0' WHERE c4 = '0';
1105 UPDATE t SET c2 = '2' WHERE c4 = '2';
1106 include/rpl_sync.inc
1107 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1108 connection server_1;
1109 DELETE FROM t WHERE c1 = 7;
1110 DELETE FROM t WHERE c1 = 8;
1111 DELETE FROM t;
1112 include/rpl_sync.inc
1113 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1114 connection server_1;
1115 DROP TABLE t;
1116 include/rpl_sync.inc
1117 connection server_1;
1118 SET SQL_LOG_BIN=0;
1119 connection server_2;
1120 SET SQL_LOG_BIN=0;
1121 connection server_3;
1122 SET SQL_LOG_BIN=0;
1123 ******* TEST: One key
1124 connection server_1;
1125 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1)) engine= MyISAM;;
1126 connection server_2;
1127 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1)) engine= MyISAM;;
1128 connection server_3;
1129 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1)) engine= InnoDB;;
1130 connection server_1;
1131 SET SQL_LOG_BIN=1;
1132 connection server_2;
1133 SET SQL_LOG_BIN=1;
1134 connection server_3;
1135 SET SQL_LOG_BIN=1;
1136 connection server_1;
1137 INSERT INTO t VALUES (1, '1', '1', '1' );
1138 INSERT INTO t VALUES (4, '4', '4', '4' );
1139 INSERT INTO t VALUES (7, '7', '7', '7' );
1140 INSERT INTO t VALUES (9, '9', '9', NULL );
1141 INSERT INTO t VALUES (2, '1', '2', '2' );
1142 INSERT INTO t VALUES (3, '1', '3', '2' );
1143 include/rpl_sync.inc
1144 connection server_1;
1145 UPDATE t SET c4 = '7';
1146 UPDATE t SET c4 = '5' WHERE c1 = 1;
1147 UPDATE t SET c2 = '5' WHERE c1 = 1;
1148 UPDATE t SET c1 = '5' WHERE c1 = 1;
1149 UPDATE t SET c4 = '8' WHERE c2 = '4';
1150 UPDATE t SET c1 = '8' WHERE c2 = '4';
1151 UPDATE t SET c2 = '8' WHERE c2 = '4';
1152 UPDATE t SET c3 = '0' WHERE c4 = NULL;
1153 UPDATE t SET c2 = '0' WHERE c4 = '0';
1154 UPDATE t SET c2 = '2' WHERE c4 = '2';
1155 include/rpl_sync.inc
1156 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1157 connection server_1;
1158 DELETE FROM t WHERE c1 = 7;
1159 DELETE FROM t WHERE c1 = 8;
1160 DELETE FROM t;
1161 include/rpl_sync.inc
1162 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1163 connection server_1;
1164 DROP TABLE t;
1165 include/rpl_sync.inc
1166 connection server_1;
1167 SET SQL_LOG_BIN=0;
1168 connection server_2;
1169 SET SQL_LOG_BIN=0;
1170 connection server_3;
1171 SET SQL_LOG_BIN=0;
1172 ******* TEST: No keys
1173 connection server_1;
1174 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1)) engine= MyISAM;;
1175 connection server_2;
1176 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1)) engine= MyISAM;;
1177 connection server_3;
1178 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1)) engine= InnoDB;;
1179 connection server_1;
1180 SET SQL_LOG_BIN=1;
1181 connection server_2;
1182 SET SQL_LOG_BIN=1;
1183 connection server_3;
1184 SET SQL_LOG_BIN=1;
1185 connection server_1;
1186 INSERT INTO t VALUES (1, '1', '1', '1' );
1187 INSERT INTO t VALUES (4, '4', '4', '4' );
1188 INSERT INTO t VALUES (7, '7', '7', '7' );
1189 INSERT INTO t VALUES (9, '9', '9', NULL );
1190 INSERT INTO t VALUES (2, '1', '2', '2' );
1191 INSERT INTO t VALUES (3, '1', '3', '2' );
1192 include/rpl_sync.inc
1193 connection server_1;
1194 UPDATE t SET c4 = '7';
1195 UPDATE t SET c4 = '5' WHERE c1 = 1;
1196 UPDATE t SET c2 = '5' WHERE c1 = 1;
1197 UPDATE t SET c1 = '5' WHERE c1 = 1;
1198 UPDATE t SET c4 = '8' WHERE c2 = '4';
1199 UPDATE t SET c1 = '8' WHERE c2 = '4';
1200 UPDATE t SET c2 = '8' WHERE c2 = '4';
1201 UPDATE t SET c3 = '0' WHERE c4 = NULL;
1202 UPDATE t SET c2 = '0' WHERE c4 = '0';
1203 UPDATE t SET c2 = '2' WHERE c4 = '2';
1204 include/rpl_sync.inc
1205 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1206 connection server_1;
1207 DELETE FROM t WHERE c1 = 7;
1208 DELETE FROM t WHERE c1 = 8;
1209 DELETE FROM t;
1210 include/rpl_sync.inc
1211 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1212 connection server_1;
1213 DROP TABLE t;
1214 include/rpl_sync.inc
1215 ### engines: MyISAM, InnoDB, MyISAM
1216 connection server_1;
1217 connection server_1;
1218 SET SQL_LOG_BIN=0;
1219 connection server_2;
1220 SET SQL_LOG_BIN=0;
1221 connection server_3;
1222 SET SQL_LOG_BIN=0;
1223 ****** TEST: One Composite NOT NULL Unique key with holes in master, but NULLABLE on first slave
1224 connection server_1;
1225 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= MyISAM;;
1226 connection server_2;
1227 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= InnoDB;;
1228 connection server_3;
1229 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= MyISAM;;
1230 connection server_1;
1231 SET SQL_LOG_BIN=1;
1232 connection server_2;
1233 SET SQL_LOG_BIN=1;
1234 connection server_3;
1235 SET SQL_LOG_BIN=1;
1236 connection server_1;
1237 INSERT INTO t VALUES (1, '1', '1', '1' );
1238 INSERT INTO t VALUES (4, '4', '4', '4' );
1239 INSERT INTO t VALUES (7, '7', '7', '7' );
1240 INSERT INTO t VALUES (9, '9', '9', NULL );
1241 INSERT INTO t VALUES (2, '1', '2', '2' );
1242 INSERT INTO t VALUES (3, '1', '3', '2' );
1243 include/rpl_sync.inc
1244 connection server_1;
1245 UPDATE t SET c4 = '7';
1246 UPDATE t SET c4 = '5' WHERE c1 = 1;
1247 UPDATE t SET c2 = '5' WHERE c1 = 1;
1248 UPDATE t SET c1 = '5' WHERE c1 = 1;
1249 UPDATE t SET c4 = '8' WHERE c2 = '4';
1250 UPDATE t SET c1 = '8' WHERE c2 = '4';
1251 UPDATE t SET c2 = '8' WHERE c2 = '4';
1252 UPDATE t SET c3 = '0' WHERE c4 = NULL;
1253 UPDATE t SET c2 = '0' WHERE c4 = '0';
1254 UPDATE t SET c2 = '2' WHERE c4 = '2';
1255 include/rpl_sync.inc
1256 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1257 connection server_1;
1258 DELETE FROM t WHERE c1 = 7;
1259 DELETE FROM t WHERE c1 = 8;
1260 DELETE FROM t;
1261 include/rpl_sync.inc
1262 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1263 connection server_1;
1264 DROP TABLE t;
1265 include/rpl_sync.inc
1266 connection server_1;
1267 SET SQL_LOG_BIN=0;
1268 connection server_2;
1269 SET SQL_LOG_BIN=0;
1270 connection server_3;
1271 SET SQL_LOG_BIN=0;
1272 ****** TEST: One Composite NOT NULL Unique key with holes
1273 connection server_1;
1274 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= MyISAM;;
1275 connection server_2;
1276 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= InnoDB;;
1277 connection server_3;
1278 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= MyISAM;;
1279 connection server_1;
1280 SET SQL_LOG_BIN=1;
1281 connection server_2;
1282 SET SQL_LOG_BIN=1;
1283 connection server_3;
1284 SET SQL_LOG_BIN=1;
1285 connection server_1;
1286 INSERT INTO t VALUES (1, '1', '1', '1' );
1287 INSERT INTO t VALUES (4, '4', '4', '4' );
1288 INSERT INTO t VALUES (7, '7', '7', '7' );
1289 INSERT INTO t VALUES (9, '9', '9', NULL );
1290 INSERT INTO t VALUES (2, '1', '2', '2' );
1291 INSERT INTO t VALUES (3, '1', '3', '2' );
1292 include/rpl_sync.inc
1293 connection server_1;
1294 UPDATE t SET c4 = '7';
1295 UPDATE t SET c4 = '5' WHERE c1 = 1;
1296 UPDATE t SET c2 = '5' WHERE c1 = 1;
1297 UPDATE t SET c1 = '5' WHERE c1 = 1;
1298 UPDATE t SET c4 = '8' WHERE c2 = '4';
1299 UPDATE t SET c1 = '8' WHERE c2 = '4';
1300 UPDATE t SET c2 = '8' WHERE c2 = '4';
1301 UPDATE t SET c3 = '0' WHERE c4 = NULL;
1302 UPDATE t SET c2 = '0' WHERE c4 = '0';
1303 UPDATE t SET c2 = '2' WHERE c4 = '2';
1304 include/rpl_sync.inc
1305 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1306 connection server_1;
1307 DELETE FROM t WHERE c1 = 7;
1308 DELETE FROM t WHERE c1 = 8;
1309 DELETE FROM t;
1310 include/rpl_sync.inc
1311 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1312 connection server_1;
1313 DROP TABLE t;
1314 include/rpl_sync.inc
1315 connection server_1;
1316 SET SQL_LOG_BIN=0;
1317 connection server_2;
1318 SET SQL_LOG_BIN=0;
1319 connection server_3;
1320 SET SQL_LOG_BIN=0;
1321 ****** TEST: One Composite Primary Key with holes
1322 connection server_1;
1323 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c3)) engine= MyISAM;;
1324 connection server_2;
1325 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c3)) engine= InnoDB;;
1326 connection server_3;
1327 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c3)) engine= MyISAM;;
1328 connection server_1;
1329 SET SQL_LOG_BIN=1;
1330 connection server_2;
1331 SET SQL_LOG_BIN=1;
1332 connection server_3;
1333 SET SQL_LOG_BIN=1;
1334 connection server_1;
1335 INSERT INTO t VALUES (1, '1', '1', '1' );
1336 INSERT INTO t VALUES (4, '4', '4', '4' );
1337 INSERT INTO t VALUES (7, '7', '7', '7' );
1338 INSERT INTO t VALUES (9, '9', '9', NULL );
1339 INSERT INTO t VALUES (2, '1', '2', '2' );
1340 INSERT INTO t VALUES (3, '1', '3', '2' );
1341 include/rpl_sync.inc
1342 connection server_1;
1343 UPDATE t SET c4 = '7';
1344 UPDATE t SET c4 = '5' WHERE c1 = 1;
1345 UPDATE t SET c2 = '5' WHERE c1 = 1;
1346 UPDATE t SET c1 = '5' WHERE c1 = 1;
1347 UPDATE t SET c4 = '8' WHERE c2 = '4';
1348 UPDATE t SET c1 = '8' WHERE c2 = '4';
1349 UPDATE t SET c2 = '8' WHERE c2 = '4';
1350 UPDATE t SET c3 = '0' WHERE c4 = NULL;
1351 UPDATE t SET c2 = '0' WHERE c4 = '0';
1352 UPDATE t SET c2 = '2' WHERE c4 = '2';
1353 include/rpl_sync.inc
1354 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1355 connection server_1;
1356 DELETE FROM t WHERE c1 = 7;
1357 DELETE FROM t WHERE c1 = 8;
1358 DELETE FROM t;
1359 include/rpl_sync.inc
1360 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1361 connection server_1;
1362 DROP TABLE t;
1363 include/rpl_sync.inc
1364 connection server_1;
1365 SET SQL_LOG_BIN=0;
1366 connection server_2;
1367 SET SQL_LOG_BIN=0;
1368 connection server_3;
1369 SET SQL_LOG_BIN=0;
1370 ****** TEST: One Composite Unique key with holes
1371 connection server_1;
1372 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= MyISAM;;
1373 connection server_2;
1374 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= InnoDB;;
1375 connection server_3;
1376 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= MyISAM;;
1377 connection server_1;
1378 SET SQL_LOG_BIN=1;
1379 connection server_2;
1380 SET SQL_LOG_BIN=1;
1381 connection server_3;
1382 SET SQL_LOG_BIN=1;
1383 connection server_1;
1384 INSERT INTO t VALUES (1, '1', '1', '1' );
1385 INSERT INTO t VALUES (4, '4', '4', '4' );
1386 INSERT INTO t VALUES (7, '7', '7', '7' );
1387 INSERT INTO t VALUES (9, '9', '9', NULL );
1388 INSERT INTO t VALUES (2, '1', '2', '2' );
1389 INSERT INTO t VALUES (3, '1', '3', '2' );
1390 include/rpl_sync.inc
1391 connection server_1;
1392 UPDATE t SET c4 = '7';
1393 UPDATE t SET c4 = '5' WHERE c1 = 1;
1394 UPDATE t SET c2 = '5' WHERE c1 = 1;
1395 UPDATE t SET c1 = '5' WHERE c1 = 1;
1396 UPDATE t SET c4 = '8' WHERE c2 = '4';
1397 UPDATE t SET c1 = '8' WHERE c2 = '4';
1398 UPDATE t SET c2 = '8' WHERE c2 = '4';
1399 UPDATE t SET c3 = '0' WHERE c4 = NULL;
1400 UPDATE t SET c2 = '0' WHERE c4 = '0';
1401 UPDATE t SET c2 = '2' WHERE c4 = '2';
1402 include/rpl_sync.inc
1403 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1404 connection server_1;
1405 DELETE FROM t WHERE c1 = 7;
1406 DELETE FROM t WHERE c1 = 8;
1407 DELETE FROM t;
1408 include/rpl_sync.inc
1409 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1410 connection server_1;
1411 DROP TABLE t;
1412 include/rpl_sync.inc
1413 connection server_1;
1414 SET SQL_LOG_BIN=0;
1415 connection server_2;
1416 SET SQL_LOG_BIN=0;
1417 connection server_3;
1418 SET SQL_LOG_BIN=0;
1419 ****** TEST: One Composite key with holes
1420 connection server_1;
1421 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c3)) engine= MyISAM;;
1422 connection server_2;
1423 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c3)) engine= InnoDB;;
1424 connection server_3;
1425 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c3)) engine= MyISAM;;
1426 connection server_1;
1427 SET SQL_LOG_BIN=1;
1428 connection server_2;
1429 SET SQL_LOG_BIN=1;
1430 connection server_3;
1431 SET SQL_LOG_BIN=1;
1432 connection server_1;
1433 INSERT INTO t VALUES (1, '1', '1', '1' );
1434 INSERT INTO t VALUES (4, '4', '4', '4' );
1435 INSERT INTO t VALUES (7, '7', '7', '7' );
1436 INSERT INTO t VALUES (9, '9', '9', NULL );
1437 INSERT INTO t VALUES (2, '1', '2', '2' );
1438 INSERT INTO t VALUES (3, '1', '3', '2' );
1439 include/rpl_sync.inc
1440 connection server_1;
1441 UPDATE t SET c4 = '7';
1442 UPDATE t SET c4 = '5' WHERE c1 = 1;
1443 UPDATE t SET c2 = '5' WHERE c1 = 1;
1444 UPDATE t SET c1 = '5' WHERE c1 = 1;
1445 UPDATE t SET c4 = '8' WHERE c2 = '4';
1446 UPDATE t SET c1 = '8' WHERE c2 = '4';
1447 UPDATE t SET c2 = '8' WHERE c2 = '4';
1448 UPDATE t SET c3 = '0' WHERE c4 = NULL;
1449 UPDATE t SET c2 = '0' WHERE c4 = '0';
1450 UPDATE t SET c2 = '2' WHERE c4 = '2';
1451 include/rpl_sync.inc
1452 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1453 connection server_1;
1454 DELETE FROM t WHERE c1 = 7;
1455 DELETE FROM t WHERE c1 = 8;
1456 DELETE FROM t;
1457 include/rpl_sync.inc
1458 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1459 connection server_1;
1460 DROP TABLE t;
1461 include/rpl_sync.inc
1462 connection server_1;
1463 SET SQL_LOG_BIN=0;
1464 connection server_2;
1465 SET SQL_LOG_BIN=0;
1466 connection server_3;
1467 SET SQL_LOG_BIN=0;
1468 ****** TEST: One Composite Primary Key
1469 connection server_1;
1470 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c2)) engine= MyISAM;;
1471 connection server_2;
1472 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c2)) engine= InnoDB;;
1473 connection server_3;
1474 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c2)) engine= MyISAM;;
1475 connection server_1;
1476 SET SQL_LOG_BIN=1;
1477 connection server_2;
1478 SET SQL_LOG_BIN=1;
1479 connection server_3;
1480 SET SQL_LOG_BIN=1;
1481 connection server_1;
1482 INSERT INTO t VALUES (1, '1', '1', '1' );
1483 INSERT INTO t VALUES (4, '4', '4', '4' );
1484 INSERT INTO t VALUES (7, '7', '7', '7' );
1485 INSERT INTO t VALUES (9, '9', '9', NULL );
1486 INSERT INTO t VALUES (2, '1', '2', '2' );
1487 INSERT INTO t VALUES (3, '1', '3', '2' );
1488 include/rpl_sync.inc
1489 connection server_1;
1490 UPDATE t SET c4 = '7';
1491 UPDATE t SET c4 = '5' WHERE c1 = 1;
1492 UPDATE t SET c2 = '5' WHERE c1 = 1;
1493 UPDATE t SET c1 = '5' WHERE c1 = 1;
1494 UPDATE t SET c4 = '8' WHERE c2 = '4';
1495 UPDATE t SET c1 = '8' WHERE c2 = '4';
1496 UPDATE t SET c2 = '8' WHERE c2 = '4';
1497 UPDATE t SET c3 = '0' WHERE c4 = NULL;
1498 UPDATE t SET c2 = '0' WHERE c4 = '0';
1499 UPDATE t SET c2 = '2' WHERE c4 = '2';
1500 include/rpl_sync.inc
1501 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1502 connection server_1;
1503 DELETE FROM t WHERE c1 = 7;
1504 DELETE FROM t WHERE c1 = 8;
1505 DELETE FROM t;
1506 include/rpl_sync.inc
1507 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1508 connection server_1;
1509 DROP TABLE t;
1510 include/rpl_sync.inc
1511 connection server_1;
1512 SET SQL_LOG_BIN=0;
1513 connection server_2;
1514 SET SQL_LOG_BIN=0;
1515 connection server_3;
1516 SET SQL_LOG_BIN=0;
1517 ****** TEST: One Primary key
1518 connection server_1;
1519 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1)) engine= MyISAM;;
1520 connection server_2;
1521 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1)) engine= InnoDB;;
1522 connection server_3;
1523 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1)) engine= MyISAM;;
1524 connection server_1;
1525 SET SQL_LOG_BIN=1;
1526 connection server_2;
1527 SET SQL_LOG_BIN=1;
1528 connection server_3;
1529 SET SQL_LOG_BIN=1;
1530 connection server_1;
1531 INSERT INTO t VALUES (1, '1', '1', '1' );
1532 INSERT INTO t VALUES (4, '4', '4', '4' );
1533 INSERT INTO t VALUES (7, '7', '7', '7' );
1534 INSERT INTO t VALUES (9, '9', '9', NULL );
1535 INSERT INTO t VALUES (2, '1', '2', '2' );
1536 INSERT INTO t VALUES (3, '1', '3', '2' );
1537 include/rpl_sync.inc
1538 connection server_1;
1539 UPDATE t SET c4 = '7';
1540 UPDATE t SET c4 = '5' WHERE c1 = 1;
1541 UPDATE t SET c2 = '5' WHERE c1 = 1;
1542 UPDATE t SET c1 = '5' WHERE c1 = 1;
1543 UPDATE t SET c4 = '8' WHERE c2 = '4';
1544 UPDATE t SET c1 = '8' WHERE c2 = '4';
1545 UPDATE t SET c2 = '8' WHERE c2 = '4';
1546 UPDATE t SET c3 = '0' WHERE c4 = NULL;
1547 UPDATE t SET c2 = '0' WHERE c4 = '0';
1548 UPDATE t SET c2 = '2' WHERE c4 = '2';
1549 include/rpl_sync.inc
1550 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1551 connection server_1;
1552 DELETE FROM t WHERE c1 = 7;
1553 DELETE FROM t WHERE c1 = 8;
1554 DELETE FROM t;
1555 include/rpl_sync.inc
1556 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1557 connection server_1;
1558 DROP TABLE t;
1559 include/rpl_sync.inc
1560 connection server_1;
1561 SET SQL_LOG_BIN=0;
1562 connection server_2;
1563 SET SQL_LOG_BIN=0;
1564 connection server_3;
1565 SET SQL_LOG_BIN=0;
1566 ****** TEST: One Composite Unique key
1567 connection server_1;
1568 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c2)) engine= MyISAM;;
1569 connection server_2;
1570 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c2)) engine= InnoDB;;
1571 connection server_3;
1572 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c2)) engine= MyISAM;;
1573 connection server_1;
1574 SET SQL_LOG_BIN=1;
1575 connection server_2;
1576 SET SQL_LOG_BIN=1;
1577 connection server_3;
1578 SET SQL_LOG_BIN=1;
1579 connection server_1;
1580 INSERT INTO t VALUES (1, '1', '1', '1' );
1581 INSERT INTO t VALUES (4, '4', '4', '4' );
1582 INSERT INTO t VALUES (7, '7', '7', '7' );
1583 INSERT INTO t VALUES (9, '9', '9', NULL );
1584 INSERT INTO t VALUES (2, '1', '2', '2' );
1585 INSERT INTO t VALUES (3, '1', '3', '2' );
1586 include/rpl_sync.inc
1587 connection server_1;
1588 UPDATE t SET c4 = '7';
1589 UPDATE t SET c4 = '5' WHERE c1 = 1;
1590 UPDATE t SET c2 = '5' WHERE c1 = 1;
1591 UPDATE t SET c1 = '5' WHERE c1 = 1;
1592 UPDATE t SET c4 = '8' WHERE c2 = '4';
1593 UPDATE t SET c1 = '8' WHERE c2 = '4';
1594 UPDATE t SET c2 = '8' WHERE c2 = '4';
1595 UPDATE t SET c3 = '0' WHERE c4 = NULL;
1596 UPDATE t SET c2 = '0' WHERE c4 = '0';
1597 UPDATE t SET c2 = '2' WHERE c4 = '2';
1598 include/rpl_sync.inc
1599 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1600 connection server_1;
1601 DELETE FROM t WHERE c1 = 7;
1602 DELETE FROM t WHERE c1 = 8;
1603 DELETE FROM t;
1604 include/rpl_sync.inc
1605 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1606 connection server_1;
1607 DROP TABLE t;
1608 include/rpl_sync.inc
1609 connection server_1;
1610 SET SQL_LOG_BIN=0;
1611 connection server_2;
1612 SET SQL_LOG_BIN=0;
1613 connection server_3;
1614 SET SQL_LOG_BIN=0;
1615 ****** TEST: One Unique key
1616 connection server_1;
1617 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1)) engine= MyISAM;;
1618 connection server_2;
1619 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1)) engine= InnoDB;;
1620 connection server_3;
1621 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1)) engine= MyISAM;;
1622 connection server_1;
1623 SET SQL_LOG_BIN=1;
1624 connection server_2;
1625 SET SQL_LOG_BIN=1;
1626 connection server_3;
1627 SET SQL_LOG_BIN=1;
1628 connection server_1;
1629 INSERT INTO t VALUES (1, '1', '1', '1' );
1630 INSERT INTO t VALUES (4, '4', '4', '4' );
1631 INSERT INTO t VALUES (7, '7', '7', '7' );
1632 INSERT INTO t VALUES (9, '9', '9', NULL );
1633 INSERT INTO t VALUES (2, '1', '2', '2' );
1634 INSERT INTO t VALUES (3, '1', '3', '2' );
1635 include/rpl_sync.inc
1636 connection server_1;
1637 UPDATE t SET c4 = '7';
1638 UPDATE t SET c4 = '5' WHERE c1 = 1;
1639 UPDATE t SET c2 = '5' WHERE c1 = 1;
1640 UPDATE t SET c1 = '5' WHERE c1 = 1;
1641 UPDATE t SET c4 = '8' WHERE c2 = '4';
1642 UPDATE t SET c1 = '8' WHERE c2 = '4';
1643 UPDATE t SET c2 = '8' WHERE c2 = '4';
1644 UPDATE t SET c3 = '0' WHERE c4 = NULL;
1645 UPDATE t SET c2 = '0' WHERE c4 = '0';
1646 UPDATE t SET c2 = '2' WHERE c4 = '2';
1647 include/rpl_sync.inc
1648 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1649 connection server_1;
1650 DELETE FROM t WHERE c1 = 7;
1651 DELETE FROM t WHERE c1 = 8;
1652 DELETE FROM t;
1653 include/rpl_sync.inc
1654 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1655 connection server_1;
1656 DROP TABLE t;
1657 include/rpl_sync.inc
1658 connection server_1;
1659 SET SQL_LOG_BIN=0;
1660 connection server_2;
1661 SET SQL_LOG_BIN=0;
1662 connection server_3;
1663 SET SQL_LOG_BIN=0;
1664 ****** TEST: One Composite key
1665 connection server_1;
1666 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c2)) engine= MyISAM;;
1667 connection server_2;
1668 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c2)) engine= InnoDB;;
1669 connection server_3;
1670 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c2)) engine= MyISAM;;
1671 connection server_1;
1672 SET SQL_LOG_BIN=1;
1673 connection server_2;
1674 SET SQL_LOG_BIN=1;
1675 connection server_3;
1676 SET SQL_LOG_BIN=1;
1677 connection server_1;
1678 INSERT INTO t VALUES (1, '1', '1', '1' );
1679 INSERT INTO t VALUES (4, '4', '4', '4' );
1680 INSERT INTO t VALUES (7, '7', '7', '7' );
1681 INSERT INTO t VALUES (9, '9', '9', NULL );
1682 INSERT INTO t VALUES (2, '1', '2', '2' );
1683 INSERT INTO t VALUES (3, '1', '3', '2' );
1684 include/rpl_sync.inc
1685 connection server_1;
1686 UPDATE t SET c4 = '7';
1687 UPDATE t SET c4 = '5' WHERE c1 = 1;
1688 UPDATE t SET c2 = '5' WHERE c1 = 1;
1689 UPDATE t SET c1 = '5' WHERE c1 = 1;
1690 UPDATE t SET c4 = '8' WHERE c2 = '4';
1691 UPDATE t SET c1 = '8' WHERE c2 = '4';
1692 UPDATE t SET c2 = '8' WHERE c2 = '4';
1693 UPDATE t SET c3 = '0' WHERE c4 = NULL;
1694 UPDATE t SET c2 = '0' WHERE c4 = '0';
1695 UPDATE t SET c2 = '2' WHERE c4 = '2';
1696 include/rpl_sync.inc
1697 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1698 connection server_1;
1699 DELETE FROM t WHERE c1 = 7;
1700 DELETE FROM t WHERE c1 = 8;
1701 DELETE FROM t;
1702 include/rpl_sync.inc
1703 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1704 connection server_1;
1705 DROP TABLE t;
1706 include/rpl_sync.inc
1707 connection server_1;
1708 SET SQL_LOG_BIN=0;
1709 connection server_2;
1710 SET SQL_LOG_BIN=0;
1711 connection server_3;
1712 SET SQL_LOG_BIN=0;
1713 ******* TEST: One key
1714 connection server_1;
1715 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1)) engine= MyISAM;;
1716 connection server_2;
1717 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1)) engine= InnoDB;;
1718 connection server_3;
1719 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1)) engine= MyISAM;;
1720 connection server_1;
1721 SET SQL_LOG_BIN=1;
1722 connection server_2;
1723 SET SQL_LOG_BIN=1;
1724 connection server_3;
1725 SET SQL_LOG_BIN=1;
1726 connection server_1;
1727 INSERT INTO t VALUES (1, '1', '1', '1' );
1728 INSERT INTO t VALUES (4, '4', '4', '4' );
1729 INSERT INTO t VALUES (7, '7', '7', '7' );
1730 INSERT INTO t VALUES (9, '9', '9', NULL );
1731 INSERT INTO t VALUES (2, '1', '2', '2' );
1732 INSERT INTO t VALUES (3, '1', '3', '2' );
1733 include/rpl_sync.inc
1734 connection server_1;
1735 UPDATE t SET c4 = '7';
1736 UPDATE t SET c4 = '5' WHERE c1 = 1;
1737 UPDATE t SET c2 = '5' WHERE c1 = 1;
1738 UPDATE t SET c1 = '5' WHERE c1 = 1;
1739 UPDATE t SET c4 = '8' WHERE c2 = '4';
1740 UPDATE t SET c1 = '8' WHERE c2 = '4';
1741 UPDATE t SET c2 = '8' WHERE c2 = '4';
1742 UPDATE t SET c3 = '0' WHERE c4 = NULL;
1743 UPDATE t SET c2 = '0' WHERE c4 = '0';
1744 UPDATE t SET c2 = '2' WHERE c4 = '2';
1745 include/rpl_sync.inc
1746 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1747 connection server_1;
1748 DELETE FROM t WHERE c1 = 7;
1749 DELETE FROM t WHERE c1 = 8;
1750 DELETE FROM t;
1751 include/rpl_sync.inc
1752 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1753 connection server_1;
1754 DROP TABLE t;
1755 include/rpl_sync.inc
1756 connection server_1;
1757 SET SQL_LOG_BIN=0;
1758 connection server_2;
1759 SET SQL_LOG_BIN=0;
1760 connection server_3;
1761 SET SQL_LOG_BIN=0;
1762 ******* TEST: No keys
1763 connection server_1;
1764 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1)) engine= MyISAM;;
1765 connection server_2;
1766 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1)) engine= InnoDB;;
1767 connection server_3;
1768 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1)) engine= MyISAM;;
1769 connection server_1;
1770 SET SQL_LOG_BIN=1;
1771 connection server_2;
1772 SET SQL_LOG_BIN=1;
1773 connection server_3;
1774 SET SQL_LOG_BIN=1;
1775 connection server_1;
1776 INSERT INTO t VALUES (1, '1', '1', '1' );
1777 INSERT INTO t VALUES (4, '4', '4', '4' );
1778 INSERT INTO t VALUES (7, '7', '7', '7' );
1779 INSERT INTO t VALUES (9, '9', '9', NULL );
1780 INSERT INTO t VALUES (2, '1', '2', '2' );
1781 INSERT INTO t VALUES (3, '1', '3', '2' );
1782 include/rpl_sync.inc
1783 connection server_1;
1784 UPDATE t SET c4 = '7';
1785 UPDATE t SET c4 = '5' WHERE c1 = 1;
1786 UPDATE t SET c2 = '5' WHERE c1 = 1;
1787 UPDATE t SET c1 = '5' WHERE c1 = 1;
1788 UPDATE t SET c4 = '8' WHERE c2 = '4';
1789 UPDATE t SET c1 = '8' WHERE c2 = '4';
1790 UPDATE t SET c2 = '8' WHERE c2 = '4';
1791 UPDATE t SET c3 = '0' WHERE c4 = NULL;
1792 UPDATE t SET c2 = '0' WHERE c4 = '0';
1793 UPDATE t SET c2 = '2' WHERE c4 = '2';
1794 include/rpl_sync.inc
1795 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1796 connection server_1;
1797 DELETE FROM t WHERE c1 = 7;
1798 DELETE FROM t WHERE c1 = 8;
1799 DELETE FROM t;
1800 include/rpl_sync.inc
1801 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1802 connection server_1;
1803 DROP TABLE t;
1804 include/rpl_sync.inc
1805 ### engines: MyISAM, InnoDB, InnoDB
1806 connection server_1;
1807 connection server_1;
1808 SET SQL_LOG_BIN=0;
1809 connection server_2;
1810 SET SQL_LOG_BIN=0;
1811 connection server_3;
1812 SET SQL_LOG_BIN=0;
1813 ****** TEST: One Composite NOT NULL Unique key with holes in master, but NULLABLE on first slave
1814 connection server_1;
1815 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= MyISAM;;
1816 connection server_2;
1817 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= InnoDB;;
1818 connection server_3;
1819 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= InnoDB;;
1820 connection server_1;
1821 SET SQL_LOG_BIN=1;
1822 connection server_2;
1823 SET SQL_LOG_BIN=1;
1824 connection server_3;
1825 SET SQL_LOG_BIN=1;
1826 connection server_1;
1827 INSERT INTO t VALUES (1, '1', '1', '1' );
1828 INSERT INTO t VALUES (4, '4', '4', '4' );
1829 INSERT INTO t VALUES (7, '7', '7', '7' );
1830 INSERT INTO t VALUES (9, '9', '9', NULL );
1831 INSERT INTO t VALUES (2, '1', '2', '2' );
1832 INSERT INTO t VALUES (3, '1', '3', '2' );
1833 include/rpl_sync.inc
1834 connection server_1;
1835 UPDATE t SET c4 = '7';
1836 UPDATE t SET c4 = '5' WHERE c1 = 1;
1837 UPDATE t SET c2 = '5' WHERE c1 = 1;
1838 UPDATE t SET c1 = '5' WHERE c1 = 1;
1839 UPDATE t SET c4 = '8' WHERE c2 = '4';
1840 UPDATE t SET c1 = '8' WHERE c2 = '4';
1841 UPDATE t SET c2 = '8' WHERE c2 = '4';
1842 UPDATE t SET c3 = '0' WHERE c4 = NULL;
1843 UPDATE t SET c2 = '0' WHERE c4 = '0';
1844 UPDATE t SET c2 = '2' WHERE c4 = '2';
1845 include/rpl_sync.inc
1846 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1847 connection server_1;
1848 DELETE FROM t WHERE c1 = 7;
1849 DELETE FROM t WHERE c1 = 8;
1850 DELETE FROM t;
1851 include/rpl_sync.inc
1852 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1853 connection server_1;
1854 DROP TABLE t;
1855 include/rpl_sync.inc
1856 connection server_1;
1857 SET SQL_LOG_BIN=0;
1858 connection server_2;
1859 SET SQL_LOG_BIN=0;
1860 connection server_3;
1861 SET SQL_LOG_BIN=0;
1862 ****** TEST: One Composite NOT NULL Unique key with holes
1863 connection server_1;
1864 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= MyISAM;;
1865 connection server_2;
1866 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= InnoDB;;
1867 connection server_3;
1868 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= InnoDB;;
1869 connection server_1;
1870 SET SQL_LOG_BIN=1;
1871 connection server_2;
1872 SET SQL_LOG_BIN=1;
1873 connection server_3;
1874 SET SQL_LOG_BIN=1;
1875 connection server_1;
1876 INSERT INTO t VALUES (1, '1', '1', '1' );
1877 INSERT INTO t VALUES (4, '4', '4', '4' );
1878 INSERT INTO t VALUES (7, '7', '7', '7' );
1879 INSERT INTO t VALUES (9, '9', '9', NULL );
1880 INSERT INTO t VALUES (2, '1', '2', '2' );
1881 INSERT INTO t VALUES (3, '1', '3', '2' );
1882 include/rpl_sync.inc
1883 connection server_1;
1884 UPDATE t SET c4 = '7';
1885 UPDATE t SET c4 = '5' WHERE c1 = 1;
1886 UPDATE t SET c2 = '5' WHERE c1 = 1;
1887 UPDATE t SET c1 = '5' WHERE c1 = 1;
1888 UPDATE t SET c4 = '8' WHERE c2 = '4';
1889 UPDATE t SET c1 = '8' WHERE c2 = '4';
1890 UPDATE t SET c2 = '8' WHERE c2 = '4';
1891 UPDATE t SET c3 = '0' WHERE c4 = NULL;
1892 UPDATE t SET c2 = '0' WHERE c4 = '0';
1893 UPDATE t SET c2 = '2' WHERE c4 = '2';
1894 include/rpl_sync.inc
1895 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1896 connection server_1;
1897 DELETE FROM t WHERE c1 = 7;
1898 DELETE FROM t WHERE c1 = 8;
1899 DELETE FROM t;
1900 include/rpl_sync.inc
1901 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1902 connection server_1;
1903 DROP TABLE t;
1904 include/rpl_sync.inc
1905 connection server_1;
1906 SET SQL_LOG_BIN=0;
1907 connection server_2;
1908 SET SQL_LOG_BIN=0;
1909 connection server_3;
1910 SET SQL_LOG_BIN=0;
1911 ****** TEST: One Composite Primary Key with holes
1912 connection server_1;
1913 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c3)) engine= MyISAM;;
1914 connection server_2;
1915 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c3)) engine= InnoDB;;
1916 connection server_3;
1917 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c3)) engine= InnoDB;;
1918 connection server_1;
1919 SET SQL_LOG_BIN=1;
1920 connection server_2;
1921 SET SQL_LOG_BIN=1;
1922 connection server_3;
1923 SET SQL_LOG_BIN=1;
1924 connection server_1;
1925 INSERT INTO t VALUES (1, '1', '1', '1' );
1926 INSERT INTO t VALUES (4, '4', '4', '4' );
1927 INSERT INTO t VALUES (7, '7', '7', '7' );
1928 INSERT INTO t VALUES (9, '9', '9', NULL );
1929 INSERT INTO t VALUES (2, '1', '2', '2' );
1930 INSERT INTO t VALUES (3, '1', '3', '2' );
1931 include/rpl_sync.inc
1932 connection server_1;
1933 UPDATE t SET c4 = '7';
1934 UPDATE t SET c4 = '5' WHERE c1 = 1;
1935 UPDATE t SET c2 = '5' WHERE c1 = 1;
1936 UPDATE t SET c1 = '5' WHERE c1 = 1;
1937 UPDATE t SET c4 = '8' WHERE c2 = '4';
1938 UPDATE t SET c1 = '8' WHERE c2 = '4';
1939 UPDATE t SET c2 = '8' WHERE c2 = '4';
1940 UPDATE t SET c3 = '0' WHERE c4 = NULL;
1941 UPDATE t SET c2 = '0' WHERE c4 = '0';
1942 UPDATE t SET c2 = '2' WHERE c4 = '2';
1943 include/rpl_sync.inc
1944 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1945 connection server_1;
1946 DELETE FROM t WHERE c1 = 7;
1947 DELETE FROM t WHERE c1 = 8;
1948 DELETE FROM t;
1949 include/rpl_sync.inc
1950 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1951 connection server_1;
1952 DROP TABLE t;
1953 include/rpl_sync.inc
1954 connection server_1;
1955 SET SQL_LOG_BIN=0;
1956 connection server_2;
1957 SET SQL_LOG_BIN=0;
1958 connection server_3;
1959 SET SQL_LOG_BIN=0;
1960 ****** TEST: One Composite Unique key with holes
1961 connection server_1;
1962 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= MyISAM;;
1963 connection server_2;
1964 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= InnoDB;;
1965 connection server_3;
1966 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= InnoDB;;
1967 connection server_1;
1968 SET SQL_LOG_BIN=1;
1969 connection server_2;
1970 SET SQL_LOG_BIN=1;
1971 connection server_3;
1972 SET SQL_LOG_BIN=1;
1973 connection server_1;
1974 INSERT INTO t VALUES (1, '1', '1', '1' );
1975 INSERT INTO t VALUES (4, '4', '4', '4' );
1976 INSERT INTO t VALUES (7, '7', '7', '7' );
1977 INSERT INTO t VALUES (9, '9', '9', NULL );
1978 INSERT INTO t VALUES (2, '1', '2', '2' );
1979 INSERT INTO t VALUES (3, '1', '3', '2' );
1980 include/rpl_sync.inc
1981 connection server_1;
1982 UPDATE t SET c4 = '7';
1983 UPDATE t SET c4 = '5' WHERE c1 = 1;
1984 UPDATE t SET c2 = '5' WHERE c1 = 1;
1985 UPDATE t SET c1 = '5' WHERE c1 = 1;
1986 UPDATE t SET c4 = '8' WHERE c2 = '4';
1987 UPDATE t SET c1 = '8' WHERE c2 = '4';
1988 UPDATE t SET c2 = '8' WHERE c2 = '4';
1989 UPDATE t SET c3 = '0' WHERE c4 = NULL;
1990 UPDATE t SET c2 = '0' WHERE c4 = '0';
1991 UPDATE t SET c2 = '2' WHERE c4 = '2';
1992 include/rpl_sync.inc
1993 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1994 connection server_1;
1995 DELETE FROM t WHERE c1 = 7;
1996 DELETE FROM t WHERE c1 = 8;
1997 DELETE FROM t;
1998 include/rpl_sync.inc
1999 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2000 connection server_1;
2001 DROP TABLE t;
2002 include/rpl_sync.inc
2003 connection server_1;
2004 SET SQL_LOG_BIN=0;
2005 connection server_2;
2006 SET SQL_LOG_BIN=0;
2007 connection server_3;
2008 SET SQL_LOG_BIN=0;
2009 ****** TEST: One Composite key with holes
2010 connection server_1;
2011 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c3)) engine= MyISAM;;
2012 connection server_2;
2013 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c3)) engine= InnoDB;;
2014 connection server_3;
2015 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c3)) engine= InnoDB;;
2016 connection server_1;
2017 SET SQL_LOG_BIN=1;
2018 connection server_2;
2019 SET SQL_LOG_BIN=1;
2020 connection server_3;
2021 SET SQL_LOG_BIN=1;
2022 connection server_1;
2023 INSERT INTO t VALUES (1, '1', '1', '1' );
2024 INSERT INTO t VALUES (4, '4', '4', '4' );
2025 INSERT INTO t VALUES (7, '7', '7', '7' );
2026 INSERT INTO t VALUES (9, '9', '9', NULL );
2027 INSERT INTO t VALUES (2, '1', '2', '2' );
2028 INSERT INTO t VALUES (3, '1', '3', '2' );
2029 include/rpl_sync.inc
2030 connection server_1;
2031 UPDATE t SET c4 = '7';
2032 UPDATE t SET c4 = '5' WHERE c1 = 1;
2033 UPDATE t SET c2 = '5' WHERE c1 = 1;
2034 UPDATE t SET c1 = '5' WHERE c1 = 1;
2035 UPDATE t SET c4 = '8' WHERE c2 = '4';
2036 UPDATE t SET c1 = '8' WHERE c2 = '4';
2037 UPDATE t SET c2 = '8' WHERE c2 = '4';
2038 UPDATE t SET c3 = '0' WHERE c4 = NULL;
2039 UPDATE t SET c2 = '0' WHERE c4 = '0';
2040 UPDATE t SET c2 = '2' WHERE c4 = '2';
2041 include/rpl_sync.inc
2042 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2043 connection server_1;
2044 DELETE FROM t WHERE c1 = 7;
2045 DELETE FROM t WHERE c1 = 8;
2046 DELETE FROM t;
2047 include/rpl_sync.inc
2048 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2049 connection server_1;
2050 DROP TABLE t;
2051 include/rpl_sync.inc
2052 connection server_1;
2053 SET SQL_LOG_BIN=0;
2054 connection server_2;
2055 SET SQL_LOG_BIN=0;
2056 connection server_3;
2057 SET SQL_LOG_BIN=0;
2058 ****** TEST: One Composite Primary Key
2059 connection server_1;
2060 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c2)) engine= MyISAM;;
2061 connection server_2;
2062 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c2)) engine= InnoDB;;
2063 connection server_3;
2064 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c2)) engine= InnoDB;;
2065 connection server_1;
2066 SET SQL_LOG_BIN=1;
2067 connection server_2;
2068 SET SQL_LOG_BIN=1;
2069 connection server_3;
2070 SET SQL_LOG_BIN=1;
2071 connection server_1;
2072 INSERT INTO t VALUES (1, '1', '1', '1' );
2073 INSERT INTO t VALUES (4, '4', '4', '4' );
2074 INSERT INTO t VALUES (7, '7', '7', '7' );
2075 INSERT INTO t VALUES (9, '9', '9', NULL );
2076 INSERT INTO t VALUES (2, '1', '2', '2' );
2077 INSERT INTO t VALUES (3, '1', '3', '2' );
2078 include/rpl_sync.inc
2079 connection server_1;
2080 UPDATE t SET c4 = '7';
2081 UPDATE t SET c4 = '5' WHERE c1 = 1;
2082 UPDATE t SET c2 = '5' WHERE c1 = 1;
2083 UPDATE t SET c1 = '5' WHERE c1 = 1;
2084 UPDATE t SET c4 = '8' WHERE c2 = '4';
2085 UPDATE t SET c1 = '8' WHERE c2 = '4';
2086 UPDATE t SET c2 = '8' WHERE c2 = '4';
2087 UPDATE t SET c3 = '0' WHERE c4 = NULL;
2088 UPDATE t SET c2 = '0' WHERE c4 = '0';
2089 UPDATE t SET c2 = '2' WHERE c4 = '2';
2090 include/rpl_sync.inc
2091 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2092 connection server_1;
2093 DELETE FROM t WHERE c1 = 7;
2094 DELETE FROM t WHERE c1 = 8;
2095 DELETE FROM t;
2096 include/rpl_sync.inc
2097 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2098 connection server_1;
2099 DROP TABLE t;
2100 include/rpl_sync.inc
2101 connection server_1;
2102 SET SQL_LOG_BIN=0;
2103 connection server_2;
2104 SET SQL_LOG_BIN=0;
2105 connection server_3;
2106 SET SQL_LOG_BIN=0;
2107 ****** TEST: One Primary key
2108 connection server_1;
2109 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1)) engine= MyISAM;;
2110 connection server_2;
2111 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1)) engine= InnoDB;;
2112 connection server_3;
2113 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1)) engine= InnoDB;;
2114 connection server_1;
2115 SET SQL_LOG_BIN=1;
2116 connection server_2;
2117 SET SQL_LOG_BIN=1;
2118 connection server_3;
2119 SET SQL_LOG_BIN=1;
2120 connection server_1;
2121 INSERT INTO t VALUES (1, '1', '1', '1' );
2122 INSERT INTO t VALUES (4, '4', '4', '4' );
2123 INSERT INTO t VALUES (7, '7', '7', '7' );
2124 INSERT INTO t VALUES (9, '9', '9', NULL );
2125 INSERT INTO t VALUES (2, '1', '2', '2' );
2126 INSERT INTO t VALUES (3, '1', '3', '2' );
2127 include/rpl_sync.inc
2128 connection server_1;
2129 UPDATE t SET c4 = '7';
2130 UPDATE t SET c4 = '5' WHERE c1 = 1;
2131 UPDATE t SET c2 = '5' WHERE c1 = 1;
2132 UPDATE t SET c1 = '5' WHERE c1 = 1;
2133 UPDATE t SET c4 = '8' WHERE c2 = '4';
2134 UPDATE t SET c1 = '8' WHERE c2 = '4';
2135 UPDATE t SET c2 = '8' WHERE c2 = '4';
2136 UPDATE t SET c3 = '0' WHERE c4 = NULL;
2137 UPDATE t SET c2 = '0' WHERE c4 = '0';
2138 UPDATE t SET c2 = '2' WHERE c4 = '2';
2139 include/rpl_sync.inc
2140 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2141 connection server_1;
2142 DELETE FROM t WHERE c1 = 7;
2143 DELETE FROM t WHERE c1 = 8;
2144 DELETE FROM t;
2145 include/rpl_sync.inc
2146 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2147 connection server_1;
2148 DROP TABLE t;
2149 include/rpl_sync.inc
2150 connection server_1;
2151 SET SQL_LOG_BIN=0;
2152 connection server_2;
2153 SET SQL_LOG_BIN=0;
2154 connection server_3;
2155 SET SQL_LOG_BIN=0;
2156 ****** TEST: One Composite Unique key
2157 connection server_1;
2158 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c2)) engine= MyISAM;;
2159 connection server_2;
2160 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c2)) engine= InnoDB;;
2161 connection server_3;
2162 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c2)) engine= InnoDB;;
2163 connection server_1;
2164 SET SQL_LOG_BIN=1;
2165 connection server_2;
2166 SET SQL_LOG_BIN=1;
2167 connection server_3;
2168 SET SQL_LOG_BIN=1;
2169 connection server_1;
2170 INSERT INTO t VALUES (1, '1', '1', '1' );
2171 INSERT INTO t VALUES (4, '4', '4', '4' );
2172 INSERT INTO t VALUES (7, '7', '7', '7' );
2173 INSERT INTO t VALUES (9, '9', '9', NULL );
2174 INSERT INTO t VALUES (2, '1', '2', '2' );
2175 INSERT INTO t VALUES (3, '1', '3', '2' );
2176 include/rpl_sync.inc
2177 connection server_1;
2178 UPDATE t SET c4 = '7';
2179 UPDATE t SET c4 = '5' WHERE c1 = 1;
2180 UPDATE t SET c2 = '5' WHERE c1 = 1;
2181 UPDATE t SET c1 = '5' WHERE c1 = 1;
2182 UPDATE t SET c4 = '8' WHERE c2 = '4';
2183 UPDATE t SET c1 = '8' WHERE c2 = '4';
2184 UPDATE t SET c2 = '8' WHERE c2 = '4';
2185 UPDATE t SET c3 = '0' WHERE c4 = NULL;
2186 UPDATE t SET c2 = '0' WHERE c4 = '0';
2187 UPDATE t SET c2 = '2' WHERE c4 = '2';
2188 include/rpl_sync.inc
2189 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2190 connection server_1;
2191 DELETE FROM t WHERE c1 = 7;
2192 DELETE FROM t WHERE c1 = 8;
2193 DELETE FROM t;
2194 include/rpl_sync.inc
2195 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2196 connection server_1;
2197 DROP TABLE t;
2198 include/rpl_sync.inc
2199 connection server_1;
2200 SET SQL_LOG_BIN=0;
2201 connection server_2;
2202 SET SQL_LOG_BIN=0;
2203 connection server_3;
2204 SET SQL_LOG_BIN=0;
2205 ****** TEST: One Unique key
2206 connection server_1;
2207 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1)) engine= MyISAM;;
2208 connection server_2;
2209 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1)) engine= InnoDB;;
2210 connection server_3;
2211 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1)) engine= InnoDB;;
2212 connection server_1;
2213 SET SQL_LOG_BIN=1;
2214 connection server_2;
2215 SET SQL_LOG_BIN=1;
2216 connection server_3;
2217 SET SQL_LOG_BIN=1;
2218 connection server_1;
2219 INSERT INTO t VALUES (1, '1', '1', '1' );
2220 INSERT INTO t VALUES (4, '4', '4', '4' );
2221 INSERT INTO t VALUES (7, '7', '7', '7' );
2222 INSERT INTO t VALUES (9, '9', '9', NULL );
2223 INSERT INTO t VALUES (2, '1', '2', '2' );
2224 INSERT INTO t VALUES (3, '1', '3', '2' );
2225 include/rpl_sync.inc
2226 connection server_1;
2227 UPDATE t SET c4 = '7';
2228 UPDATE t SET c4 = '5' WHERE c1 = 1;
2229 UPDATE t SET c2 = '5' WHERE c1 = 1;
2230 UPDATE t SET c1 = '5' WHERE c1 = 1;
2231 UPDATE t SET c4 = '8' WHERE c2 = '4';
2232 UPDATE t SET c1 = '8' WHERE c2 = '4';
2233 UPDATE t SET c2 = '8' WHERE c2 = '4';
2234 UPDATE t SET c3 = '0' WHERE c4 = NULL;
2235 UPDATE t SET c2 = '0' WHERE c4 = '0';
2236 UPDATE t SET c2 = '2' WHERE c4 = '2';
2237 include/rpl_sync.inc
2238 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2239 connection server_1;
2240 DELETE FROM t WHERE c1 = 7;
2241 DELETE FROM t WHERE c1 = 8;
2242 DELETE FROM t;
2243 include/rpl_sync.inc
2244 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2245 connection server_1;
2246 DROP TABLE t;
2247 include/rpl_sync.inc
2248 connection server_1;
2249 SET SQL_LOG_BIN=0;
2250 connection server_2;
2251 SET SQL_LOG_BIN=0;
2252 connection server_3;
2253 SET SQL_LOG_BIN=0;
2254 ****** TEST: One Composite key
2255 connection server_1;
2256 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c2)) engine= MyISAM;;
2257 connection server_2;
2258 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c2)) engine= InnoDB;;
2259 connection server_3;
2260 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c2)) engine= InnoDB;;
2261 connection server_1;
2262 SET SQL_LOG_BIN=1;
2263 connection server_2;
2264 SET SQL_LOG_BIN=1;
2265 connection server_3;
2266 SET SQL_LOG_BIN=1;
2267 connection server_1;
2268 INSERT INTO t VALUES (1, '1', '1', '1' );
2269 INSERT INTO t VALUES (4, '4', '4', '4' );
2270 INSERT INTO t VALUES (7, '7', '7', '7' );
2271 INSERT INTO t VALUES (9, '9', '9', NULL );
2272 INSERT INTO t VALUES (2, '1', '2', '2' );
2273 INSERT INTO t VALUES (3, '1', '3', '2' );
2274 include/rpl_sync.inc
2275 connection server_1;
2276 UPDATE t SET c4 = '7';
2277 UPDATE t SET c4 = '5' WHERE c1 = 1;
2278 UPDATE t SET c2 = '5' WHERE c1 = 1;
2279 UPDATE t SET c1 = '5' WHERE c1 = 1;
2280 UPDATE t SET c4 = '8' WHERE c2 = '4';
2281 UPDATE t SET c1 = '8' WHERE c2 = '4';
2282 UPDATE t SET c2 = '8' WHERE c2 = '4';
2283 UPDATE t SET c3 = '0' WHERE c4 = NULL;
2284 UPDATE t SET c2 = '0' WHERE c4 = '0';
2285 UPDATE t SET c2 = '2' WHERE c4 = '2';
2286 include/rpl_sync.inc
2287 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2288 connection server_1;
2289 DELETE FROM t WHERE c1 = 7;
2290 DELETE FROM t WHERE c1 = 8;
2291 DELETE FROM t;
2292 include/rpl_sync.inc
2293 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2294 connection server_1;
2295 DROP TABLE t;
2296 include/rpl_sync.inc
2297 connection server_1;
2298 SET SQL_LOG_BIN=0;
2299 connection server_2;
2300 SET SQL_LOG_BIN=0;
2301 connection server_3;
2302 SET SQL_LOG_BIN=0;
2303 ******* TEST: One key
2304 connection server_1;
2305 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1)) engine= MyISAM;;
2306 connection server_2;
2307 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1)) engine= InnoDB;;
2308 connection server_3;
2309 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1)) engine= InnoDB;;
2310 connection server_1;
2311 SET SQL_LOG_BIN=1;
2312 connection server_2;
2313 SET SQL_LOG_BIN=1;
2314 connection server_3;
2315 SET SQL_LOG_BIN=1;
2316 connection server_1;
2317 INSERT INTO t VALUES (1, '1', '1', '1' );
2318 INSERT INTO t VALUES (4, '4', '4', '4' );
2319 INSERT INTO t VALUES (7, '7', '7', '7' );
2320 INSERT INTO t VALUES (9, '9', '9', NULL );
2321 INSERT INTO t VALUES (2, '1', '2', '2' );
2322 INSERT INTO t VALUES (3, '1', '3', '2' );
2323 include/rpl_sync.inc
2324 connection server_1;
2325 UPDATE t SET c4 = '7';
2326 UPDATE t SET c4 = '5' WHERE c1 = 1;
2327 UPDATE t SET c2 = '5' WHERE c1 = 1;
2328 UPDATE t SET c1 = '5' WHERE c1 = 1;
2329 UPDATE t SET c4 = '8' WHERE c2 = '4';
2330 UPDATE t SET c1 = '8' WHERE c2 = '4';
2331 UPDATE t SET c2 = '8' WHERE c2 = '4';
2332 UPDATE t SET c3 = '0' WHERE c4 = NULL;
2333 UPDATE t SET c2 = '0' WHERE c4 = '0';
2334 UPDATE t SET c2 = '2' WHERE c4 = '2';
2335 include/rpl_sync.inc
2336 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2337 connection server_1;
2338 DELETE FROM t WHERE c1 = 7;
2339 DELETE FROM t WHERE c1 = 8;
2340 DELETE FROM t;
2341 include/rpl_sync.inc
2342 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2343 connection server_1;
2344 DROP TABLE t;
2345 include/rpl_sync.inc
2346 connection server_1;
2347 SET SQL_LOG_BIN=0;
2348 connection server_2;
2349 SET SQL_LOG_BIN=0;
2350 connection server_3;
2351 SET SQL_LOG_BIN=0;
2352 ******* TEST: No keys
2353 connection server_1;
2354 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1)) engine= MyISAM;;
2355 connection server_2;
2356 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1)) engine= InnoDB;;
2357 connection server_3;
2358 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1)) engine= InnoDB;;
2359 connection server_1;
2360 SET SQL_LOG_BIN=1;
2361 connection server_2;
2362 SET SQL_LOG_BIN=1;
2363 connection server_3;
2364 SET SQL_LOG_BIN=1;
2365 connection server_1;
2366 INSERT INTO t VALUES (1, '1', '1', '1' );
2367 INSERT INTO t VALUES (4, '4', '4', '4' );
2368 INSERT INTO t VALUES (7, '7', '7', '7' );
2369 INSERT INTO t VALUES (9, '9', '9', NULL );
2370 INSERT INTO t VALUES (2, '1', '2', '2' );
2371 INSERT INTO t VALUES (3, '1', '3', '2' );
2372 include/rpl_sync.inc
2373 connection server_1;
2374 UPDATE t SET c4 = '7';
2375 UPDATE t SET c4 = '5' WHERE c1 = 1;
2376 UPDATE t SET c2 = '5' WHERE c1 = 1;
2377 UPDATE t SET c1 = '5' WHERE c1 = 1;
2378 UPDATE t SET c4 = '8' WHERE c2 = '4';
2379 UPDATE t SET c1 = '8' WHERE c2 = '4';
2380 UPDATE t SET c2 = '8' WHERE c2 = '4';
2381 UPDATE t SET c3 = '0' WHERE c4 = NULL;
2382 UPDATE t SET c2 = '0' WHERE c4 = '0';
2383 UPDATE t SET c2 = '2' WHERE c4 = '2';
2384 include/rpl_sync.inc
2385 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2386 connection server_1;
2387 DELETE FROM t WHERE c1 = 7;
2388 DELETE FROM t WHERE c1 = 8;
2389 DELETE FROM t;
2390 include/rpl_sync.inc
2391 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2392 connection server_1;
2393 DROP TABLE t;
2394 include/rpl_sync.inc
2395 ### engines: InnoDB, MyISAM, MyISAM
2396 connection server_1;
2397 connection server_1;
2398 SET SQL_LOG_BIN=0;
2399 connection server_2;
2400 SET SQL_LOG_BIN=0;
2401 connection server_3;
2402 SET SQL_LOG_BIN=0;
2403 ****** TEST: One Composite NOT NULL Unique key with holes in master, but NULLABLE on first slave
2404 connection server_1;
2405 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= InnoDB;;
2406 connection server_2;
2407 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= MyISAM;;
2408 connection server_3;
2409 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= MyISAM;;
2410 connection server_1;
2411 SET SQL_LOG_BIN=1;
2412 connection server_2;
2413 SET SQL_LOG_BIN=1;
2414 connection server_3;
2415 SET SQL_LOG_BIN=1;
2416 connection server_1;
2417 INSERT INTO t VALUES (1, '1', '1', '1' );
2418 INSERT INTO t VALUES (4, '4', '4', '4' );
2419 INSERT INTO t VALUES (7, '7', '7', '7' );
2420 INSERT INTO t VALUES (9, '9', '9', NULL );
2421 INSERT INTO t VALUES (2, '1', '2', '2' );
2422 INSERT INTO t VALUES (3, '1', '3', '2' );
2423 include/rpl_sync.inc
2424 connection server_1;
2425 UPDATE t SET c4 = '7';
2426 UPDATE t SET c4 = '5' WHERE c1 = 1;
2427 UPDATE t SET c2 = '5' WHERE c1 = 1;
2428 UPDATE t SET c1 = '5' WHERE c1 = 1;
2429 UPDATE t SET c4 = '8' WHERE c2 = '4';
2430 UPDATE t SET c1 = '8' WHERE c2 = '4';
2431 UPDATE t SET c2 = '8' WHERE c2 = '4';
2432 UPDATE t SET c3 = '0' WHERE c4 = NULL;
2433 UPDATE t SET c2 = '0' WHERE c4 = '0';
2434 UPDATE t SET c2 = '2' WHERE c4 = '2';
2435 include/rpl_sync.inc
2436 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2437 connection server_1;
2438 DELETE FROM t WHERE c1 = 7;
2439 DELETE FROM t WHERE c1 = 8;
2440 DELETE FROM t;
2441 include/rpl_sync.inc
2442 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2443 connection server_1;
2444 DROP TABLE t;
2445 include/rpl_sync.inc
2446 connection server_1;
2447 SET SQL_LOG_BIN=0;
2448 connection server_2;
2449 SET SQL_LOG_BIN=0;
2450 connection server_3;
2451 SET SQL_LOG_BIN=0;
2452 ****** TEST: One Composite NOT NULL Unique key with holes
2453 connection server_1;
2454 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= InnoDB;;
2455 connection server_2;
2456 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= MyISAM;;
2457 connection server_3;
2458 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= MyISAM;;
2459 connection server_1;
2460 SET SQL_LOG_BIN=1;
2461 connection server_2;
2462 SET SQL_LOG_BIN=1;
2463 connection server_3;
2464 SET SQL_LOG_BIN=1;
2465 connection server_1;
2466 INSERT INTO t VALUES (1, '1', '1', '1' );
2467 INSERT INTO t VALUES (4, '4', '4', '4' );
2468 INSERT INTO t VALUES (7, '7', '7', '7' );
2469 INSERT INTO t VALUES (9, '9', '9', NULL );
2470 INSERT INTO t VALUES (2, '1', '2', '2' );
2471 INSERT INTO t VALUES (3, '1', '3', '2' );
2472 include/rpl_sync.inc
2473 connection server_1;
2474 UPDATE t SET c4 = '7';
2475 UPDATE t SET c4 = '5' WHERE c1 = 1;
2476 UPDATE t SET c2 = '5' WHERE c1 = 1;
2477 UPDATE t SET c1 = '5' WHERE c1 = 1;
2478 UPDATE t SET c4 = '8' WHERE c2 = '4';
2479 UPDATE t SET c1 = '8' WHERE c2 = '4';
2480 UPDATE t SET c2 = '8' WHERE c2 = '4';
2481 UPDATE t SET c3 = '0' WHERE c4 = NULL;
2482 UPDATE t SET c2 = '0' WHERE c4 = '0';
2483 UPDATE t SET c2 = '2' WHERE c4 = '2';
2484 include/rpl_sync.inc
2485 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2486 connection server_1;
2487 DELETE FROM t WHERE c1 = 7;
2488 DELETE FROM t WHERE c1 = 8;
2489 DELETE FROM t;
2490 include/rpl_sync.inc
2491 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2492 connection server_1;
2493 DROP TABLE t;
2494 include/rpl_sync.inc
2495 connection server_1;
2496 SET SQL_LOG_BIN=0;
2497 connection server_2;
2498 SET SQL_LOG_BIN=0;
2499 connection server_3;
2500 SET SQL_LOG_BIN=0;
2501 ****** TEST: One Composite Primary Key with holes
2502 connection server_1;
2503 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c3)) engine= InnoDB;;
2504 connection server_2;
2505 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c3)) engine= MyISAM;;
2506 connection server_3;
2507 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c3)) engine= MyISAM;;
2508 connection server_1;
2509 SET SQL_LOG_BIN=1;
2510 connection server_2;
2511 SET SQL_LOG_BIN=1;
2512 connection server_3;
2513 SET SQL_LOG_BIN=1;
2514 connection server_1;
2515 INSERT INTO t VALUES (1, '1', '1', '1' );
2516 INSERT INTO t VALUES (4, '4', '4', '4' );
2517 INSERT INTO t VALUES (7, '7', '7', '7' );
2518 INSERT INTO t VALUES (9, '9', '9', NULL );
2519 INSERT INTO t VALUES (2, '1', '2', '2' );
2520 INSERT INTO t VALUES (3, '1', '3', '2' );
2521 include/rpl_sync.inc
2522 connection server_1;
2523 UPDATE t SET c4 = '7';
2524 UPDATE t SET c4 = '5' WHERE c1 = 1;
2525 UPDATE t SET c2 = '5' WHERE c1 = 1;
2526 UPDATE t SET c1 = '5' WHERE c1 = 1;
2527 UPDATE t SET c4 = '8' WHERE c2 = '4';
2528 UPDATE t SET c1 = '8' WHERE c2 = '4';
2529 UPDATE t SET c2 = '8' WHERE c2 = '4';
2530 UPDATE t SET c3 = '0' WHERE c4 = NULL;
2531 UPDATE t SET c2 = '0' WHERE c4 = '0';
2532 UPDATE t SET c2 = '2' WHERE c4 = '2';
2533 include/rpl_sync.inc
2534 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2535 connection server_1;
2536 DELETE FROM t WHERE c1 = 7;
2537 DELETE FROM t WHERE c1 = 8;
2538 DELETE FROM t;
2539 include/rpl_sync.inc
2540 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2541 connection server_1;
2542 DROP TABLE t;
2543 include/rpl_sync.inc
2544 connection server_1;
2545 SET SQL_LOG_BIN=0;
2546 connection server_2;
2547 SET SQL_LOG_BIN=0;
2548 connection server_3;
2549 SET SQL_LOG_BIN=0;
2550 ****** TEST: One Composite Unique key with holes
2551 connection server_1;
2552 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= InnoDB;;
2553 connection server_2;
2554 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= MyISAM;;
2555 connection server_3;
2556 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= MyISAM;;
2557 connection server_1;
2558 SET SQL_LOG_BIN=1;
2559 connection server_2;
2560 SET SQL_LOG_BIN=1;
2561 connection server_3;
2562 SET SQL_LOG_BIN=1;
2563 connection server_1;
2564 INSERT INTO t VALUES (1, '1', '1', '1' );
2565 INSERT INTO t VALUES (4, '4', '4', '4' );
2566 INSERT INTO t VALUES (7, '7', '7', '7' );
2567 INSERT INTO t VALUES (9, '9', '9', NULL );
2568 INSERT INTO t VALUES (2, '1', '2', '2' );
2569 INSERT INTO t VALUES (3, '1', '3', '2' );
2570 include/rpl_sync.inc
2571 connection server_1;
2572 UPDATE t SET c4 = '7';
2573 UPDATE t SET c4 = '5' WHERE c1 = 1;
2574 UPDATE t SET c2 = '5' WHERE c1 = 1;
2575 UPDATE t SET c1 = '5' WHERE c1 = 1;
2576 UPDATE t SET c4 = '8' WHERE c2 = '4';
2577 UPDATE t SET c1 = '8' WHERE c2 = '4';
2578 UPDATE t SET c2 = '8' WHERE c2 = '4';
2579 UPDATE t SET c3 = '0' WHERE c4 = NULL;
2580 UPDATE t SET c2 = '0' WHERE c4 = '0';
2581 UPDATE t SET c2 = '2' WHERE c4 = '2';
2582 include/rpl_sync.inc
2583 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2584 connection server_1;
2585 DELETE FROM t WHERE c1 = 7;
2586 DELETE FROM t WHERE c1 = 8;
2587 DELETE FROM t;
2588 include/rpl_sync.inc
2589 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2590 connection server_1;
2591 DROP TABLE t;
2592 include/rpl_sync.inc
2593 connection server_1;
2594 SET SQL_LOG_BIN=0;
2595 connection server_2;
2596 SET SQL_LOG_BIN=0;
2597 connection server_3;
2598 SET SQL_LOG_BIN=0;
2599 ****** TEST: One Composite key with holes
2600 connection server_1;
2601 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c3)) engine= InnoDB;;
2602 connection server_2;
2603 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c3)) engine= MyISAM;;
2604 connection server_3;
2605 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c3)) engine= MyISAM;;
2606 connection server_1;
2607 SET SQL_LOG_BIN=1;
2608 connection server_2;
2609 SET SQL_LOG_BIN=1;
2610 connection server_3;
2611 SET SQL_LOG_BIN=1;
2612 connection server_1;
2613 INSERT INTO t VALUES (1, '1', '1', '1' );
2614 INSERT INTO t VALUES (4, '4', '4', '4' );
2615 INSERT INTO t VALUES (7, '7', '7', '7' );
2616 INSERT INTO t VALUES (9, '9', '9', NULL );
2617 INSERT INTO t VALUES (2, '1', '2', '2' );
2618 INSERT INTO t VALUES (3, '1', '3', '2' );
2619 include/rpl_sync.inc
2620 connection server_1;
2621 UPDATE t SET c4 = '7';
2622 UPDATE t SET c4 = '5' WHERE c1 = 1;
2623 UPDATE t SET c2 = '5' WHERE c1 = 1;
2624 UPDATE t SET c1 = '5' WHERE c1 = 1;
2625 UPDATE t SET c4 = '8' WHERE c2 = '4';
2626 UPDATE t SET c1 = '8' WHERE c2 = '4';
2627 UPDATE t SET c2 = '8' WHERE c2 = '4';
2628 UPDATE t SET c3 = '0' WHERE c4 = NULL;
2629 UPDATE t SET c2 = '0' WHERE c4 = '0';
2630 UPDATE t SET c2 = '2' WHERE c4 = '2';
2631 include/rpl_sync.inc
2632 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2633 connection server_1;
2634 DELETE FROM t WHERE c1 = 7;
2635 DELETE FROM t WHERE c1 = 8;
2636 DELETE FROM t;
2637 include/rpl_sync.inc
2638 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2639 connection server_1;
2640 DROP TABLE t;
2641 include/rpl_sync.inc
2642 connection server_1;
2643 SET SQL_LOG_BIN=0;
2644 connection server_2;
2645 SET SQL_LOG_BIN=0;
2646 connection server_3;
2647 SET SQL_LOG_BIN=0;
2648 ****** TEST: One Composite Primary Key
2649 connection server_1;
2650 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c2)) engine= InnoDB;;
2651 connection server_2;
2652 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c2)) engine= MyISAM;;
2653 connection server_3;
2654 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c2)) engine= MyISAM;;
2655 connection server_1;
2656 SET SQL_LOG_BIN=1;
2657 connection server_2;
2658 SET SQL_LOG_BIN=1;
2659 connection server_3;
2660 SET SQL_LOG_BIN=1;
2661 connection server_1;
2662 INSERT INTO t VALUES (1, '1', '1', '1' );
2663 INSERT INTO t VALUES (4, '4', '4', '4' );
2664 INSERT INTO t VALUES (7, '7', '7', '7' );
2665 INSERT INTO t VALUES (9, '9', '9', NULL );
2666 INSERT INTO t VALUES (2, '1', '2', '2' );
2667 INSERT INTO t VALUES (3, '1', '3', '2' );
2668 include/rpl_sync.inc
2669 connection server_1;
2670 UPDATE t SET c4 = '7';
2671 UPDATE t SET c4 = '5' WHERE c1 = 1;
2672 UPDATE t SET c2 = '5' WHERE c1 = 1;
2673 UPDATE t SET c1 = '5' WHERE c1 = 1;
2674 UPDATE t SET c4 = '8' WHERE c2 = '4';
2675 UPDATE t SET c1 = '8' WHERE c2 = '4';
2676 UPDATE t SET c2 = '8' WHERE c2 = '4';
2677 UPDATE t SET c3 = '0' WHERE c4 = NULL;
2678 UPDATE t SET c2 = '0' WHERE c4 = '0';
2679 UPDATE t SET c2 = '2' WHERE c4 = '2';
2680 include/rpl_sync.inc
2681 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2682 connection server_1;
2683 DELETE FROM t WHERE c1 = 7;
2684 DELETE FROM t WHERE c1 = 8;
2685 DELETE FROM t;
2686 include/rpl_sync.inc
2687 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2688 connection server_1;
2689 DROP TABLE t;
2690 include/rpl_sync.inc
2691 connection server_1;
2692 SET SQL_LOG_BIN=0;
2693 connection server_2;
2694 SET SQL_LOG_BIN=0;
2695 connection server_3;
2696 SET SQL_LOG_BIN=0;
2697 ****** TEST: One Primary key
2698 connection server_1;
2699 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1)) engine= InnoDB;;
2700 connection server_2;
2701 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1)) engine= MyISAM;;
2702 connection server_3;
2703 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1)) engine= MyISAM;;
2704 connection server_1;
2705 SET SQL_LOG_BIN=1;
2706 connection server_2;
2707 SET SQL_LOG_BIN=1;
2708 connection server_3;
2709 SET SQL_LOG_BIN=1;
2710 connection server_1;
2711 INSERT INTO t VALUES (1, '1', '1', '1' );
2712 INSERT INTO t VALUES (4, '4', '4', '4' );
2713 INSERT INTO t VALUES (7, '7', '7', '7' );
2714 INSERT INTO t VALUES (9, '9', '9', NULL );
2715 INSERT INTO t VALUES (2, '1', '2', '2' );
2716 INSERT INTO t VALUES (3, '1', '3', '2' );
2717 include/rpl_sync.inc
2718 connection server_1;
2719 UPDATE t SET c4 = '7';
2720 UPDATE t SET c4 = '5' WHERE c1 = 1;
2721 UPDATE t SET c2 = '5' WHERE c1 = 1;
2722 UPDATE t SET c1 = '5' WHERE c1 = 1;
2723 UPDATE t SET c4 = '8' WHERE c2 = '4';
2724 UPDATE t SET c1 = '8' WHERE c2 = '4';
2725 UPDATE t SET c2 = '8' WHERE c2 = '4';
2726 UPDATE t SET c3 = '0' WHERE c4 = NULL;
2727 UPDATE t SET c2 = '0' WHERE c4 = '0';
2728 UPDATE t SET c2 = '2' WHERE c4 = '2';
2729 include/rpl_sync.inc
2730 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2731 connection server_1;
2732 DELETE FROM t WHERE c1 = 7;
2733 DELETE FROM t WHERE c1 = 8;
2734 DELETE FROM t;
2735 include/rpl_sync.inc
2736 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2737 connection server_1;
2738 DROP TABLE t;
2739 include/rpl_sync.inc
2740 connection server_1;
2741 SET SQL_LOG_BIN=0;
2742 connection server_2;
2743 SET SQL_LOG_BIN=0;
2744 connection server_3;
2745 SET SQL_LOG_BIN=0;
2746 ****** TEST: One Composite Unique key
2747 connection server_1;
2748 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c2)) engine= InnoDB;;
2749 connection server_2;
2750 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c2)) engine= MyISAM;;
2751 connection server_3;
2752 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c2)) engine= MyISAM;;
2753 connection server_1;
2754 SET SQL_LOG_BIN=1;
2755 connection server_2;
2756 SET SQL_LOG_BIN=1;
2757 connection server_3;
2758 SET SQL_LOG_BIN=1;
2759 connection server_1;
2760 INSERT INTO t VALUES (1, '1', '1', '1' );
2761 INSERT INTO t VALUES (4, '4', '4', '4' );
2762 INSERT INTO t VALUES (7, '7', '7', '7' );
2763 INSERT INTO t VALUES (9, '9', '9', NULL );
2764 INSERT INTO t VALUES (2, '1', '2', '2' );
2765 INSERT INTO t VALUES (3, '1', '3', '2' );
2766 include/rpl_sync.inc
2767 connection server_1;
2768 UPDATE t SET c4 = '7';
2769 UPDATE t SET c4 = '5' WHERE c1 = 1;
2770 UPDATE t SET c2 = '5' WHERE c1 = 1;
2771 UPDATE t SET c1 = '5' WHERE c1 = 1;
2772 UPDATE t SET c4 = '8' WHERE c2 = '4';
2773 UPDATE t SET c1 = '8' WHERE c2 = '4';
2774 UPDATE t SET c2 = '8' WHERE c2 = '4';
2775 UPDATE t SET c3 = '0' WHERE c4 = NULL;
2776 UPDATE t SET c2 = '0' WHERE c4 = '0';
2777 UPDATE t SET c2 = '2' WHERE c4 = '2';
2778 include/rpl_sync.inc
2779 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2780 connection server_1;
2781 DELETE FROM t WHERE c1 = 7;
2782 DELETE FROM t WHERE c1 = 8;
2783 DELETE FROM t;
2784 include/rpl_sync.inc
2785 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2786 connection server_1;
2787 DROP TABLE t;
2788 include/rpl_sync.inc
2789 connection server_1;
2790 SET SQL_LOG_BIN=0;
2791 connection server_2;
2792 SET SQL_LOG_BIN=0;
2793 connection server_3;
2794 SET SQL_LOG_BIN=0;
2795 ****** TEST: One Unique key
2796 connection server_1;
2797 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1)) engine= InnoDB;;
2798 connection server_2;
2799 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1)) engine= MyISAM;;
2800 connection server_3;
2801 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1)) engine= MyISAM;;
2802 connection server_1;
2803 SET SQL_LOG_BIN=1;
2804 connection server_2;
2805 SET SQL_LOG_BIN=1;
2806 connection server_3;
2807 SET SQL_LOG_BIN=1;
2808 connection server_1;
2809 INSERT INTO t VALUES (1, '1', '1', '1' );
2810 INSERT INTO t VALUES (4, '4', '4', '4' );
2811 INSERT INTO t VALUES (7, '7', '7', '7' );
2812 INSERT INTO t VALUES (9, '9', '9', NULL );
2813 INSERT INTO t VALUES (2, '1', '2', '2' );
2814 INSERT INTO t VALUES (3, '1', '3', '2' );
2815 include/rpl_sync.inc
2816 connection server_1;
2817 UPDATE t SET c4 = '7';
2818 UPDATE t SET c4 = '5' WHERE c1 = 1;
2819 UPDATE t SET c2 = '5' WHERE c1 = 1;
2820 UPDATE t SET c1 = '5' WHERE c1 = 1;
2821 UPDATE t SET c4 = '8' WHERE c2 = '4';
2822 UPDATE t SET c1 = '8' WHERE c2 = '4';
2823 UPDATE t SET c2 = '8' WHERE c2 = '4';
2824 UPDATE t SET c3 = '0' WHERE c4 = NULL;
2825 UPDATE t SET c2 = '0' WHERE c4 = '0';
2826 UPDATE t SET c2 = '2' WHERE c4 = '2';
2827 include/rpl_sync.inc
2828 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2829 connection server_1;
2830 DELETE FROM t WHERE c1 = 7;
2831 DELETE FROM t WHERE c1 = 8;
2832 DELETE FROM t;
2833 include/rpl_sync.inc
2834 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2835 connection server_1;
2836 DROP TABLE t;
2837 include/rpl_sync.inc
2838 connection server_1;
2839 SET SQL_LOG_BIN=0;
2840 connection server_2;
2841 SET SQL_LOG_BIN=0;
2842 connection server_3;
2843 SET SQL_LOG_BIN=0;
2844 ****** TEST: One Composite key
2845 connection server_1;
2846 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c2)) engine= InnoDB;;
2847 connection server_2;
2848 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c2)) engine= MyISAM;;
2849 connection server_3;
2850 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c2)) engine= MyISAM;;
2851 connection server_1;
2852 SET SQL_LOG_BIN=1;
2853 connection server_2;
2854 SET SQL_LOG_BIN=1;
2855 connection server_3;
2856 SET SQL_LOG_BIN=1;
2857 connection server_1;
2858 INSERT INTO t VALUES (1, '1', '1', '1' );
2859 INSERT INTO t VALUES (4, '4', '4', '4' );
2860 INSERT INTO t VALUES (7, '7', '7', '7' );
2861 INSERT INTO t VALUES (9, '9', '9', NULL );
2862 INSERT INTO t VALUES (2, '1', '2', '2' );
2863 INSERT INTO t VALUES (3, '1', '3', '2' );
2864 include/rpl_sync.inc
2865 connection server_1;
2866 UPDATE t SET c4 = '7';
2867 UPDATE t SET c4 = '5' WHERE c1 = 1;
2868 UPDATE t SET c2 = '5' WHERE c1 = 1;
2869 UPDATE t SET c1 = '5' WHERE c1 = 1;
2870 UPDATE t SET c4 = '8' WHERE c2 = '4';
2871 UPDATE t SET c1 = '8' WHERE c2 = '4';
2872 UPDATE t SET c2 = '8' WHERE c2 = '4';
2873 UPDATE t SET c3 = '0' WHERE c4 = NULL;
2874 UPDATE t SET c2 = '0' WHERE c4 = '0';
2875 UPDATE t SET c2 = '2' WHERE c4 = '2';
2876 include/rpl_sync.inc
2877 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2878 connection server_1;
2879 DELETE FROM t WHERE c1 = 7;
2880 DELETE FROM t WHERE c1 = 8;
2881 DELETE FROM t;
2882 include/rpl_sync.inc
2883 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2884 connection server_1;
2885 DROP TABLE t;
2886 include/rpl_sync.inc
2887 connection server_1;
2888 SET SQL_LOG_BIN=0;
2889 connection server_2;
2890 SET SQL_LOG_BIN=0;
2891 connection server_3;
2892 SET SQL_LOG_BIN=0;
2893 ******* TEST: One key
2894 connection server_1;
2895 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1)) engine= InnoDB;;
2896 connection server_2;
2897 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1)) engine= MyISAM;;
2898 connection server_3;
2899 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1)) engine= MyISAM;;
2900 connection server_1;
2901 SET SQL_LOG_BIN=1;
2902 connection server_2;
2903 SET SQL_LOG_BIN=1;
2904 connection server_3;
2905 SET SQL_LOG_BIN=1;
2906 connection server_1;
2907 INSERT INTO t VALUES (1, '1', '1', '1' );
2908 INSERT INTO t VALUES (4, '4', '4', '4' );
2909 INSERT INTO t VALUES (7, '7', '7', '7' );
2910 INSERT INTO t VALUES (9, '9', '9', NULL );
2911 INSERT INTO t VALUES (2, '1', '2', '2' );
2912 INSERT INTO t VALUES (3, '1', '3', '2' );
2913 include/rpl_sync.inc
2914 connection server_1;
2915 UPDATE t SET c4 = '7';
2916 UPDATE t SET c4 = '5' WHERE c1 = 1;
2917 UPDATE t SET c2 = '5' WHERE c1 = 1;
2918 UPDATE t SET c1 = '5' WHERE c1 = 1;
2919 UPDATE t SET c4 = '8' WHERE c2 = '4';
2920 UPDATE t SET c1 = '8' WHERE c2 = '4';
2921 UPDATE t SET c2 = '8' WHERE c2 = '4';
2922 UPDATE t SET c3 = '0' WHERE c4 = NULL;
2923 UPDATE t SET c2 = '0' WHERE c4 = '0';
2924 UPDATE t SET c2 = '2' WHERE c4 = '2';
2925 include/rpl_sync.inc
2926 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2927 connection server_1;
2928 DELETE FROM t WHERE c1 = 7;
2929 DELETE FROM t WHERE c1 = 8;
2930 DELETE FROM t;
2931 include/rpl_sync.inc
2932 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2933 connection server_1;
2934 DROP TABLE t;
2935 include/rpl_sync.inc
2936 connection server_1;
2937 SET SQL_LOG_BIN=0;
2938 connection server_2;
2939 SET SQL_LOG_BIN=0;
2940 connection server_3;
2941 SET SQL_LOG_BIN=0;
2942 ******* TEST: No keys
2943 connection server_1;
2944 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1)) engine= InnoDB;;
2945 connection server_2;
2946 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1)) engine= MyISAM;;
2947 connection server_3;
2948 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1)) engine= MyISAM;;
2949 connection server_1;
2950 SET SQL_LOG_BIN=1;
2951 connection server_2;
2952 SET SQL_LOG_BIN=1;
2953 connection server_3;
2954 SET SQL_LOG_BIN=1;
2955 connection server_1;
2956 INSERT INTO t VALUES (1, '1', '1', '1' );
2957 INSERT INTO t VALUES (4, '4', '4', '4' );
2958 INSERT INTO t VALUES (7, '7', '7', '7' );
2959 INSERT INTO t VALUES (9, '9', '9', NULL );
2960 INSERT INTO t VALUES (2, '1', '2', '2' );
2961 INSERT INTO t VALUES (3, '1', '3', '2' );
2962 include/rpl_sync.inc
2963 connection server_1;
2964 UPDATE t SET c4 = '7';
2965 UPDATE t SET c4 = '5' WHERE c1 = 1;
2966 UPDATE t SET c2 = '5' WHERE c1 = 1;
2967 UPDATE t SET c1 = '5' WHERE c1 = 1;
2968 UPDATE t SET c4 = '8' WHERE c2 = '4';
2969 UPDATE t SET c1 = '8' WHERE c2 = '4';
2970 UPDATE t SET c2 = '8' WHERE c2 = '4';
2971 UPDATE t SET c3 = '0' WHERE c4 = NULL;
2972 UPDATE t SET c2 = '0' WHERE c4 = '0';
2973 UPDATE t SET c2 = '2' WHERE c4 = '2';
2974 include/rpl_sync.inc
2975 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2976 connection server_1;
2977 DELETE FROM t WHERE c1 = 7;
2978 DELETE FROM t WHERE c1 = 8;
2979 DELETE FROM t;
2980 include/rpl_sync.inc
2981 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2982 connection server_1;
2983 DROP TABLE t;
2984 include/rpl_sync.inc
2985 ### engines: InnoDB, MyISAM, InnoDB
2986 connection server_1;
2987 connection server_1;
2988 SET SQL_LOG_BIN=0;
2989 connection server_2;
2990 SET SQL_LOG_BIN=0;
2991 connection server_3;
2992 SET SQL_LOG_BIN=0;
2993 ****** TEST: One Composite NOT NULL Unique key with holes in master, but NULLABLE on first slave
2994 connection server_1;
2995 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= InnoDB;;
2996 connection server_2;
2997 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= MyISAM;;
2998 connection server_3;
2999 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= InnoDB;;
3000 connection server_1;
3001 SET SQL_LOG_BIN=1;
3002 connection server_2;
3003 SET SQL_LOG_BIN=1;
3004 connection server_3;
3005 SET SQL_LOG_BIN=1;
3006 connection server_1;
3007 INSERT INTO t VALUES (1, '1', '1', '1' );
3008 INSERT INTO t VALUES (4, '4', '4', '4' );
3009 INSERT INTO t VALUES (7, '7', '7', '7' );
3010 INSERT INTO t VALUES (9, '9', '9', NULL );
3011 INSERT INTO t VALUES (2, '1', '2', '2' );
3012 INSERT INTO t VALUES (3, '1', '3', '2' );
3013 include/rpl_sync.inc
3014 connection server_1;
3015 UPDATE t SET c4 = '7';
3016 UPDATE t SET c4 = '5' WHERE c1 = 1;
3017 UPDATE t SET c2 = '5' WHERE c1 = 1;
3018 UPDATE t SET c1 = '5' WHERE c1 = 1;
3019 UPDATE t SET c4 = '8' WHERE c2 = '4';
3020 UPDATE t SET c1 = '8' WHERE c2 = '4';
3021 UPDATE t SET c2 = '8' WHERE c2 = '4';
3022 UPDATE t SET c3 = '0' WHERE c4 = NULL;
3023 UPDATE t SET c2 = '0' WHERE c4 = '0';
3024 UPDATE t SET c2 = '2' WHERE c4 = '2';
3025 include/rpl_sync.inc
3026 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3027 connection server_1;
3028 DELETE FROM t WHERE c1 = 7;
3029 DELETE FROM t WHERE c1 = 8;
3030 DELETE FROM t;
3031 include/rpl_sync.inc
3032 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3033 connection server_1;
3034 DROP TABLE t;
3035 include/rpl_sync.inc
3036 connection server_1;
3037 SET SQL_LOG_BIN=0;
3038 connection server_2;
3039 SET SQL_LOG_BIN=0;
3040 connection server_3;
3041 SET SQL_LOG_BIN=0;
3042 ****** TEST: One Composite NOT NULL Unique key with holes
3043 connection server_1;
3044 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= InnoDB;;
3045 connection server_2;
3046 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= MyISAM;;
3047 connection server_3;
3048 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= InnoDB;;
3049 connection server_1;
3050 SET SQL_LOG_BIN=1;
3051 connection server_2;
3052 SET SQL_LOG_BIN=1;
3053 connection server_3;
3054 SET SQL_LOG_BIN=1;
3055 connection server_1;
3056 INSERT INTO t VALUES (1, '1', '1', '1' );
3057 INSERT INTO t VALUES (4, '4', '4', '4' );
3058 INSERT INTO t VALUES (7, '7', '7', '7' );
3059 INSERT INTO t VALUES (9, '9', '9', NULL );
3060 INSERT INTO t VALUES (2, '1', '2', '2' );
3061 INSERT INTO t VALUES (3, '1', '3', '2' );
3062 include/rpl_sync.inc
3063 connection server_1;
3064 UPDATE t SET c4 = '7';
3065 UPDATE t SET c4 = '5' WHERE c1 = 1;
3066 UPDATE t SET c2 = '5' WHERE c1 = 1;
3067 UPDATE t SET c1 = '5' WHERE c1 = 1;
3068 UPDATE t SET c4 = '8' WHERE c2 = '4';
3069 UPDATE t SET c1 = '8' WHERE c2 = '4';
3070 UPDATE t SET c2 = '8' WHERE c2 = '4';
3071 UPDATE t SET c3 = '0' WHERE c4 = NULL;
3072 UPDATE t SET c2 = '0' WHERE c4 = '0';
3073 UPDATE t SET c2 = '2' WHERE c4 = '2';
3074 include/rpl_sync.inc
3075 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3076 connection server_1;
3077 DELETE FROM t WHERE c1 = 7;
3078 DELETE FROM t WHERE c1 = 8;
3079 DELETE FROM t;
3080 include/rpl_sync.inc
3081 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3082 connection server_1;
3083 DROP TABLE t;
3084 include/rpl_sync.inc
3085 connection server_1;
3086 SET SQL_LOG_BIN=0;
3087 connection server_2;
3088 SET SQL_LOG_BIN=0;
3089 connection server_3;
3090 SET SQL_LOG_BIN=0;
3091 ****** TEST: One Composite Primary Key with holes
3092 connection server_1;
3093 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c3)) engine= InnoDB;;
3094 connection server_2;
3095 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c3)) engine= MyISAM;;
3096 connection server_3;
3097 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c3)) engine= InnoDB;;
3098 connection server_1;
3099 SET SQL_LOG_BIN=1;
3100 connection server_2;
3101 SET SQL_LOG_BIN=1;
3102 connection server_3;
3103 SET SQL_LOG_BIN=1;
3104 connection server_1;
3105 INSERT INTO t VALUES (1, '1', '1', '1' );
3106 INSERT INTO t VALUES (4, '4', '4', '4' );
3107 INSERT INTO t VALUES (7, '7', '7', '7' );
3108 INSERT INTO t VALUES (9, '9', '9', NULL );
3109 INSERT INTO t VALUES (2, '1', '2', '2' );
3110 INSERT INTO t VALUES (3, '1', '3', '2' );
3111 include/rpl_sync.inc
3112 connection server_1;
3113 UPDATE t SET c4 = '7';
3114 UPDATE t SET c4 = '5' WHERE c1 = 1;
3115 UPDATE t SET c2 = '5' WHERE c1 = 1;
3116 UPDATE t SET c1 = '5' WHERE c1 = 1;
3117 UPDATE t SET c4 = '8' WHERE c2 = '4';
3118 UPDATE t SET c1 = '8' WHERE c2 = '4';
3119 UPDATE t SET c2 = '8' WHERE c2 = '4';
3120 UPDATE t SET c3 = '0' WHERE c4 = NULL;
3121 UPDATE t SET c2 = '0' WHERE c4 = '0';
3122 UPDATE t SET c2 = '2' WHERE c4 = '2';
3123 include/rpl_sync.inc
3124 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3125 connection server_1;
3126 DELETE FROM t WHERE c1 = 7;
3127 DELETE FROM t WHERE c1 = 8;
3128 DELETE FROM t;
3129 include/rpl_sync.inc
3130 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3131 connection server_1;
3132 DROP TABLE t;
3133 include/rpl_sync.inc
3134 connection server_1;
3135 SET SQL_LOG_BIN=0;
3136 connection server_2;
3137 SET SQL_LOG_BIN=0;
3138 connection server_3;
3139 SET SQL_LOG_BIN=0;
3140 ****** TEST: One Composite Unique key with holes
3141 connection server_1;
3142 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= InnoDB;;
3143 connection server_2;
3144 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= MyISAM;;
3145 connection server_3;
3146 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= InnoDB;;
3147 connection server_1;
3148 SET SQL_LOG_BIN=1;
3149 connection server_2;
3150 SET SQL_LOG_BIN=1;
3151 connection server_3;
3152 SET SQL_LOG_BIN=1;
3153 connection server_1;
3154 INSERT INTO t VALUES (1, '1', '1', '1' );
3155 INSERT INTO t VALUES (4, '4', '4', '4' );
3156 INSERT INTO t VALUES (7, '7', '7', '7' );
3157 INSERT INTO t VALUES (9, '9', '9', NULL );
3158 INSERT INTO t VALUES (2, '1', '2', '2' );
3159 INSERT INTO t VALUES (3, '1', '3', '2' );
3160 include/rpl_sync.inc
3161 connection server_1;
3162 UPDATE t SET c4 = '7';
3163 UPDATE t SET c4 = '5' WHERE c1 = 1;
3164 UPDATE t SET c2 = '5' WHERE c1 = 1;
3165 UPDATE t SET c1 = '5' WHERE c1 = 1;
3166 UPDATE t SET c4 = '8' WHERE c2 = '4';
3167 UPDATE t SET c1 = '8' WHERE c2 = '4';
3168 UPDATE t SET c2 = '8' WHERE c2 = '4';
3169 UPDATE t SET c3 = '0' WHERE c4 = NULL;
3170 UPDATE t SET c2 = '0' WHERE c4 = '0';
3171 UPDATE t SET c2 = '2' WHERE c4 = '2';
3172 include/rpl_sync.inc
3173 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3174 connection server_1;
3175 DELETE FROM t WHERE c1 = 7;
3176 DELETE FROM t WHERE c1 = 8;
3177 DELETE FROM t;
3178 include/rpl_sync.inc
3179 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3180 connection server_1;
3181 DROP TABLE t;
3182 include/rpl_sync.inc
3183 connection server_1;
3184 SET SQL_LOG_BIN=0;
3185 connection server_2;
3186 SET SQL_LOG_BIN=0;
3187 connection server_3;
3188 SET SQL_LOG_BIN=0;
3189 ****** TEST: One Composite key with holes
3190 connection server_1;
3191 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c3)) engine= InnoDB;;
3192 connection server_2;
3193 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c3)) engine= MyISAM;;
3194 connection server_3;
3195 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c3)) engine= InnoDB;;
3196 connection server_1;
3197 SET SQL_LOG_BIN=1;
3198 connection server_2;
3199 SET SQL_LOG_BIN=1;
3200 connection server_3;
3201 SET SQL_LOG_BIN=1;
3202 connection server_1;
3203 INSERT INTO t VALUES (1, '1', '1', '1' );
3204 INSERT INTO t VALUES (4, '4', '4', '4' );
3205 INSERT INTO t VALUES (7, '7', '7', '7' );
3206 INSERT INTO t VALUES (9, '9', '9', NULL );
3207 INSERT INTO t VALUES (2, '1', '2', '2' );
3208 INSERT INTO t VALUES (3, '1', '3', '2' );
3209 include/rpl_sync.inc
3210 connection server_1;
3211 UPDATE t SET c4 = '7';
3212 UPDATE t SET c4 = '5' WHERE c1 = 1;
3213 UPDATE t SET c2 = '5' WHERE c1 = 1;
3214 UPDATE t SET c1 = '5' WHERE c1 = 1;
3215 UPDATE t SET c4 = '8' WHERE c2 = '4';
3216 UPDATE t SET c1 = '8' WHERE c2 = '4';
3217 UPDATE t SET c2 = '8' WHERE c2 = '4';
3218 UPDATE t SET c3 = '0' WHERE c4 = NULL;
3219 UPDATE t SET c2 = '0' WHERE c4 = '0';
3220 UPDATE t SET c2 = '2' WHERE c4 = '2';
3221 include/rpl_sync.inc
3222 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3223 connection server_1;
3224 DELETE FROM t WHERE c1 = 7;
3225 DELETE FROM t WHERE c1 = 8;
3226 DELETE FROM t;
3227 include/rpl_sync.inc
3228 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3229 connection server_1;
3230 DROP TABLE t;
3231 include/rpl_sync.inc
3232 connection server_1;
3233 SET SQL_LOG_BIN=0;
3234 connection server_2;
3235 SET SQL_LOG_BIN=0;
3236 connection server_3;
3237 SET SQL_LOG_BIN=0;
3238 ****** TEST: One Composite Primary Key
3239 connection server_1;
3240 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c2)) engine= InnoDB;;
3241 connection server_2;
3242 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c2)) engine= MyISAM;;
3243 connection server_3;
3244 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c2)) engine= InnoDB;;
3245 connection server_1;
3246 SET SQL_LOG_BIN=1;
3247 connection server_2;
3248 SET SQL_LOG_BIN=1;
3249 connection server_3;
3250 SET SQL_LOG_BIN=1;
3251 connection server_1;
3252 INSERT INTO t VALUES (1, '1', '1', '1' );
3253 INSERT INTO t VALUES (4, '4', '4', '4' );
3254 INSERT INTO t VALUES (7, '7', '7', '7' );
3255 INSERT INTO t VALUES (9, '9', '9', NULL );
3256 INSERT INTO t VALUES (2, '1', '2', '2' );
3257 INSERT INTO t VALUES (3, '1', '3', '2' );
3258 include/rpl_sync.inc
3259 connection server_1;
3260 UPDATE t SET c4 = '7';
3261 UPDATE t SET c4 = '5' WHERE c1 = 1;
3262 UPDATE t SET c2 = '5' WHERE c1 = 1;
3263 UPDATE t SET c1 = '5' WHERE c1 = 1;
3264 UPDATE t SET c4 = '8' WHERE c2 = '4';
3265 UPDATE t SET c1 = '8' WHERE c2 = '4';
3266 UPDATE t SET c2 = '8' WHERE c2 = '4';
3267 UPDATE t SET c3 = '0' WHERE c4 = NULL;
3268 UPDATE t SET c2 = '0' WHERE c4 = '0';
3269 UPDATE t SET c2 = '2' WHERE c4 = '2';
3270 include/rpl_sync.inc
3271 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3272 connection server_1;
3273 DELETE FROM t WHERE c1 = 7;
3274 DELETE FROM t WHERE c1 = 8;
3275 DELETE FROM t;
3276 include/rpl_sync.inc
3277 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3278 connection server_1;
3279 DROP TABLE t;
3280 include/rpl_sync.inc
3281 connection server_1;
3282 SET SQL_LOG_BIN=0;
3283 connection server_2;
3284 SET SQL_LOG_BIN=0;
3285 connection server_3;
3286 SET SQL_LOG_BIN=0;
3287 ****** TEST: One Primary key
3288 connection server_1;
3289 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1)) engine= InnoDB;;
3290 connection server_2;
3291 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1)) engine= MyISAM;;
3292 connection server_3;
3293 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1)) engine= InnoDB;;
3294 connection server_1;
3295 SET SQL_LOG_BIN=1;
3296 connection server_2;
3297 SET SQL_LOG_BIN=1;
3298 connection server_3;
3299 SET SQL_LOG_BIN=1;
3300 connection server_1;
3301 INSERT INTO t VALUES (1, '1', '1', '1' );
3302 INSERT INTO t VALUES (4, '4', '4', '4' );
3303 INSERT INTO t VALUES (7, '7', '7', '7' );
3304 INSERT INTO t VALUES (9, '9', '9', NULL );
3305 INSERT INTO t VALUES (2, '1', '2', '2' );
3306 INSERT INTO t VALUES (3, '1', '3', '2' );
3307 include/rpl_sync.inc
3308 connection server_1;
3309 UPDATE t SET c4 = '7';
3310 UPDATE t SET c4 = '5' WHERE c1 = 1;
3311 UPDATE t SET c2 = '5' WHERE c1 = 1;
3312 UPDATE t SET c1 = '5' WHERE c1 = 1;
3313 UPDATE t SET c4 = '8' WHERE c2 = '4';
3314 UPDATE t SET c1 = '8' WHERE c2 = '4';
3315 UPDATE t SET c2 = '8' WHERE c2 = '4';
3316 UPDATE t SET c3 = '0' WHERE c4 = NULL;
3317 UPDATE t SET c2 = '0' WHERE c4 = '0';
3318 UPDATE t SET c2 = '2' WHERE c4 = '2';
3319 include/rpl_sync.inc
3320 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3321 connection server_1;
3322 DELETE FROM t WHERE c1 = 7;
3323 DELETE FROM t WHERE c1 = 8;
3324 DELETE FROM t;
3325 include/rpl_sync.inc
3326 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3327 connection server_1;
3328 DROP TABLE t;
3329 include/rpl_sync.inc
3330 connection server_1;
3331 SET SQL_LOG_BIN=0;
3332 connection server_2;
3333 SET SQL_LOG_BIN=0;
3334 connection server_3;
3335 SET SQL_LOG_BIN=0;
3336 ****** TEST: One Composite Unique key
3337 connection server_1;
3338 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c2)) engine= InnoDB;;
3339 connection server_2;
3340 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c2)) engine= MyISAM;;
3341 connection server_3;
3342 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c2)) engine= InnoDB;;
3343 connection server_1;
3344 SET SQL_LOG_BIN=1;
3345 connection server_2;
3346 SET SQL_LOG_BIN=1;
3347 connection server_3;
3348 SET SQL_LOG_BIN=1;
3349 connection server_1;
3350 INSERT INTO t VALUES (1, '1', '1', '1' );
3351 INSERT INTO t VALUES (4, '4', '4', '4' );
3352 INSERT INTO t VALUES (7, '7', '7', '7' );
3353 INSERT INTO t VALUES (9, '9', '9', NULL );
3354 INSERT INTO t VALUES (2, '1', '2', '2' );
3355 INSERT INTO t VALUES (3, '1', '3', '2' );
3356 include/rpl_sync.inc
3357 connection server_1;
3358 UPDATE t SET c4 = '7';
3359 UPDATE t SET c4 = '5' WHERE c1 = 1;
3360 UPDATE t SET c2 = '5' WHERE c1 = 1;
3361 UPDATE t SET c1 = '5' WHERE c1 = 1;
3362 UPDATE t SET c4 = '8' WHERE c2 = '4';
3363 UPDATE t SET c1 = '8' WHERE c2 = '4';
3364 UPDATE t SET c2 = '8' WHERE c2 = '4';
3365 UPDATE t SET c3 = '0' WHERE c4 = NULL;
3366 UPDATE t SET c2 = '0' WHERE c4 = '0';
3367 UPDATE t SET c2 = '2' WHERE c4 = '2';
3368 include/rpl_sync.inc
3369 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3370 connection server_1;
3371 DELETE FROM t WHERE c1 = 7;
3372 DELETE FROM t WHERE c1 = 8;
3373 DELETE FROM t;
3374 include/rpl_sync.inc
3375 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3376 connection server_1;
3377 DROP TABLE t;
3378 include/rpl_sync.inc
3379 connection server_1;
3380 SET SQL_LOG_BIN=0;
3381 connection server_2;
3382 SET SQL_LOG_BIN=0;
3383 connection server_3;
3384 SET SQL_LOG_BIN=0;
3385 ****** TEST: One Unique key
3386 connection server_1;
3387 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1)) engine= InnoDB;;
3388 connection server_2;
3389 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1)) engine= MyISAM;;
3390 connection server_3;
3391 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1)) engine= InnoDB;;
3392 connection server_1;
3393 SET SQL_LOG_BIN=1;
3394 connection server_2;
3395 SET SQL_LOG_BIN=1;
3396 connection server_3;
3397 SET SQL_LOG_BIN=1;
3398 connection server_1;
3399 INSERT INTO t VALUES (1, '1', '1', '1' );
3400 INSERT INTO t VALUES (4, '4', '4', '4' );
3401 INSERT INTO t VALUES (7, '7', '7', '7' );
3402 INSERT INTO t VALUES (9, '9', '9', NULL );
3403 INSERT INTO t VALUES (2, '1', '2', '2' );
3404 INSERT INTO t VALUES (3, '1', '3', '2' );
3405 include/rpl_sync.inc
3406 connection server_1;
3407 UPDATE t SET c4 = '7';
3408 UPDATE t SET c4 = '5' WHERE c1 = 1;
3409 UPDATE t SET c2 = '5' WHERE c1 = 1;
3410 UPDATE t SET c1 = '5' WHERE c1 = 1;
3411 UPDATE t SET c4 = '8' WHERE c2 = '4';
3412 UPDATE t SET c1 = '8' WHERE c2 = '4';
3413 UPDATE t SET c2 = '8' WHERE c2 = '4';
3414 UPDATE t SET c3 = '0' WHERE c4 = NULL;
3415 UPDATE t SET c2 = '0' WHERE c4 = '0';
3416 UPDATE t SET c2 = '2' WHERE c4 = '2';
3417 include/rpl_sync.inc
3418 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3419 connection server_1;
3420 DELETE FROM t WHERE c1 = 7;
3421 DELETE FROM t WHERE c1 = 8;
3422 DELETE FROM t;
3423 include/rpl_sync.inc
3424 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3425 connection server_1;
3426 DROP TABLE t;
3427 include/rpl_sync.inc
3428 connection server_1;
3429 SET SQL_LOG_BIN=0;
3430 connection server_2;
3431 SET SQL_LOG_BIN=0;
3432 connection server_3;
3433 SET SQL_LOG_BIN=0;
3434 ****** TEST: One Composite key
3435 connection server_1;
3436 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c2)) engine= InnoDB;;
3437 connection server_2;
3438 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c2)) engine= MyISAM;;
3439 connection server_3;
3440 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c2)) engine= InnoDB;;
3441 connection server_1;
3442 SET SQL_LOG_BIN=1;
3443 connection server_2;
3444 SET SQL_LOG_BIN=1;
3445 connection server_3;
3446 SET SQL_LOG_BIN=1;
3447 connection server_1;
3448 INSERT INTO t VALUES (1, '1', '1', '1' );
3449 INSERT INTO t VALUES (4, '4', '4', '4' );
3450 INSERT INTO t VALUES (7, '7', '7', '7' );
3451 INSERT INTO t VALUES (9, '9', '9', NULL );
3452 INSERT INTO t VALUES (2, '1', '2', '2' );
3453 INSERT INTO t VALUES (3, '1', '3', '2' );
3454 include/rpl_sync.inc
3455 connection server_1;
3456 UPDATE t SET c4 = '7';
3457 UPDATE t SET c4 = '5' WHERE c1 = 1;
3458 UPDATE t SET c2 = '5' WHERE c1 = 1;
3459 UPDATE t SET c1 = '5' WHERE c1 = 1;
3460 UPDATE t SET c4 = '8' WHERE c2 = '4';
3461 UPDATE t SET c1 = '8' WHERE c2 = '4';
3462 UPDATE t SET c2 = '8' WHERE c2 = '4';
3463 UPDATE t SET c3 = '0' WHERE c4 = NULL;
3464 UPDATE t SET c2 = '0' WHERE c4 = '0';
3465 UPDATE t SET c2 = '2' WHERE c4 = '2';
3466 include/rpl_sync.inc
3467 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3468 connection server_1;
3469 DELETE FROM t WHERE c1 = 7;
3470 DELETE FROM t WHERE c1 = 8;
3471 DELETE FROM t;
3472 include/rpl_sync.inc
3473 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3474 connection server_1;
3475 DROP TABLE t;
3476 include/rpl_sync.inc
3477 connection server_1;
3478 SET SQL_LOG_BIN=0;
3479 connection server_2;
3480 SET SQL_LOG_BIN=0;
3481 connection server_3;
3482 SET SQL_LOG_BIN=0;
3483 ******* TEST: One key
3484 connection server_1;
3485 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1)) engine= InnoDB;;
3486 connection server_2;
3487 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1)) engine= MyISAM;;
3488 connection server_3;
3489 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1)) engine= InnoDB;;
3490 connection server_1;
3491 SET SQL_LOG_BIN=1;
3492 connection server_2;
3493 SET SQL_LOG_BIN=1;
3494 connection server_3;
3495 SET SQL_LOG_BIN=1;
3496 connection server_1;
3497 INSERT INTO t VALUES (1, '1', '1', '1' );
3498 INSERT INTO t VALUES (4, '4', '4', '4' );
3499 INSERT INTO t VALUES (7, '7', '7', '7' );
3500 INSERT INTO t VALUES (9, '9', '9', NULL );
3501 INSERT INTO t VALUES (2, '1', '2', '2' );
3502 INSERT INTO t VALUES (3, '1', '3', '2' );
3503 include/rpl_sync.inc
3504 connection server_1;
3505 UPDATE t SET c4 = '7';
3506 UPDATE t SET c4 = '5' WHERE c1 = 1;
3507 UPDATE t SET c2 = '5' WHERE c1 = 1;
3508 UPDATE t SET c1 = '5' WHERE c1 = 1;
3509 UPDATE t SET c4 = '8' WHERE c2 = '4';
3510 UPDATE t SET c1 = '8' WHERE c2 = '4';
3511 UPDATE t SET c2 = '8' WHERE c2 = '4';
3512 UPDATE t SET c3 = '0' WHERE c4 = NULL;
3513 UPDATE t SET c2 = '0' WHERE c4 = '0';
3514 UPDATE t SET c2 = '2' WHERE c4 = '2';
3515 include/rpl_sync.inc
3516 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3517 connection server_1;
3518 DELETE FROM t WHERE c1 = 7;
3519 DELETE FROM t WHERE c1 = 8;
3520 DELETE FROM t;
3521 include/rpl_sync.inc
3522 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3523 connection server_1;
3524 DROP TABLE t;
3525 include/rpl_sync.inc
3526 connection server_1;
3527 SET SQL_LOG_BIN=0;
3528 connection server_2;
3529 SET SQL_LOG_BIN=0;
3530 connection server_3;
3531 SET SQL_LOG_BIN=0;
3532 ******* TEST: No keys
3533 connection server_1;
3534 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1)) engine= InnoDB;;
3535 connection server_2;
3536 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1)) engine= MyISAM;;
3537 connection server_3;
3538 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1)) engine= InnoDB;;
3539 connection server_1;
3540 SET SQL_LOG_BIN=1;
3541 connection server_2;
3542 SET SQL_LOG_BIN=1;
3543 connection server_3;
3544 SET SQL_LOG_BIN=1;
3545 connection server_1;
3546 INSERT INTO t VALUES (1, '1', '1', '1' );
3547 INSERT INTO t VALUES (4, '4', '4', '4' );
3548 INSERT INTO t VALUES (7, '7', '7', '7' );
3549 INSERT INTO t VALUES (9, '9', '9', NULL );
3550 INSERT INTO t VALUES (2, '1', '2', '2' );
3551 INSERT INTO t VALUES (3, '1', '3', '2' );
3552 include/rpl_sync.inc
3553 connection server_1;
3554 UPDATE t SET c4 = '7';
3555 UPDATE t SET c4 = '5' WHERE c1 = 1;
3556 UPDATE t SET c2 = '5' WHERE c1 = 1;
3557 UPDATE t SET c1 = '5' WHERE c1 = 1;
3558 UPDATE t SET c4 = '8' WHERE c2 = '4';
3559 UPDATE t SET c1 = '8' WHERE c2 = '4';
3560 UPDATE t SET c2 = '8' WHERE c2 = '4';
3561 UPDATE t SET c3 = '0' WHERE c4 = NULL;
3562 UPDATE t SET c2 = '0' WHERE c4 = '0';
3563 UPDATE t SET c2 = '2' WHERE c4 = '2';
3564 include/rpl_sync.inc
3565 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3566 connection server_1;
3567 DELETE FROM t WHERE c1 = 7;
3568 DELETE FROM t WHERE c1 = 8;
3569 DELETE FROM t;
3570 include/rpl_sync.inc
3571 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3572 connection server_1;
3573 DROP TABLE t;
3574 include/rpl_sync.inc
3575 ### engines: InnoDB, InnoDB, MyISAM
3576 connection server_1;
3577 connection server_1;
3578 SET SQL_LOG_BIN=0;
3579 connection server_2;
3580 SET SQL_LOG_BIN=0;
3581 connection server_3;
3582 SET SQL_LOG_BIN=0;
3583 ****** TEST: One Composite NOT NULL Unique key with holes in master, but NULLABLE on first slave
3584 connection server_1;
3585 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= InnoDB;;
3586 connection server_2;
3587 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= InnoDB;;
3588 connection server_3;
3589 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= MyISAM;;
3590 connection server_1;
3591 SET SQL_LOG_BIN=1;
3592 connection server_2;
3593 SET SQL_LOG_BIN=1;
3594 connection server_3;
3595 SET SQL_LOG_BIN=1;
3596 connection server_1;
3597 INSERT INTO t VALUES (1, '1', '1', '1' );
3598 INSERT INTO t VALUES (4, '4', '4', '4' );
3599 INSERT INTO t VALUES (7, '7', '7', '7' );
3600 INSERT INTO t VALUES (9, '9', '9', NULL );
3601 INSERT INTO t VALUES (2, '1', '2', '2' );
3602 INSERT INTO t VALUES (3, '1', '3', '2' );
3603 include/rpl_sync.inc
3604 connection server_1;
3605 UPDATE t SET c4 = '7';
3606 UPDATE t SET c4 = '5' WHERE c1 = 1;
3607 UPDATE t SET c2 = '5' WHERE c1 = 1;
3608 UPDATE t SET c1 = '5' WHERE c1 = 1;
3609 UPDATE t SET c4 = '8' WHERE c2 = '4';
3610 UPDATE t SET c1 = '8' WHERE c2 = '4';
3611 UPDATE t SET c2 = '8' WHERE c2 = '4';
3612 UPDATE t SET c3 = '0' WHERE c4 = NULL;
3613 UPDATE t SET c2 = '0' WHERE c4 = '0';
3614 UPDATE t SET c2 = '2' WHERE c4 = '2';
3615 include/rpl_sync.inc
3616 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3617 connection server_1;
3618 DELETE FROM t WHERE c1 = 7;
3619 DELETE FROM t WHERE c1 = 8;
3620 DELETE FROM t;
3621 include/rpl_sync.inc
3622 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3623 connection server_1;
3624 DROP TABLE t;
3625 include/rpl_sync.inc
3626 connection server_1;
3627 SET SQL_LOG_BIN=0;
3628 connection server_2;
3629 SET SQL_LOG_BIN=0;
3630 connection server_3;
3631 SET SQL_LOG_BIN=0;
3632 ****** TEST: One Composite NOT NULL Unique key with holes
3633 connection server_1;
3634 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= InnoDB;;
3635 connection server_2;
3636 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= InnoDB;;
3637 connection server_3;
3638 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= MyISAM;;
3639 connection server_1;
3640 SET SQL_LOG_BIN=1;
3641 connection server_2;
3642 SET SQL_LOG_BIN=1;
3643 connection server_3;
3644 SET SQL_LOG_BIN=1;
3645 connection server_1;
3646 INSERT INTO t VALUES (1, '1', '1', '1' );
3647 INSERT INTO t VALUES (4, '4', '4', '4' );
3648 INSERT INTO t VALUES (7, '7', '7', '7' );
3649 INSERT INTO t VALUES (9, '9', '9', NULL );
3650 INSERT INTO t VALUES (2, '1', '2', '2' );
3651 INSERT INTO t VALUES (3, '1', '3', '2' );
3652 include/rpl_sync.inc
3653 connection server_1;
3654 UPDATE t SET c4 = '7';
3655 UPDATE t SET c4 = '5' WHERE c1 = 1;
3656 UPDATE t SET c2 = '5' WHERE c1 = 1;
3657 UPDATE t SET c1 = '5' WHERE c1 = 1;
3658 UPDATE t SET c4 = '8' WHERE c2 = '4';
3659 UPDATE t SET c1 = '8' WHERE c2 = '4';
3660 UPDATE t SET c2 = '8' WHERE c2 = '4';
3661 UPDATE t SET c3 = '0' WHERE c4 = NULL;
3662 UPDATE t SET c2 = '0' WHERE c4 = '0';
3663 UPDATE t SET c2 = '2' WHERE c4 = '2';
3664 include/rpl_sync.inc
3665 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3666 connection server_1;
3667 DELETE FROM t WHERE c1 = 7;
3668 DELETE FROM t WHERE c1 = 8;
3669 DELETE FROM t;
3670 include/rpl_sync.inc
3671 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3672 connection server_1;
3673 DROP TABLE t;
3674 include/rpl_sync.inc
3675 connection server_1;
3676 SET SQL_LOG_BIN=0;
3677 connection server_2;
3678 SET SQL_LOG_BIN=0;
3679 connection server_3;
3680 SET SQL_LOG_BIN=0;
3681 ****** TEST: One Composite Primary Key with holes
3682 connection server_1;
3683 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c3)) engine= InnoDB;;
3684 connection server_2;
3685 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c3)) engine= InnoDB;;
3686 connection server_3;
3687 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c3)) engine= MyISAM;;
3688 connection server_1;
3689 SET SQL_LOG_BIN=1;
3690 connection server_2;
3691 SET SQL_LOG_BIN=1;
3692 connection server_3;
3693 SET SQL_LOG_BIN=1;
3694 connection server_1;
3695 INSERT INTO t VALUES (1, '1', '1', '1' );
3696 INSERT INTO t VALUES (4, '4', '4', '4' );
3697 INSERT INTO t VALUES (7, '7', '7', '7' );
3698 INSERT INTO t VALUES (9, '9', '9', NULL );
3699 INSERT INTO t VALUES (2, '1', '2', '2' );
3700 INSERT INTO t VALUES (3, '1', '3', '2' );
3701 include/rpl_sync.inc
3702 connection server_1;
3703 UPDATE t SET c4 = '7';
3704 UPDATE t SET c4 = '5' WHERE c1 = 1;
3705 UPDATE t SET c2 = '5' WHERE c1 = 1;
3706 UPDATE t SET c1 = '5' WHERE c1 = 1;
3707 UPDATE t SET c4 = '8' WHERE c2 = '4';
3708 UPDATE t SET c1 = '8' WHERE c2 = '4';
3709 UPDATE t SET c2 = '8' WHERE c2 = '4';
3710 UPDATE t SET c3 = '0' WHERE c4 = NULL;
3711 UPDATE t SET c2 = '0' WHERE c4 = '0';
3712 UPDATE t SET c2 = '2' WHERE c4 = '2';
3713 include/rpl_sync.inc
3714 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3715 connection server_1;
3716 DELETE FROM t WHERE c1 = 7;
3717 DELETE FROM t WHERE c1 = 8;
3718 DELETE FROM t;
3719 include/rpl_sync.inc
3720 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3721 connection server_1;
3722 DROP TABLE t;
3723 include/rpl_sync.inc
3724 connection server_1;
3725 SET SQL_LOG_BIN=0;
3726 connection server_2;
3727 SET SQL_LOG_BIN=0;
3728 connection server_3;
3729 SET SQL_LOG_BIN=0;
3730 ****** TEST: One Composite Unique key with holes
3731 connection server_1;
3732 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= InnoDB;;
3733 connection server_2;
3734 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= InnoDB;;
3735 connection server_3;
3736 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= MyISAM;;
3737 connection server_1;
3738 SET SQL_LOG_BIN=1;
3739 connection server_2;
3740 SET SQL_LOG_BIN=1;
3741 connection server_3;
3742 SET SQL_LOG_BIN=1;
3743 connection server_1;
3744 INSERT INTO t VALUES (1, '1', '1', '1' );
3745 INSERT INTO t VALUES (4, '4', '4', '4' );
3746 INSERT INTO t VALUES (7, '7', '7', '7' );
3747 INSERT INTO t VALUES (9, '9', '9', NULL );
3748 INSERT INTO t VALUES (2, '1', '2', '2' );
3749 INSERT INTO t VALUES (3, '1', '3', '2' );
3750 include/rpl_sync.inc
3751 connection server_1;
3752 UPDATE t SET c4 = '7';
3753 UPDATE t SET c4 = '5' WHERE c1 = 1;
3754 UPDATE t SET c2 = '5' WHERE c1 = 1;
3755 UPDATE t SET c1 = '5' WHERE c1 = 1;
3756 UPDATE t SET c4 = '8' WHERE c2 = '4';
3757 UPDATE t SET c1 = '8' WHERE c2 = '4';
3758 UPDATE t SET c2 = '8' WHERE c2 = '4';
3759 UPDATE t SET c3 = '0' WHERE c4 = NULL;
3760 UPDATE t SET c2 = '0' WHERE c4 = '0';
3761 UPDATE t SET c2 = '2' WHERE c4 = '2';
3762 include/rpl_sync.inc
3763 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3764 connection server_1;
3765 DELETE FROM t WHERE c1 = 7;
3766 DELETE FROM t WHERE c1 = 8;
3767 DELETE FROM t;
3768 include/rpl_sync.inc
3769 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3770 connection server_1;
3771 DROP TABLE t;
3772 include/rpl_sync.inc
3773 connection server_1;
3774 SET SQL_LOG_BIN=0;
3775 connection server_2;
3776 SET SQL_LOG_BIN=0;
3777 connection server_3;
3778 SET SQL_LOG_BIN=0;
3779 ****** TEST: One Composite key with holes
3780 connection server_1;
3781 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c3)) engine= InnoDB;;
3782 connection server_2;
3783 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c3)) engine= InnoDB;;
3784 connection server_3;
3785 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c3)) engine= MyISAM;;
3786 connection server_1;
3787 SET SQL_LOG_BIN=1;
3788 connection server_2;
3789 SET SQL_LOG_BIN=1;
3790 connection server_3;
3791 SET SQL_LOG_BIN=1;
3792 connection server_1;
3793 INSERT INTO t VALUES (1, '1', '1', '1' );
3794 INSERT INTO t VALUES (4, '4', '4', '4' );
3795 INSERT INTO t VALUES (7, '7', '7', '7' );
3796 INSERT INTO t VALUES (9, '9', '9', NULL );
3797 INSERT INTO t VALUES (2, '1', '2', '2' );
3798 INSERT INTO t VALUES (3, '1', '3', '2' );
3799 include/rpl_sync.inc
3800 connection server_1;
3801 UPDATE t SET c4 = '7';
3802 UPDATE t SET c4 = '5' WHERE c1 = 1;
3803 UPDATE t SET c2 = '5' WHERE c1 = 1;
3804 UPDATE t SET c1 = '5' WHERE c1 = 1;
3805 UPDATE t SET c4 = '8' WHERE c2 = '4';
3806 UPDATE t SET c1 = '8' WHERE c2 = '4';
3807 UPDATE t SET c2 = '8' WHERE c2 = '4';
3808 UPDATE t SET c3 = '0' WHERE c4 = NULL;
3809 UPDATE t SET c2 = '0' WHERE c4 = '0';
3810 UPDATE t SET c2 = '2' WHERE c4 = '2';
3811 include/rpl_sync.inc
3812 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3813 connection server_1;
3814 DELETE FROM t WHERE c1 = 7;
3815 DELETE FROM t WHERE c1 = 8;
3816 DELETE FROM t;
3817 include/rpl_sync.inc
3818 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3819 connection server_1;
3820 DROP TABLE t;
3821 include/rpl_sync.inc
3822 connection server_1;
3823 SET SQL_LOG_BIN=0;
3824 connection server_2;
3825 SET SQL_LOG_BIN=0;
3826 connection server_3;
3827 SET SQL_LOG_BIN=0;
3828 ****** TEST: One Composite Primary Key
3829 connection server_1;
3830 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c2)) engine= InnoDB;;
3831 connection server_2;
3832 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c2)) engine= InnoDB;;
3833 connection server_3;
3834 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c2)) engine= MyISAM;;
3835 connection server_1;
3836 SET SQL_LOG_BIN=1;
3837 connection server_2;
3838 SET SQL_LOG_BIN=1;
3839 connection server_3;
3840 SET SQL_LOG_BIN=1;
3841 connection server_1;
3842 INSERT INTO t VALUES (1, '1', '1', '1' );
3843 INSERT INTO t VALUES (4, '4', '4', '4' );
3844 INSERT INTO t VALUES (7, '7', '7', '7' );
3845 INSERT INTO t VALUES (9, '9', '9', NULL );
3846 INSERT INTO t VALUES (2, '1', '2', '2' );
3847 INSERT INTO t VALUES (3, '1', '3', '2' );
3848 include/rpl_sync.inc
3849 connection server_1;
3850 UPDATE t SET c4 = '7';
3851 UPDATE t SET c4 = '5' WHERE c1 = 1;
3852 UPDATE t SET c2 = '5' WHERE c1 = 1;
3853 UPDATE t SET c1 = '5' WHERE c1 = 1;
3854 UPDATE t SET c4 = '8' WHERE c2 = '4';
3855 UPDATE t SET c1 = '8' WHERE c2 = '4';
3856 UPDATE t SET c2 = '8' WHERE c2 = '4';
3857 UPDATE t SET c3 = '0' WHERE c4 = NULL;
3858 UPDATE t SET c2 = '0' WHERE c4 = '0';
3859 UPDATE t SET c2 = '2' WHERE c4 = '2';
3860 include/rpl_sync.inc
3861 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3862 connection server_1;
3863 DELETE FROM t WHERE c1 = 7;
3864 DELETE FROM t WHERE c1 = 8;
3865 DELETE FROM t;
3866 include/rpl_sync.inc
3867 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3868 connection server_1;
3869 DROP TABLE t;
3870 include/rpl_sync.inc
3871 connection server_1;
3872 SET SQL_LOG_BIN=0;
3873 connection server_2;
3874 SET SQL_LOG_BIN=0;
3875 connection server_3;
3876 SET SQL_LOG_BIN=0;
3877 ****** TEST: One Primary key
3878 connection server_1;
3879 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1)) engine= InnoDB;;
3880 connection server_2;
3881 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1)) engine= InnoDB;;
3882 connection server_3;
3883 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1)) engine= MyISAM;;
3884 connection server_1;
3885 SET SQL_LOG_BIN=1;
3886 connection server_2;
3887 SET SQL_LOG_BIN=1;
3888 connection server_3;
3889 SET SQL_LOG_BIN=1;
3890 connection server_1;
3891 INSERT INTO t VALUES (1, '1', '1', '1' );
3892 INSERT INTO t VALUES (4, '4', '4', '4' );
3893 INSERT INTO t VALUES (7, '7', '7', '7' );
3894 INSERT INTO t VALUES (9, '9', '9', NULL );
3895 INSERT INTO t VALUES (2, '1', '2', '2' );
3896 INSERT INTO t VALUES (3, '1', '3', '2' );
3897 include/rpl_sync.inc
3898 connection server_1;
3899 UPDATE t SET c4 = '7';
3900 UPDATE t SET c4 = '5' WHERE c1 = 1;
3901 UPDATE t SET c2 = '5' WHERE c1 = 1;
3902 UPDATE t SET c1 = '5' WHERE c1 = 1;
3903 UPDATE t SET c4 = '8' WHERE c2 = '4';
3904 UPDATE t SET c1 = '8' WHERE c2 = '4';
3905 UPDATE t SET c2 = '8' WHERE c2 = '4';
3906 UPDATE t SET c3 = '0' WHERE c4 = NULL;
3907 UPDATE t SET c2 = '0' WHERE c4 = '0';
3908 UPDATE t SET c2 = '2' WHERE c4 = '2';
3909 include/rpl_sync.inc
3910 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3911 connection server_1;
3912 DELETE FROM t WHERE c1 = 7;
3913 DELETE FROM t WHERE c1 = 8;
3914 DELETE FROM t;
3915 include/rpl_sync.inc
3916 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3917 connection server_1;
3918 DROP TABLE t;
3919 include/rpl_sync.inc
3920 connection server_1;
3921 SET SQL_LOG_BIN=0;
3922 connection server_2;
3923 SET SQL_LOG_BIN=0;
3924 connection server_3;
3925 SET SQL_LOG_BIN=0;
3926 ****** TEST: One Composite Unique key
3927 connection server_1;
3928 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c2)) engine= InnoDB;;
3929 connection server_2;
3930 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c2)) engine= InnoDB;;
3931 connection server_3;
3932 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c2)) engine= MyISAM;;
3933 connection server_1;
3934 SET SQL_LOG_BIN=1;
3935 connection server_2;
3936 SET SQL_LOG_BIN=1;
3937 connection server_3;
3938 SET SQL_LOG_BIN=1;
3939 connection server_1;
3940 INSERT INTO t VALUES (1, '1', '1', '1' );
3941 INSERT INTO t VALUES (4, '4', '4', '4' );
3942 INSERT INTO t VALUES (7, '7', '7', '7' );
3943 INSERT INTO t VALUES (9, '9', '9', NULL );
3944 INSERT INTO t VALUES (2, '1', '2', '2' );
3945 INSERT INTO t VALUES (3, '1', '3', '2' );
3946 include/rpl_sync.inc
3947 connection server_1;
3948 UPDATE t SET c4 = '7';
3949 UPDATE t SET c4 = '5' WHERE c1 = 1;
3950 UPDATE t SET c2 = '5' WHERE c1 = 1;
3951 UPDATE t SET c1 = '5' WHERE c1 = 1;
3952 UPDATE t SET c4 = '8' WHERE c2 = '4';
3953 UPDATE t SET c1 = '8' WHERE c2 = '4';
3954 UPDATE t SET c2 = '8' WHERE c2 = '4';
3955 UPDATE t SET c3 = '0' WHERE c4 = NULL;
3956 UPDATE t SET c2 = '0' WHERE c4 = '0';
3957 UPDATE t SET c2 = '2' WHERE c4 = '2';
3958 include/rpl_sync.inc
3959 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3960 connection server_1;
3961 DELETE FROM t WHERE c1 = 7;
3962 DELETE FROM t WHERE c1 = 8;
3963 DELETE FROM t;
3964 include/rpl_sync.inc
3965 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3966 connection server_1;
3967 DROP TABLE t;
3968 include/rpl_sync.inc
3969 connection server_1;
3970 SET SQL_LOG_BIN=0;
3971 connection server_2;
3972 SET SQL_LOG_BIN=0;
3973 connection server_3;
3974 SET SQL_LOG_BIN=0;
3975 ****** TEST: One Unique key
3976 connection server_1;
3977 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1)) engine= InnoDB;;
3978 connection server_2;
3979 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1)) engine= InnoDB;;
3980 connection server_3;
3981 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1)) engine= MyISAM;;
3982 connection server_1;
3983 SET SQL_LOG_BIN=1;
3984 connection server_2;
3985 SET SQL_LOG_BIN=1;
3986 connection server_3;
3987 SET SQL_LOG_BIN=1;
3988 connection server_1;
3989 INSERT INTO t VALUES (1, '1', '1', '1' );
3990 INSERT INTO t VALUES (4, '4', '4', '4' );
3991 INSERT INTO t VALUES (7, '7', '7', '7' );
3992 INSERT INTO t VALUES (9, '9', '9', NULL );
3993 INSERT INTO t VALUES (2, '1', '2', '2' );
3994 INSERT INTO t VALUES (3, '1', '3', '2' );
3995 include/rpl_sync.inc
3996 connection server_1;
3997 UPDATE t SET c4 = '7';
3998 UPDATE t SET c4 = '5' WHERE c1 = 1;
3999 UPDATE t SET c2 = '5' WHERE c1 = 1;
4000 UPDATE t SET c1 = '5' WHERE c1 = 1;
4001 UPDATE t SET c4 = '8' WHERE c2 = '4';
4002 UPDATE t SET c1 = '8' WHERE c2 = '4';
4003 UPDATE t SET c2 = '8' WHERE c2 = '4';
4004 UPDATE t SET c3 = '0' WHERE c4 = NULL;
4005 UPDATE t SET c2 = '0' WHERE c4 = '0';
4006 UPDATE t SET c2 = '2' WHERE c4 = '2';
4007 include/rpl_sync.inc
4008 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4009 connection server_1;
4010 DELETE FROM t WHERE c1 = 7;
4011 DELETE FROM t WHERE c1 = 8;
4012 DELETE FROM t;
4013 include/rpl_sync.inc
4014 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4015 connection server_1;
4016 DROP TABLE t;
4017 include/rpl_sync.inc
4018 connection server_1;
4019 SET SQL_LOG_BIN=0;
4020 connection server_2;
4021 SET SQL_LOG_BIN=0;
4022 connection server_3;
4023 SET SQL_LOG_BIN=0;
4024 ****** TEST: One Composite key
4025 connection server_1;
4026 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c2)) engine= InnoDB;;
4027 connection server_2;
4028 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c2)) engine= InnoDB;;
4029 connection server_3;
4030 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c2)) engine= MyISAM;;
4031 connection server_1;
4032 SET SQL_LOG_BIN=1;
4033 connection server_2;
4034 SET SQL_LOG_BIN=1;
4035 connection server_3;
4036 SET SQL_LOG_BIN=1;
4037 connection server_1;
4038 INSERT INTO t VALUES (1, '1', '1', '1' );
4039 INSERT INTO t VALUES (4, '4', '4', '4' );
4040 INSERT INTO t VALUES (7, '7', '7', '7' );
4041 INSERT INTO t VALUES (9, '9', '9', NULL );
4042 INSERT INTO t VALUES (2, '1', '2', '2' );
4043 INSERT INTO t VALUES (3, '1', '3', '2' );
4044 include/rpl_sync.inc
4045 connection server_1;
4046 UPDATE t SET c4 = '7';
4047 UPDATE t SET c4 = '5' WHERE c1 = 1;
4048 UPDATE t SET c2 = '5' WHERE c1 = 1;
4049 UPDATE t SET c1 = '5' WHERE c1 = 1;
4050 UPDATE t SET c4 = '8' WHERE c2 = '4';
4051 UPDATE t SET c1 = '8' WHERE c2 = '4';
4052 UPDATE t SET c2 = '8' WHERE c2 = '4';
4053 UPDATE t SET c3 = '0' WHERE c4 = NULL;
4054 UPDATE t SET c2 = '0' WHERE c4 = '0';
4055 UPDATE t SET c2 = '2' WHERE c4 = '2';
4056 include/rpl_sync.inc
4057 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4058 connection server_1;
4059 DELETE FROM t WHERE c1 = 7;
4060 DELETE FROM t WHERE c1 = 8;
4061 DELETE FROM t;
4062 include/rpl_sync.inc
4063 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4064 connection server_1;
4065 DROP TABLE t;
4066 include/rpl_sync.inc
4067 connection server_1;
4068 SET SQL_LOG_BIN=0;
4069 connection server_2;
4070 SET SQL_LOG_BIN=0;
4071 connection server_3;
4072 SET SQL_LOG_BIN=0;
4073 ******* TEST: One key
4074 connection server_1;
4075 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1)) engine= InnoDB;;
4076 connection server_2;
4077 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1)) engine= InnoDB;;
4078 connection server_3;
4079 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1)) engine= MyISAM;;
4080 connection server_1;
4081 SET SQL_LOG_BIN=1;
4082 connection server_2;
4083 SET SQL_LOG_BIN=1;
4084 connection server_3;
4085 SET SQL_LOG_BIN=1;
4086 connection server_1;
4087 INSERT INTO t VALUES (1, '1', '1', '1' );
4088 INSERT INTO t VALUES (4, '4', '4', '4' );
4089 INSERT INTO t VALUES (7, '7', '7', '7' );
4090 INSERT INTO t VALUES (9, '9', '9', NULL );
4091 INSERT INTO t VALUES (2, '1', '2', '2' );
4092 INSERT INTO t VALUES (3, '1', '3', '2' );
4093 include/rpl_sync.inc
4094 connection server_1;
4095 UPDATE t SET c4 = '7';
4096 UPDATE t SET c4 = '5' WHERE c1 = 1;
4097 UPDATE t SET c2 = '5' WHERE c1 = 1;
4098 UPDATE t SET c1 = '5' WHERE c1 = 1;
4099 UPDATE t SET c4 = '8' WHERE c2 = '4';
4100 UPDATE t SET c1 = '8' WHERE c2 = '4';
4101 UPDATE t SET c2 = '8' WHERE c2 = '4';
4102 UPDATE t SET c3 = '0' WHERE c4 = NULL;
4103 UPDATE t SET c2 = '0' WHERE c4 = '0';
4104 UPDATE t SET c2 = '2' WHERE c4 = '2';
4105 include/rpl_sync.inc
4106 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4107 connection server_1;
4108 DELETE FROM t WHERE c1 = 7;
4109 DELETE FROM t WHERE c1 = 8;
4110 DELETE FROM t;
4111 include/rpl_sync.inc
4112 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4113 connection server_1;
4114 DROP TABLE t;
4115 include/rpl_sync.inc
4116 connection server_1;
4117 SET SQL_LOG_BIN=0;
4118 connection server_2;
4119 SET SQL_LOG_BIN=0;
4120 connection server_3;
4121 SET SQL_LOG_BIN=0;
4122 ******* TEST: No keys
4123 connection server_1;
4124 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1)) engine= InnoDB;;
4125 connection server_2;
4126 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1)) engine= InnoDB;;
4127 connection server_3;
4128 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1)) engine= MyISAM;;
4129 connection server_1;
4130 SET SQL_LOG_BIN=1;
4131 connection server_2;
4132 SET SQL_LOG_BIN=1;
4133 connection server_3;
4134 SET SQL_LOG_BIN=1;
4135 connection server_1;
4136 INSERT INTO t VALUES (1, '1', '1', '1' );
4137 INSERT INTO t VALUES (4, '4', '4', '4' );
4138 INSERT INTO t VALUES (7, '7', '7', '7' );
4139 INSERT INTO t VALUES (9, '9', '9', NULL );
4140 INSERT INTO t VALUES (2, '1', '2', '2' );
4141 INSERT INTO t VALUES (3, '1', '3', '2' );
4142 include/rpl_sync.inc
4143 connection server_1;
4144 UPDATE t SET c4 = '7';
4145 UPDATE t SET c4 = '5' WHERE c1 = 1;
4146 UPDATE t SET c2 = '5' WHERE c1 = 1;
4147 UPDATE t SET c1 = '5' WHERE c1 = 1;
4148 UPDATE t SET c4 = '8' WHERE c2 = '4';
4149 UPDATE t SET c1 = '8' WHERE c2 = '4';
4150 UPDATE t SET c2 = '8' WHERE c2 = '4';
4151 UPDATE t SET c3 = '0' WHERE c4 = NULL;
4152 UPDATE t SET c2 = '0' WHERE c4 = '0';
4153 UPDATE t SET c2 = '2' WHERE c4 = '2';
4154 include/rpl_sync.inc
4155 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4156 connection server_1;
4157 DELETE FROM t WHERE c1 = 7;
4158 DELETE FROM t WHERE c1 = 8;
4159 DELETE FROM t;
4160 include/rpl_sync.inc
4161 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4162 connection server_1;
4163 DROP TABLE t;
4164 include/rpl_sync.inc
4165 ### engines: InnoDB, InnoDB, InnoDB
4166 connection server_1;
4167 connection server_1;
4168 SET SQL_LOG_BIN=0;
4169 connection server_2;
4170 SET SQL_LOG_BIN=0;
4171 connection server_3;
4172 SET SQL_LOG_BIN=0;
4173 ****** TEST: One Composite NOT NULL Unique key with holes in master, but NULLABLE on first slave
4174 connection server_1;
4175 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= InnoDB;;
4176 connection server_2;
4177 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= InnoDB;;
4178 connection server_3;
4179 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= InnoDB;;
4180 connection server_1;
4181 SET SQL_LOG_BIN=1;
4182 connection server_2;
4183 SET SQL_LOG_BIN=1;
4184 connection server_3;
4185 SET SQL_LOG_BIN=1;
4186 connection server_1;
4187 INSERT INTO t VALUES (1, '1', '1', '1' );
4188 INSERT INTO t VALUES (4, '4', '4', '4' );
4189 INSERT INTO t VALUES (7, '7', '7', '7' );
4190 INSERT INTO t VALUES (9, '9', '9', NULL );
4191 INSERT INTO t VALUES (2, '1', '2', '2' );
4192 INSERT INTO t VALUES (3, '1', '3', '2' );
4193 include/rpl_sync.inc
4194 connection server_1;
4195 UPDATE t SET c4 = '7';
4196 UPDATE t SET c4 = '5' WHERE c1 = 1;
4197 UPDATE t SET c2 = '5' WHERE c1 = 1;
4198 UPDATE t SET c1 = '5' WHERE c1 = 1;
4199 UPDATE t SET c4 = '8' WHERE c2 = '4';
4200 UPDATE t SET c1 = '8' WHERE c2 = '4';
4201 UPDATE t SET c2 = '8' WHERE c2 = '4';
4202 UPDATE t SET c3 = '0' WHERE c4 = NULL;
4203 UPDATE t SET c2 = '0' WHERE c4 = '0';
4204 UPDATE t SET c2 = '2' WHERE c4 = '2';
4205 include/rpl_sync.inc
4206 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4207 connection server_1;
4208 DELETE FROM t WHERE c1 = 7;
4209 DELETE FROM t WHERE c1 = 8;
4210 DELETE FROM t;
4211 include/rpl_sync.inc
4212 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4213 connection server_1;
4214 DROP TABLE t;
4215 include/rpl_sync.inc
4216 connection server_1;
4217 SET SQL_LOG_BIN=0;
4218 connection server_2;
4219 SET SQL_LOG_BIN=0;
4220 connection server_3;
4221 SET SQL_LOG_BIN=0;
4222 ****** TEST: One Composite NOT NULL Unique key with holes
4223 connection server_1;
4224 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= InnoDB;;
4225 connection server_2;
4226 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= InnoDB;;
4227 connection server_3;
4228 CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= InnoDB;;
4229 connection server_1;
4230 SET SQL_LOG_BIN=1;
4231 connection server_2;
4232 SET SQL_LOG_BIN=1;
4233 connection server_3;
4234 SET SQL_LOG_BIN=1;
4235 connection server_1;
4236 INSERT INTO t VALUES (1, '1', '1', '1' );
4237 INSERT INTO t VALUES (4, '4', '4', '4' );
4238 INSERT INTO t VALUES (7, '7', '7', '7' );
4239 INSERT INTO t VALUES (9, '9', '9', NULL );
4240 INSERT INTO t VALUES (2, '1', '2', '2' );
4241 INSERT INTO t VALUES (3, '1', '3', '2' );
4242 include/rpl_sync.inc
4243 connection server_1;
4244 UPDATE t SET c4 = '7';
4245 UPDATE t SET c4 = '5' WHERE c1 = 1;
4246 UPDATE t SET c2 = '5' WHERE c1 = 1;
4247 UPDATE t SET c1 = '5' WHERE c1 = 1;
4248 UPDATE t SET c4 = '8' WHERE c2 = '4';
4249 UPDATE t SET c1 = '8' WHERE c2 = '4';
4250 UPDATE t SET c2 = '8' WHERE c2 = '4';
4251 UPDATE t SET c3 = '0' WHERE c4 = NULL;
4252 UPDATE t SET c2 = '0' WHERE c4 = '0';
4253 UPDATE t SET c2 = '2' WHERE c4 = '2';
4254 include/rpl_sync.inc
4255 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4256 connection server_1;
4257 DELETE FROM t WHERE c1 = 7;
4258 DELETE FROM t WHERE c1 = 8;
4259 DELETE FROM t;
4260 include/rpl_sync.inc
4261 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4262 connection server_1;
4263 DROP TABLE t;
4264 include/rpl_sync.inc
4265 connection server_1;
4266 SET SQL_LOG_BIN=0;
4267 connection server_2;
4268 SET SQL_LOG_BIN=0;
4269 connection server_3;
4270 SET SQL_LOG_BIN=0;
4271 ****** TEST: One Composite Primary Key with holes
4272 connection server_1;
4273 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c3)) engine= InnoDB;;
4274 connection server_2;
4275 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c3)) engine= InnoDB;;
4276 connection server_3;
4277 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c3)) engine= InnoDB;;
4278 connection server_1;
4279 SET SQL_LOG_BIN=1;
4280 connection server_2;
4281 SET SQL_LOG_BIN=1;
4282 connection server_3;
4283 SET SQL_LOG_BIN=1;
4284 connection server_1;
4285 INSERT INTO t VALUES (1, '1', '1', '1' );
4286 INSERT INTO t VALUES (4, '4', '4', '4' );
4287 INSERT INTO t VALUES (7, '7', '7', '7' );
4288 INSERT INTO t VALUES (9, '9', '9', NULL );
4289 INSERT INTO t VALUES (2, '1', '2', '2' );
4290 INSERT INTO t VALUES (3, '1', '3', '2' );
4291 include/rpl_sync.inc
4292 connection server_1;
4293 UPDATE t SET c4 = '7';
4294 UPDATE t SET c4 = '5' WHERE c1 = 1;
4295 UPDATE t SET c2 = '5' WHERE c1 = 1;
4296 UPDATE t SET c1 = '5' WHERE c1 = 1;
4297 UPDATE t SET c4 = '8' WHERE c2 = '4';
4298 UPDATE t SET c1 = '8' WHERE c2 = '4';
4299 UPDATE t SET c2 = '8' WHERE c2 = '4';
4300 UPDATE t SET c3 = '0' WHERE c4 = NULL;
4301 UPDATE t SET c2 = '0' WHERE c4 = '0';
4302 UPDATE t SET c2 = '2' WHERE c4 = '2';
4303 include/rpl_sync.inc
4304 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4305 connection server_1;
4306 DELETE FROM t WHERE c1 = 7;
4307 DELETE FROM t WHERE c1 = 8;
4308 DELETE FROM t;
4309 include/rpl_sync.inc
4310 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4311 connection server_1;
4312 DROP TABLE t;
4313 include/rpl_sync.inc
4314 connection server_1;
4315 SET SQL_LOG_BIN=0;
4316 connection server_2;
4317 SET SQL_LOG_BIN=0;
4318 connection server_3;
4319 SET SQL_LOG_BIN=0;
4320 ****** TEST: One Composite Unique key with holes
4321 connection server_1;
4322 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= InnoDB;;
4323 connection server_2;
4324 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= InnoDB;;
4325 connection server_3;
4326 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= InnoDB;;
4327 connection server_1;
4328 SET SQL_LOG_BIN=1;
4329 connection server_2;
4330 SET SQL_LOG_BIN=1;
4331 connection server_3;
4332 SET SQL_LOG_BIN=1;
4333 connection server_1;
4334 INSERT INTO t VALUES (1, '1', '1', '1' );
4335 INSERT INTO t VALUES (4, '4', '4', '4' );
4336 INSERT INTO t VALUES (7, '7', '7', '7' );
4337 INSERT INTO t VALUES (9, '9', '9', NULL );
4338 INSERT INTO t VALUES (2, '1', '2', '2' );
4339 INSERT INTO t VALUES (3, '1', '3', '2' );
4340 include/rpl_sync.inc
4341 connection server_1;
4342 UPDATE t SET c4 = '7';
4343 UPDATE t SET c4 = '5' WHERE c1 = 1;
4344 UPDATE t SET c2 = '5' WHERE c1 = 1;
4345 UPDATE t SET c1 = '5' WHERE c1 = 1;
4346 UPDATE t SET c4 = '8' WHERE c2 = '4';
4347 UPDATE t SET c1 = '8' WHERE c2 = '4';
4348 UPDATE t SET c2 = '8' WHERE c2 = '4';
4349 UPDATE t SET c3 = '0' WHERE c4 = NULL;
4350 UPDATE t SET c2 = '0' WHERE c4 = '0';
4351 UPDATE t SET c2 = '2' WHERE c4 = '2';
4352 include/rpl_sync.inc
4353 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4354 connection server_1;
4355 DELETE FROM t WHERE c1 = 7;
4356 DELETE FROM t WHERE c1 = 8;
4357 DELETE FROM t;
4358 include/rpl_sync.inc
4359 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4360 connection server_1;
4361 DROP TABLE t;
4362 include/rpl_sync.inc
4363 connection server_1;
4364 SET SQL_LOG_BIN=0;
4365 connection server_2;
4366 SET SQL_LOG_BIN=0;
4367 connection server_3;
4368 SET SQL_LOG_BIN=0;
4369 ****** TEST: One Composite key with holes
4370 connection server_1;
4371 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c3)) engine= InnoDB;;
4372 connection server_2;
4373 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c3)) engine= InnoDB;;
4374 connection server_3;
4375 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c3)) engine= InnoDB;;
4376 connection server_1;
4377 SET SQL_LOG_BIN=1;
4378 connection server_2;
4379 SET SQL_LOG_BIN=1;
4380 connection server_3;
4381 SET SQL_LOG_BIN=1;
4382 connection server_1;
4383 INSERT INTO t VALUES (1, '1', '1', '1' );
4384 INSERT INTO t VALUES (4, '4', '4', '4' );
4385 INSERT INTO t VALUES (7, '7', '7', '7' );
4386 INSERT INTO t VALUES (9, '9', '9', NULL );
4387 INSERT INTO t VALUES (2, '1', '2', '2' );
4388 INSERT INTO t VALUES (3, '1', '3', '2' );
4389 include/rpl_sync.inc
4390 connection server_1;
4391 UPDATE t SET c4 = '7';
4392 UPDATE t SET c4 = '5' WHERE c1 = 1;
4393 UPDATE t SET c2 = '5' WHERE c1 = 1;
4394 UPDATE t SET c1 = '5' WHERE c1 = 1;
4395 UPDATE t SET c4 = '8' WHERE c2 = '4';
4396 UPDATE t SET c1 = '8' WHERE c2 = '4';
4397 UPDATE t SET c2 = '8' WHERE c2 = '4';
4398 UPDATE t SET c3 = '0' WHERE c4 = NULL;
4399 UPDATE t SET c2 = '0' WHERE c4 = '0';
4400 UPDATE t SET c2 = '2' WHERE c4 = '2';
4401 include/rpl_sync.inc
4402 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4403 connection server_1;
4404 DELETE FROM t WHERE c1 = 7;
4405 DELETE FROM t WHERE c1 = 8;
4406 DELETE FROM t;
4407 include/rpl_sync.inc
4408 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4409 connection server_1;
4410 DROP TABLE t;
4411 include/rpl_sync.inc
4412 connection server_1;
4413 SET SQL_LOG_BIN=0;
4414 connection server_2;
4415 SET SQL_LOG_BIN=0;
4416 connection server_3;
4417 SET SQL_LOG_BIN=0;
4418 ****** TEST: One Composite Primary Key
4419 connection server_1;
4420 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c2)) engine= InnoDB;;
4421 connection server_2;
4422 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c2)) engine= InnoDB;;
4423 connection server_3;
4424 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c2)) engine= InnoDB;;
4425 connection server_1;
4426 SET SQL_LOG_BIN=1;
4427 connection server_2;
4428 SET SQL_LOG_BIN=1;
4429 connection server_3;
4430 SET SQL_LOG_BIN=1;
4431 connection server_1;
4432 INSERT INTO t VALUES (1, '1', '1', '1' );
4433 INSERT INTO t VALUES (4, '4', '4', '4' );
4434 INSERT INTO t VALUES (7, '7', '7', '7' );
4435 INSERT INTO t VALUES (9, '9', '9', NULL );
4436 INSERT INTO t VALUES (2, '1', '2', '2' );
4437 INSERT INTO t VALUES (3, '1', '3', '2' );
4438 include/rpl_sync.inc
4439 connection server_1;
4440 UPDATE t SET c4 = '7';
4441 UPDATE t SET c4 = '5' WHERE c1 = 1;
4442 UPDATE t SET c2 = '5' WHERE c1 = 1;
4443 UPDATE t SET c1 = '5' WHERE c1 = 1;
4444 UPDATE t SET c4 = '8' WHERE c2 = '4';
4445 UPDATE t SET c1 = '8' WHERE c2 = '4';
4446 UPDATE t SET c2 = '8' WHERE c2 = '4';
4447 UPDATE t SET c3 = '0' WHERE c4 = NULL;
4448 UPDATE t SET c2 = '0' WHERE c4 = '0';
4449 UPDATE t SET c2 = '2' WHERE c4 = '2';
4450 include/rpl_sync.inc
4451 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4452 connection server_1;
4453 DELETE FROM t WHERE c1 = 7;
4454 DELETE FROM t WHERE c1 = 8;
4455 DELETE FROM t;
4456 include/rpl_sync.inc
4457 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4458 connection server_1;
4459 DROP TABLE t;
4460 include/rpl_sync.inc
4461 connection server_1;
4462 SET SQL_LOG_BIN=0;
4463 connection server_2;
4464 SET SQL_LOG_BIN=0;
4465 connection server_3;
4466 SET SQL_LOG_BIN=0;
4467 ****** TEST: One Primary key
4468 connection server_1;
4469 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1)) engine= InnoDB;;
4470 connection server_2;
4471 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1)) engine= InnoDB;;
4472 connection server_3;
4473 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1)) engine= InnoDB;;
4474 connection server_1;
4475 SET SQL_LOG_BIN=1;
4476 connection server_2;
4477 SET SQL_LOG_BIN=1;
4478 connection server_3;
4479 SET SQL_LOG_BIN=1;
4480 connection server_1;
4481 INSERT INTO t VALUES (1, '1', '1', '1' );
4482 INSERT INTO t VALUES (4, '4', '4', '4' );
4483 INSERT INTO t VALUES (7, '7', '7', '7' );
4484 INSERT INTO t VALUES (9, '9', '9', NULL );
4485 INSERT INTO t VALUES (2, '1', '2', '2' );
4486 INSERT INTO t VALUES (3, '1', '3', '2' );
4487 include/rpl_sync.inc
4488 connection server_1;
4489 UPDATE t SET c4 = '7';
4490 UPDATE t SET c4 = '5' WHERE c1 = 1;
4491 UPDATE t SET c2 = '5' WHERE c1 = 1;
4492 UPDATE t SET c1 = '5' WHERE c1 = 1;
4493 UPDATE t SET c4 = '8' WHERE c2 = '4';
4494 UPDATE t SET c1 = '8' WHERE c2 = '4';
4495 UPDATE t SET c2 = '8' WHERE c2 = '4';
4496 UPDATE t SET c3 = '0' WHERE c4 = NULL;
4497 UPDATE t SET c2 = '0' WHERE c4 = '0';
4498 UPDATE t SET c2 = '2' WHERE c4 = '2';
4499 include/rpl_sync.inc
4500 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4501 connection server_1;
4502 DELETE FROM t WHERE c1 = 7;
4503 DELETE FROM t WHERE c1 = 8;
4504 DELETE FROM t;
4505 include/rpl_sync.inc
4506 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4507 connection server_1;
4508 DROP TABLE t;
4509 include/rpl_sync.inc
4510 connection server_1;
4511 SET SQL_LOG_BIN=0;
4512 connection server_2;
4513 SET SQL_LOG_BIN=0;
4514 connection server_3;
4515 SET SQL_LOG_BIN=0;
4516 ****** TEST: One Composite Unique key
4517 connection server_1;
4518 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c2)) engine= InnoDB;;
4519 connection server_2;
4520 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c2)) engine= InnoDB;;
4521 connection server_3;
4522 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c2)) engine= InnoDB;;
4523 connection server_1;
4524 SET SQL_LOG_BIN=1;
4525 connection server_2;
4526 SET SQL_LOG_BIN=1;
4527 connection server_3;
4528 SET SQL_LOG_BIN=1;
4529 connection server_1;
4530 INSERT INTO t VALUES (1, '1', '1', '1' );
4531 INSERT INTO t VALUES (4, '4', '4', '4' );
4532 INSERT INTO t VALUES (7, '7', '7', '7' );
4533 INSERT INTO t VALUES (9, '9', '9', NULL );
4534 INSERT INTO t VALUES (2, '1', '2', '2' );
4535 INSERT INTO t VALUES (3, '1', '3', '2' );
4536 include/rpl_sync.inc
4537 connection server_1;
4538 UPDATE t SET c4 = '7';
4539 UPDATE t SET c4 = '5' WHERE c1 = 1;
4540 UPDATE t SET c2 = '5' WHERE c1 = 1;
4541 UPDATE t SET c1 = '5' WHERE c1 = 1;
4542 UPDATE t SET c4 = '8' WHERE c2 = '4';
4543 UPDATE t SET c1 = '8' WHERE c2 = '4';
4544 UPDATE t SET c2 = '8' WHERE c2 = '4';
4545 UPDATE t SET c3 = '0' WHERE c4 = NULL;
4546 UPDATE t SET c2 = '0' WHERE c4 = '0';
4547 UPDATE t SET c2 = '2' WHERE c4 = '2';
4548 include/rpl_sync.inc
4549 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4550 connection server_1;
4551 DELETE FROM t WHERE c1 = 7;
4552 DELETE FROM t WHERE c1 = 8;
4553 DELETE FROM t;
4554 include/rpl_sync.inc
4555 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4556 connection server_1;
4557 DROP TABLE t;
4558 include/rpl_sync.inc
4559 connection server_1;
4560 SET SQL_LOG_BIN=0;
4561 connection server_2;
4562 SET SQL_LOG_BIN=0;
4563 connection server_3;
4564 SET SQL_LOG_BIN=0;
4565 ****** TEST: One Unique key
4566 connection server_1;
4567 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1)) engine= InnoDB;;
4568 connection server_2;
4569 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1)) engine= InnoDB;;
4570 connection server_3;
4571 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1)) engine= InnoDB;;
4572 connection server_1;
4573 SET SQL_LOG_BIN=1;
4574 connection server_2;
4575 SET SQL_LOG_BIN=1;
4576 connection server_3;
4577 SET SQL_LOG_BIN=1;
4578 connection server_1;
4579 INSERT INTO t VALUES (1, '1', '1', '1' );
4580 INSERT INTO t VALUES (4, '4', '4', '4' );
4581 INSERT INTO t VALUES (7, '7', '7', '7' );
4582 INSERT INTO t VALUES (9, '9', '9', NULL );
4583 INSERT INTO t VALUES (2, '1', '2', '2' );
4584 INSERT INTO t VALUES (3, '1', '3', '2' );
4585 include/rpl_sync.inc
4586 connection server_1;
4587 UPDATE t SET c4 = '7';
4588 UPDATE t SET c4 = '5' WHERE c1 = 1;
4589 UPDATE t SET c2 = '5' WHERE c1 = 1;
4590 UPDATE t SET c1 = '5' WHERE c1 = 1;
4591 UPDATE t SET c4 = '8' WHERE c2 = '4';
4592 UPDATE t SET c1 = '8' WHERE c2 = '4';
4593 UPDATE t SET c2 = '8' WHERE c2 = '4';
4594 UPDATE t SET c3 = '0' WHERE c4 = NULL;
4595 UPDATE t SET c2 = '0' WHERE c4 = '0';
4596 UPDATE t SET c2 = '2' WHERE c4 = '2';
4597 include/rpl_sync.inc
4598 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4599 connection server_1;
4600 DELETE FROM t WHERE c1 = 7;
4601 DELETE FROM t WHERE c1 = 8;
4602 DELETE FROM t;
4603 include/rpl_sync.inc
4604 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4605 connection server_1;
4606 DROP TABLE t;
4607 include/rpl_sync.inc
4608 connection server_1;
4609 SET SQL_LOG_BIN=0;
4610 connection server_2;
4611 SET SQL_LOG_BIN=0;
4612 connection server_3;
4613 SET SQL_LOG_BIN=0;
4614 ****** TEST: One Composite key
4615 connection server_1;
4616 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c2)) engine= InnoDB;;
4617 connection server_2;
4618 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c2)) engine= InnoDB;;
4619 connection server_3;
4620 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c2)) engine= InnoDB;;
4621 connection server_1;
4622 SET SQL_LOG_BIN=1;
4623 connection server_2;
4624 SET SQL_LOG_BIN=1;
4625 connection server_3;
4626 SET SQL_LOG_BIN=1;
4627 connection server_1;
4628 INSERT INTO t VALUES (1, '1', '1', '1' );
4629 INSERT INTO t VALUES (4, '4', '4', '4' );
4630 INSERT INTO t VALUES (7, '7', '7', '7' );
4631 INSERT INTO t VALUES (9, '9', '9', NULL );
4632 INSERT INTO t VALUES (2, '1', '2', '2' );
4633 INSERT INTO t VALUES (3, '1', '3', '2' );
4634 include/rpl_sync.inc
4635 connection server_1;
4636 UPDATE t SET c4 = '7';
4637 UPDATE t SET c4 = '5' WHERE c1 = 1;
4638 UPDATE t SET c2 = '5' WHERE c1 = 1;
4639 UPDATE t SET c1 = '5' WHERE c1 = 1;
4640 UPDATE t SET c4 = '8' WHERE c2 = '4';
4641 UPDATE t SET c1 = '8' WHERE c2 = '4';
4642 UPDATE t SET c2 = '8' WHERE c2 = '4';
4643 UPDATE t SET c3 = '0' WHERE c4 = NULL;
4644 UPDATE t SET c2 = '0' WHERE c4 = '0';
4645 UPDATE t SET c2 = '2' WHERE c4 = '2';
4646 include/rpl_sync.inc
4647 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4648 connection server_1;
4649 DELETE FROM t WHERE c1 = 7;
4650 DELETE FROM t WHERE c1 = 8;
4651 DELETE FROM t;
4652 include/rpl_sync.inc
4653 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4654 connection server_1;
4655 DROP TABLE t;
4656 include/rpl_sync.inc
4657 connection server_1;
4658 SET SQL_LOG_BIN=0;
4659 connection server_2;
4660 SET SQL_LOG_BIN=0;
4661 connection server_3;
4662 SET SQL_LOG_BIN=0;
4663 ******* TEST: One key
4664 connection server_1;
4665 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1)) engine= InnoDB;;
4666 connection server_2;
4667 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1)) engine= InnoDB;;
4668 connection server_3;
4669 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1)) engine= InnoDB;;
4670 connection server_1;
4671 SET SQL_LOG_BIN=1;
4672 connection server_2;
4673 SET SQL_LOG_BIN=1;
4674 connection server_3;
4675 SET SQL_LOG_BIN=1;
4676 connection server_1;
4677 INSERT INTO t VALUES (1, '1', '1', '1' );
4678 INSERT INTO t VALUES (4, '4', '4', '4' );
4679 INSERT INTO t VALUES (7, '7', '7', '7' );
4680 INSERT INTO t VALUES (9, '9', '9', NULL );
4681 INSERT INTO t VALUES (2, '1', '2', '2' );
4682 INSERT INTO t VALUES (3, '1', '3', '2' );
4683 include/rpl_sync.inc
4684 connection server_1;
4685 UPDATE t SET c4 = '7';
4686 UPDATE t SET c4 = '5' WHERE c1 = 1;
4687 UPDATE t SET c2 = '5' WHERE c1 = 1;
4688 UPDATE t SET c1 = '5' WHERE c1 = 1;
4689 UPDATE t SET c4 = '8' WHERE c2 = '4';
4690 UPDATE t SET c1 = '8' WHERE c2 = '4';
4691 UPDATE t SET c2 = '8' WHERE c2 = '4';
4692 UPDATE t SET c3 = '0' WHERE c4 = NULL;
4693 UPDATE t SET c2 = '0' WHERE c4 = '0';
4694 UPDATE t SET c2 = '2' WHERE c4 = '2';
4695 include/rpl_sync.inc
4696 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4697 connection server_1;
4698 DELETE FROM t WHERE c1 = 7;
4699 DELETE FROM t WHERE c1 = 8;
4700 DELETE FROM t;
4701 include/rpl_sync.inc
4702 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4703 connection server_1;
4704 DROP TABLE t;
4705 include/rpl_sync.inc
4706 connection server_1;
4707 SET SQL_LOG_BIN=0;
4708 connection server_2;
4709 SET SQL_LOG_BIN=0;
4710 connection server_3;
4711 SET SQL_LOG_BIN=0;
4712 ******* TEST: No keys
4713 connection server_1;
4714 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1)) engine= InnoDB;;
4715 connection server_2;
4716 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1)) engine= InnoDB;;
4717 connection server_3;
4718 CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1)) engine= InnoDB;;
4719 connection server_1;
4720 SET SQL_LOG_BIN=1;
4721 connection server_2;
4722 SET SQL_LOG_BIN=1;
4723 connection server_3;
4724 SET SQL_LOG_BIN=1;
4725 connection server_1;
4726 INSERT INTO t VALUES (1, '1', '1', '1' );
4727 INSERT INTO t VALUES (4, '4', '4', '4' );
4728 INSERT INTO t VALUES (7, '7', '7', '7' );
4729 INSERT INTO t VALUES (9, '9', '9', NULL );
4730 INSERT INTO t VALUES (2, '1', '2', '2' );
4731 INSERT INTO t VALUES (3, '1', '3', '2' );
4732 include/rpl_sync.inc
4733 connection server_1;
4734 UPDATE t SET c4 = '7';
4735 UPDATE t SET c4 = '5' WHERE c1 = 1;
4736 UPDATE t SET c2 = '5' WHERE c1 = 1;
4737 UPDATE t SET c1 = '5' WHERE c1 = 1;
4738 UPDATE t SET c4 = '8' WHERE c2 = '4';
4739 UPDATE t SET c1 = '8' WHERE c2 = '4';
4740 UPDATE t SET c2 = '8' WHERE c2 = '4';
4741 UPDATE t SET c3 = '0' WHERE c4 = NULL;
4742 UPDATE t SET c2 = '0' WHERE c4 = '0';
4743 UPDATE t SET c2 = '2' WHERE c4 = '2';
4744 include/rpl_sync.inc
4745 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4746 connection server_1;
4747 DELETE FROM t WHERE c1 = 7;
4748 DELETE FROM t WHERE c1 = 8;
4749 DELETE FROM t;
4750 include/rpl_sync.inc
4751 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
4752 connection server_1;
4753 DROP TABLE t;
4754 include/rpl_sync.inc
4755 CON: 'server_1', IMG: 'FULL', RESTART SLAVE: 'N'
4756 connection server_1;
4757 SET SESSION binlog_row_image= 'FULL';
4758 SET GLOBAL binlog_row_image= 'FULL';
4759 FLUSH TABLES;
4760 SHOW VARIABLES LIKE 'binlog_row_image';
4761 Variable_name Value
4762 binlog_row_image FULL
4763 CON: 'server_2', IMG: 'FULL', RESTART SLAVE: 'Y'
4764 connection server_2;
4765 SET SESSION binlog_row_image= 'FULL';
4766 SET GLOBAL binlog_row_image= 'FULL';
4767 include/stop_slave.inc
4768 include/start_slave.inc
4769 FLUSH TABLES;
4770 SHOW VARIABLES LIKE 'binlog_row_image';
4771 Variable_name Value
4772 binlog_row_image FULL
4773 CON: 'server_3', IMG: 'FULL', RESTART SLAVE: 'Y'
4774 connection server_3;
4775 SET SESSION binlog_row_image= 'FULL';
4776 SET GLOBAL binlog_row_image= 'FULL';
4777 include/stop_slave.inc
4778 include/start_slave.inc
4779 FLUSH TABLES;
4780 SHOW VARIABLES LIKE 'binlog_row_image';
4781 Variable_name Value
4782 binlog_row_image FULL
4783 connection server_1;
4784 include/rpl_end.inc