Debian Codegraph @

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

raw
1 include/rpl_init.inc [topology=1->2->3]
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 Warnings:
6 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
7 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
8 CALL mtr.add_suppression(".*Worker.*failed executing transaction.*at source log .*, end_log_pos.*Deadlock found when trying to get lock.*");
9 CON: 'server_1', IMG: 'NOBLOB', RESTART SLAVE: 'N'
10 SET SESSION binlog_row_image= 'NOBLOB';
11 SET GLOBAL binlog_row_image= 'NOBLOB';
12 FLUSH TABLES;
13 SHOW VARIABLES LIKE 'binlog_row_image';
14 Variable_name Value
15 binlog_row_image NOBLOB
16 CON: 'server_2', IMG: 'NOBLOB', RESTART SLAVE: 'Y'
17 SET SESSION binlog_row_image= 'NOBLOB';
18 SET GLOBAL binlog_row_image= 'NOBLOB';
19 include/stop_slave.inc
20 include/start_slave.inc
21 FLUSH TABLES;
22 SHOW VARIABLES LIKE 'binlog_row_image';
23 Variable_name Value
24 binlog_row_image NOBLOB
25 CON: 'server_3', IMG: 'NOBLOB', RESTART SLAVE: 'Y'
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 ### engines: MyISAM, MyISAM, MyISAM
35 include/rpl_sync.inc
36 SET SQL_LOG_BIN=0;
37 SET SQL_LOG_BIN=0;
38 SET SQL_LOG_BIN=0;
39 ### Master with no keys slaves with no keys as well
40 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;
41 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;
42 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;
43 SET SQL_LOG_BIN=1;
44 SET SQL_LOG_BIN=1;
45 SET SQL_LOG_BIN=1;
46 INSERT INTO t VALUES (1, "a", 10);
47 INSERT INTO t VALUES (2, "b", 20);
48 INSERT INTO t VALUES (3, "c", 30);
49 include/rpl_sync.inc
50 UPDATE t SET c1=10 WHERE c2="a";
51 UPDATE t SET c1=20 WHERE c1=2;
52 UPDATE t SET c1=30 WHERE c3=30;
53 UPDATE t SET c3=40 WHERE c1=30;
54 include/rpl_sync.inc
55 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
56 DELETE FROM t WHERE c2="a";
57 DELETE FROM t WHERE c1=20;
58 DELETE FROM t;
59 include/rpl_sync.inc
60 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
61 DROP TABLE t;
62 include/rpl_sync.inc
63 SET SQL_LOG_BIN=0;
64 SET SQL_LOG_BIN=0;
65 SET SQL_LOG_BIN=0;
66 ### Master with no key, slaves with keys
67 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
68 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= MyISAM;;
69 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= MyISAM;;
70 SET SQL_LOG_BIN=1;
71 SET SQL_LOG_BIN=1;
72 SET SQL_LOG_BIN=1;
73 INSERT INTO t VALUES (1, "a", 10);
74 INSERT INTO t VALUES (2, "b", 20);
75 INSERT INTO t VALUES (3, "c", 30);
76 include/rpl_sync.inc
77 UPDATE t SET c1=10 WHERE c2="a";
78 UPDATE t SET c1=20 WHERE c1=2;
79 UPDATE t SET c1=30 WHERE c3=30;
80 UPDATE t SET c3=40 WHERE c1=30;
81 include/rpl_sync.inc
82 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
83 DELETE FROM t WHERE c2="a";
84 DELETE FROM t WHERE c1=20;
85 DELETE FROM t;
86 include/rpl_sync.inc
87 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
88 DROP TABLE t;
89 include/rpl_sync.inc
90 SET SQL_LOG_BIN=0;
91 SET SQL_LOG_BIN=0;
92 SET SQL_LOG_BIN=0;
93 ### Master with no key, slaves with PKs on different fields (first slave with UK NOT NULL, second with PK)
94 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int) engine= MyISAM;;
95 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= MyISAM;;
96 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= MyISAM;;
97 SET SQL_LOG_BIN=1;
98 SET SQL_LOG_BIN=1;
99 SET SQL_LOG_BIN=1;
100 INSERT INTO t VALUES (1, "a", 10);
101 INSERT INTO t VALUES (2, "b", 20);
102 INSERT INTO t VALUES (3, "c", 30);
103 include/rpl_sync.inc
104 UPDATE t SET c1=10 WHERE c2="a";
105 UPDATE t SET c1=20 WHERE c1=2;
106 UPDATE t SET c1=30 WHERE c3=30;
107 UPDATE t SET c3=40 WHERE c1=30;
108 include/rpl_sync.inc
109 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
110 DELETE FROM t WHERE c2="a";
111 DELETE FROM t WHERE c1=20;
112 DELETE FROM t;
113 include/rpl_sync.inc
114 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
115 DROP TABLE t;
116 include/rpl_sync.inc
117 SET SQL_LOG_BIN=0;
118 SET SQL_LOG_BIN=0;
119 SET SQL_LOG_BIN=0;
120 ### Master with no key, slaves with PKs on different fields
121 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
122 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= MyISAM;;
123 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= MyISAM;;
124 SET SQL_LOG_BIN=1;
125 SET SQL_LOG_BIN=1;
126 SET SQL_LOG_BIN=1;
127 INSERT INTO t VALUES (1, "a", 10);
128 INSERT INTO t VALUES (2, "b", 20);
129 INSERT INTO t VALUES (3, "c", 30);
130 include/rpl_sync.inc
131 UPDATE t SET c1=10 WHERE c2="a";
132 UPDATE t SET c1=20 WHERE c1=2;
133 UPDATE t SET c1=30 WHERE c3=30;
134 UPDATE t SET c3=40 WHERE c1=30;
135 include/rpl_sync.inc
136 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
137 DELETE FROM t WHERE c2="a";
138 DELETE FROM t WHERE c1=20;
139 DELETE FROM t;
140 include/rpl_sync.inc
141 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
142 DROP TABLE t;
143 include/rpl_sync.inc
144 SET SQL_LOG_BIN=0;
145 SET SQL_LOG_BIN=0;
146 SET SQL_LOG_BIN=0;
147 ### Master with Key, slaves with no keys
148 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= MyISAM;;
149 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
150 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
151 SET SQL_LOG_BIN=1;
152 SET SQL_LOG_BIN=1;
153 SET SQL_LOG_BIN=1;
154 INSERT INTO t VALUES (1, "a", 10);
155 INSERT INTO t VALUES (2, "b", 20);
156 INSERT INTO t VALUES (3, "c", 30);
157 include/rpl_sync.inc
158 UPDATE t SET c1=10 WHERE c2="a";
159 UPDATE t SET c1=20 WHERE c1=2;
160 UPDATE t SET c1=30 WHERE c3=30;
161 UPDATE t SET c3=40 WHERE c1=30;
162 include/rpl_sync.inc
163 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
164 DELETE FROM t WHERE c2="a";
165 DELETE FROM t WHERE c1=20;
166 DELETE FROM t;
167 include/rpl_sync.inc
168 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
169 DROP TABLE t;
170 include/rpl_sync.inc
171 SET SQL_LOG_BIN=0;
172 SET SQL_LOG_BIN=0;
173 SET SQL_LOG_BIN=0;
174 ### Master with Key, first slave with key on different field and second slave with key on yet another different field.
175 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c1)) engine= MyISAM;;
176 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= MyISAM;;
177 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= MyISAM;;
178 SET SQL_LOG_BIN=1;
179 SET SQL_LOG_BIN=1;
180 SET SQL_LOG_BIN=1;
181 INSERT INTO t VALUES (1, "a", 10);
182 INSERT INTO t VALUES (2, "b", 20);
183 INSERT INTO t VALUES (3, "c", 30);
184 include/rpl_sync.inc
185 UPDATE t SET c1=10 WHERE c2="a";
186 UPDATE t SET c1=20 WHERE c1=2;
187 UPDATE t SET c1=30 WHERE c3=30;
188 UPDATE t SET c3=40 WHERE c1=30;
189 include/rpl_sync.inc
190 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
191 DELETE FROM t WHERE c2="a";
192 DELETE FROM t WHERE c1=20;
193 DELETE FROM t;
194 include/rpl_sync.inc
195 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
196 DROP TABLE t;
197 include/rpl_sync.inc
198 SET SQL_LOG_BIN=0;
199 SET SQL_LOG_BIN=0;
200 SET SQL_LOG_BIN=0;
201 ### Master with Key, slaves with PKs on different fields (first slave has UK NOT NULL)
202 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, key(c1)) engine= MyISAM;;
203 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= MyISAM;;
204 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= MyISAM;;
205 SET SQL_LOG_BIN=1;
206 SET SQL_LOG_BIN=1;
207 SET SQL_LOG_BIN=1;
208 INSERT INTO t VALUES (1, "a", 10);
209 INSERT INTO t VALUES (2, "b", 20);
210 INSERT INTO t VALUES (3, "c", 30);
211 include/rpl_sync.inc
212 UPDATE t SET c1=10 WHERE c2="a";
213 UPDATE t SET c1=20 WHERE c1=2;
214 UPDATE t SET c1=30 WHERE c3=30;
215 UPDATE t SET c3=40 WHERE c1=30;
216 include/rpl_sync.inc
217 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
218 DELETE FROM t WHERE c2="a";
219 DELETE FROM t WHERE c1=20;
220 DELETE FROM t;
221 include/rpl_sync.inc
222 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
223 DROP TABLE t;
224 include/rpl_sync.inc
225 SET SQL_LOG_BIN=0;
226 SET SQL_LOG_BIN=0;
227 SET SQL_LOG_BIN=0;
228 ### Master with Key, slaves with PKs on different fields
229 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c1)) engine= MyISAM;;
230 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= MyISAM;;
231 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= MyISAM;;
232 SET SQL_LOG_BIN=1;
233 SET SQL_LOG_BIN=1;
234 SET SQL_LOG_BIN=1;
235 INSERT INTO t VALUES (1, "a", 10);
236 INSERT INTO t VALUES (2, "b", 20);
237 INSERT INTO t VALUES (3, "c", 30);
238 include/rpl_sync.inc
239 UPDATE t SET c1=10 WHERE c2="a";
240 UPDATE t SET c1=20 WHERE c1=2;
241 UPDATE t SET c1=30 WHERE c3=30;
242 UPDATE t SET c3=40 WHERE c1=30;
243 include/rpl_sync.inc
244 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
245 DELETE FROM t WHERE c2="a";
246 DELETE FROM t WHERE c1=20;
247 DELETE FROM t;
248 include/rpl_sync.inc
249 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
250 DROP TABLE t;
251 include/rpl_sync.inc
252 SET SQL_LOG_BIN=0;
253 SET SQL_LOG_BIN=0;
254 SET SQL_LOG_BIN=0;
255 ### Master with UK NULLABLE, slaves with no keys
256 CREATE TABLE t (c1 int, c2 blob, c3 int, unique key(c3)) engine= MyISAM;;
257 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
258 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
259 SET SQL_LOG_BIN=1;
260 SET SQL_LOG_BIN=1;
261 SET SQL_LOG_BIN=1;
262 INSERT INTO t VALUES (1, "a", 10);
263 INSERT INTO t VALUES (2, "b", 20);
264 INSERT INTO t VALUES (3, "c", 30);
265 include/rpl_sync.inc
266 UPDATE t SET c1=10 WHERE c2="a";
267 UPDATE t SET c1=20 WHERE c1=2;
268 UPDATE t SET c1=30 WHERE c3=30;
269 UPDATE t SET c3=40 WHERE c1=30;
270 include/rpl_sync.inc
271 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
272 DELETE FROM t WHERE c2="a";
273 DELETE FROM t WHERE c1=20;
274 DELETE FROM t;
275 include/rpl_sync.inc
276 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
277 DROP TABLE t;
278 include/rpl_sync.inc
279 SET SQL_LOG_BIN=0;
280 SET SQL_LOG_BIN=0;
281 SET SQL_LOG_BIN=0;
282 ### Master with UK NULLABLE, first slave with K on different field second slave with key on yet another different field
283 CREATE TABLE t (c1 int, c2 blob, c3 int, unique key(c1)) engine= MyISAM;;
284 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= MyISAM;;
285 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= MyISAM;;
286 SET SQL_LOG_BIN=1;
287 SET SQL_LOG_BIN=1;
288 SET SQL_LOG_BIN=1;
289 INSERT INTO t VALUES (1, "a", 10);
290 INSERT INTO t VALUES (2, "b", 20);
291 INSERT INTO t VALUES (3, "c", 30);
292 include/rpl_sync.inc
293 UPDATE t SET c1=10 WHERE c2="a";
294 UPDATE t SET c1=20 WHERE c1=2;
295 UPDATE t SET c1=30 WHERE c3=30;
296 UPDATE t SET c3=40 WHERE c1=30;
297 include/rpl_sync.inc
298 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
299 DELETE FROM t WHERE c2="a";
300 DELETE FROM t WHERE c1=20;
301 DELETE FROM t;
302 include/rpl_sync.inc
303 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
304 DROP TABLE t;
305 include/rpl_sync.inc
306 SET SQL_LOG_BIN=0;
307 SET SQL_LOG_BIN=0;
308 SET SQL_LOG_BIN=0;
309 ### Master with UK NOT NULL, first slave with UK NOT NULL on different field
310 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c1)) engine= MyISAM;;
311 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= MyISAM;;
312 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= MyISAM;;
313 SET SQL_LOG_BIN=1;
314 SET SQL_LOG_BIN=1;
315 SET SQL_LOG_BIN=1;
316 INSERT INTO t VALUES (1, "a", 10);
317 INSERT INTO t VALUES (2, "b", 20);
318 INSERT INTO t VALUES (3, "c", 30);
319 include/rpl_sync.inc
320 UPDATE t SET c1=10 WHERE c2="a";
321 UPDATE t SET c1=20 WHERE c1=2;
322 UPDATE t SET c1=30 WHERE c3=30;
323 UPDATE t SET c3=40 WHERE c1=30;
324 include/rpl_sync.inc
325 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
326 DELETE FROM t WHERE c2="a";
327 DELETE FROM t WHERE c1=20;
328 DELETE FROM t;
329 include/rpl_sync.inc
330 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
331 DROP TABLE t;
332 include/rpl_sync.inc
333 SET SQL_LOG_BIN=0;
334 SET SQL_LOG_BIN=0;
335 SET SQL_LOG_BIN=0;
336 ### Master with UK NOT NULL and slaves with PK on different fields
337 CREATE TABLE t (c1 int NOT NULL, c2 blob, c3 int, unique key(c1)) engine= MyISAM;;
338 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= MyISAM;;
339 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= MyISAM;;
340 SET SQL_LOG_BIN=1;
341 SET SQL_LOG_BIN=1;
342 SET SQL_LOG_BIN=1;
343 INSERT INTO t VALUES (1, "a", 10);
344 INSERT INTO t VALUES (2, "b", 20);
345 INSERT INTO t VALUES (3, "c", 30);
346 include/rpl_sync.inc
347 UPDATE t SET c1=10 WHERE c2="a";
348 UPDATE t SET c1=20 WHERE c1=2;
349 UPDATE t SET c1=30 WHERE c3=30;
350 UPDATE t SET c3=40 WHERE c1=30;
351 include/rpl_sync.inc
352 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
353 DELETE FROM t WHERE c2="a";
354 DELETE FROM t WHERE c1=20;
355 DELETE FROM t;
356 include/rpl_sync.inc
357 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
358 DROP TABLE t;
359 include/rpl_sync.inc
360 SET SQL_LOG_BIN=0;
361 SET SQL_LOG_BIN=0;
362 SET SQL_LOG_BIN=0;
363 ### Master with PK and no keys on the slaves
364 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c3)) engine= MyISAM;;
365 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
366 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
367 SET SQL_LOG_BIN=1;
368 SET SQL_LOG_BIN=1;
369 SET SQL_LOG_BIN=1;
370 INSERT INTO t VALUES (1, "a", 10);
371 INSERT INTO t VALUES (2, "b", 20);
372 INSERT INTO t VALUES (3, "c", 30);
373 include/rpl_sync.inc
374 UPDATE t SET c1=10 WHERE c2="a";
375 UPDATE t SET c1=20 WHERE c1=2;
376 UPDATE t SET c1=30 WHERE c3=30;
377 UPDATE t SET c3=40 WHERE c1=30;
378 include/rpl_sync.inc
379 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
380 DELETE FROM t WHERE c2="a";
381 DELETE FROM t WHERE c1=20;
382 DELETE FROM t;
383 include/rpl_sync.inc
384 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
385 DROP TABLE t;
386 include/rpl_sync.inc
387 SET SQL_LOG_BIN=0;
388 SET SQL_LOG_BIN=0;
389 SET SQL_LOG_BIN=0;
390 ### Master with PK and first slave with KEY only
391 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= MyISAM;;
392 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= MyISAM;;
393 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= MyISAM;;
394 SET SQL_LOG_BIN=1;
395 SET SQL_LOG_BIN=1;
396 SET SQL_LOG_BIN=1;
397 INSERT INTO t VALUES (1, "a", 10);
398 INSERT INTO t VALUES (2, "b", 20);
399 INSERT INTO t VALUES (3, "c", 30);
400 include/rpl_sync.inc
401 UPDATE t SET c1=10 WHERE c2="a";
402 UPDATE t SET c1=20 WHERE c1=2;
403 UPDATE t SET c1=30 WHERE c3=30;
404 UPDATE t SET c3=40 WHERE c1=30;
405 include/rpl_sync.inc
406 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
407 DELETE FROM t WHERE c2="a";
408 DELETE FROM t WHERE c1=20;
409 DELETE FROM t;
410 include/rpl_sync.inc
411 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
412 DROP TABLE t;
413 include/rpl_sync.inc
414 SET SQL_LOG_BIN=0;
415 SET SQL_LOG_BIN=0;
416 SET SQL_LOG_BIN=0;
417 ### Different PKs on master and first slave (which has unique NOT NULL key instead of PK)
418 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= MyISAM;;
419 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= MyISAM;;
420 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= MyISAM;;
421 SET SQL_LOG_BIN=1;
422 SET SQL_LOG_BIN=1;
423 SET SQL_LOG_BIN=1;
424 INSERT INTO t VALUES (1, "a", 10);
425 INSERT INTO t VALUES (2, "b", 20);
426 INSERT INTO t VALUES (3, "c", 30);
427 include/rpl_sync.inc
428 UPDATE t SET c1=10 WHERE c2="a";
429 UPDATE t SET c1=20 WHERE c1=2;
430 UPDATE t SET c1=30 WHERE c3=30;
431 UPDATE t SET c3=40 WHERE c1=30;
432 include/rpl_sync.inc
433 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
434 DELETE FROM t WHERE c2="a";
435 DELETE FROM t WHERE c1=20;
436 DELETE FROM t;
437 include/rpl_sync.inc
438 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
439 DROP TABLE t;
440 include/rpl_sync.inc
441 SET SQL_LOG_BIN=0;
442 SET SQL_LOG_BIN=0;
443 SET SQL_LOG_BIN=0;
444 ### Different PKs on master and first slave
445 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= MyISAM;;
446 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= MyISAM;;
447 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= MyISAM;;
448 SET SQL_LOG_BIN=1;
449 SET SQL_LOG_BIN=1;
450 SET SQL_LOG_BIN=1;
451 INSERT INTO t VALUES (1, "a", 10);
452 INSERT INTO t VALUES (2, "b", 20);
453 INSERT INTO t VALUES (3, "c", 30);
454 include/rpl_sync.inc
455 UPDATE t SET c1=10 WHERE c2="a";
456 UPDATE t SET c1=20 WHERE c1=2;
457 UPDATE t SET c1=30 WHERE c3=30;
458 UPDATE t SET c3=40 WHERE c1=30;
459 include/rpl_sync.inc
460 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
461 DELETE FROM t WHERE c2="a";
462 DELETE FROM t WHERE c1=20;
463 DELETE FROM t;
464 include/rpl_sync.inc
465 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
466 DROP TABLE t;
467 include/rpl_sync.inc
468 ### engines: MyISAM, MyISAM, InnoDB
469 include/rpl_sync.inc
470 SET SQL_LOG_BIN=0;
471 SET SQL_LOG_BIN=0;
472 SET SQL_LOG_BIN=0;
473 ### Master with no keys slaves with no keys as well
474 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;
475 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;
476 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;
477 SET SQL_LOG_BIN=1;
478 SET SQL_LOG_BIN=1;
479 SET SQL_LOG_BIN=1;
480 INSERT INTO t VALUES (1, "a", 10);
481 INSERT INTO t VALUES (2, "b", 20);
482 INSERT INTO t VALUES (3, "c", 30);
483 include/rpl_sync.inc
484 UPDATE t SET c1=10 WHERE c2="a";
485 UPDATE t SET c1=20 WHERE c1=2;
486 UPDATE t SET c1=30 WHERE c3=30;
487 UPDATE t SET c3=40 WHERE c1=30;
488 include/rpl_sync.inc
489 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
490 DELETE FROM t WHERE c2="a";
491 DELETE FROM t WHERE c1=20;
492 DELETE FROM t;
493 include/rpl_sync.inc
494 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
495 DROP TABLE t;
496 include/rpl_sync.inc
497 SET SQL_LOG_BIN=0;
498 SET SQL_LOG_BIN=0;
499 SET SQL_LOG_BIN=0;
500 ### Master with no key, slaves with keys
501 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
502 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= MyISAM;;
503 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= InnoDB;;
504 SET SQL_LOG_BIN=1;
505 SET SQL_LOG_BIN=1;
506 SET SQL_LOG_BIN=1;
507 INSERT INTO t VALUES (1, "a", 10);
508 INSERT INTO t VALUES (2, "b", 20);
509 INSERT INTO t VALUES (3, "c", 30);
510 include/rpl_sync.inc
511 UPDATE t SET c1=10 WHERE c2="a";
512 UPDATE t SET c1=20 WHERE c1=2;
513 UPDATE t SET c1=30 WHERE c3=30;
514 UPDATE t SET c3=40 WHERE c1=30;
515 include/rpl_sync.inc
516 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
517 DELETE FROM t WHERE c2="a";
518 DELETE FROM t WHERE c1=20;
519 DELETE FROM t;
520 include/rpl_sync.inc
521 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
522 DROP TABLE t;
523 include/rpl_sync.inc
524 SET SQL_LOG_BIN=0;
525 SET SQL_LOG_BIN=0;
526 SET SQL_LOG_BIN=0;
527 ### Master with no key, slaves with PKs on different fields (first slave with UK NOT NULL, second with PK)
528 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int) engine= MyISAM;;
529 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= MyISAM;;
530 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= InnoDB;;
531 SET SQL_LOG_BIN=1;
532 SET SQL_LOG_BIN=1;
533 SET SQL_LOG_BIN=1;
534 INSERT INTO t VALUES (1, "a", 10);
535 INSERT INTO t VALUES (2, "b", 20);
536 INSERT INTO t VALUES (3, "c", 30);
537 include/rpl_sync.inc
538 UPDATE t SET c1=10 WHERE c2="a";
539 UPDATE t SET c1=20 WHERE c1=2;
540 UPDATE t SET c1=30 WHERE c3=30;
541 UPDATE t SET c3=40 WHERE c1=30;
542 include/rpl_sync.inc
543 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
544 DELETE FROM t WHERE c2="a";
545 DELETE FROM t WHERE c1=20;
546 DELETE FROM t;
547 include/rpl_sync.inc
548 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
549 DROP TABLE t;
550 include/rpl_sync.inc
551 SET SQL_LOG_BIN=0;
552 SET SQL_LOG_BIN=0;
553 SET SQL_LOG_BIN=0;
554 ### Master with no key, slaves with PKs on different fields
555 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
556 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= MyISAM;;
557 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= InnoDB;;
558 SET SQL_LOG_BIN=1;
559 SET SQL_LOG_BIN=1;
560 SET SQL_LOG_BIN=1;
561 INSERT INTO t VALUES (1, "a", 10);
562 INSERT INTO t VALUES (2, "b", 20);
563 INSERT INTO t VALUES (3, "c", 30);
564 include/rpl_sync.inc
565 UPDATE t SET c1=10 WHERE c2="a";
566 UPDATE t SET c1=20 WHERE c1=2;
567 UPDATE t SET c1=30 WHERE c3=30;
568 UPDATE t SET c3=40 WHERE c1=30;
569 include/rpl_sync.inc
570 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
571 DELETE FROM t WHERE c2="a";
572 DELETE FROM t WHERE c1=20;
573 DELETE FROM t;
574 include/rpl_sync.inc
575 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
576 DROP TABLE t;
577 include/rpl_sync.inc
578 SET SQL_LOG_BIN=0;
579 SET SQL_LOG_BIN=0;
580 SET SQL_LOG_BIN=0;
581 ### Master with Key, slaves with no keys
582 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= MyISAM;;
583 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
584 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
585 SET SQL_LOG_BIN=1;
586 SET SQL_LOG_BIN=1;
587 SET SQL_LOG_BIN=1;
588 INSERT INTO t VALUES (1, "a", 10);
589 INSERT INTO t VALUES (2, "b", 20);
590 INSERT INTO t VALUES (3, "c", 30);
591 include/rpl_sync.inc
592 UPDATE t SET c1=10 WHERE c2="a";
593 UPDATE t SET c1=20 WHERE c1=2;
594 UPDATE t SET c1=30 WHERE c3=30;
595 UPDATE t SET c3=40 WHERE c1=30;
596 include/rpl_sync.inc
597 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
598 DELETE FROM t WHERE c2="a";
599 DELETE FROM t WHERE c1=20;
600 DELETE FROM t;
601 include/rpl_sync.inc
602 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
603 DROP TABLE t;
604 include/rpl_sync.inc
605 SET SQL_LOG_BIN=0;
606 SET SQL_LOG_BIN=0;
607 SET SQL_LOG_BIN=0;
608 ### Master with Key, first slave with key on different field and second slave with key on yet another different field.
609 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c1)) engine= MyISAM;;
610 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= MyISAM;;
611 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= InnoDB;;
612 SET SQL_LOG_BIN=1;
613 SET SQL_LOG_BIN=1;
614 SET SQL_LOG_BIN=1;
615 INSERT INTO t VALUES (1, "a", 10);
616 INSERT INTO t VALUES (2, "b", 20);
617 INSERT INTO t VALUES (3, "c", 30);
618 include/rpl_sync.inc
619 UPDATE t SET c1=10 WHERE c2="a";
620 UPDATE t SET c1=20 WHERE c1=2;
621 UPDATE t SET c1=30 WHERE c3=30;
622 UPDATE t SET c3=40 WHERE c1=30;
623 include/rpl_sync.inc
624 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
625 DELETE FROM t WHERE c2="a";
626 DELETE FROM t WHERE c1=20;
627 DELETE FROM t;
628 include/rpl_sync.inc
629 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
630 DROP TABLE t;
631 include/rpl_sync.inc
632 SET SQL_LOG_BIN=0;
633 SET SQL_LOG_BIN=0;
634 SET SQL_LOG_BIN=0;
635 ### Master with Key, slaves with PKs on different fields (first slave has UK NOT NULL)
636 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, key(c1)) engine= MyISAM;;
637 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= MyISAM;;
638 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= InnoDB;;
639 SET SQL_LOG_BIN=1;
640 SET SQL_LOG_BIN=1;
641 SET SQL_LOG_BIN=1;
642 INSERT INTO t VALUES (1, "a", 10);
643 INSERT INTO t VALUES (2, "b", 20);
644 INSERT INTO t VALUES (3, "c", 30);
645 include/rpl_sync.inc
646 UPDATE t SET c1=10 WHERE c2="a";
647 UPDATE t SET c1=20 WHERE c1=2;
648 UPDATE t SET c1=30 WHERE c3=30;
649 UPDATE t SET c3=40 WHERE c1=30;
650 include/rpl_sync.inc
651 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
652 DELETE FROM t WHERE c2="a";
653 DELETE FROM t WHERE c1=20;
654 DELETE FROM t;
655 include/rpl_sync.inc
656 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
657 DROP TABLE t;
658 include/rpl_sync.inc
659 SET SQL_LOG_BIN=0;
660 SET SQL_LOG_BIN=0;
661 SET SQL_LOG_BIN=0;
662 ### Master with Key, slaves with PKs on different fields
663 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c1)) engine= MyISAM;;
664 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= MyISAM;;
665 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= InnoDB;;
666 SET SQL_LOG_BIN=1;
667 SET SQL_LOG_BIN=1;
668 SET SQL_LOG_BIN=1;
669 INSERT INTO t VALUES (1, "a", 10);
670 INSERT INTO t VALUES (2, "b", 20);
671 INSERT INTO t VALUES (3, "c", 30);
672 include/rpl_sync.inc
673 UPDATE t SET c1=10 WHERE c2="a";
674 UPDATE t SET c1=20 WHERE c1=2;
675 UPDATE t SET c1=30 WHERE c3=30;
676 UPDATE t SET c3=40 WHERE c1=30;
677 include/rpl_sync.inc
678 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
679 DELETE FROM t WHERE c2="a";
680 DELETE FROM t WHERE c1=20;
681 DELETE FROM t;
682 include/rpl_sync.inc
683 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
684 DROP TABLE t;
685 include/rpl_sync.inc
686 SET SQL_LOG_BIN=0;
687 SET SQL_LOG_BIN=0;
688 SET SQL_LOG_BIN=0;
689 ### Master with UK NULLABLE, slaves with no keys
690 CREATE TABLE t (c1 int, c2 blob, c3 int, unique key(c3)) engine= MyISAM;;
691 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
692 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
693 SET SQL_LOG_BIN=1;
694 SET SQL_LOG_BIN=1;
695 SET SQL_LOG_BIN=1;
696 INSERT INTO t VALUES (1, "a", 10);
697 INSERT INTO t VALUES (2, "b", 20);
698 INSERT INTO t VALUES (3, "c", 30);
699 include/rpl_sync.inc
700 UPDATE t SET c1=10 WHERE c2="a";
701 UPDATE t SET c1=20 WHERE c1=2;
702 UPDATE t SET c1=30 WHERE c3=30;
703 UPDATE t SET c3=40 WHERE c1=30;
704 include/rpl_sync.inc
705 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
706 DELETE FROM t WHERE c2="a";
707 DELETE FROM t WHERE c1=20;
708 DELETE FROM t;
709 include/rpl_sync.inc
710 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
711 DROP TABLE t;
712 include/rpl_sync.inc
713 SET SQL_LOG_BIN=0;
714 SET SQL_LOG_BIN=0;
715 SET SQL_LOG_BIN=0;
716 ### Master with UK NULLABLE, first slave with K on different field second slave with key on yet another different field
717 CREATE TABLE t (c1 int, c2 blob, c3 int, unique key(c1)) engine= MyISAM;;
718 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= MyISAM;;
719 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= InnoDB;;
720 SET SQL_LOG_BIN=1;
721 SET SQL_LOG_BIN=1;
722 SET SQL_LOG_BIN=1;
723 INSERT INTO t VALUES (1, "a", 10);
724 INSERT INTO t VALUES (2, "b", 20);
725 INSERT INTO t VALUES (3, "c", 30);
726 include/rpl_sync.inc
727 UPDATE t SET c1=10 WHERE c2="a";
728 UPDATE t SET c1=20 WHERE c1=2;
729 UPDATE t SET c1=30 WHERE c3=30;
730 UPDATE t SET c3=40 WHERE c1=30;
731 include/rpl_sync.inc
732 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
733 DELETE FROM t WHERE c2="a";
734 DELETE FROM t WHERE c1=20;
735 DELETE FROM t;
736 include/rpl_sync.inc
737 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
738 DROP TABLE t;
739 include/rpl_sync.inc
740 SET SQL_LOG_BIN=0;
741 SET SQL_LOG_BIN=0;
742 SET SQL_LOG_BIN=0;
743 ### Master with UK NOT NULL, first slave with UK NOT NULL on different field
744 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c1)) engine= MyISAM;;
745 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= MyISAM;;
746 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= InnoDB;;
747 SET SQL_LOG_BIN=1;
748 SET SQL_LOG_BIN=1;
749 SET SQL_LOG_BIN=1;
750 INSERT INTO t VALUES (1, "a", 10);
751 INSERT INTO t VALUES (2, "b", 20);
752 INSERT INTO t VALUES (3, "c", 30);
753 include/rpl_sync.inc
754 UPDATE t SET c1=10 WHERE c2="a";
755 UPDATE t SET c1=20 WHERE c1=2;
756 UPDATE t SET c1=30 WHERE c3=30;
757 UPDATE t SET c3=40 WHERE c1=30;
758 include/rpl_sync.inc
759 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
760 DELETE FROM t WHERE c2="a";
761 DELETE FROM t WHERE c1=20;
762 DELETE FROM t;
763 include/rpl_sync.inc
764 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
765 DROP TABLE t;
766 include/rpl_sync.inc
767 SET SQL_LOG_BIN=0;
768 SET SQL_LOG_BIN=0;
769 SET SQL_LOG_BIN=0;
770 ### Master with UK NOT NULL and slaves with PK on different fields
771 CREATE TABLE t (c1 int NOT NULL, c2 blob, c3 int, unique key(c1)) engine= MyISAM;;
772 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= MyISAM;;
773 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= InnoDB;;
774 SET SQL_LOG_BIN=1;
775 SET SQL_LOG_BIN=1;
776 SET SQL_LOG_BIN=1;
777 INSERT INTO t VALUES (1, "a", 10);
778 INSERT INTO t VALUES (2, "b", 20);
779 INSERT INTO t VALUES (3, "c", 30);
780 include/rpl_sync.inc
781 UPDATE t SET c1=10 WHERE c2="a";
782 UPDATE t SET c1=20 WHERE c1=2;
783 UPDATE t SET c1=30 WHERE c3=30;
784 UPDATE t SET c3=40 WHERE c1=30;
785 include/rpl_sync.inc
786 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
787 DELETE FROM t WHERE c2="a";
788 DELETE FROM t WHERE c1=20;
789 DELETE FROM t;
790 include/rpl_sync.inc
791 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
792 DROP TABLE t;
793 include/rpl_sync.inc
794 SET SQL_LOG_BIN=0;
795 SET SQL_LOG_BIN=0;
796 SET SQL_LOG_BIN=0;
797 ### Master with PK and no keys on the slaves
798 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c3)) engine= MyISAM;;
799 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
800 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
801 SET SQL_LOG_BIN=1;
802 SET SQL_LOG_BIN=1;
803 SET SQL_LOG_BIN=1;
804 INSERT INTO t VALUES (1, "a", 10);
805 INSERT INTO t VALUES (2, "b", 20);
806 INSERT INTO t VALUES (3, "c", 30);
807 include/rpl_sync.inc
808 UPDATE t SET c1=10 WHERE c2="a";
809 UPDATE t SET c1=20 WHERE c1=2;
810 UPDATE t SET c1=30 WHERE c3=30;
811 UPDATE t SET c3=40 WHERE c1=30;
812 include/rpl_sync.inc
813 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
814 DELETE FROM t WHERE c2="a";
815 DELETE FROM t WHERE c1=20;
816 DELETE FROM t;
817 include/rpl_sync.inc
818 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
819 DROP TABLE t;
820 include/rpl_sync.inc
821 SET SQL_LOG_BIN=0;
822 SET SQL_LOG_BIN=0;
823 SET SQL_LOG_BIN=0;
824 ### Master with PK and first slave with KEY only
825 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= MyISAM;;
826 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= MyISAM;;
827 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= InnoDB;;
828 SET SQL_LOG_BIN=1;
829 SET SQL_LOG_BIN=1;
830 SET SQL_LOG_BIN=1;
831 INSERT INTO t VALUES (1, "a", 10);
832 INSERT INTO t VALUES (2, "b", 20);
833 INSERT INTO t VALUES (3, "c", 30);
834 include/rpl_sync.inc
835 UPDATE t SET c1=10 WHERE c2="a";
836 UPDATE t SET c1=20 WHERE c1=2;
837 UPDATE t SET c1=30 WHERE c3=30;
838 UPDATE t SET c3=40 WHERE c1=30;
839 include/rpl_sync.inc
840 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
841 DELETE FROM t WHERE c2="a";
842 DELETE FROM t WHERE c1=20;
843 DELETE FROM t;
844 include/rpl_sync.inc
845 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
846 DROP TABLE t;
847 include/rpl_sync.inc
848 SET SQL_LOG_BIN=0;
849 SET SQL_LOG_BIN=0;
850 SET SQL_LOG_BIN=0;
851 ### Different PKs on master and first slave (which has unique NOT NULL key instead of PK)
852 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= MyISAM;;
853 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= MyISAM;;
854 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= InnoDB;;
855 SET SQL_LOG_BIN=1;
856 SET SQL_LOG_BIN=1;
857 SET SQL_LOG_BIN=1;
858 INSERT INTO t VALUES (1, "a", 10);
859 INSERT INTO t VALUES (2, "b", 20);
860 INSERT INTO t VALUES (3, "c", 30);
861 include/rpl_sync.inc
862 UPDATE t SET c1=10 WHERE c2="a";
863 UPDATE t SET c1=20 WHERE c1=2;
864 UPDATE t SET c1=30 WHERE c3=30;
865 UPDATE t SET c3=40 WHERE c1=30;
866 include/rpl_sync.inc
867 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
868 DELETE FROM t WHERE c2="a";
869 DELETE FROM t WHERE c1=20;
870 DELETE FROM t;
871 include/rpl_sync.inc
872 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
873 DROP TABLE t;
874 include/rpl_sync.inc
875 SET SQL_LOG_BIN=0;
876 SET SQL_LOG_BIN=0;
877 SET SQL_LOG_BIN=0;
878 ### Different PKs on master and first slave
879 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= MyISAM;;
880 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= MyISAM;;
881 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= InnoDB;;
882 SET SQL_LOG_BIN=1;
883 SET SQL_LOG_BIN=1;
884 SET SQL_LOG_BIN=1;
885 INSERT INTO t VALUES (1, "a", 10);
886 INSERT INTO t VALUES (2, "b", 20);
887 INSERT INTO t VALUES (3, "c", 30);
888 include/rpl_sync.inc
889 UPDATE t SET c1=10 WHERE c2="a";
890 UPDATE t SET c1=20 WHERE c1=2;
891 UPDATE t SET c1=30 WHERE c3=30;
892 UPDATE t SET c3=40 WHERE c1=30;
893 include/rpl_sync.inc
894 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
895 DELETE FROM t WHERE c2="a";
896 DELETE FROM t WHERE c1=20;
897 DELETE FROM t;
898 include/rpl_sync.inc
899 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
900 DROP TABLE t;
901 include/rpl_sync.inc
902 ### engines: MyISAM, InnoDB, MyISAM
903 include/rpl_sync.inc
904 SET SQL_LOG_BIN=0;
905 SET SQL_LOG_BIN=0;
906 SET SQL_LOG_BIN=0;
907 ### Master with no keys slaves with no keys as well
908 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;
909 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;
910 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;
911 SET SQL_LOG_BIN=1;
912 SET SQL_LOG_BIN=1;
913 SET SQL_LOG_BIN=1;
914 INSERT INTO t VALUES (1, "a", 10);
915 INSERT INTO t VALUES (2, "b", 20);
916 INSERT INTO t VALUES (3, "c", 30);
917 include/rpl_sync.inc
918 UPDATE t SET c1=10 WHERE c2="a";
919 UPDATE t SET c1=20 WHERE c1=2;
920 UPDATE t SET c1=30 WHERE c3=30;
921 UPDATE t SET c3=40 WHERE c1=30;
922 include/rpl_sync.inc
923 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
924 DELETE FROM t WHERE c2="a";
925 DELETE FROM t WHERE c1=20;
926 DELETE FROM t;
927 include/rpl_sync.inc
928 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
929 DROP TABLE t;
930 include/rpl_sync.inc
931 SET SQL_LOG_BIN=0;
932 SET SQL_LOG_BIN=0;
933 SET SQL_LOG_BIN=0;
934 ### Master with no key, slaves with keys
935 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
936 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= InnoDB;;
937 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= MyISAM;;
938 SET SQL_LOG_BIN=1;
939 SET SQL_LOG_BIN=1;
940 SET SQL_LOG_BIN=1;
941 INSERT INTO t VALUES (1, "a", 10);
942 INSERT INTO t VALUES (2, "b", 20);
943 INSERT INTO t VALUES (3, "c", 30);
944 include/rpl_sync.inc
945 UPDATE t SET c1=10 WHERE c2="a";
946 UPDATE t SET c1=20 WHERE c1=2;
947 UPDATE t SET c1=30 WHERE c3=30;
948 UPDATE t SET c3=40 WHERE c1=30;
949 include/rpl_sync.inc
950 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
951 DELETE FROM t WHERE c2="a";
952 DELETE FROM t WHERE c1=20;
953 DELETE FROM t;
954 include/rpl_sync.inc
955 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
956 DROP TABLE t;
957 include/rpl_sync.inc
958 SET SQL_LOG_BIN=0;
959 SET SQL_LOG_BIN=0;
960 SET SQL_LOG_BIN=0;
961 ### Master with no key, slaves with PKs on different fields (first slave with UK NOT NULL, second with PK)
962 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int) engine= MyISAM;;
963 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= InnoDB;;
964 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= MyISAM;;
965 SET SQL_LOG_BIN=1;
966 SET SQL_LOG_BIN=1;
967 SET SQL_LOG_BIN=1;
968 INSERT INTO t VALUES (1, "a", 10);
969 INSERT INTO t VALUES (2, "b", 20);
970 INSERT INTO t VALUES (3, "c", 30);
971 include/rpl_sync.inc
972 UPDATE t SET c1=10 WHERE c2="a";
973 UPDATE t SET c1=20 WHERE c1=2;
974 UPDATE t SET c1=30 WHERE c3=30;
975 UPDATE t SET c3=40 WHERE c1=30;
976 include/rpl_sync.inc
977 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
978 DELETE FROM t WHERE c2="a";
979 DELETE FROM t WHERE c1=20;
980 DELETE FROM t;
981 include/rpl_sync.inc
982 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
983 DROP TABLE t;
984 include/rpl_sync.inc
985 SET SQL_LOG_BIN=0;
986 SET SQL_LOG_BIN=0;
987 SET SQL_LOG_BIN=0;
988 ### Master with no key, slaves with PKs on different fields
989 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
990 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= InnoDB;;
991 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= MyISAM;;
992 SET SQL_LOG_BIN=1;
993 SET SQL_LOG_BIN=1;
994 SET SQL_LOG_BIN=1;
995 INSERT INTO t VALUES (1, "a", 10);
996 INSERT INTO t VALUES (2, "b", 20);
997 INSERT INTO t VALUES (3, "c", 30);
998 include/rpl_sync.inc
999 UPDATE t SET c1=10 WHERE c2="a";
1000 UPDATE t SET c1=20 WHERE c1=2;
1001 UPDATE t SET c1=30 WHERE c3=30;
1002 UPDATE t SET c3=40 WHERE c1=30;
1003 include/rpl_sync.inc
1004 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1005 DELETE FROM t WHERE c2="a";
1006 DELETE FROM t WHERE c1=20;
1007 DELETE FROM t;
1008 include/rpl_sync.inc
1009 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1010 DROP TABLE t;
1011 include/rpl_sync.inc
1012 SET SQL_LOG_BIN=0;
1013 SET SQL_LOG_BIN=0;
1014 SET SQL_LOG_BIN=0;
1015 ### Master with Key, slaves with no keys
1016 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= MyISAM;;
1017 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
1018 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
1019 SET SQL_LOG_BIN=1;
1020 SET SQL_LOG_BIN=1;
1021 SET SQL_LOG_BIN=1;
1022 INSERT INTO t VALUES (1, "a", 10);
1023 INSERT INTO t VALUES (2, "b", 20);
1024 INSERT INTO t VALUES (3, "c", 30);
1025 include/rpl_sync.inc
1026 UPDATE t SET c1=10 WHERE c2="a";
1027 UPDATE t SET c1=20 WHERE c1=2;
1028 UPDATE t SET c1=30 WHERE c3=30;
1029 UPDATE t SET c3=40 WHERE c1=30;
1030 include/rpl_sync.inc
1031 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1032 DELETE FROM t WHERE c2="a";
1033 DELETE FROM t WHERE c1=20;
1034 DELETE FROM t;
1035 include/rpl_sync.inc
1036 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1037 DROP TABLE t;
1038 include/rpl_sync.inc
1039 SET SQL_LOG_BIN=0;
1040 SET SQL_LOG_BIN=0;
1041 SET SQL_LOG_BIN=0;
1042 ### Master with Key, first slave with key on different field and second slave with key on yet another different field.
1043 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c1)) engine= MyISAM;;
1044 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= InnoDB;;
1045 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= MyISAM;;
1046 SET SQL_LOG_BIN=1;
1047 SET SQL_LOG_BIN=1;
1048 SET SQL_LOG_BIN=1;
1049 INSERT INTO t VALUES (1, "a", 10);
1050 INSERT INTO t VALUES (2, "b", 20);
1051 INSERT INTO t VALUES (3, "c", 30);
1052 include/rpl_sync.inc
1053 UPDATE t SET c1=10 WHERE c2="a";
1054 UPDATE t SET c1=20 WHERE c1=2;
1055 UPDATE t SET c1=30 WHERE c3=30;
1056 UPDATE t SET c3=40 WHERE c1=30;
1057 include/rpl_sync.inc
1058 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1059 DELETE FROM t WHERE c2="a";
1060 DELETE FROM t WHERE c1=20;
1061 DELETE FROM t;
1062 include/rpl_sync.inc
1063 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1064 DROP TABLE t;
1065 include/rpl_sync.inc
1066 SET SQL_LOG_BIN=0;
1067 SET SQL_LOG_BIN=0;
1068 SET SQL_LOG_BIN=0;
1069 ### Master with Key, slaves with PKs on different fields (first slave has UK NOT NULL)
1070 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, key(c1)) engine= MyISAM;;
1071 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= InnoDB;;
1072 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= MyISAM;;
1073 SET SQL_LOG_BIN=1;
1074 SET SQL_LOG_BIN=1;
1075 SET SQL_LOG_BIN=1;
1076 INSERT INTO t VALUES (1, "a", 10);
1077 INSERT INTO t VALUES (2, "b", 20);
1078 INSERT INTO t VALUES (3, "c", 30);
1079 include/rpl_sync.inc
1080 UPDATE t SET c1=10 WHERE c2="a";
1081 UPDATE t SET c1=20 WHERE c1=2;
1082 UPDATE t SET c1=30 WHERE c3=30;
1083 UPDATE t SET c3=40 WHERE c1=30;
1084 include/rpl_sync.inc
1085 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1086 DELETE FROM t WHERE c2="a";
1087 DELETE FROM t WHERE c1=20;
1088 DELETE FROM t;
1089 include/rpl_sync.inc
1090 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1091 DROP TABLE t;
1092 include/rpl_sync.inc
1093 SET SQL_LOG_BIN=0;
1094 SET SQL_LOG_BIN=0;
1095 SET SQL_LOG_BIN=0;
1096 ### Master with Key, slaves with PKs on different fields
1097 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c1)) engine= MyISAM;;
1098 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= InnoDB;;
1099 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= MyISAM;;
1100 SET SQL_LOG_BIN=1;
1101 SET SQL_LOG_BIN=1;
1102 SET SQL_LOG_BIN=1;
1103 INSERT INTO t VALUES (1, "a", 10);
1104 INSERT INTO t VALUES (2, "b", 20);
1105 INSERT INTO t VALUES (3, "c", 30);
1106 include/rpl_sync.inc
1107 UPDATE t SET c1=10 WHERE c2="a";
1108 UPDATE t SET c1=20 WHERE c1=2;
1109 UPDATE t SET c1=30 WHERE c3=30;
1110 UPDATE t SET c3=40 WHERE c1=30;
1111 include/rpl_sync.inc
1112 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1113 DELETE FROM t WHERE c2="a";
1114 DELETE FROM t WHERE c1=20;
1115 DELETE FROM t;
1116 include/rpl_sync.inc
1117 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1118 DROP TABLE t;
1119 include/rpl_sync.inc
1120 SET SQL_LOG_BIN=0;
1121 SET SQL_LOG_BIN=0;
1122 SET SQL_LOG_BIN=0;
1123 ### Master with UK NULLABLE, slaves with no keys
1124 CREATE TABLE t (c1 int, c2 blob, c3 int, unique key(c3)) engine= MyISAM;;
1125 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
1126 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
1127 SET SQL_LOG_BIN=1;
1128 SET SQL_LOG_BIN=1;
1129 SET SQL_LOG_BIN=1;
1130 INSERT INTO t VALUES (1, "a", 10);
1131 INSERT INTO t VALUES (2, "b", 20);
1132 INSERT INTO t VALUES (3, "c", 30);
1133 include/rpl_sync.inc
1134 UPDATE t SET c1=10 WHERE c2="a";
1135 UPDATE t SET c1=20 WHERE c1=2;
1136 UPDATE t SET c1=30 WHERE c3=30;
1137 UPDATE t SET c3=40 WHERE c1=30;
1138 include/rpl_sync.inc
1139 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1140 DELETE FROM t WHERE c2="a";
1141 DELETE FROM t WHERE c1=20;
1142 DELETE FROM t;
1143 include/rpl_sync.inc
1144 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1145 DROP TABLE t;
1146 include/rpl_sync.inc
1147 SET SQL_LOG_BIN=0;
1148 SET SQL_LOG_BIN=0;
1149 SET SQL_LOG_BIN=0;
1150 ### Master with UK NULLABLE, first slave with K on different field second slave with key on yet another different field
1151 CREATE TABLE t (c1 int, c2 blob, c3 int, unique key(c1)) engine= MyISAM;;
1152 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= InnoDB;;
1153 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= MyISAM;;
1154 SET SQL_LOG_BIN=1;
1155 SET SQL_LOG_BIN=1;
1156 SET SQL_LOG_BIN=1;
1157 INSERT INTO t VALUES (1, "a", 10);
1158 INSERT INTO t VALUES (2, "b", 20);
1159 INSERT INTO t VALUES (3, "c", 30);
1160 include/rpl_sync.inc
1161 UPDATE t SET c1=10 WHERE c2="a";
1162 UPDATE t SET c1=20 WHERE c1=2;
1163 UPDATE t SET c1=30 WHERE c3=30;
1164 UPDATE t SET c3=40 WHERE c1=30;
1165 include/rpl_sync.inc
1166 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1167 DELETE FROM t WHERE c2="a";
1168 DELETE FROM t WHERE c1=20;
1169 DELETE FROM t;
1170 include/rpl_sync.inc
1171 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1172 DROP TABLE t;
1173 include/rpl_sync.inc
1174 SET SQL_LOG_BIN=0;
1175 SET SQL_LOG_BIN=0;
1176 SET SQL_LOG_BIN=0;
1177 ### Master with UK NOT NULL, first slave with UK NOT NULL on different field
1178 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c1)) engine= MyISAM;;
1179 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= InnoDB;;
1180 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= MyISAM;;
1181 SET SQL_LOG_BIN=1;
1182 SET SQL_LOG_BIN=1;
1183 SET SQL_LOG_BIN=1;
1184 INSERT INTO t VALUES (1, "a", 10);
1185 INSERT INTO t VALUES (2, "b", 20);
1186 INSERT INTO t VALUES (3, "c", 30);
1187 include/rpl_sync.inc
1188 UPDATE t SET c1=10 WHERE c2="a";
1189 UPDATE t SET c1=20 WHERE c1=2;
1190 UPDATE t SET c1=30 WHERE c3=30;
1191 UPDATE t SET c3=40 WHERE c1=30;
1192 include/rpl_sync.inc
1193 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1194 DELETE FROM t WHERE c2="a";
1195 DELETE FROM t WHERE c1=20;
1196 DELETE FROM t;
1197 include/rpl_sync.inc
1198 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1199 DROP TABLE t;
1200 include/rpl_sync.inc
1201 SET SQL_LOG_BIN=0;
1202 SET SQL_LOG_BIN=0;
1203 SET SQL_LOG_BIN=0;
1204 ### Master with UK NOT NULL and slaves with PK on different fields
1205 CREATE TABLE t (c1 int NOT NULL, c2 blob, c3 int, unique key(c1)) engine= MyISAM;;
1206 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= InnoDB;;
1207 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= MyISAM;;
1208 SET SQL_LOG_BIN=1;
1209 SET SQL_LOG_BIN=1;
1210 SET SQL_LOG_BIN=1;
1211 INSERT INTO t VALUES (1, "a", 10);
1212 INSERT INTO t VALUES (2, "b", 20);
1213 INSERT INTO t VALUES (3, "c", 30);
1214 include/rpl_sync.inc
1215 UPDATE t SET c1=10 WHERE c2="a";
1216 UPDATE t SET c1=20 WHERE c1=2;
1217 UPDATE t SET c1=30 WHERE c3=30;
1218 UPDATE t SET c3=40 WHERE c1=30;
1219 include/rpl_sync.inc
1220 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1221 DELETE FROM t WHERE c2="a";
1222 DELETE FROM t WHERE c1=20;
1223 DELETE FROM t;
1224 include/rpl_sync.inc
1225 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1226 DROP TABLE t;
1227 include/rpl_sync.inc
1228 SET SQL_LOG_BIN=0;
1229 SET SQL_LOG_BIN=0;
1230 SET SQL_LOG_BIN=0;
1231 ### Master with PK and no keys on the slaves
1232 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c3)) engine= MyISAM;;
1233 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
1234 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
1235 SET SQL_LOG_BIN=1;
1236 SET SQL_LOG_BIN=1;
1237 SET SQL_LOG_BIN=1;
1238 INSERT INTO t VALUES (1, "a", 10);
1239 INSERT INTO t VALUES (2, "b", 20);
1240 INSERT INTO t VALUES (3, "c", 30);
1241 include/rpl_sync.inc
1242 UPDATE t SET c1=10 WHERE c2="a";
1243 UPDATE t SET c1=20 WHERE c1=2;
1244 UPDATE t SET c1=30 WHERE c3=30;
1245 UPDATE t SET c3=40 WHERE c1=30;
1246 include/rpl_sync.inc
1247 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1248 DELETE FROM t WHERE c2="a";
1249 DELETE FROM t WHERE c1=20;
1250 DELETE FROM t;
1251 include/rpl_sync.inc
1252 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1253 DROP TABLE t;
1254 include/rpl_sync.inc
1255 SET SQL_LOG_BIN=0;
1256 SET SQL_LOG_BIN=0;
1257 SET SQL_LOG_BIN=0;
1258 ### Master with PK and first slave with KEY only
1259 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= MyISAM;;
1260 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= InnoDB;;
1261 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= MyISAM;;
1262 SET SQL_LOG_BIN=1;
1263 SET SQL_LOG_BIN=1;
1264 SET SQL_LOG_BIN=1;
1265 INSERT INTO t VALUES (1, "a", 10);
1266 INSERT INTO t VALUES (2, "b", 20);
1267 INSERT INTO t VALUES (3, "c", 30);
1268 include/rpl_sync.inc
1269 UPDATE t SET c1=10 WHERE c2="a";
1270 UPDATE t SET c1=20 WHERE c1=2;
1271 UPDATE t SET c1=30 WHERE c3=30;
1272 UPDATE t SET c3=40 WHERE c1=30;
1273 include/rpl_sync.inc
1274 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1275 DELETE FROM t WHERE c2="a";
1276 DELETE FROM t WHERE c1=20;
1277 DELETE FROM t;
1278 include/rpl_sync.inc
1279 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1280 DROP TABLE t;
1281 include/rpl_sync.inc
1282 SET SQL_LOG_BIN=0;
1283 SET SQL_LOG_BIN=0;
1284 SET SQL_LOG_BIN=0;
1285 ### Different PKs on master and first slave (which has unique NOT NULL key instead of PK)
1286 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= MyISAM;;
1287 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= InnoDB;;
1288 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= MyISAM;;
1289 SET SQL_LOG_BIN=1;
1290 SET SQL_LOG_BIN=1;
1291 SET SQL_LOG_BIN=1;
1292 INSERT INTO t VALUES (1, "a", 10);
1293 INSERT INTO t VALUES (2, "b", 20);
1294 INSERT INTO t VALUES (3, "c", 30);
1295 include/rpl_sync.inc
1296 UPDATE t SET c1=10 WHERE c2="a";
1297 UPDATE t SET c1=20 WHERE c1=2;
1298 UPDATE t SET c1=30 WHERE c3=30;
1299 UPDATE t SET c3=40 WHERE c1=30;
1300 include/rpl_sync.inc
1301 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1302 DELETE FROM t WHERE c2="a";
1303 DELETE FROM t WHERE c1=20;
1304 DELETE FROM t;
1305 include/rpl_sync.inc
1306 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1307 DROP TABLE t;
1308 include/rpl_sync.inc
1309 SET SQL_LOG_BIN=0;
1310 SET SQL_LOG_BIN=0;
1311 SET SQL_LOG_BIN=0;
1312 ### Different PKs on master and first slave
1313 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= MyISAM;;
1314 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= InnoDB;;
1315 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= MyISAM;;
1316 SET SQL_LOG_BIN=1;
1317 SET SQL_LOG_BIN=1;
1318 SET SQL_LOG_BIN=1;
1319 INSERT INTO t VALUES (1, "a", 10);
1320 INSERT INTO t VALUES (2, "b", 20);
1321 INSERT INTO t VALUES (3, "c", 30);
1322 include/rpl_sync.inc
1323 UPDATE t SET c1=10 WHERE c2="a";
1324 UPDATE t SET c1=20 WHERE c1=2;
1325 UPDATE t SET c1=30 WHERE c3=30;
1326 UPDATE t SET c3=40 WHERE c1=30;
1327 include/rpl_sync.inc
1328 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1329 DELETE FROM t WHERE c2="a";
1330 DELETE FROM t WHERE c1=20;
1331 DELETE FROM t;
1332 include/rpl_sync.inc
1333 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1334 DROP TABLE t;
1335 include/rpl_sync.inc
1336 ### engines: MyISAM, InnoDB, InnoDB
1337 include/rpl_sync.inc
1338 SET SQL_LOG_BIN=0;
1339 SET SQL_LOG_BIN=0;
1340 SET SQL_LOG_BIN=0;
1341 ### Master with no keys slaves with no keys as well
1342 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;
1343 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;
1344 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;
1345 SET SQL_LOG_BIN=1;
1346 SET SQL_LOG_BIN=1;
1347 SET SQL_LOG_BIN=1;
1348 INSERT INTO t VALUES (1, "a", 10);
1349 INSERT INTO t VALUES (2, "b", 20);
1350 INSERT INTO t VALUES (3, "c", 30);
1351 include/rpl_sync.inc
1352 UPDATE t SET c1=10 WHERE c2="a";
1353 UPDATE t SET c1=20 WHERE c1=2;
1354 UPDATE t SET c1=30 WHERE c3=30;
1355 UPDATE t SET c3=40 WHERE c1=30;
1356 include/rpl_sync.inc
1357 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1358 DELETE FROM t WHERE c2="a";
1359 DELETE FROM t WHERE c1=20;
1360 DELETE FROM t;
1361 include/rpl_sync.inc
1362 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1363 DROP TABLE t;
1364 include/rpl_sync.inc
1365 SET SQL_LOG_BIN=0;
1366 SET SQL_LOG_BIN=0;
1367 SET SQL_LOG_BIN=0;
1368 ### Master with no key, slaves with keys
1369 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
1370 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= InnoDB;;
1371 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= InnoDB;;
1372 SET SQL_LOG_BIN=1;
1373 SET SQL_LOG_BIN=1;
1374 SET SQL_LOG_BIN=1;
1375 INSERT INTO t VALUES (1, "a", 10);
1376 INSERT INTO t VALUES (2, "b", 20);
1377 INSERT INTO t VALUES (3, "c", 30);
1378 include/rpl_sync.inc
1379 UPDATE t SET c1=10 WHERE c2="a";
1380 UPDATE t SET c1=20 WHERE c1=2;
1381 UPDATE t SET c1=30 WHERE c3=30;
1382 UPDATE t SET c3=40 WHERE c1=30;
1383 include/rpl_sync.inc
1384 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1385 DELETE FROM t WHERE c2="a";
1386 DELETE FROM t WHERE c1=20;
1387 DELETE FROM t;
1388 include/rpl_sync.inc
1389 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1390 DROP TABLE t;
1391 include/rpl_sync.inc
1392 SET SQL_LOG_BIN=0;
1393 SET SQL_LOG_BIN=0;
1394 SET SQL_LOG_BIN=0;
1395 ### Master with no key, slaves with PKs on different fields (first slave with UK NOT NULL, second with PK)
1396 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int) engine= MyISAM;;
1397 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= InnoDB;;
1398 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= InnoDB;;
1399 SET SQL_LOG_BIN=1;
1400 SET SQL_LOG_BIN=1;
1401 SET SQL_LOG_BIN=1;
1402 INSERT INTO t VALUES (1, "a", 10);
1403 INSERT INTO t VALUES (2, "b", 20);
1404 INSERT INTO t VALUES (3, "c", 30);
1405 include/rpl_sync.inc
1406 UPDATE t SET c1=10 WHERE c2="a";
1407 UPDATE t SET c1=20 WHERE c1=2;
1408 UPDATE t SET c1=30 WHERE c3=30;
1409 UPDATE t SET c3=40 WHERE c1=30;
1410 include/rpl_sync.inc
1411 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1412 DELETE FROM t WHERE c2="a";
1413 DELETE FROM t WHERE c1=20;
1414 DELETE FROM t;
1415 include/rpl_sync.inc
1416 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1417 DROP TABLE t;
1418 include/rpl_sync.inc
1419 SET SQL_LOG_BIN=0;
1420 SET SQL_LOG_BIN=0;
1421 SET SQL_LOG_BIN=0;
1422 ### Master with no key, slaves with PKs on different fields
1423 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
1424 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= InnoDB;;
1425 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= InnoDB;;
1426 SET SQL_LOG_BIN=1;
1427 SET SQL_LOG_BIN=1;
1428 SET SQL_LOG_BIN=1;
1429 INSERT INTO t VALUES (1, "a", 10);
1430 INSERT INTO t VALUES (2, "b", 20);
1431 INSERT INTO t VALUES (3, "c", 30);
1432 include/rpl_sync.inc
1433 UPDATE t SET c1=10 WHERE c2="a";
1434 UPDATE t SET c1=20 WHERE c1=2;
1435 UPDATE t SET c1=30 WHERE c3=30;
1436 UPDATE t SET c3=40 WHERE c1=30;
1437 include/rpl_sync.inc
1438 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1439 DELETE FROM t WHERE c2="a";
1440 DELETE FROM t WHERE c1=20;
1441 DELETE FROM t;
1442 include/rpl_sync.inc
1443 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1444 DROP TABLE t;
1445 include/rpl_sync.inc
1446 SET SQL_LOG_BIN=0;
1447 SET SQL_LOG_BIN=0;
1448 SET SQL_LOG_BIN=0;
1449 ### Master with Key, slaves with no keys
1450 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= MyISAM;;
1451 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
1452 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
1453 SET SQL_LOG_BIN=1;
1454 SET SQL_LOG_BIN=1;
1455 SET SQL_LOG_BIN=1;
1456 INSERT INTO t VALUES (1, "a", 10);
1457 INSERT INTO t VALUES (2, "b", 20);
1458 INSERT INTO t VALUES (3, "c", 30);
1459 include/rpl_sync.inc
1460 UPDATE t SET c1=10 WHERE c2="a";
1461 UPDATE t SET c1=20 WHERE c1=2;
1462 UPDATE t SET c1=30 WHERE c3=30;
1463 UPDATE t SET c3=40 WHERE c1=30;
1464 include/rpl_sync.inc
1465 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1466 DELETE FROM t WHERE c2="a";
1467 DELETE FROM t WHERE c1=20;
1468 DELETE FROM t;
1469 include/rpl_sync.inc
1470 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1471 DROP TABLE t;
1472 include/rpl_sync.inc
1473 SET SQL_LOG_BIN=0;
1474 SET SQL_LOG_BIN=0;
1475 SET SQL_LOG_BIN=0;
1476 ### Master with Key, first slave with key on different field and second slave with key on yet another different field.
1477 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c1)) engine= MyISAM;;
1478 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= InnoDB;;
1479 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= InnoDB;;
1480 SET SQL_LOG_BIN=1;
1481 SET SQL_LOG_BIN=1;
1482 SET SQL_LOG_BIN=1;
1483 INSERT INTO t VALUES (1, "a", 10);
1484 INSERT INTO t VALUES (2, "b", 20);
1485 INSERT INTO t VALUES (3, "c", 30);
1486 include/rpl_sync.inc
1487 UPDATE t SET c1=10 WHERE c2="a";
1488 UPDATE t SET c1=20 WHERE c1=2;
1489 UPDATE t SET c1=30 WHERE c3=30;
1490 UPDATE t SET c3=40 WHERE c1=30;
1491 include/rpl_sync.inc
1492 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1493 DELETE FROM t WHERE c2="a";
1494 DELETE FROM t WHERE c1=20;
1495 DELETE FROM t;
1496 include/rpl_sync.inc
1497 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1498 DROP TABLE t;
1499 include/rpl_sync.inc
1500 SET SQL_LOG_BIN=0;
1501 SET SQL_LOG_BIN=0;
1502 SET SQL_LOG_BIN=0;
1503 ### Master with Key, slaves with PKs on different fields (first slave has UK NOT NULL)
1504 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, key(c1)) engine= MyISAM;;
1505 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= InnoDB;;
1506 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= InnoDB;;
1507 SET SQL_LOG_BIN=1;
1508 SET SQL_LOG_BIN=1;
1509 SET SQL_LOG_BIN=1;
1510 INSERT INTO t VALUES (1, "a", 10);
1511 INSERT INTO t VALUES (2, "b", 20);
1512 INSERT INTO t VALUES (3, "c", 30);
1513 include/rpl_sync.inc
1514 UPDATE t SET c1=10 WHERE c2="a";
1515 UPDATE t SET c1=20 WHERE c1=2;
1516 UPDATE t SET c1=30 WHERE c3=30;
1517 UPDATE t SET c3=40 WHERE c1=30;
1518 include/rpl_sync.inc
1519 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1520 DELETE FROM t WHERE c2="a";
1521 DELETE FROM t WHERE c1=20;
1522 DELETE FROM t;
1523 include/rpl_sync.inc
1524 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1525 DROP TABLE t;
1526 include/rpl_sync.inc
1527 SET SQL_LOG_BIN=0;
1528 SET SQL_LOG_BIN=0;
1529 SET SQL_LOG_BIN=0;
1530 ### Master with Key, slaves with PKs on different fields
1531 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c1)) engine= MyISAM;;
1532 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= InnoDB;;
1533 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= InnoDB;;
1534 SET SQL_LOG_BIN=1;
1535 SET SQL_LOG_BIN=1;
1536 SET SQL_LOG_BIN=1;
1537 INSERT INTO t VALUES (1, "a", 10);
1538 INSERT INTO t VALUES (2, "b", 20);
1539 INSERT INTO t VALUES (3, "c", 30);
1540 include/rpl_sync.inc
1541 UPDATE t SET c1=10 WHERE c2="a";
1542 UPDATE t SET c1=20 WHERE c1=2;
1543 UPDATE t SET c1=30 WHERE c3=30;
1544 UPDATE t SET c3=40 WHERE c1=30;
1545 include/rpl_sync.inc
1546 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1547 DELETE FROM t WHERE c2="a";
1548 DELETE FROM t WHERE c1=20;
1549 DELETE FROM t;
1550 include/rpl_sync.inc
1551 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1552 DROP TABLE t;
1553 include/rpl_sync.inc
1554 SET SQL_LOG_BIN=0;
1555 SET SQL_LOG_BIN=0;
1556 SET SQL_LOG_BIN=0;
1557 ### Master with UK NULLABLE, slaves with no keys
1558 CREATE TABLE t (c1 int, c2 blob, c3 int, unique key(c3)) engine= MyISAM;;
1559 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
1560 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
1561 SET SQL_LOG_BIN=1;
1562 SET SQL_LOG_BIN=1;
1563 SET SQL_LOG_BIN=1;
1564 INSERT INTO t VALUES (1, "a", 10);
1565 INSERT INTO t VALUES (2, "b", 20);
1566 INSERT INTO t VALUES (3, "c", 30);
1567 include/rpl_sync.inc
1568 UPDATE t SET c1=10 WHERE c2="a";
1569 UPDATE t SET c1=20 WHERE c1=2;
1570 UPDATE t SET c1=30 WHERE c3=30;
1571 UPDATE t SET c3=40 WHERE c1=30;
1572 include/rpl_sync.inc
1573 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1574 DELETE FROM t WHERE c2="a";
1575 DELETE FROM t WHERE c1=20;
1576 DELETE FROM t;
1577 include/rpl_sync.inc
1578 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1579 DROP TABLE t;
1580 include/rpl_sync.inc
1581 SET SQL_LOG_BIN=0;
1582 SET SQL_LOG_BIN=0;
1583 SET SQL_LOG_BIN=0;
1584 ### Master with UK NULLABLE, first slave with K on different field second slave with key on yet another different field
1585 CREATE TABLE t (c1 int, c2 blob, c3 int, unique key(c1)) engine= MyISAM;;
1586 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= InnoDB;;
1587 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= InnoDB;;
1588 SET SQL_LOG_BIN=1;
1589 SET SQL_LOG_BIN=1;
1590 SET SQL_LOG_BIN=1;
1591 INSERT INTO t VALUES (1, "a", 10);
1592 INSERT INTO t VALUES (2, "b", 20);
1593 INSERT INTO t VALUES (3, "c", 30);
1594 include/rpl_sync.inc
1595 UPDATE t SET c1=10 WHERE c2="a";
1596 UPDATE t SET c1=20 WHERE c1=2;
1597 UPDATE t SET c1=30 WHERE c3=30;
1598 UPDATE t SET c3=40 WHERE c1=30;
1599 include/rpl_sync.inc
1600 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1601 DELETE FROM t WHERE c2="a";
1602 DELETE FROM t WHERE c1=20;
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 DROP TABLE t;
1607 include/rpl_sync.inc
1608 SET SQL_LOG_BIN=0;
1609 SET SQL_LOG_BIN=0;
1610 SET SQL_LOG_BIN=0;
1611 ### Master with UK NOT NULL, first slave with UK NOT NULL on different field
1612 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c1)) engine= MyISAM;;
1613 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= InnoDB;;
1614 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= InnoDB;;
1615 SET SQL_LOG_BIN=1;
1616 SET SQL_LOG_BIN=1;
1617 SET SQL_LOG_BIN=1;
1618 INSERT INTO t VALUES (1, "a", 10);
1619 INSERT INTO t VALUES (2, "b", 20);
1620 INSERT INTO t VALUES (3, "c", 30);
1621 include/rpl_sync.inc
1622 UPDATE t SET c1=10 WHERE c2="a";
1623 UPDATE t SET c1=20 WHERE c1=2;
1624 UPDATE t SET c1=30 WHERE c3=30;
1625 UPDATE t SET c3=40 WHERE c1=30;
1626 include/rpl_sync.inc
1627 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1628 DELETE FROM t WHERE c2="a";
1629 DELETE FROM t WHERE c1=20;
1630 DELETE FROM t;
1631 include/rpl_sync.inc
1632 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1633 DROP TABLE t;
1634 include/rpl_sync.inc
1635 SET SQL_LOG_BIN=0;
1636 SET SQL_LOG_BIN=0;
1637 SET SQL_LOG_BIN=0;
1638 ### Master with UK NOT NULL and slaves with PK on different fields
1639 CREATE TABLE t (c1 int NOT NULL, c2 blob, c3 int, unique key(c1)) engine= MyISAM;;
1640 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= InnoDB;;
1641 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= InnoDB;;
1642 SET SQL_LOG_BIN=1;
1643 SET SQL_LOG_BIN=1;
1644 SET SQL_LOG_BIN=1;
1645 INSERT INTO t VALUES (1, "a", 10);
1646 INSERT INTO t VALUES (2, "b", 20);
1647 INSERT INTO t VALUES (3, "c", 30);
1648 include/rpl_sync.inc
1649 UPDATE t SET c1=10 WHERE c2="a";
1650 UPDATE t SET c1=20 WHERE c1=2;
1651 UPDATE t SET c1=30 WHERE c3=30;
1652 UPDATE t SET c3=40 WHERE c1=30;
1653 include/rpl_sync.inc
1654 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1655 DELETE FROM t WHERE c2="a";
1656 DELETE FROM t WHERE c1=20;
1657 DELETE FROM t;
1658 include/rpl_sync.inc
1659 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1660 DROP TABLE t;
1661 include/rpl_sync.inc
1662 SET SQL_LOG_BIN=0;
1663 SET SQL_LOG_BIN=0;
1664 SET SQL_LOG_BIN=0;
1665 ### Master with PK and no keys on the slaves
1666 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c3)) engine= MyISAM;;
1667 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
1668 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
1669 SET SQL_LOG_BIN=1;
1670 SET SQL_LOG_BIN=1;
1671 SET SQL_LOG_BIN=1;
1672 INSERT INTO t VALUES (1, "a", 10);
1673 INSERT INTO t VALUES (2, "b", 20);
1674 INSERT INTO t VALUES (3, "c", 30);
1675 include/rpl_sync.inc
1676 UPDATE t SET c1=10 WHERE c2="a";
1677 UPDATE t SET c1=20 WHERE c1=2;
1678 UPDATE t SET c1=30 WHERE c3=30;
1679 UPDATE t SET c3=40 WHERE c1=30;
1680 include/rpl_sync.inc
1681 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1682 DELETE FROM t WHERE c2="a";
1683 DELETE FROM t WHERE c1=20;
1684 DELETE FROM t;
1685 include/rpl_sync.inc
1686 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1687 DROP TABLE t;
1688 include/rpl_sync.inc
1689 SET SQL_LOG_BIN=0;
1690 SET SQL_LOG_BIN=0;
1691 SET SQL_LOG_BIN=0;
1692 ### Master with PK and first slave with KEY only
1693 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= MyISAM;;
1694 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= InnoDB;;
1695 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= InnoDB;;
1696 SET SQL_LOG_BIN=1;
1697 SET SQL_LOG_BIN=1;
1698 SET SQL_LOG_BIN=1;
1699 INSERT INTO t VALUES (1, "a", 10);
1700 INSERT INTO t VALUES (2, "b", 20);
1701 INSERT INTO t VALUES (3, "c", 30);
1702 include/rpl_sync.inc
1703 UPDATE t SET c1=10 WHERE c2="a";
1704 UPDATE t SET c1=20 WHERE c1=2;
1705 UPDATE t SET c1=30 WHERE c3=30;
1706 UPDATE t SET c3=40 WHERE c1=30;
1707 include/rpl_sync.inc
1708 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1709 DELETE FROM t WHERE c2="a";
1710 DELETE FROM t WHERE c1=20;
1711 DELETE FROM t;
1712 include/rpl_sync.inc
1713 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1714 DROP TABLE t;
1715 include/rpl_sync.inc
1716 SET SQL_LOG_BIN=0;
1717 SET SQL_LOG_BIN=0;
1718 SET SQL_LOG_BIN=0;
1719 ### Different PKs on master and first slave (which has unique NOT NULL key instead of PK)
1720 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= MyISAM;;
1721 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= InnoDB;;
1722 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= InnoDB;;
1723 SET SQL_LOG_BIN=1;
1724 SET SQL_LOG_BIN=1;
1725 SET SQL_LOG_BIN=1;
1726 INSERT INTO t VALUES (1, "a", 10);
1727 INSERT INTO t VALUES (2, "b", 20);
1728 INSERT INTO t VALUES (3, "c", 30);
1729 include/rpl_sync.inc
1730 UPDATE t SET c1=10 WHERE c2="a";
1731 UPDATE t SET c1=20 WHERE c1=2;
1732 UPDATE t SET c1=30 WHERE c3=30;
1733 UPDATE t SET c3=40 WHERE c1=30;
1734 include/rpl_sync.inc
1735 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1736 DELETE FROM t WHERE c2="a";
1737 DELETE FROM t WHERE c1=20;
1738 DELETE FROM t;
1739 include/rpl_sync.inc
1740 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1741 DROP TABLE t;
1742 include/rpl_sync.inc
1743 SET SQL_LOG_BIN=0;
1744 SET SQL_LOG_BIN=0;
1745 SET SQL_LOG_BIN=0;
1746 ### Different PKs on master and first slave
1747 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= MyISAM;;
1748 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= InnoDB;;
1749 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= InnoDB;;
1750 SET SQL_LOG_BIN=1;
1751 SET SQL_LOG_BIN=1;
1752 SET SQL_LOG_BIN=1;
1753 INSERT INTO t VALUES (1, "a", 10);
1754 INSERT INTO t VALUES (2, "b", 20);
1755 INSERT INTO t VALUES (3, "c", 30);
1756 include/rpl_sync.inc
1757 UPDATE t SET c1=10 WHERE c2="a";
1758 UPDATE t SET c1=20 WHERE c1=2;
1759 UPDATE t SET c1=30 WHERE c3=30;
1760 UPDATE t SET c3=40 WHERE c1=30;
1761 include/rpl_sync.inc
1762 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1763 DELETE FROM t WHERE c2="a";
1764 DELETE FROM t WHERE c1=20;
1765 DELETE FROM t;
1766 include/rpl_sync.inc
1767 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1768 DROP TABLE t;
1769 include/rpl_sync.inc
1770 ### engines: InnoDB, MyISAM, MyISAM
1771 include/rpl_sync.inc
1772 SET SQL_LOG_BIN=0;
1773 SET SQL_LOG_BIN=0;
1774 SET SQL_LOG_BIN=0;
1775 ### Master with no keys slaves with no keys as well
1776 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;
1777 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;
1778 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;
1779 SET SQL_LOG_BIN=1;
1780 SET SQL_LOG_BIN=1;
1781 SET SQL_LOG_BIN=1;
1782 INSERT INTO t VALUES (1, "a", 10);
1783 INSERT INTO t VALUES (2, "b", 20);
1784 INSERT INTO t VALUES (3, "c", 30);
1785 include/rpl_sync.inc
1786 UPDATE t SET c1=10 WHERE c2="a";
1787 UPDATE t SET c1=20 WHERE c1=2;
1788 UPDATE t SET c1=30 WHERE c3=30;
1789 UPDATE t SET c3=40 WHERE c1=30;
1790 include/rpl_sync.inc
1791 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1792 DELETE FROM t WHERE c2="a";
1793 DELETE FROM t WHERE c1=20;
1794 DELETE FROM t;
1795 include/rpl_sync.inc
1796 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1797 DROP TABLE t;
1798 include/rpl_sync.inc
1799 SET SQL_LOG_BIN=0;
1800 SET SQL_LOG_BIN=0;
1801 SET SQL_LOG_BIN=0;
1802 ### Master with no key, slaves with keys
1803 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
1804 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= MyISAM;;
1805 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= MyISAM;;
1806 SET SQL_LOG_BIN=1;
1807 SET SQL_LOG_BIN=1;
1808 SET SQL_LOG_BIN=1;
1809 INSERT INTO t VALUES (1, "a", 10);
1810 INSERT INTO t VALUES (2, "b", 20);
1811 INSERT INTO t VALUES (3, "c", 30);
1812 include/rpl_sync.inc
1813 UPDATE t SET c1=10 WHERE c2="a";
1814 UPDATE t SET c1=20 WHERE c1=2;
1815 UPDATE t SET c1=30 WHERE c3=30;
1816 UPDATE t SET c3=40 WHERE c1=30;
1817 include/rpl_sync.inc
1818 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1819 DELETE FROM t WHERE c2="a";
1820 DELETE FROM t WHERE c1=20;
1821 DELETE FROM t;
1822 include/rpl_sync.inc
1823 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1824 DROP TABLE t;
1825 include/rpl_sync.inc
1826 SET SQL_LOG_BIN=0;
1827 SET SQL_LOG_BIN=0;
1828 SET SQL_LOG_BIN=0;
1829 ### Master with no key, slaves with PKs on different fields (first slave with UK NOT NULL, second with PK)
1830 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int) engine= InnoDB;;
1831 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= MyISAM;;
1832 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= MyISAM;;
1833 SET SQL_LOG_BIN=1;
1834 SET SQL_LOG_BIN=1;
1835 SET SQL_LOG_BIN=1;
1836 INSERT INTO t VALUES (1, "a", 10);
1837 INSERT INTO t VALUES (2, "b", 20);
1838 INSERT INTO t VALUES (3, "c", 30);
1839 include/rpl_sync.inc
1840 UPDATE t SET c1=10 WHERE c2="a";
1841 UPDATE t SET c1=20 WHERE c1=2;
1842 UPDATE t SET c1=30 WHERE c3=30;
1843 UPDATE t SET c3=40 WHERE c1=30;
1844 include/rpl_sync.inc
1845 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1846 DELETE FROM t WHERE c2="a";
1847 DELETE FROM t WHERE c1=20;
1848 DELETE FROM t;
1849 include/rpl_sync.inc
1850 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1851 DROP TABLE t;
1852 include/rpl_sync.inc
1853 SET SQL_LOG_BIN=0;
1854 SET SQL_LOG_BIN=0;
1855 SET SQL_LOG_BIN=0;
1856 ### Master with no key, slaves with PKs on different fields
1857 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
1858 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= MyISAM;;
1859 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= MyISAM;;
1860 SET SQL_LOG_BIN=1;
1861 SET SQL_LOG_BIN=1;
1862 SET SQL_LOG_BIN=1;
1863 INSERT INTO t VALUES (1, "a", 10);
1864 INSERT INTO t VALUES (2, "b", 20);
1865 INSERT INTO t VALUES (3, "c", 30);
1866 include/rpl_sync.inc
1867 UPDATE t SET c1=10 WHERE c2="a";
1868 UPDATE t SET c1=20 WHERE c1=2;
1869 UPDATE t SET c1=30 WHERE c3=30;
1870 UPDATE t SET c3=40 WHERE c1=30;
1871 include/rpl_sync.inc
1872 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1873 DELETE FROM t WHERE c2="a";
1874 DELETE FROM t WHERE c1=20;
1875 DELETE FROM t;
1876 include/rpl_sync.inc
1877 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1878 DROP TABLE t;
1879 include/rpl_sync.inc
1880 SET SQL_LOG_BIN=0;
1881 SET SQL_LOG_BIN=0;
1882 SET SQL_LOG_BIN=0;
1883 ### Master with Key, slaves with no keys
1884 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= InnoDB;;
1885 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
1886 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
1887 SET SQL_LOG_BIN=1;
1888 SET SQL_LOG_BIN=1;
1889 SET SQL_LOG_BIN=1;
1890 INSERT INTO t VALUES (1, "a", 10);
1891 INSERT INTO t VALUES (2, "b", 20);
1892 INSERT INTO t VALUES (3, "c", 30);
1893 include/rpl_sync.inc
1894 UPDATE t SET c1=10 WHERE c2="a";
1895 UPDATE t SET c1=20 WHERE c1=2;
1896 UPDATE t SET c1=30 WHERE c3=30;
1897 UPDATE t SET c3=40 WHERE c1=30;
1898 include/rpl_sync.inc
1899 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1900 DELETE FROM t WHERE c2="a";
1901 DELETE FROM t WHERE c1=20;
1902 DELETE FROM t;
1903 include/rpl_sync.inc
1904 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1905 DROP TABLE t;
1906 include/rpl_sync.inc
1907 SET SQL_LOG_BIN=0;
1908 SET SQL_LOG_BIN=0;
1909 SET SQL_LOG_BIN=0;
1910 ### Master with Key, first slave with key on different field and second slave with key on yet another different field.
1911 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c1)) engine= InnoDB;;
1912 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= MyISAM;;
1913 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= MyISAM;;
1914 SET SQL_LOG_BIN=1;
1915 SET SQL_LOG_BIN=1;
1916 SET SQL_LOG_BIN=1;
1917 INSERT INTO t VALUES (1, "a", 10);
1918 INSERT INTO t VALUES (2, "b", 20);
1919 INSERT INTO t VALUES (3, "c", 30);
1920 include/rpl_sync.inc
1921 UPDATE t SET c1=10 WHERE c2="a";
1922 UPDATE t SET c1=20 WHERE c1=2;
1923 UPDATE t SET c1=30 WHERE c3=30;
1924 UPDATE t SET c3=40 WHERE c1=30;
1925 include/rpl_sync.inc
1926 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1927 DELETE FROM t WHERE c2="a";
1928 DELETE FROM t WHERE c1=20;
1929 DELETE FROM t;
1930 include/rpl_sync.inc
1931 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1932 DROP TABLE t;
1933 include/rpl_sync.inc
1934 SET SQL_LOG_BIN=0;
1935 SET SQL_LOG_BIN=0;
1936 SET SQL_LOG_BIN=0;
1937 ### Master with Key, slaves with PKs on different fields (first slave has UK NOT NULL)
1938 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, key(c1)) engine= InnoDB;;
1939 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= MyISAM;;
1940 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= MyISAM;;
1941 SET SQL_LOG_BIN=1;
1942 SET SQL_LOG_BIN=1;
1943 SET SQL_LOG_BIN=1;
1944 INSERT INTO t VALUES (1, "a", 10);
1945 INSERT INTO t VALUES (2, "b", 20);
1946 INSERT INTO t VALUES (3, "c", 30);
1947 include/rpl_sync.inc
1948 UPDATE t SET c1=10 WHERE c2="a";
1949 UPDATE t SET c1=20 WHERE c1=2;
1950 UPDATE t SET c1=30 WHERE c3=30;
1951 UPDATE t SET c3=40 WHERE c1=30;
1952 include/rpl_sync.inc
1953 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1954 DELETE FROM t WHERE c2="a";
1955 DELETE FROM t WHERE c1=20;
1956 DELETE FROM t;
1957 include/rpl_sync.inc
1958 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1959 DROP TABLE t;
1960 include/rpl_sync.inc
1961 SET SQL_LOG_BIN=0;
1962 SET SQL_LOG_BIN=0;
1963 SET SQL_LOG_BIN=0;
1964 ### Master with Key, slaves with PKs on different fields
1965 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c1)) engine= InnoDB;;
1966 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= MyISAM;;
1967 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= MyISAM;;
1968 SET SQL_LOG_BIN=1;
1969 SET SQL_LOG_BIN=1;
1970 SET SQL_LOG_BIN=1;
1971 INSERT INTO t VALUES (1, "a", 10);
1972 INSERT INTO t VALUES (2, "b", 20);
1973 INSERT INTO t VALUES (3, "c", 30);
1974 include/rpl_sync.inc
1975 UPDATE t SET c1=10 WHERE c2="a";
1976 UPDATE t SET c1=20 WHERE c1=2;
1977 UPDATE t SET c1=30 WHERE c3=30;
1978 UPDATE t SET c3=40 WHERE c1=30;
1979 include/rpl_sync.inc
1980 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1981 DELETE FROM t WHERE c2="a";
1982 DELETE FROM t WHERE c1=20;
1983 DELETE FROM t;
1984 include/rpl_sync.inc
1985 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
1986 DROP TABLE t;
1987 include/rpl_sync.inc
1988 SET SQL_LOG_BIN=0;
1989 SET SQL_LOG_BIN=0;
1990 SET SQL_LOG_BIN=0;
1991 ### Master with UK NULLABLE, slaves with no keys
1992 CREATE TABLE t (c1 int, c2 blob, c3 int, unique key(c3)) engine= InnoDB;;
1993 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
1994 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
1995 SET SQL_LOG_BIN=1;
1996 SET SQL_LOG_BIN=1;
1997 SET SQL_LOG_BIN=1;
1998 INSERT INTO t VALUES (1, "a", 10);
1999 INSERT INTO t VALUES (2, "b", 20);
2000 INSERT INTO t VALUES (3, "c", 30);
2001 include/rpl_sync.inc
2002 UPDATE t SET c1=10 WHERE c2="a";
2003 UPDATE t SET c1=20 WHERE c1=2;
2004 UPDATE t SET c1=30 WHERE c3=30;
2005 UPDATE t SET c3=40 WHERE c1=30;
2006 include/rpl_sync.inc
2007 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2008 DELETE FROM t WHERE c2="a";
2009 DELETE FROM t WHERE c1=20;
2010 DELETE FROM t;
2011 include/rpl_sync.inc
2012 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2013 DROP TABLE t;
2014 include/rpl_sync.inc
2015 SET SQL_LOG_BIN=0;
2016 SET SQL_LOG_BIN=0;
2017 SET SQL_LOG_BIN=0;
2018 ### Master with UK NULLABLE, first slave with K on different field second slave with key on yet another different field
2019 CREATE TABLE t (c1 int, c2 blob, c3 int, unique key(c1)) engine= InnoDB;;
2020 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= MyISAM;;
2021 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= MyISAM;;
2022 SET SQL_LOG_BIN=1;
2023 SET SQL_LOG_BIN=1;
2024 SET SQL_LOG_BIN=1;
2025 INSERT INTO t VALUES (1, "a", 10);
2026 INSERT INTO t VALUES (2, "b", 20);
2027 INSERT INTO t VALUES (3, "c", 30);
2028 include/rpl_sync.inc
2029 UPDATE t SET c1=10 WHERE c2="a";
2030 UPDATE t SET c1=20 WHERE c1=2;
2031 UPDATE t SET c1=30 WHERE c3=30;
2032 UPDATE t SET c3=40 WHERE c1=30;
2033 include/rpl_sync.inc
2034 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2035 DELETE FROM t WHERE c2="a";
2036 DELETE FROM t WHERE c1=20;
2037 DELETE FROM t;
2038 include/rpl_sync.inc
2039 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2040 DROP TABLE t;
2041 include/rpl_sync.inc
2042 SET SQL_LOG_BIN=0;
2043 SET SQL_LOG_BIN=0;
2044 SET SQL_LOG_BIN=0;
2045 ### Master with UK NOT NULL, first slave with UK NOT NULL on different field
2046 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c1)) engine= InnoDB;;
2047 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= MyISAM;;
2048 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= MyISAM;;
2049 SET SQL_LOG_BIN=1;
2050 SET SQL_LOG_BIN=1;
2051 SET SQL_LOG_BIN=1;
2052 INSERT INTO t VALUES (1, "a", 10);
2053 INSERT INTO t VALUES (2, "b", 20);
2054 INSERT INTO t VALUES (3, "c", 30);
2055 include/rpl_sync.inc
2056 UPDATE t SET c1=10 WHERE c2="a";
2057 UPDATE t SET c1=20 WHERE c1=2;
2058 UPDATE t SET c1=30 WHERE c3=30;
2059 UPDATE t SET c3=40 WHERE c1=30;
2060 include/rpl_sync.inc
2061 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2062 DELETE FROM t WHERE c2="a";
2063 DELETE FROM t WHERE c1=20;
2064 DELETE FROM t;
2065 include/rpl_sync.inc
2066 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2067 DROP TABLE t;
2068 include/rpl_sync.inc
2069 SET SQL_LOG_BIN=0;
2070 SET SQL_LOG_BIN=0;
2071 SET SQL_LOG_BIN=0;
2072 ### Master with UK NOT NULL and slaves with PK on different fields
2073 CREATE TABLE t (c1 int NOT NULL, c2 blob, c3 int, unique key(c1)) engine= InnoDB;;
2074 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= MyISAM;;
2075 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= MyISAM;;
2076 SET SQL_LOG_BIN=1;
2077 SET SQL_LOG_BIN=1;
2078 SET SQL_LOG_BIN=1;
2079 INSERT INTO t VALUES (1, "a", 10);
2080 INSERT INTO t VALUES (2, "b", 20);
2081 INSERT INTO t VALUES (3, "c", 30);
2082 include/rpl_sync.inc
2083 UPDATE t SET c1=10 WHERE c2="a";
2084 UPDATE t SET c1=20 WHERE c1=2;
2085 UPDATE t SET c1=30 WHERE c3=30;
2086 UPDATE t SET c3=40 WHERE c1=30;
2087 include/rpl_sync.inc
2088 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2089 DELETE FROM t WHERE c2="a";
2090 DELETE FROM t WHERE c1=20;
2091 DELETE FROM t;
2092 include/rpl_sync.inc
2093 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2094 DROP TABLE t;
2095 include/rpl_sync.inc
2096 SET SQL_LOG_BIN=0;
2097 SET SQL_LOG_BIN=0;
2098 SET SQL_LOG_BIN=0;
2099 ### Master with PK and no keys on the slaves
2100 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c3)) engine= InnoDB;;
2101 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
2102 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
2103 SET SQL_LOG_BIN=1;
2104 SET SQL_LOG_BIN=1;
2105 SET SQL_LOG_BIN=1;
2106 INSERT INTO t VALUES (1, "a", 10);
2107 INSERT INTO t VALUES (2, "b", 20);
2108 INSERT INTO t VALUES (3, "c", 30);
2109 include/rpl_sync.inc
2110 UPDATE t SET c1=10 WHERE c2="a";
2111 UPDATE t SET c1=20 WHERE c1=2;
2112 UPDATE t SET c1=30 WHERE c3=30;
2113 UPDATE t SET c3=40 WHERE c1=30;
2114 include/rpl_sync.inc
2115 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2116 DELETE FROM t WHERE c2="a";
2117 DELETE FROM t WHERE c1=20;
2118 DELETE FROM t;
2119 include/rpl_sync.inc
2120 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2121 DROP TABLE t;
2122 include/rpl_sync.inc
2123 SET SQL_LOG_BIN=0;
2124 SET SQL_LOG_BIN=0;
2125 SET SQL_LOG_BIN=0;
2126 ### Master with PK and first slave with KEY only
2127 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= InnoDB;;
2128 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= MyISAM;;
2129 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= MyISAM;;
2130 SET SQL_LOG_BIN=1;
2131 SET SQL_LOG_BIN=1;
2132 SET SQL_LOG_BIN=1;
2133 INSERT INTO t VALUES (1, "a", 10);
2134 INSERT INTO t VALUES (2, "b", 20);
2135 INSERT INTO t VALUES (3, "c", 30);
2136 include/rpl_sync.inc
2137 UPDATE t SET c1=10 WHERE c2="a";
2138 UPDATE t SET c1=20 WHERE c1=2;
2139 UPDATE t SET c1=30 WHERE c3=30;
2140 UPDATE t SET c3=40 WHERE c1=30;
2141 include/rpl_sync.inc
2142 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2143 DELETE FROM t WHERE c2="a";
2144 DELETE FROM t WHERE c1=20;
2145 DELETE FROM t;
2146 include/rpl_sync.inc
2147 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2148 DROP TABLE t;
2149 include/rpl_sync.inc
2150 SET SQL_LOG_BIN=0;
2151 SET SQL_LOG_BIN=0;
2152 SET SQL_LOG_BIN=0;
2153 ### Different PKs on master and first slave (which has unique NOT NULL key instead of PK)
2154 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= InnoDB;;
2155 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= MyISAM;;
2156 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= MyISAM;;
2157 SET SQL_LOG_BIN=1;
2158 SET SQL_LOG_BIN=1;
2159 SET SQL_LOG_BIN=1;
2160 INSERT INTO t VALUES (1, "a", 10);
2161 INSERT INTO t VALUES (2, "b", 20);
2162 INSERT INTO t VALUES (3, "c", 30);
2163 include/rpl_sync.inc
2164 UPDATE t SET c1=10 WHERE c2="a";
2165 UPDATE t SET c1=20 WHERE c1=2;
2166 UPDATE t SET c1=30 WHERE c3=30;
2167 UPDATE t SET c3=40 WHERE c1=30;
2168 include/rpl_sync.inc
2169 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2170 DELETE FROM t WHERE c2="a";
2171 DELETE FROM t WHERE c1=20;
2172 DELETE FROM t;
2173 include/rpl_sync.inc
2174 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2175 DROP TABLE t;
2176 include/rpl_sync.inc
2177 SET SQL_LOG_BIN=0;
2178 SET SQL_LOG_BIN=0;
2179 SET SQL_LOG_BIN=0;
2180 ### Different PKs on master and first slave
2181 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= InnoDB;;
2182 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= MyISAM;;
2183 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= MyISAM;;
2184 SET SQL_LOG_BIN=1;
2185 SET SQL_LOG_BIN=1;
2186 SET SQL_LOG_BIN=1;
2187 INSERT INTO t VALUES (1, "a", 10);
2188 INSERT INTO t VALUES (2, "b", 20);
2189 INSERT INTO t VALUES (3, "c", 30);
2190 include/rpl_sync.inc
2191 UPDATE t SET c1=10 WHERE c2="a";
2192 UPDATE t SET c1=20 WHERE c1=2;
2193 UPDATE t SET c1=30 WHERE c3=30;
2194 UPDATE t SET c3=40 WHERE c1=30;
2195 include/rpl_sync.inc
2196 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2197 DELETE FROM t WHERE c2="a";
2198 DELETE FROM t WHERE c1=20;
2199 DELETE FROM t;
2200 include/rpl_sync.inc
2201 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2202 DROP TABLE t;
2203 include/rpl_sync.inc
2204 ### engines: InnoDB, MyISAM, InnoDB
2205 include/rpl_sync.inc
2206 SET SQL_LOG_BIN=0;
2207 SET SQL_LOG_BIN=0;
2208 SET SQL_LOG_BIN=0;
2209 ### Master with no keys slaves with no keys as well
2210 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;
2211 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;
2212 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;
2213 SET SQL_LOG_BIN=1;
2214 SET SQL_LOG_BIN=1;
2215 SET SQL_LOG_BIN=1;
2216 INSERT INTO t VALUES (1, "a", 10);
2217 INSERT INTO t VALUES (2, "b", 20);
2218 INSERT INTO t VALUES (3, "c", 30);
2219 include/rpl_sync.inc
2220 UPDATE t SET c1=10 WHERE c2="a";
2221 UPDATE t SET c1=20 WHERE c1=2;
2222 UPDATE t SET c1=30 WHERE c3=30;
2223 UPDATE t SET c3=40 WHERE c1=30;
2224 include/rpl_sync.inc
2225 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2226 DELETE FROM t WHERE c2="a";
2227 DELETE FROM t WHERE c1=20;
2228 DELETE FROM t;
2229 include/rpl_sync.inc
2230 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2231 DROP TABLE t;
2232 include/rpl_sync.inc
2233 SET SQL_LOG_BIN=0;
2234 SET SQL_LOG_BIN=0;
2235 SET SQL_LOG_BIN=0;
2236 ### Master with no key, slaves with keys
2237 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
2238 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= MyISAM;;
2239 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= InnoDB;;
2240 SET SQL_LOG_BIN=1;
2241 SET SQL_LOG_BIN=1;
2242 SET SQL_LOG_BIN=1;
2243 INSERT INTO t VALUES (1, "a", 10);
2244 INSERT INTO t VALUES (2, "b", 20);
2245 INSERT INTO t VALUES (3, "c", 30);
2246 include/rpl_sync.inc
2247 UPDATE t SET c1=10 WHERE c2="a";
2248 UPDATE t SET c1=20 WHERE c1=2;
2249 UPDATE t SET c1=30 WHERE c3=30;
2250 UPDATE t SET c3=40 WHERE c1=30;
2251 include/rpl_sync.inc
2252 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2253 DELETE FROM t WHERE c2="a";
2254 DELETE FROM t WHERE c1=20;
2255 DELETE FROM t;
2256 include/rpl_sync.inc
2257 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2258 DROP TABLE t;
2259 include/rpl_sync.inc
2260 SET SQL_LOG_BIN=0;
2261 SET SQL_LOG_BIN=0;
2262 SET SQL_LOG_BIN=0;
2263 ### Master with no key, slaves with PKs on different fields (first slave with UK NOT NULL, second with PK)
2264 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int) engine= InnoDB;;
2265 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= MyISAM;;
2266 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= InnoDB;;
2267 SET SQL_LOG_BIN=1;
2268 SET SQL_LOG_BIN=1;
2269 SET SQL_LOG_BIN=1;
2270 INSERT INTO t VALUES (1, "a", 10);
2271 INSERT INTO t VALUES (2, "b", 20);
2272 INSERT INTO t VALUES (3, "c", 30);
2273 include/rpl_sync.inc
2274 UPDATE t SET c1=10 WHERE c2="a";
2275 UPDATE t SET c1=20 WHERE c1=2;
2276 UPDATE t SET c1=30 WHERE c3=30;
2277 UPDATE t SET c3=40 WHERE c1=30;
2278 include/rpl_sync.inc
2279 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2280 DELETE FROM t WHERE c2="a";
2281 DELETE FROM t WHERE c1=20;
2282 DELETE FROM t;
2283 include/rpl_sync.inc
2284 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2285 DROP TABLE t;
2286 include/rpl_sync.inc
2287 SET SQL_LOG_BIN=0;
2288 SET SQL_LOG_BIN=0;
2289 SET SQL_LOG_BIN=0;
2290 ### Master with no key, slaves with PKs on different fields
2291 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
2292 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= MyISAM;;
2293 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= InnoDB;;
2294 SET SQL_LOG_BIN=1;
2295 SET SQL_LOG_BIN=1;
2296 SET SQL_LOG_BIN=1;
2297 INSERT INTO t VALUES (1, "a", 10);
2298 INSERT INTO t VALUES (2, "b", 20);
2299 INSERT INTO t VALUES (3, "c", 30);
2300 include/rpl_sync.inc
2301 UPDATE t SET c1=10 WHERE c2="a";
2302 UPDATE t SET c1=20 WHERE c1=2;
2303 UPDATE t SET c1=30 WHERE c3=30;
2304 UPDATE t SET c3=40 WHERE c1=30;
2305 include/rpl_sync.inc
2306 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2307 DELETE FROM t WHERE c2="a";
2308 DELETE FROM t WHERE c1=20;
2309 DELETE FROM t;
2310 include/rpl_sync.inc
2311 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2312 DROP TABLE t;
2313 include/rpl_sync.inc
2314 SET SQL_LOG_BIN=0;
2315 SET SQL_LOG_BIN=0;
2316 SET SQL_LOG_BIN=0;
2317 ### Master with Key, slaves with no keys
2318 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= InnoDB;;
2319 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
2320 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
2321 SET SQL_LOG_BIN=1;
2322 SET SQL_LOG_BIN=1;
2323 SET SQL_LOG_BIN=1;
2324 INSERT INTO t VALUES (1, "a", 10);
2325 INSERT INTO t VALUES (2, "b", 20);
2326 INSERT INTO t VALUES (3, "c", 30);
2327 include/rpl_sync.inc
2328 UPDATE t SET c1=10 WHERE c2="a";
2329 UPDATE t SET c1=20 WHERE c1=2;
2330 UPDATE t SET c1=30 WHERE c3=30;
2331 UPDATE t SET c3=40 WHERE c1=30;
2332 include/rpl_sync.inc
2333 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2334 DELETE FROM t WHERE c2="a";
2335 DELETE FROM t WHERE c1=20;
2336 DELETE FROM t;
2337 include/rpl_sync.inc
2338 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2339 DROP TABLE t;
2340 include/rpl_sync.inc
2341 SET SQL_LOG_BIN=0;
2342 SET SQL_LOG_BIN=0;
2343 SET SQL_LOG_BIN=0;
2344 ### Master with Key, first slave with key on different field and second slave with key on yet another different field.
2345 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c1)) engine= InnoDB;;
2346 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= MyISAM;;
2347 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= InnoDB;;
2348 SET SQL_LOG_BIN=1;
2349 SET SQL_LOG_BIN=1;
2350 SET SQL_LOG_BIN=1;
2351 INSERT INTO t VALUES (1, "a", 10);
2352 INSERT INTO t VALUES (2, "b", 20);
2353 INSERT INTO t VALUES (3, "c", 30);
2354 include/rpl_sync.inc
2355 UPDATE t SET c1=10 WHERE c2="a";
2356 UPDATE t SET c1=20 WHERE c1=2;
2357 UPDATE t SET c1=30 WHERE c3=30;
2358 UPDATE t SET c3=40 WHERE c1=30;
2359 include/rpl_sync.inc
2360 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2361 DELETE FROM t WHERE c2="a";
2362 DELETE FROM t WHERE c1=20;
2363 DELETE FROM t;
2364 include/rpl_sync.inc
2365 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2366 DROP TABLE t;
2367 include/rpl_sync.inc
2368 SET SQL_LOG_BIN=0;
2369 SET SQL_LOG_BIN=0;
2370 SET SQL_LOG_BIN=0;
2371 ### Master with Key, slaves with PKs on different fields (first slave has UK NOT NULL)
2372 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, key(c1)) engine= InnoDB;;
2373 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= MyISAM;;
2374 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= InnoDB;;
2375 SET SQL_LOG_BIN=1;
2376 SET SQL_LOG_BIN=1;
2377 SET SQL_LOG_BIN=1;
2378 INSERT INTO t VALUES (1, "a", 10);
2379 INSERT INTO t VALUES (2, "b", 20);
2380 INSERT INTO t VALUES (3, "c", 30);
2381 include/rpl_sync.inc
2382 UPDATE t SET c1=10 WHERE c2="a";
2383 UPDATE t SET c1=20 WHERE c1=2;
2384 UPDATE t SET c1=30 WHERE c3=30;
2385 UPDATE t SET c3=40 WHERE c1=30;
2386 include/rpl_sync.inc
2387 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2388 DELETE FROM t WHERE c2="a";
2389 DELETE FROM t WHERE c1=20;
2390 DELETE FROM t;
2391 include/rpl_sync.inc
2392 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2393 DROP TABLE t;
2394 include/rpl_sync.inc
2395 SET SQL_LOG_BIN=0;
2396 SET SQL_LOG_BIN=0;
2397 SET SQL_LOG_BIN=0;
2398 ### Master with Key, slaves with PKs on different fields
2399 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c1)) engine= InnoDB;;
2400 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= MyISAM;;
2401 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= InnoDB;;
2402 SET SQL_LOG_BIN=1;
2403 SET SQL_LOG_BIN=1;
2404 SET SQL_LOG_BIN=1;
2405 INSERT INTO t VALUES (1, "a", 10);
2406 INSERT INTO t VALUES (2, "b", 20);
2407 INSERT INTO t VALUES (3, "c", 30);
2408 include/rpl_sync.inc
2409 UPDATE t SET c1=10 WHERE c2="a";
2410 UPDATE t SET c1=20 WHERE c1=2;
2411 UPDATE t SET c1=30 WHERE c3=30;
2412 UPDATE t SET c3=40 WHERE c1=30;
2413 include/rpl_sync.inc
2414 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2415 DELETE FROM t WHERE c2="a";
2416 DELETE FROM t WHERE c1=20;
2417 DELETE FROM t;
2418 include/rpl_sync.inc
2419 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2420 DROP TABLE t;
2421 include/rpl_sync.inc
2422 SET SQL_LOG_BIN=0;
2423 SET SQL_LOG_BIN=0;
2424 SET SQL_LOG_BIN=0;
2425 ### Master with UK NULLABLE, slaves with no keys
2426 CREATE TABLE t (c1 int, c2 blob, c3 int, unique key(c3)) engine= InnoDB;;
2427 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
2428 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
2429 SET SQL_LOG_BIN=1;
2430 SET SQL_LOG_BIN=1;
2431 SET SQL_LOG_BIN=1;
2432 INSERT INTO t VALUES (1, "a", 10);
2433 INSERT INTO t VALUES (2, "b", 20);
2434 INSERT INTO t VALUES (3, "c", 30);
2435 include/rpl_sync.inc
2436 UPDATE t SET c1=10 WHERE c2="a";
2437 UPDATE t SET c1=20 WHERE c1=2;
2438 UPDATE t SET c1=30 WHERE c3=30;
2439 UPDATE t SET c3=40 WHERE c1=30;
2440 include/rpl_sync.inc
2441 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2442 DELETE FROM t WHERE c2="a";
2443 DELETE FROM t WHERE c1=20;
2444 DELETE FROM t;
2445 include/rpl_sync.inc
2446 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2447 DROP TABLE t;
2448 include/rpl_sync.inc
2449 SET SQL_LOG_BIN=0;
2450 SET SQL_LOG_BIN=0;
2451 SET SQL_LOG_BIN=0;
2452 ### Master with UK NULLABLE, first slave with K on different field second slave with key on yet another different field
2453 CREATE TABLE t (c1 int, c2 blob, c3 int, unique key(c1)) engine= InnoDB;;
2454 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= MyISAM;;
2455 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= InnoDB;;
2456 SET SQL_LOG_BIN=1;
2457 SET SQL_LOG_BIN=1;
2458 SET SQL_LOG_BIN=1;
2459 INSERT INTO t VALUES (1, "a", 10);
2460 INSERT INTO t VALUES (2, "b", 20);
2461 INSERT INTO t VALUES (3, "c", 30);
2462 include/rpl_sync.inc
2463 UPDATE t SET c1=10 WHERE c2="a";
2464 UPDATE t SET c1=20 WHERE c1=2;
2465 UPDATE t SET c1=30 WHERE c3=30;
2466 UPDATE t SET c3=40 WHERE c1=30;
2467 include/rpl_sync.inc
2468 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2469 DELETE FROM t WHERE c2="a";
2470 DELETE FROM t WHERE c1=20;
2471 DELETE FROM t;
2472 include/rpl_sync.inc
2473 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2474 DROP TABLE t;
2475 include/rpl_sync.inc
2476 SET SQL_LOG_BIN=0;
2477 SET SQL_LOG_BIN=0;
2478 SET SQL_LOG_BIN=0;
2479 ### Master with UK NOT NULL, first slave with UK NOT NULL on different field
2480 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c1)) engine= InnoDB;;
2481 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= MyISAM;;
2482 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= InnoDB;;
2483 SET SQL_LOG_BIN=1;
2484 SET SQL_LOG_BIN=1;
2485 SET SQL_LOG_BIN=1;
2486 INSERT INTO t VALUES (1, "a", 10);
2487 INSERT INTO t VALUES (2, "b", 20);
2488 INSERT INTO t VALUES (3, "c", 30);
2489 include/rpl_sync.inc
2490 UPDATE t SET c1=10 WHERE c2="a";
2491 UPDATE t SET c1=20 WHERE c1=2;
2492 UPDATE t SET c1=30 WHERE c3=30;
2493 UPDATE t SET c3=40 WHERE c1=30;
2494 include/rpl_sync.inc
2495 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2496 DELETE FROM t WHERE c2="a";
2497 DELETE FROM t WHERE c1=20;
2498 DELETE FROM t;
2499 include/rpl_sync.inc
2500 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2501 DROP TABLE t;
2502 include/rpl_sync.inc
2503 SET SQL_LOG_BIN=0;
2504 SET SQL_LOG_BIN=0;
2505 SET SQL_LOG_BIN=0;
2506 ### Master with UK NOT NULL and slaves with PK on different fields
2507 CREATE TABLE t (c1 int NOT NULL, c2 blob, c3 int, unique key(c1)) engine= InnoDB;;
2508 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= MyISAM;;
2509 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= InnoDB;;
2510 SET SQL_LOG_BIN=1;
2511 SET SQL_LOG_BIN=1;
2512 SET SQL_LOG_BIN=1;
2513 INSERT INTO t VALUES (1, "a", 10);
2514 INSERT INTO t VALUES (2, "b", 20);
2515 INSERT INTO t VALUES (3, "c", 30);
2516 include/rpl_sync.inc
2517 UPDATE t SET c1=10 WHERE c2="a";
2518 UPDATE t SET c1=20 WHERE c1=2;
2519 UPDATE t SET c1=30 WHERE c3=30;
2520 UPDATE t SET c3=40 WHERE c1=30;
2521 include/rpl_sync.inc
2522 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2523 DELETE FROM t WHERE c2="a";
2524 DELETE FROM t WHERE c1=20;
2525 DELETE FROM t;
2526 include/rpl_sync.inc
2527 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2528 DROP TABLE t;
2529 include/rpl_sync.inc
2530 SET SQL_LOG_BIN=0;
2531 SET SQL_LOG_BIN=0;
2532 SET SQL_LOG_BIN=0;
2533 ### Master with PK and no keys on the slaves
2534 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c3)) engine= InnoDB;;
2535 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
2536 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
2537 SET SQL_LOG_BIN=1;
2538 SET SQL_LOG_BIN=1;
2539 SET SQL_LOG_BIN=1;
2540 INSERT INTO t VALUES (1, "a", 10);
2541 INSERT INTO t VALUES (2, "b", 20);
2542 INSERT INTO t VALUES (3, "c", 30);
2543 include/rpl_sync.inc
2544 UPDATE t SET c1=10 WHERE c2="a";
2545 UPDATE t SET c1=20 WHERE c1=2;
2546 UPDATE t SET c1=30 WHERE c3=30;
2547 UPDATE t SET c3=40 WHERE c1=30;
2548 include/rpl_sync.inc
2549 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2550 DELETE FROM t WHERE c2="a";
2551 DELETE FROM t WHERE c1=20;
2552 DELETE FROM t;
2553 include/rpl_sync.inc
2554 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2555 DROP TABLE t;
2556 include/rpl_sync.inc
2557 SET SQL_LOG_BIN=0;
2558 SET SQL_LOG_BIN=0;
2559 SET SQL_LOG_BIN=0;
2560 ### Master with PK and first slave with KEY only
2561 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= InnoDB;;
2562 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= MyISAM;;
2563 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= InnoDB;;
2564 SET SQL_LOG_BIN=1;
2565 SET SQL_LOG_BIN=1;
2566 SET SQL_LOG_BIN=1;
2567 INSERT INTO t VALUES (1, "a", 10);
2568 INSERT INTO t VALUES (2, "b", 20);
2569 INSERT INTO t VALUES (3, "c", 30);
2570 include/rpl_sync.inc
2571 UPDATE t SET c1=10 WHERE c2="a";
2572 UPDATE t SET c1=20 WHERE c1=2;
2573 UPDATE t SET c1=30 WHERE c3=30;
2574 UPDATE t SET c3=40 WHERE c1=30;
2575 include/rpl_sync.inc
2576 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2577 DELETE FROM t WHERE c2="a";
2578 DELETE FROM t WHERE c1=20;
2579 DELETE FROM t;
2580 include/rpl_sync.inc
2581 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2582 DROP TABLE t;
2583 include/rpl_sync.inc
2584 SET SQL_LOG_BIN=0;
2585 SET SQL_LOG_BIN=0;
2586 SET SQL_LOG_BIN=0;
2587 ### Different PKs on master and first slave (which has unique NOT NULL key instead of PK)
2588 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= InnoDB;;
2589 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= MyISAM;;
2590 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= InnoDB;;
2591 SET SQL_LOG_BIN=1;
2592 SET SQL_LOG_BIN=1;
2593 SET SQL_LOG_BIN=1;
2594 INSERT INTO t VALUES (1, "a", 10);
2595 INSERT INTO t VALUES (2, "b", 20);
2596 INSERT INTO t VALUES (3, "c", 30);
2597 include/rpl_sync.inc
2598 UPDATE t SET c1=10 WHERE c2="a";
2599 UPDATE t SET c1=20 WHERE c1=2;
2600 UPDATE t SET c1=30 WHERE c3=30;
2601 UPDATE t SET c3=40 WHERE c1=30;
2602 include/rpl_sync.inc
2603 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2604 DELETE FROM t WHERE c2="a";
2605 DELETE FROM t WHERE c1=20;
2606 DELETE FROM t;
2607 include/rpl_sync.inc
2608 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2609 DROP TABLE t;
2610 include/rpl_sync.inc
2611 SET SQL_LOG_BIN=0;
2612 SET SQL_LOG_BIN=0;
2613 SET SQL_LOG_BIN=0;
2614 ### Different PKs on master and first slave
2615 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= InnoDB;;
2616 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= MyISAM;;
2617 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= InnoDB;;
2618 SET SQL_LOG_BIN=1;
2619 SET SQL_LOG_BIN=1;
2620 SET SQL_LOG_BIN=1;
2621 INSERT INTO t VALUES (1, "a", 10);
2622 INSERT INTO t VALUES (2, "b", 20);
2623 INSERT INTO t VALUES (3, "c", 30);
2624 include/rpl_sync.inc
2625 UPDATE t SET c1=10 WHERE c2="a";
2626 UPDATE t SET c1=20 WHERE c1=2;
2627 UPDATE t SET c1=30 WHERE c3=30;
2628 UPDATE t SET c3=40 WHERE c1=30;
2629 include/rpl_sync.inc
2630 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2631 DELETE FROM t WHERE c2="a";
2632 DELETE FROM t WHERE c1=20;
2633 DELETE FROM t;
2634 include/rpl_sync.inc
2635 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2636 DROP TABLE t;
2637 include/rpl_sync.inc
2638 ### engines: InnoDB, InnoDB, MyISAM
2639 include/rpl_sync.inc
2640 SET SQL_LOG_BIN=0;
2641 SET SQL_LOG_BIN=0;
2642 SET SQL_LOG_BIN=0;
2643 ### Master with no keys slaves with no keys as well
2644 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;
2645 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;
2646 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;
2647 SET SQL_LOG_BIN=1;
2648 SET SQL_LOG_BIN=1;
2649 SET SQL_LOG_BIN=1;
2650 INSERT INTO t VALUES (1, "a", 10);
2651 INSERT INTO t VALUES (2, "b", 20);
2652 INSERT INTO t VALUES (3, "c", 30);
2653 include/rpl_sync.inc
2654 UPDATE t SET c1=10 WHERE c2="a";
2655 UPDATE t SET c1=20 WHERE c1=2;
2656 UPDATE t SET c1=30 WHERE c3=30;
2657 UPDATE t SET c3=40 WHERE c1=30;
2658 include/rpl_sync.inc
2659 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2660 DELETE FROM t WHERE c2="a";
2661 DELETE FROM t WHERE c1=20;
2662 DELETE FROM t;
2663 include/rpl_sync.inc
2664 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2665 DROP TABLE t;
2666 include/rpl_sync.inc
2667 SET SQL_LOG_BIN=0;
2668 SET SQL_LOG_BIN=0;
2669 SET SQL_LOG_BIN=0;
2670 ### Master with no key, slaves with keys
2671 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
2672 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= InnoDB;;
2673 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= MyISAM;;
2674 SET SQL_LOG_BIN=1;
2675 SET SQL_LOG_BIN=1;
2676 SET SQL_LOG_BIN=1;
2677 INSERT INTO t VALUES (1, "a", 10);
2678 INSERT INTO t VALUES (2, "b", 20);
2679 INSERT INTO t VALUES (3, "c", 30);
2680 include/rpl_sync.inc
2681 UPDATE t SET c1=10 WHERE c2="a";
2682 UPDATE t SET c1=20 WHERE c1=2;
2683 UPDATE t SET c1=30 WHERE c3=30;
2684 UPDATE t SET c3=40 WHERE c1=30;
2685 include/rpl_sync.inc
2686 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2687 DELETE FROM t WHERE c2="a";
2688 DELETE FROM t WHERE c1=20;
2689 DELETE FROM t;
2690 include/rpl_sync.inc
2691 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2692 DROP TABLE t;
2693 include/rpl_sync.inc
2694 SET SQL_LOG_BIN=0;
2695 SET SQL_LOG_BIN=0;
2696 SET SQL_LOG_BIN=0;
2697 ### Master with no key, slaves with PKs on different fields (first slave with UK NOT NULL, second with PK)
2698 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int) engine= InnoDB;;
2699 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= InnoDB;;
2700 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= MyISAM;;
2701 SET SQL_LOG_BIN=1;
2702 SET SQL_LOG_BIN=1;
2703 SET SQL_LOG_BIN=1;
2704 INSERT INTO t VALUES (1, "a", 10);
2705 INSERT INTO t VALUES (2, "b", 20);
2706 INSERT INTO t VALUES (3, "c", 30);
2707 include/rpl_sync.inc
2708 UPDATE t SET c1=10 WHERE c2="a";
2709 UPDATE t SET c1=20 WHERE c1=2;
2710 UPDATE t SET c1=30 WHERE c3=30;
2711 UPDATE t SET c3=40 WHERE c1=30;
2712 include/rpl_sync.inc
2713 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2714 DELETE FROM t WHERE c2="a";
2715 DELETE FROM t WHERE c1=20;
2716 DELETE FROM t;
2717 include/rpl_sync.inc
2718 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2719 DROP TABLE t;
2720 include/rpl_sync.inc
2721 SET SQL_LOG_BIN=0;
2722 SET SQL_LOG_BIN=0;
2723 SET SQL_LOG_BIN=0;
2724 ### Master with no key, slaves with PKs on different fields
2725 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
2726 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= InnoDB;;
2727 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= MyISAM;;
2728 SET SQL_LOG_BIN=1;
2729 SET SQL_LOG_BIN=1;
2730 SET SQL_LOG_BIN=1;
2731 INSERT INTO t VALUES (1, "a", 10);
2732 INSERT INTO t VALUES (2, "b", 20);
2733 INSERT INTO t VALUES (3, "c", 30);
2734 include/rpl_sync.inc
2735 UPDATE t SET c1=10 WHERE c2="a";
2736 UPDATE t SET c1=20 WHERE c1=2;
2737 UPDATE t SET c1=30 WHERE c3=30;
2738 UPDATE t SET c3=40 WHERE c1=30;
2739 include/rpl_sync.inc
2740 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2741 DELETE FROM t WHERE c2="a";
2742 DELETE FROM t WHERE c1=20;
2743 DELETE FROM t;
2744 include/rpl_sync.inc
2745 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2746 DROP TABLE t;
2747 include/rpl_sync.inc
2748 SET SQL_LOG_BIN=0;
2749 SET SQL_LOG_BIN=0;
2750 SET SQL_LOG_BIN=0;
2751 ### Master with Key, slaves with no keys
2752 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= InnoDB;;
2753 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
2754 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
2755 SET SQL_LOG_BIN=1;
2756 SET SQL_LOG_BIN=1;
2757 SET SQL_LOG_BIN=1;
2758 INSERT INTO t VALUES (1, "a", 10);
2759 INSERT INTO t VALUES (2, "b", 20);
2760 INSERT INTO t VALUES (3, "c", 30);
2761 include/rpl_sync.inc
2762 UPDATE t SET c1=10 WHERE c2="a";
2763 UPDATE t SET c1=20 WHERE c1=2;
2764 UPDATE t SET c1=30 WHERE c3=30;
2765 UPDATE t SET c3=40 WHERE c1=30;
2766 include/rpl_sync.inc
2767 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2768 DELETE FROM t WHERE c2="a";
2769 DELETE FROM t WHERE c1=20;
2770 DELETE FROM t;
2771 include/rpl_sync.inc
2772 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2773 DROP TABLE t;
2774 include/rpl_sync.inc
2775 SET SQL_LOG_BIN=0;
2776 SET SQL_LOG_BIN=0;
2777 SET SQL_LOG_BIN=0;
2778 ### Master with Key, first slave with key on different field and second slave with key on yet another different field.
2779 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c1)) engine= InnoDB;;
2780 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= InnoDB;;
2781 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= MyISAM;;
2782 SET SQL_LOG_BIN=1;
2783 SET SQL_LOG_BIN=1;
2784 SET SQL_LOG_BIN=1;
2785 INSERT INTO t VALUES (1, "a", 10);
2786 INSERT INTO t VALUES (2, "b", 20);
2787 INSERT INTO t VALUES (3, "c", 30);
2788 include/rpl_sync.inc
2789 UPDATE t SET c1=10 WHERE c2="a";
2790 UPDATE t SET c1=20 WHERE c1=2;
2791 UPDATE t SET c1=30 WHERE c3=30;
2792 UPDATE t SET c3=40 WHERE c1=30;
2793 include/rpl_sync.inc
2794 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2795 DELETE FROM t WHERE c2="a";
2796 DELETE FROM t WHERE c1=20;
2797 DELETE FROM t;
2798 include/rpl_sync.inc
2799 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2800 DROP TABLE t;
2801 include/rpl_sync.inc
2802 SET SQL_LOG_BIN=0;
2803 SET SQL_LOG_BIN=0;
2804 SET SQL_LOG_BIN=0;
2805 ### Master with Key, slaves with PKs on different fields (first slave has UK NOT NULL)
2806 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, key(c1)) engine= InnoDB;;
2807 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= InnoDB;;
2808 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= MyISAM;;
2809 SET SQL_LOG_BIN=1;
2810 SET SQL_LOG_BIN=1;
2811 SET SQL_LOG_BIN=1;
2812 INSERT INTO t VALUES (1, "a", 10);
2813 INSERT INTO t VALUES (2, "b", 20);
2814 INSERT INTO t VALUES (3, "c", 30);
2815 include/rpl_sync.inc
2816 UPDATE t SET c1=10 WHERE c2="a";
2817 UPDATE t SET c1=20 WHERE c1=2;
2818 UPDATE t SET c1=30 WHERE c3=30;
2819 UPDATE t SET c3=40 WHERE c1=30;
2820 include/rpl_sync.inc
2821 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2822 DELETE FROM t WHERE c2="a";
2823 DELETE FROM t WHERE c1=20;
2824 DELETE FROM t;
2825 include/rpl_sync.inc
2826 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2827 DROP TABLE t;
2828 include/rpl_sync.inc
2829 SET SQL_LOG_BIN=0;
2830 SET SQL_LOG_BIN=0;
2831 SET SQL_LOG_BIN=0;
2832 ### Master with Key, slaves with PKs on different fields
2833 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c1)) engine= InnoDB;;
2834 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= InnoDB;;
2835 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= MyISAM;;
2836 SET SQL_LOG_BIN=1;
2837 SET SQL_LOG_BIN=1;
2838 SET SQL_LOG_BIN=1;
2839 INSERT INTO t VALUES (1, "a", 10);
2840 INSERT INTO t VALUES (2, "b", 20);
2841 INSERT INTO t VALUES (3, "c", 30);
2842 include/rpl_sync.inc
2843 UPDATE t SET c1=10 WHERE c2="a";
2844 UPDATE t SET c1=20 WHERE c1=2;
2845 UPDATE t SET c1=30 WHERE c3=30;
2846 UPDATE t SET c3=40 WHERE c1=30;
2847 include/rpl_sync.inc
2848 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2849 DELETE FROM t WHERE c2="a";
2850 DELETE FROM t WHERE c1=20;
2851 DELETE FROM t;
2852 include/rpl_sync.inc
2853 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2854 DROP TABLE t;
2855 include/rpl_sync.inc
2856 SET SQL_LOG_BIN=0;
2857 SET SQL_LOG_BIN=0;
2858 SET SQL_LOG_BIN=0;
2859 ### Master with UK NULLABLE, slaves with no keys
2860 CREATE TABLE t (c1 int, c2 blob, c3 int, unique key(c3)) engine= InnoDB;;
2861 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
2862 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
2863 SET SQL_LOG_BIN=1;
2864 SET SQL_LOG_BIN=1;
2865 SET SQL_LOG_BIN=1;
2866 INSERT INTO t VALUES (1, "a", 10);
2867 INSERT INTO t VALUES (2, "b", 20);
2868 INSERT INTO t VALUES (3, "c", 30);
2869 include/rpl_sync.inc
2870 UPDATE t SET c1=10 WHERE c2="a";
2871 UPDATE t SET c1=20 WHERE c1=2;
2872 UPDATE t SET c1=30 WHERE c3=30;
2873 UPDATE t SET c3=40 WHERE c1=30;
2874 include/rpl_sync.inc
2875 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2876 DELETE FROM t WHERE c2="a";
2877 DELETE FROM t WHERE c1=20;
2878 DELETE FROM t;
2879 include/rpl_sync.inc
2880 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2881 DROP TABLE t;
2882 include/rpl_sync.inc
2883 SET SQL_LOG_BIN=0;
2884 SET SQL_LOG_BIN=0;
2885 SET SQL_LOG_BIN=0;
2886 ### Master with UK NULLABLE, first slave with K on different field second slave with key on yet another different field
2887 CREATE TABLE t (c1 int, c2 blob, c3 int, unique key(c1)) engine= InnoDB;;
2888 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= InnoDB;;
2889 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= MyISAM;;
2890 SET SQL_LOG_BIN=1;
2891 SET SQL_LOG_BIN=1;
2892 SET SQL_LOG_BIN=1;
2893 INSERT INTO t VALUES (1, "a", 10);
2894 INSERT INTO t VALUES (2, "b", 20);
2895 INSERT INTO t VALUES (3, "c", 30);
2896 include/rpl_sync.inc
2897 UPDATE t SET c1=10 WHERE c2="a";
2898 UPDATE t SET c1=20 WHERE c1=2;
2899 UPDATE t SET c1=30 WHERE c3=30;
2900 UPDATE t SET c3=40 WHERE c1=30;
2901 include/rpl_sync.inc
2902 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2903 DELETE FROM t WHERE c2="a";
2904 DELETE FROM t WHERE c1=20;
2905 DELETE FROM t;
2906 include/rpl_sync.inc
2907 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2908 DROP TABLE t;
2909 include/rpl_sync.inc
2910 SET SQL_LOG_BIN=0;
2911 SET SQL_LOG_BIN=0;
2912 SET SQL_LOG_BIN=0;
2913 ### Master with UK NOT NULL, first slave with UK NOT NULL on different field
2914 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c1)) engine= InnoDB;;
2915 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= InnoDB;;
2916 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= MyISAM;;
2917 SET SQL_LOG_BIN=1;
2918 SET SQL_LOG_BIN=1;
2919 SET SQL_LOG_BIN=1;
2920 INSERT INTO t VALUES (1, "a", 10);
2921 INSERT INTO t VALUES (2, "b", 20);
2922 INSERT INTO t VALUES (3, "c", 30);
2923 include/rpl_sync.inc
2924 UPDATE t SET c1=10 WHERE c2="a";
2925 UPDATE t SET c1=20 WHERE c1=2;
2926 UPDATE t SET c1=30 WHERE c3=30;
2927 UPDATE t SET c3=40 WHERE c1=30;
2928 include/rpl_sync.inc
2929 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2930 DELETE FROM t WHERE c2="a";
2931 DELETE FROM t WHERE c1=20;
2932 DELETE FROM t;
2933 include/rpl_sync.inc
2934 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2935 DROP TABLE t;
2936 include/rpl_sync.inc
2937 SET SQL_LOG_BIN=0;
2938 SET SQL_LOG_BIN=0;
2939 SET SQL_LOG_BIN=0;
2940 ### Master with UK NOT NULL and slaves with PK on different fields
2941 CREATE TABLE t (c1 int NOT NULL, c2 blob, c3 int, unique key(c1)) engine= InnoDB;;
2942 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= InnoDB;;
2943 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= MyISAM;;
2944 SET SQL_LOG_BIN=1;
2945 SET SQL_LOG_BIN=1;
2946 SET SQL_LOG_BIN=1;
2947 INSERT INTO t VALUES (1, "a", 10);
2948 INSERT INTO t VALUES (2, "b", 20);
2949 INSERT INTO t VALUES (3, "c", 30);
2950 include/rpl_sync.inc
2951 UPDATE t SET c1=10 WHERE c2="a";
2952 UPDATE t SET c1=20 WHERE c1=2;
2953 UPDATE t SET c1=30 WHERE c3=30;
2954 UPDATE t SET c3=40 WHERE c1=30;
2955 include/rpl_sync.inc
2956 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2957 DELETE FROM t WHERE c2="a";
2958 DELETE FROM t WHERE c1=20;
2959 DELETE FROM t;
2960 include/rpl_sync.inc
2961 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2962 DROP TABLE t;
2963 include/rpl_sync.inc
2964 SET SQL_LOG_BIN=0;
2965 SET SQL_LOG_BIN=0;
2966 SET SQL_LOG_BIN=0;
2967 ### Master with PK and no keys on the slaves
2968 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c3)) engine= InnoDB;;
2969 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
2970 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= MyISAM;;
2971 SET SQL_LOG_BIN=1;
2972 SET SQL_LOG_BIN=1;
2973 SET SQL_LOG_BIN=1;
2974 INSERT INTO t VALUES (1, "a", 10);
2975 INSERT INTO t VALUES (2, "b", 20);
2976 INSERT INTO t VALUES (3, "c", 30);
2977 include/rpl_sync.inc
2978 UPDATE t SET c1=10 WHERE c2="a";
2979 UPDATE t SET c1=20 WHERE c1=2;
2980 UPDATE t SET c1=30 WHERE c3=30;
2981 UPDATE t SET c3=40 WHERE c1=30;
2982 include/rpl_sync.inc
2983 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2984 DELETE FROM t WHERE c2="a";
2985 DELETE FROM t WHERE c1=20;
2986 DELETE FROM t;
2987 include/rpl_sync.inc
2988 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
2989 DROP TABLE t;
2990 include/rpl_sync.inc
2991 SET SQL_LOG_BIN=0;
2992 SET SQL_LOG_BIN=0;
2993 SET SQL_LOG_BIN=0;
2994 ### Master with PK and first slave with KEY only
2995 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= InnoDB;;
2996 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= InnoDB;;
2997 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= MyISAM;;
2998 SET SQL_LOG_BIN=1;
2999 SET SQL_LOG_BIN=1;
3000 SET SQL_LOG_BIN=1;
3001 INSERT INTO t VALUES (1, "a", 10);
3002 INSERT INTO t VALUES (2, "b", 20);
3003 INSERT INTO t VALUES (3, "c", 30);
3004 include/rpl_sync.inc
3005 UPDATE t SET c1=10 WHERE c2="a";
3006 UPDATE t SET c1=20 WHERE c1=2;
3007 UPDATE t SET c1=30 WHERE c3=30;
3008 UPDATE t SET c3=40 WHERE c1=30;
3009 include/rpl_sync.inc
3010 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3011 DELETE FROM t WHERE c2="a";
3012 DELETE FROM t WHERE c1=20;
3013 DELETE FROM t;
3014 include/rpl_sync.inc
3015 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3016 DROP TABLE t;
3017 include/rpl_sync.inc
3018 SET SQL_LOG_BIN=0;
3019 SET SQL_LOG_BIN=0;
3020 SET SQL_LOG_BIN=0;
3021 ### Different PKs on master and first slave (which has unique NOT NULL key instead of PK)
3022 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= InnoDB;;
3023 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= InnoDB;;
3024 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= MyISAM;;
3025 SET SQL_LOG_BIN=1;
3026 SET SQL_LOG_BIN=1;
3027 SET SQL_LOG_BIN=1;
3028 INSERT INTO t VALUES (1, "a", 10);
3029 INSERT INTO t VALUES (2, "b", 20);
3030 INSERT INTO t VALUES (3, "c", 30);
3031 include/rpl_sync.inc
3032 UPDATE t SET c1=10 WHERE c2="a";
3033 UPDATE t SET c1=20 WHERE c1=2;
3034 UPDATE t SET c1=30 WHERE c3=30;
3035 UPDATE t SET c3=40 WHERE c1=30;
3036 include/rpl_sync.inc
3037 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3038 DELETE FROM t WHERE c2="a";
3039 DELETE FROM t WHERE c1=20;
3040 DELETE FROM t;
3041 include/rpl_sync.inc
3042 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3043 DROP TABLE t;
3044 include/rpl_sync.inc
3045 SET SQL_LOG_BIN=0;
3046 SET SQL_LOG_BIN=0;
3047 SET SQL_LOG_BIN=0;
3048 ### Different PKs on master and first slave
3049 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= InnoDB;;
3050 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= InnoDB;;
3051 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= MyISAM;;
3052 SET SQL_LOG_BIN=1;
3053 SET SQL_LOG_BIN=1;
3054 SET SQL_LOG_BIN=1;
3055 INSERT INTO t VALUES (1, "a", 10);
3056 INSERT INTO t VALUES (2, "b", 20);
3057 INSERT INTO t VALUES (3, "c", 30);
3058 include/rpl_sync.inc
3059 UPDATE t SET c1=10 WHERE c2="a";
3060 UPDATE t SET c1=20 WHERE c1=2;
3061 UPDATE t SET c1=30 WHERE c3=30;
3062 UPDATE t SET c3=40 WHERE c1=30;
3063 include/rpl_sync.inc
3064 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3065 DELETE FROM t WHERE c2="a";
3066 DELETE FROM t WHERE c1=20;
3067 DELETE FROM t;
3068 include/rpl_sync.inc
3069 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3070 DROP TABLE t;
3071 include/rpl_sync.inc
3072 ### engines: InnoDB, InnoDB, InnoDB
3073 include/rpl_sync.inc
3074 SET SQL_LOG_BIN=0;
3075 SET SQL_LOG_BIN=0;
3076 SET SQL_LOG_BIN=0;
3077 ### Master with no keys slaves with no keys as well
3078 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;
3079 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;
3080 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;
3081 SET SQL_LOG_BIN=1;
3082 SET SQL_LOG_BIN=1;
3083 SET SQL_LOG_BIN=1;
3084 INSERT INTO t VALUES (1, "a", 10);
3085 INSERT INTO t VALUES (2, "b", 20);
3086 INSERT INTO t VALUES (3, "c", 30);
3087 include/rpl_sync.inc
3088 UPDATE t SET c1=10 WHERE c2="a";
3089 UPDATE t SET c1=20 WHERE c1=2;
3090 UPDATE t SET c1=30 WHERE c3=30;
3091 UPDATE t SET c3=40 WHERE c1=30;
3092 include/rpl_sync.inc
3093 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3094 DELETE FROM t WHERE c2="a";
3095 DELETE FROM t WHERE c1=20;
3096 DELETE FROM t;
3097 include/rpl_sync.inc
3098 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3099 DROP TABLE t;
3100 include/rpl_sync.inc
3101 SET SQL_LOG_BIN=0;
3102 SET SQL_LOG_BIN=0;
3103 SET SQL_LOG_BIN=0;
3104 ### Master with no key, slaves with keys
3105 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
3106 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= InnoDB;;
3107 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= InnoDB;;
3108 SET SQL_LOG_BIN=1;
3109 SET SQL_LOG_BIN=1;
3110 SET SQL_LOG_BIN=1;
3111 INSERT INTO t VALUES (1, "a", 10);
3112 INSERT INTO t VALUES (2, "b", 20);
3113 INSERT INTO t VALUES (3, "c", 30);
3114 include/rpl_sync.inc
3115 UPDATE t SET c1=10 WHERE c2="a";
3116 UPDATE t SET c1=20 WHERE c1=2;
3117 UPDATE t SET c1=30 WHERE c3=30;
3118 UPDATE t SET c3=40 WHERE c1=30;
3119 include/rpl_sync.inc
3120 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3121 DELETE FROM t WHERE c2="a";
3122 DELETE FROM t WHERE c1=20;
3123 DELETE FROM t;
3124 include/rpl_sync.inc
3125 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3126 DROP TABLE t;
3127 include/rpl_sync.inc
3128 SET SQL_LOG_BIN=0;
3129 SET SQL_LOG_BIN=0;
3130 SET SQL_LOG_BIN=0;
3131 ### Master with no key, slaves with PKs on different fields (first slave with UK NOT NULL, second with PK)
3132 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int) engine= InnoDB;;
3133 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= InnoDB;;
3134 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= InnoDB;;
3135 SET SQL_LOG_BIN=1;
3136 SET SQL_LOG_BIN=1;
3137 SET SQL_LOG_BIN=1;
3138 INSERT INTO t VALUES (1, "a", 10);
3139 INSERT INTO t VALUES (2, "b", 20);
3140 INSERT INTO t VALUES (3, "c", 30);
3141 include/rpl_sync.inc
3142 UPDATE t SET c1=10 WHERE c2="a";
3143 UPDATE t SET c1=20 WHERE c1=2;
3144 UPDATE t SET c1=30 WHERE c3=30;
3145 UPDATE t SET c3=40 WHERE c1=30;
3146 include/rpl_sync.inc
3147 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3148 DELETE FROM t WHERE c2="a";
3149 DELETE FROM t WHERE c1=20;
3150 DELETE FROM t;
3151 include/rpl_sync.inc
3152 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3153 DROP TABLE t;
3154 include/rpl_sync.inc
3155 SET SQL_LOG_BIN=0;
3156 SET SQL_LOG_BIN=0;
3157 SET SQL_LOG_BIN=0;
3158 ### Master with no key, slaves with PKs on different fields
3159 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
3160 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= InnoDB;;
3161 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= InnoDB;;
3162 SET SQL_LOG_BIN=1;
3163 SET SQL_LOG_BIN=1;
3164 SET SQL_LOG_BIN=1;
3165 INSERT INTO t VALUES (1, "a", 10);
3166 INSERT INTO t VALUES (2, "b", 20);
3167 INSERT INTO t VALUES (3, "c", 30);
3168 include/rpl_sync.inc
3169 UPDATE t SET c1=10 WHERE c2="a";
3170 UPDATE t SET c1=20 WHERE c1=2;
3171 UPDATE t SET c1=30 WHERE c3=30;
3172 UPDATE t SET c3=40 WHERE c1=30;
3173 include/rpl_sync.inc
3174 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3175 DELETE FROM t WHERE c2="a";
3176 DELETE FROM t WHERE c1=20;
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 DROP TABLE t;
3181 include/rpl_sync.inc
3182 SET SQL_LOG_BIN=0;
3183 SET SQL_LOG_BIN=0;
3184 SET SQL_LOG_BIN=0;
3185 ### Master with Key, slaves with no keys
3186 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= InnoDB;;
3187 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
3188 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
3189 SET SQL_LOG_BIN=1;
3190 SET SQL_LOG_BIN=1;
3191 SET SQL_LOG_BIN=1;
3192 INSERT INTO t VALUES (1, "a", 10);
3193 INSERT INTO t VALUES (2, "b", 20);
3194 INSERT INTO t VALUES (3, "c", 30);
3195 include/rpl_sync.inc
3196 UPDATE t SET c1=10 WHERE c2="a";
3197 UPDATE t SET c1=20 WHERE c1=2;
3198 UPDATE t SET c1=30 WHERE c3=30;
3199 UPDATE t SET c3=40 WHERE c1=30;
3200 include/rpl_sync.inc
3201 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3202 DELETE FROM t WHERE c2="a";
3203 DELETE FROM t WHERE c1=20;
3204 DELETE FROM t;
3205 include/rpl_sync.inc
3206 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3207 DROP TABLE t;
3208 include/rpl_sync.inc
3209 SET SQL_LOG_BIN=0;
3210 SET SQL_LOG_BIN=0;
3211 SET SQL_LOG_BIN=0;
3212 ### Master with Key, first slave with key on different field and second slave with key on yet another different field.
3213 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c1)) engine= InnoDB;;
3214 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= InnoDB;;
3215 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= InnoDB;;
3216 SET SQL_LOG_BIN=1;
3217 SET SQL_LOG_BIN=1;
3218 SET SQL_LOG_BIN=1;
3219 INSERT INTO t VALUES (1, "a", 10);
3220 INSERT INTO t VALUES (2, "b", 20);
3221 INSERT INTO t VALUES (3, "c", 30);
3222 include/rpl_sync.inc
3223 UPDATE t SET c1=10 WHERE c2="a";
3224 UPDATE t SET c1=20 WHERE c1=2;
3225 UPDATE t SET c1=30 WHERE c3=30;
3226 UPDATE t SET c3=40 WHERE c1=30;
3227 include/rpl_sync.inc
3228 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3229 DELETE FROM t WHERE c2="a";
3230 DELETE FROM t WHERE c1=20;
3231 DELETE FROM t;
3232 include/rpl_sync.inc
3233 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3234 DROP TABLE t;
3235 include/rpl_sync.inc
3236 SET SQL_LOG_BIN=0;
3237 SET SQL_LOG_BIN=0;
3238 SET SQL_LOG_BIN=0;
3239 ### Master with Key, slaves with PKs on different fields (first slave has UK NOT NULL)
3240 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, key(c1)) engine= InnoDB;;
3241 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= InnoDB;;
3242 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= InnoDB;;
3243 SET SQL_LOG_BIN=1;
3244 SET SQL_LOG_BIN=1;
3245 SET SQL_LOG_BIN=1;
3246 INSERT INTO t VALUES (1, "a", 10);
3247 INSERT INTO t VALUES (2, "b", 20);
3248 INSERT INTO t VALUES (3, "c", 30);
3249 include/rpl_sync.inc
3250 UPDATE t SET c1=10 WHERE c2="a";
3251 UPDATE t SET c1=20 WHERE c1=2;
3252 UPDATE t SET c1=30 WHERE c3=30;
3253 UPDATE t SET c3=40 WHERE c1=30;
3254 include/rpl_sync.inc
3255 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3256 DELETE FROM t WHERE c2="a";
3257 DELETE FROM t WHERE c1=20;
3258 DELETE FROM t;
3259 include/rpl_sync.inc
3260 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3261 DROP TABLE t;
3262 include/rpl_sync.inc
3263 SET SQL_LOG_BIN=0;
3264 SET SQL_LOG_BIN=0;
3265 SET SQL_LOG_BIN=0;
3266 ### Master with Key, slaves with PKs on different fields
3267 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c1)) engine= InnoDB;;
3268 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= InnoDB;;
3269 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= InnoDB;;
3270 SET SQL_LOG_BIN=1;
3271 SET SQL_LOG_BIN=1;
3272 SET SQL_LOG_BIN=1;
3273 INSERT INTO t VALUES (1, "a", 10);
3274 INSERT INTO t VALUES (2, "b", 20);
3275 INSERT INTO t VALUES (3, "c", 30);
3276 include/rpl_sync.inc
3277 UPDATE t SET c1=10 WHERE c2="a";
3278 UPDATE t SET c1=20 WHERE c1=2;
3279 UPDATE t SET c1=30 WHERE c3=30;
3280 UPDATE t SET c3=40 WHERE c1=30;
3281 include/rpl_sync.inc
3282 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3283 DELETE FROM t WHERE c2="a";
3284 DELETE FROM t WHERE c1=20;
3285 DELETE FROM t;
3286 include/rpl_sync.inc
3287 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3288 DROP TABLE t;
3289 include/rpl_sync.inc
3290 SET SQL_LOG_BIN=0;
3291 SET SQL_LOG_BIN=0;
3292 SET SQL_LOG_BIN=0;
3293 ### Master with UK NULLABLE, slaves with no keys
3294 CREATE TABLE t (c1 int, c2 blob, c3 int, unique key(c3)) engine= InnoDB;;
3295 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
3296 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
3297 SET SQL_LOG_BIN=1;
3298 SET SQL_LOG_BIN=1;
3299 SET SQL_LOG_BIN=1;
3300 INSERT INTO t VALUES (1, "a", 10);
3301 INSERT INTO t VALUES (2, "b", 20);
3302 INSERT INTO t VALUES (3, "c", 30);
3303 include/rpl_sync.inc
3304 UPDATE t SET c1=10 WHERE c2="a";
3305 UPDATE t SET c1=20 WHERE c1=2;
3306 UPDATE t SET c1=30 WHERE c3=30;
3307 UPDATE t SET c3=40 WHERE c1=30;
3308 include/rpl_sync.inc
3309 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3310 DELETE FROM t WHERE c2="a";
3311 DELETE FROM t WHERE c1=20;
3312 DELETE FROM t;
3313 include/rpl_sync.inc
3314 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3315 DROP TABLE t;
3316 include/rpl_sync.inc
3317 SET SQL_LOG_BIN=0;
3318 SET SQL_LOG_BIN=0;
3319 SET SQL_LOG_BIN=0;
3320 ### Master with UK NULLABLE, first slave with K on different field second slave with key on yet another different field
3321 CREATE TABLE t (c1 int, c2 blob, c3 int, unique key(c1)) engine= InnoDB;;
3322 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= InnoDB;;
3323 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= InnoDB;;
3324 SET SQL_LOG_BIN=1;
3325 SET SQL_LOG_BIN=1;
3326 SET SQL_LOG_BIN=1;
3327 INSERT INTO t VALUES (1, "a", 10);
3328 INSERT INTO t VALUES (2, "b", 20);
3329 INSERT INTO t VALUES (3, "c", 30);
3330 include/rpl_sync.inc
3331 UPDATE t SET c1=10 WHERE c2="a";
3332 UPDATE t SET c1=20 WHERE c1=2;
3333 UPDATE t SET c1=30 WHERE c3=30;
3334 UPDATE t SET c3=40 WHERE c1=30;
3335 include/rpl_sync.inc
3336 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3337 DELETE FROM t WHERE c2="a";
3338 DELETE FROM t WHERE c1=20;
3339 DELETE FROM t;
3340 include/rpl_sync.inc
3341 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3342 DROP TABLE t;
3343 include/rpl_sync.inc
3344 SET SQL_LOG_BIN=0;
3345 SET SQL_LOG_BIN=0;
3346 SET SQL_LOG_BIN=0;
3347 ### Master with UK NOT NULL, first slave with UK NOT NULL on different field
3348 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c1)) engine= InnoDB;;
3349 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= InnoDB;;
3350 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= InnoDB;;
3351 SET SQL_LOG_BIN=1;
3352 SET SQL_LOG_BIN=1;
3353 SET SQL_LOG_BIN=1;
3354 INSERT INTO t VALUES (1, "a", 10);
3355 INSERT INTO t VALUES (2, "b", 20);
3356 INSERT INTO t VALUES (3, "c", 30);
3357 include/rpl_sync.inc
3358 UPDATE t SET c1=10 WHERE c2="a";
3359 UPDATE t SET c1=20 WHERE c1=2;
3360 UPDATE t SET c1=30 WHERE c3=30;
3361 UPDATE t SET c3=40 WHERE c1=30;
3362 include/rpl_sync.inc
3363 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3364 DELETE FROM t WHERE c2="a";
3365 DELETE FROM t WHERE c1=20;
3366 DELETE FROM t;
3367 include/rpl_sync.inc
3368 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3369 DROP TABLE t;
3370 include/rpl_sync.inc
3371 SET SQL_LOG_BIN=0;
3372 SET SQL_LOG_BIN=0;
3373 SET SQL_LOG_BIN=0;
3374 ### Master with UK NOT NULL and slaves with PK on different fields
3375 CREATE TABLE t (c1 int NOT NULL, c2 blob, c3 int, unique key(c1)) engine= InnoDB;;
3376 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= InnoDB;;
3377 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= InnoDB;;
3378 SET SQL_LOG_BIN=1;
3379 SET SQL_LOG_BIN=1;
3380 SET SQL_LOG_BIN=1;
3381 INSERT INTO t VALUES (1, "a", 10);
3382 INSERT INTO t VALUES (2, "b", 20);
3383 INSERT INTO t VALUES (3, "c", 30);
3384 include/rpl_sync.inc
3385 UPDATE t SET c1=10 WHERE c2="a";
3386 UPDATE t SET c1=20 WHERE c1=2;
3387 UPDATE t SET c1=30 WHERE c3=30;
3388 UPDATE t SET c3=40 WHERE c1=30;
3389 include/rpl_sync.inc
3390 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3391 DELETE FROM t WHERE c2="a";
3392 DELETE FROM t WHERE c1=20;
3393 DELETE FROM t;
3394 include/rpl_sync.inc
3395 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3396 DROP TABLE t;
3397 include/rpl_sync.inc
3398 SET SQL_LOG_BIN=0;
3399 SET SQL_LOG_BIN=0;
3400 SET SQL_LOG_BIN=0;
3401 ### Master with PK and no keys on the slaves
3402 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c3)) engine= InnoDB;;
3403 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
3404 CREATE TABLE t (c1 int, c2 blob, c3 int) engine= InnoDB;;
3405 SET SQL_LOG_BIN=1;
3406 SET SQL_LOG_BIN=1;
3407 SET SQL_LOG_BIN=1;
3408 INSERT INTO t VALUES (1, "a", 10);
3409 INSERT INTO t VALUES (2, "b", 20);
3410 INSERT INTO t VALUES (3, "c", 30);
3411 include/rpl_sync.inc
3412 UPDATE t SET c1=10 WHERE c2="a";
3413 UPDATE t SET c1=20 WHERE c1=2;
3414 UPDATE t SET c1=30 WHERE c3=30;
3415 UPDATE t SET c3=40 WHERE c1=30;
3416 include/rpl_sync.inc
3417 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3418 DELETE FROM t WHERE c2="a";
3419 DELETE FROM t WHERE c1=20;
3420 DELETE FROM t;
3421 include/rpl_sync.inc
3422 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3423 DROP TABLE t;
3424 include/rpl_sync.inc
3425 SET SQL_LOG_BIN=0;
3426 SET SQL_LOG_BIN=0;
3427 SET SQL_LOG_BIN=0;
3428 ### Master with PK and first slave with KEY only
3429 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= InnoDB;;
3430 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c3)) engine= InnoDB;;
3431 CREATE TABLE t (c1 int, c2 blob, c3 int, key(c2(512))) engine= InnoDB;;
3432 SET SQL_LOG_BIN=1;
3433 SET SQL_LOG_BIN=1;
3434 SET SQL_LOG_BIN=1;
3435 INSERT INTO t VALUES (1, "a", 10);
3436 INSERT INTO t VALUES (2, "b", 20);
3437 INSERT INTO t VALUES (3, "c", 30);
3438 include/rpl_sync.inc
3439 UPDATE t SET c1=10 WHERE c2="a";
3440 UPDATE t SET c1=20 WHERE c1=2;
3441 UPDATE t SET c1=30 WHERE c3=30;
3442 UPDATE t SET c3=40 WHERE c1=30;
3443 include/rpl_sync.inc
3444 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3445 DELETE FROM t WHERE c2="a";
3446 DELETE FROM t WHERE c1=20;
3447 DELETE FROM t;
3448 include/rpl_sync.inc
3449 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3450 DROP TABLE t;
3451 include/rpl_sync.inc
3452 SET SQL_LOG_BIN=0;
3453 SET SQL_LOG_BIN=0;
3454 SET SQL_LOG_BIN=0;
3455 ### Different PKs on master and first slave (which has unique NOT NULL key instead of PK)
3456 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= InnoDB;;
3457 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, unique key(c2(512))) engine= InnoDB;;
3458 CREATE TABLE t (c1 int, c2 blob NOT NULL, c3 int, primary key(c1)) engine= InnoDB;;
3459 SET SQL_LOG_BIN=1;
3460 SET SQL_LOG_BIN=1;
3461 SET SQL_LOG_BIN=1;
3462 INSERT INTO t VALUES (1, "a", 10);
3463 INSERT INTO t VALUES (2, "b", 20);
3464 INSERT INTO t VALUES (3, "c", 30);
3465 include/rpl_sync.inc
3466 UPDATE t SET c1=10 WHERE c2="a";
3467 UPDATE t SET c1=20 WHERE c1=2;
3468 UPDATE t SET c1=30 WHERE c3=30;
3469 UPDATE t SET c3=40 WHERE c1=30;
3470 include/rpl_sync.inc
3471 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3472 DELETE FROM t WHERE c2="a";
3473 DELETE FROM t WHERE c1=20;
3474 DELETE FROM t;
3475 include/rpl_sync.inc
3476 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3477 DROP TABLE t;
3478 include/rpl_sync.inc
3479 SET SQL_LOG_BIN=0;
3480 SET SQL_LOG_BIN=0;
3481 SET SQL_LOG_BIN=0;
3482 ### Different PKs on master and first slave
3483 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= InnoDB;;
3484 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c2(512))) engine= InnoDB;;
3485 CREATE TABLE t (c1 int, c2 blob, c3 int, primary key(c1)) engine= InnoDB;;
3486 SET SQL_LOG_BIN=1;
3487 SET SQL_LOG_BIN=1;
3488 SET SQL_LOG_BIN=1;
3489 INSERT INTO t VALUES (1, "a", 10);
3490 INSERT INTO t VALUES (2, "b", 20);
3491 INSERT INTO t VALUES (3, "c", 30);
3492 include/rpl_sync.inc
3493 UPDATE t SET c1=10 WHERE c2="a";
3494 UPDATE t SET c1=20 WHERE c1=2;
3495 UPDATE t SET c1=30 WHERE c3=30;
3496 UPDATE t SET c3=40 WHERE c1=30;
3497 include/rpl_sync.inc
3498 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3499 DELETE FROM t WHERE c2="a";
3500 DELETE FROM t WHERE c1=20;
3501 DELETE FROM t;
3502 include/rpl_sync.inc
3503 include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
3504 DROP TABLE t;
3505 include/rpl_sync.inc
3506 CON: 'server_1', IMG: 'FULL', RESTART SLAVE: 'N'
3507 SET SESSION binlog_row_image= 'FULL';
3508 SET GLOBAL binlog_row_image= 'FULL';
3509 FLUSH TABLES;
3510 SHOW VARIABLES LIKE 'binlog_row_image';
3511 Variable_name Value
3512 binlog_row_image FULL
3513 CON: 'server_2', IMG: 'FULL', RESTART SLAVE: 'Y'
3514 SET SESSION binlog_row_image= 'FULL';
3515 SET GLOBAL binlog_row_image= 'FULL';
3516 include/stop_slave.inc
3517 include/start_slave.inc
3518 FLUSH TABLES;
3519 SHOW VARIABLES LIKE 'binlog_row_image';
3520 Variable_name Value
3521 binlog_row_image FULL
3522 CON: 'server_3', IMG: 'FULL', RESTART SLAVE: 'Y'
3523 SET SESSION binlog_row_image= 'FULL';
3524 SET GLOBAL binlog_row_image= 'FULL';
3525 include/stop_slave.inc
3526 include/start_slave.inc
3527 FLUSH TABLES;
3528 SHOW VARIABLES LIKE 'binlog_row_image';
3529 Variable_name Value
3530 binlog_row_image FULL
3531 include/rpl_end.inc