Debian Codegraph @

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