Debian Codegraph @

mysql-test/suite/ndb/t/ndb_restore_schema_rewrites.test

raw
1 ######################################################################
2 # Test restoring backups into renamed databases
3 ######################################################################
4
5 -- source include/have_ndb.inc
6 -- source suite/ndb/include/backup_restore_setup.inc
7
8 # mysqld's configuration is not relevant to this test
9
10 --echo ************************************************************
11 --echo * Creating multiple databases with identical tables
12 --echo * (have blobs and indexes to cover the hidden tables)
13 --echo ************************************************************
14
15 CREATE DATABASE db0;
16 CREATE DATABASE db0_rewrite;
17 CREATE DATABASE db1;
18 CREATE DATABASE db2;
19
20 USE db0;
21 CREATE TABLE t0 (
22 id INT PRIMARY KEY,
23 cint INT,
24 cvarchar VARCHAR(5),
25 cblob BLOB(1000004),
26 UNIQUE INDEX UNIQUE_t0_0 USING BTREE (cint ASC),
27 UNIQUE INDEX UNIQUE_t0_2 USING BTREE (cvarchar ASC)
28 ) ENGINE=NDB;
29
30 USE db0_rewrite;
31 CREATE TABLE t0 (
32 id INT PRIMARY KEY,
33 cint INT,
34 cvarchar VARCHAR(5),
35 cblob BLOB(1000004),
36 UNIQUE INDEX UNIQUE_t0_0 USING BTREE (cint ASC),
37 UNIQUE INDEX UNIQUE_t0_2 USING BTREE (cvarchar ASC)
38 ) ENGINE=NDB;
39
40 USE db1;
41 CREATE TABLE t0 (
42 id INT PRIMARY KEY,
43 cint INT,
44 cvarchar VARCHAR(5),
45 cblob BLOB(1000004),
46 UNIQUE INDEX UNIQUE_t0_0 USING BTREE (cint ASC),
47 UNIQUE INDEX UNIQUE_t0_2 USING BTREE (cvarchar ASC)
48 ) ENGINE=NDB;
49
50 USE db2;
51 CREATE TABLE t0 (
52 id INT PRIMARY KEY,
53 cint INT,
54 cvarchar VARCHAR(5),
55 cblob BLOB(1000004),
56 UNIQUE INDEX UNIQUE_t0_0 USING BTREE (cint ASC),
57 UNIQUE INDEX UNIQUE_t0_2 USING BTREE (cvarchar ASC)
58 ) ENGINE=NDB;
59
60
61 --echo ************************************************************
62 --echo * Inserting data
63 --echo * (create disjunct sets of rows to merge without conflicts;
64 --echo * at this time, ndb_restore does not offer any detection
65 --echo * of data conflicts between databases in the backup or in
66 --echo * memory; databases are restored in an unspecified order)
67 --echo * (make blob data long enough to be held in extra table)
68 --echo ************************************************************
69
70 USE db0;
71 INSERT INTO t0 VALUES (0, 0, '00000', '123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890');
72 INSERT INTO t0 VALUES (1, 1, '11111', '123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890');
73 INSERT INTO t0 VALUES (2, 2, '22222', '123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890');
74
75 USE db1;
76 INSERT INTO t0 VALUES (3, 3, '33333', '123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890');
77 INSERT INTO t0 VALUES (4, 4, '44444', '123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890');
78 INSERT INTO t0 VALUES (5, 5, '55555', '123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890');
79
80 USE db2;
81 INSERT INTO t0 VALUES (6, 6, '66666', '123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890');
82 INSERT INTO t0 VALUES (7, 7, '77777', '123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890');
83 INSERT INTO t0 VALUES (8, 8, '88888', '123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890');
84
85 --echo ************************************************************
86 --echo * Creating in-memory copies of the NDB tables
87 --echo ************************************************************
88
89 CREATE TABLE db0.t0_data ENGINE=MYISAM AS SELECT * FROM db0.t0;
90 CREATE TABLE db1.t0_data ENGINE=MYISAM AS SELECT * FROM db1.t0;
91 CREATE TABLE db2.t0_data ENGINE=MYISAM AS SELECT * FROM db2.t0;
92
93 --echo ************************************************************
94 --echo * Backing up databases
95 --echo ************************************************************
96
97 --source include/ndb_backup.inc
98
99 # command shortcuts, cover rebuilding of indexes
100 --let $restore_cmd=$NDB_RESTORE
101 --let $restore_cmd=$restore_cmd --disable-indexes --rebuild-indexes
102 --let $restore_cmd=$restore_cmd -b $the_backup_id -r
103 --let $restore_cmd=$restore_cmd --backup_path=$NDB_BACKUPS-$the_backup_id
104
105 --echo ************************************************************
106 --echo * Restoring databases with no rewrite (sanity check)
107 --echo ************************************************************
108
109 # create temporary tables against which to compare data
110 CREATE TABLE db0.t0_temp ENGINE=MYISAM AS SELECT * FROM db0.t0_data;
111 CREATE TABLE db1.t0_temp ENGINE=MYISAM AS SELECT * FROM db1.t0_data;
112 CREATE TABLE db2.t0_temp ENGINE=MYISAM AS SELECT * FROM db2.t0_data;
113
114 # restore NDB tables
115 DELETE FROM db0.t0;
116 DELETE FROM db1.t0;
117 DELETE FROM db2.t0;
118 --let $restore_opt=
119 --exec $restore_cmd -n 1 $restore_opt --print > /dev/null
120 --exec $restore_cmd -n 2 $restore_opt --print > /dev/null
121
122 # summary-check ndb tables
123 SELECT COUNT(*) FROM db0.t0;
124 SELECT COUNT(*) FROM db1.t0;
125 SELECT COUNT(*) FROM db2.t0;
126
127 # verify ndb tables
128 SELECT COUNT(*) FROM db0.t0 NATURAL JOIN db0.t0_temp;
129 SELECT COUNT(*) FROM db1.t0 NATURAL JOIN db1.t0_temp;
130 SELECT COUNT(*) FROM db2.t0 NATURAL JOIN db2.t0_temp;
131
132 # delete temporary tables
133 DROP TABLE db0.t0_temp;
134 DROP TABLE db1.t0_temp;
135 DROP TABLE db2.t0_temp;
136
137 --echo ************************************************************
138 --echo * Negative testing: check wrong usage of command-line option
139 --echo * (expected exit code for usage errors: NDBT_WRONGARGS = 2)
140 --echo ************************************************************
141
142 # empty argument
143 --let $restore_opt=--rewrite-database=
144 --error 2
145 --exec $restore_cmd -n 1 $restore_opt > /dev/null
146
147 # missing separator
148 --let $restore_opt=--rewrite-database=aaaa
149 --error 2
150 --exec $restore_cmd -n 1 $restore_opt > /dev/null
151
152 # missing source and target
153 --let $restore_opt=--rewrite-database=,
154 --error 2
155 --exec $restore_cmd -n 1 $restore_opt > /dev/null
156
157 # missing source
158 --let $restore_opt=--rewrite-database=,a
159 --error 2
160 --exec $restore_cmd -n 1 $restore_opt > /dev/null
161
162 # missing target
163 --let $restore_opt=--rewrite-database=a,
164 --error 2
165 --exec $restore_cmd -n 1 $restore_opt > /dev/null
166
167 --echo ************************************************************
168 --echo * Restoring databases with rewritten source db excluded
169 --echo ************************************************************
170
171 # create temporary tables against which to compare data
172 CREATE TABLE db0.t0_temp ENGINE=MYISAM AS SELECT * FROM db0.t0_data;
173 CREATE TABLE db1.t0_temp ENGINE=MYISAM AS SELECT * FROM db1.t0_data;
174 CREATE TABLE db2.t0_temp ENGINE=MYISAM AS SELECT * FROM db2.t0_data;
175
176 # restore NDB tables
177 DELETE FROM db0.t0;
178 DELETE FROM db0_rewrite.t0;
179 DELETE FROM db1.t0;
180 DELETE FROM db2.t0;
181 --let $restore_opt=--rewrite-database=db0,db0_rewrite --exclude-databases=db0
182 --exec $restore_cmd -n 1 $restore_opt --print > /dev/null
183 --exec $restore_cmd -n 2 $restore_opt --print > /dev/null
184
185 # summary-check ndb tables
186 SELECT COUNT(*) FROM db0.t0;
187 SELECT COUNT(*) FROM db0_rewrite.t0;
188 SELECT COUNT(*) FROM db1.t0;
189 SELECT COUNT(*) FROM db2.t0;
190
191 # verify ndb tables
192 SELECT COUNT(*) FROM db0.t0 NATURAL JOIN db0.t0_temp;
193 SELECT COUNT(*) FROM db0_rewrite.t0 NATURAL JOIN db0.t0_temp;
194 SELECT COUNT(*) FROM db1.t0 NATURAL JOIN db1.t0_temp;
195 SELECT COUNT(*) FROM db2.t0 NATURAL JOIN db2.t0_temp;
196
197 # delete temporary tables
198 DROP TABLE db0.t0_temp;
199 DROP TABLE db1.t0_temp;
200 DROP TABLE db2.t0_temp;
201
202 --echo ************************************************************
203 --echo * Restoring databases with rewritten source db included
204 --echo ************************************************************
205
206 # create temporary tables against which to compare data
207 CREATE TABLE db0.t0_temp ENGINE=MYISAM AS SELECT * FROM db0.t0_data;
208 CREATE TABLE db1.t0_temp ENGINE=MYISAM AS SELECT * FROM db1.t0_data;
209 CREATE TABLE db2.t0_temp ENGINE=MYISAM AS SELECT * FROM db2.t0_data;
210
211 # restore NDB tables
212 DELETE FROM db0.t0;
213 DELETE FROM db0_rewrite.t0;
214 DELETE FROM db1.t0;
215 DELETE FROM db2.t0;
216 --let $restore_opt=--rewrite-database=db0,db0_rewrite --include-databases=db0
217 --exec $restore_cmd -n 1 $restore_opt --print > /dev/null
218 --exec $restore_cmd -n 2 $restore_opt --print > /dev/null
219
220 # summary-check ndb tables
221 SELECT COUNT(*) FROM db0.t0;
222 SELECT COUNT(*) FROM db0_rewrite.t0;
223 SELECT COUNT(*) FROM db1.t0;
224 SELECT COUNT(*) FROM db2.t0;
225
226 # verify ndb tables
227 SELECT COUNT(*) FROM db0.t0 NATURAL JOIN db0.t0_temp;
228 SELECT COUNT(*) FROM db0_rewrite.t0 NATURAL JOIN db0.t0_temp;
229 SELECT COUNT(*) FROM db1.t0 NATURAL JOIN db1.t0_temp;
230 SELECT COUNT(*) FROM db2.t0 NATURAL JOIN db2.t0_temp;
231
232 # delete temporary tables
233 DROP TABLE db0.t0_temp;
234 DROP TABLE db1.t0_temp;
235 DROP TABLE db2.t0_temp;
236
237 --echo ************************************************************
238 --echo * Restoring databases with rewritten destination db excluded
239 --echo ************************************************************
240
241 # create temporary tables against which to compare data
242 CREATE TABLE db0.t0_temp ENGINE=MYISAM AS SELECT * FROM db0.t0_data;
243 CREATE TABLE db1.t0_temp ENGINE=MYISAM AS SELECT * FROM db1.t0_data;
244 CREATE TABLE db2.t0_temp ENGINE=MYISAM AS SELECT * FROM db2.t0_data;
245
246 # restore NDB tables
247 DELETE FROM db0.t0;
248 DELETE FROM db0_rewrite.t0;
249 DELETE FROM db1.t0;
250 DELETE FROM db2.t0;
251 --let $restore_opt=--rewrite-database=db0,db0_rewrite --exclude-databases=db0_rewrite
252 --exec $restore_cmd -n 1 $restore_opt --print > /dev/null
253 --exec $restore_cmd -n 2 $restore_opt --print > /dev/null
254
255 # summary-check ndb tables
256 SELECT COUNT(*) FROM db0.t0;
257 SELECT COUNT(*) FROM db0_rewrite.t0;
258 SELECT COUNT(*) FROM db1.t0;
259 SELECT COUNT(*) FROM db2.t0;
260
261 # verify ndb tables
262 SELECT COUNT(*) FROM db0.t0 NATURAL JOIN db0.t0_temp;
263 SELECT COUNT(*) FROM db0_rewrite.t0 NATURAL JOIN db0.t0_temp;
264 SELECT COUNT(*) FROM db1.t0 NATURAL JOIN db1.t0_temp;
265 SELECT COUNT(*) FROM db2.t0 NATURAL JOIN db2.t0_temp;
266
267 # delete temporary tables
268 DROP TABLE db0.t0_temp;
269 DROP TABLE db1.t0_temp;
270 DROP TABLE db2.t0_temp;
271
272 --echo ************************************************************
273 --echo * Restoring databases with rewritten destination db included
274 --echo ************************************************************
275
276 # create temporary tables against which to compare data
277 CREATE TABLE db0.t0_temp ENGINE=MYISAM AS SELECT * FROM db0.t0_data;
278 CREATE TABLE db1.t0_temp ENGINE=MYISAM AS SELECT * FROM db1.t0_data;
279 CREATE TABLE db2.t0_temp ENGINE=MYISAM AS SELECT * FROM db2.t0_data;
280
281 # restore NDB tables
282 DELETE FROM db0.t0;
283 DELETE FROM db0_rewrite.t0;
284 DELETE FROM db1.t0;
285 DELETE FROM db2.t0;
286 --let $restore_opt=--rewrite-database=db0,db0_rewrite --include-databases=db0_rewrite
287 --exec $restore_cmd -n 1 $restore_opt --print > /dev/null
288 --exec $restore_cmd -n 2 $restore_opt --print > /dev/null
289
290 # summary-check ndb tables
291 SELECT COUNT(*) FROM db0.t0;
292 SELECT COUNT(*) FROM db0_rewrite.t0;
293 SELECT COUNT(*) FROM db1.t0;
294 SELECT COUNT(*) FROM db2.t0;
295
296 # verify ndb tables
297 SELECT COUNT(*) FROM db0.t0 NATURAL JOIN db0.t0_temp;
298 SELECT COUNT(*) FROM db0_rewrite.t0 NATURAL JOIN db0.t0_temp;
299 SELECT COUNT(*) FROM db1.t0 NATURAL JOIN db1.t0_temp;
300 SELECT COUNT(*) FROM db2.t0 NATURAL JOIN db2.t0_temp;
301
302 # delete temporary tables
303 DROP TABLE db0.t0_temp;
304 DROP TABLE db1.t0_temp;
305 DROP TABLE db2.t0_temp;
306
307 --echo ************************************************************
308 --echo * Restoring databases with redundant/self-rewrite options
309 --echo ************************************************************
310
311 # create temporary tables against which to compare data
312 CREATE TABLE db0.t0_temp ENGINE=MYISAM AS SELECT * FROM db0.t0_data;
313 CREATE TABLE db1.t0_temp ENGINE=MYISAM AS SELECT * FROM db1.t0_data;
314 CREATE TABLE db2.t0_temp ENGINE=MYISAM AS SELECT * FROM db2.t0_data;
315
316 # restore NDB tables
317 DELETE FROM db0.t0;
318 DELETE FROM db1.t0;
319 DELETE FROM db2.t0;
320 --let $restore_opt=--rewrite-database=db0,db0 --rewrite-database=db1,db1
321 --exec $restore_cmd -n 1 $restore_opt --print > /dev/null
322 --exec $restore_cmd -n 2 $restore_opt --print > /dev/null
323
324 # summary-check ndb tables
325 SELECT COUNT(*) FROM db0.t0;
326 SELECT COUNT(*) FROM db1.t0;
327 SELECT COUNT(*) FROM db2.t0;
328
329 # verify ndb tables
330 SELECT COUNT(*) FROM db0.t0 NATURAL JOIN db0.t0_temp;
331 SELECT COUNT(*) FROM db0_rewrite.t0 NATURAL JOIN db0.t0_temp;
332 SELECT COUNT(*) FROM db1.t0 NATURAL JOIN db1.t0_temp;
333 SELECT COUNT(*) FROM db2.t0 NATURAL JOIN db2.t0_temp;
334
335 # delete temporary tables
336 DROP TABLE db0.t0_temp;
337 DROP TABLE db1.t0_temp;
338 DROP TABLE db2.t0_temp;
339
340 --echo ************************************************************
341 --echo * Restoring databases with overriding rewrite options
342 --echo ************************************************************
343
344 # create temporary tables against which to compare data
345 CREATE TABLE db0.t0_temp ENGINE=MYISAM AS SELECT * FROM db0.t0_data;
346 CREATE TABLE db1.t0_temp ENGINE=MYISAM AS SELECT * FROM db1.t0_data;
347 CREATE TABLE db2.t0_temp ENGINE=MYISAM AS SELECT * FROM db2.t0_data;
348
349 # restore NDB tables
350 DELETE FROM db0.t0;
351 DELETE FROM db1.t0;
352 DELETE FROM db2.t0;
353 # no rewrite, since the later option overrides the former
354 --let $restore_opt=--rewrite-database=db0,db1 --rewrite-database=db0,db0
355 --exec $restore_cmd -n 1 $restore_opt --print > /dev/null
356 --exec $restore_cmd -n 2 $restore_opt --print > /dev/null
357
358 # summary-check ndb tables
359 SELECT COUNT(*) FROM db0.t0;
360 SELECT COUNT(*) FROM db1.t0;
361 SELECT COUNT(*) FROM db2.t0;
362
363 # verify ndb tables
364 SELECT COUNT(*) FROM db0.t0 NATURAL JOIN db0.t0_temp;
365 SELECT COUNT(*) FROM db0_rewrite.t0 NATURAL JOIN db0.t0_temp;
366 SELECT COUNT(*) FROM db1.t0 NATURAL JOIN db1.t0_temp;
367 SELECT COUNT(*) FROM db2.t0 NATURAL JOIN db2.t0_temp;
368
369 # delete temporary tables
370 DROP TABLE db0.t0_temp;
371 DROP TABLE db1.t0_temp;
372 DROP TABLE db2.t0_temp;
373
374 --echo ************************************************************
375 --echo * Restoring databases with a single rewrite
376 --echo ************************************************************
377
378 # create temporary tables against which to compare data
379 CREATE TABLE db0.t0_temp LIKE db0.t0_data;
380 CREATE TABLE db1.t0_temp LIKE db1.t0_data;
381 CREATE TABLE db2.t0_temp LIKE db2.t0_data;
382
383 # restore NDB tables
384 DELETE FROM db0.t0;
385 DELETE FROM db1.t0;
386 DELETE FROM db2.t0;
387 --let $restore_opt=--rewrite-database=db0,db1
388 --exec $restore_cmd -n 1 $restore_opt --print > /dev/null
389 --exec $restore_cmd -n 2 $restore_opt --print > /dev/null
390
391 # summary-check ndb tables
392 SELECT COUNT(*) FROM db0.t0;
393 SELECT COUNT(*) FROM db1.t0;
394 SELECT COUNT(*) FROM db2.t0;
395
396 # fill temporary tables
397 INSERT db1.t0_temp SELECT * FROM db0.t0_data;
398 INSERT db1.t0_temp SELECT * FROM db1.t0_data;
399 INSERT db2.t0_temp SELECT * FROM db2.t0_data;
400
401 # verify ndb tables
402 SELECT COUNT(*) FROM db0.t0 NATURAL JOIN db0.t0_temp;
403 SELECT COUNT(*) FROM db1.t0 NATURAL JOIN db1.t0_temp;
404 SELECT COUNT(*) FROM db2.t0 NATURAL JOIN db2.t0_temp;
405
406 # delete temporary tables
407 DROP TABLE db0.t0_temp;
408 DROP TABLE db1.t0_temp;
409 DROP TABLE db2.t0_temp;
410
411 --echo ************************************************************
412 --echo * Restoring databases with multiple rewrites
413 --echo ************************************************************
414
415 # create temporary tables against which to compare data
416 CREATE TABLE db0.t0_temp LIKE db0.t0_data;
417 CREATE TABLE db1.t0_temp LIKE db1.t0_data;
418 CREATE TABLE db2.t0_temp LIKE db2.t0_data;
419
420 # restore NDB tables
421 DELETE FROM db0.t0;
422 DELETE FROM db1.t0;
423 DELETE FROM db2.t0;
424 --let $restore_opt=--rewrite-database=db0,db1 --rewrite-database=db1,db2
425 --exec $restore_cmd -n 1 $restore_opt --print > /dev/null
426 --exec $restore_cmd -n 2 $restore_opt --print > /dev/null
427
428 # summary-check ndb tables
429 SELECT COUNT(*) FROM db0.t0;
430 SELECT COUNT(*) FROM db1.t0;
431 SELECT COUNT(*) FROM db2.t0;
432
433 # fill temporary tables
434 INSERT db1.t0_temp SELECT * FROM db0.t0_data;
435 INSERT db2.t0_temp SELECT * FROM db1.t0_data;
436 INSERT db2.t0_temp SELECT * FROM db2.t0_data;
437
438 # verify ndb tables
439 SELECT COUNT(*) FROM db0.t0 NATURAL JOIN db0.t0_temp;
440 SELECT COUNT(*) FROM db1.t0 NATURAL JOIN db1.t0_temp;
441 SELECT COUNT(*) FROM db2.t0 NATURAL JOIN db2.t0_temp;
442
443 # delete temporary tables
444 DROP TABLE db0.t0_temp;
445 DROP TABLE db1.t0_temp;
446 DROP TABLE db2.t0_temp;
447
448 --echo ************************************************************
449 --echo * Restoring databases with multiple rewrites into same target
450 --echo ************************************************************
451
452 # create temporary tables against which to compare data
453 CREATE TABLE db0.t0_temp LIKE db0.t0_data;
454 CREATE TABLE db1.t0_temp LIKE db1.t0_data;
455 CREATE TABLE db2.t0_temp LIKE db2.t0_data;
456
457 # restore NDB tables
458 DELETE FROM db0.t0;
459 DELETE FROM db1.t0;
460 DELETE FROM db2.t0;
461 --let $restore_opt=--rewrite-database=db0,db2 --rewrite-database=db1,db2
462 --exec $restore_cmd -n 1 $restore_opt --print > /dev/null
463 --exec $restore_cmd -n 2 $restore_opt --print > /dev/null
464
465 # summary-check ndb tables
466 SELECT COUNT(*) FROM db0.t0;
467 SELECT COUNT(*) FROM db1.t0;
468 SELECT COUNT(*) FROM db2.t0;
469
470 # fill temporary tables
471 INSERT db2.t0_temp SELECT * FROM db0.t0_data;
472 INSERT db2.t0_temp SELECT * FROM db1.t0_data;
473 INSERT db2.t0_temp SELECT * FROM db2.t0_data;
474
475 # verify ndb tables
476 SELECT COUNT(*) FROM db0.t0 NATURAL JOIN db0.t0_temp;
477 SELECT COUNT(*) FROM db1.t0 NATURAL JOIN db1.t0_temp;
478 SELECT COUNT(*) FROM db2.t0 NATURAL JOIN db2.t0_temp;
479
480 # delete temporary tables
481 DROP TABLE db0.t0_temp;
482 DROP TABLE db1.t0_temp;
483 DROP TABLE db2.t0_temp;
484
485 --echo ************************************************************
486 --echo * Restoring databases with swapping rewrites
487 --echo ************************************************************
488
489 # create temporary tables against which to compare data
490 CREATE TABLE db0.t0_temp LIKE db0.t0_data;
491 CREATE TABLE db1.t0_temp LIKE db1.t0_data;
492 CREATE TABLE db2.t0_temp LIKE db2.t0_data;
493
494 # restore NDB tables
495 DELETE FROM db0.t0;
496 DELETE FROM db1.t0;
497 DELETE FROM db2.t0;
498 --let $restore_opt=--rewrite-database=db0,db1 --rewrite-database=db1,db0
499 --exec $restore_cmd -n 1 $restore_opt --print > /dev/null
500 --exec $restore_cmd -n 2 $restore_opt --print > /dev/null
501
502 # summary-check ndb tables
503 SELECT COUNT(*) FROM db0.t0;
504 SELECT COUNT(*) FROM db1.t0;
505 SELECT COUNT(*) FROM db2.t0;
506
507 # fill temporary tables
508 INSERT db1.t0_temp SELECT * FROM db0.t0_data;
509 INSERT db0.t0_temp SELECT * FROM db1.t0_data;
510 INSERT db2.t0_temp SELECT * FROM db2.t0_data;
511
512 # verify ndb tables
513 SELECT COUNT(*) FROM db0.t0 NATURAL JOIN db0.t0_temp;
514 SELECT COUNT(*) FROM db1.t0 NATURAL JOIN db1.t0_temp;
515 SELECT COUNT(*) FROM db2.t0 NATURAL JOIN db2.t0_temp;
516
517 # delete temporary tables
518 DROP TABLE db0.t0_temp;
519 DROP TABLE db1.t0_temp;
520 DROP TABLE db2.t0_temp;
521
522 --echo ************************************************************
523 --echo * Restoring databases with permutating rewrites
524 --echo ************************************************************
525
526 # create temporary tables against which to compare data
527 CREATE TABLE db0.t0_temp LIKE db0.t0_data;
528 CREATE TABLE db1.t0_temp LIKE db1.t0_data;
529 CREATE TABLE db2.t0_temp LIKE db2.t0_data;
530
531 # restore NDB tables
532 DELETE FROM db0.t0;
533 DELETE FROM db1.t0;
534 DELETE FROM db2.t0;
535 --let $restore_opt=--rewrite-database=db0,db1 --rewrite-database=db1,db2
536 --let $restore_opt=$restore_opt --rewrite-database=db2,db0
537 --exec $restore_cmd -n 1 $restore_opt --print > /dev/null
538 --exec $restore_cmd -n 2 $restore_opt --print > /dev/null
539
540 # summary-check ndb tables
541 SELECT COUNT(*) FROM db0.t0;
542 SELECT COUNT(*) FROM db1.t0;
543 SELECT COUNT(*) FROM db2.t0;
544
545 # fill temporary tables
546 INSERT db1.t0_temp SELECT * FROM db0.t0_data;
547 INSERT db2.t0_temp SELECT * FROM db1.t0_data;
548 INSERT db0.t0_temp SELECT * FROM db2.t0_data;
549
550 # verify ndb tables
551 SELECT COUNT(*) FROM db0.t0 NATURAL JOIN db0.t0_temp;
552 SELECT COUNT(*) FROM db1.t0 NATURAL JOIN db1.t0_temp;
553 SELECT COUNT(*) FROM db2.t0 NATURAL JOIN db2.t0_temp;
554
555 # delete temporary tables
556 DROP TABLE db0.t0_temp;
557 DROP TABLE db1.t0_temp;
558 DROP TABLE db2.t0_temp;
559
560 --echo ************************************************************
561 --echo * Deleting tables and databases
562 --echo ************************************************************
563
564 DROP DATABASE db0;
565 DROP DATABASE db0_rewrite;
566 DROP DATABASE db1;
567 DROP DATABASE db2;
568 --source suite/ndb/include/backup_restore_cleanup.inc
569 --remove_file $NDB_TOOLS_OUTPUT