Debian Codegraph @

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

raw
1 ######################################################################
2 # Test restoring backups into similar schemas
3 ######################################################################
4
5 -- source include/have_ndb.inc
6 -- source suite/ndb/include/backup_restore_setup.inc
7
8 --echo Test ndb_restore ability to ignore some schema differences
9
10 use test;
11 create table t1 (
12 a int,
13 b int,
14 c int,
15 d int,
16 e varchar(200),
17 f int,
18 g char(20),
19 h text,
20 i int,
21 primary key(a,b)) engine = ndb;
22
23 insert into t1 values
24 (1, 1, 1, 1, '1', 1, 'Rankin', 'Rebus', 1),
25 (2, 2, 2, 2, '2', 2, 'Doyle', 'Holmes', 2),
26 (3, 3, 3, 3, '3', 3, 'Burns', 'Mouse', 3),
27 (4, 4, 4, 4, '4', 4, 'Gibbon', 'Chris', 4),
28 (5, 5, 5, 5, '5', 5, 'Gray', 'Lanark', 5);
29
30 select * from t1 order by a;
31
32 --echo Backing up data
33 --source include/ndb_backup.inc
34
35 drop table t1;
36
37 --echo Normal restore
38 --exec $NDB_RESTORE -b $the_backup_id -n 1 -r -m $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
39 --exec $NDB_RESTORE -b $the_backup_id -n 2 -r $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
40
41 --disable_warnings
42 show create table t1;
43 --enable_warnings
44
45 select * from t1 order by a;
46
47 truncate t1;
48
49 --echo Column name change, should fail without --exclude-missing-columns
50
51 alter table t1 change c cc int;
52
53 --error 1
54 --exec $NDB_RESTORE -b $the_backup_id -n 1 -r $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
55
56 --echo Retry with --exclude-missing-columns
57
58 --exec $NDB_RESTORE -b $the_backup_id -n 1 -r --exclude-missing-columns $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
59 --exec $NDB_RESTORE -b $the_backup_id -n 2 -r --exclude-missing-columns $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
60
61 select * from t1 order by a;
62 truncate t1;
63
64 --echo Column type change, should fail
65
66 alter table t1 change cc c bigint;
67 --disable_warnings
68 show create table t1; #REMOVE!
69 --enable_warnings
70 --error 1
71 --exec $NDB_RESTORE -b $the_backup_id -n 1 -r $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
72
73 --echo Retry with --promote-attributes
74
75 --exec $NDB_RESTORE -b $the_backup_id -n 1 -r --promote-attributes $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
76 --exec $NDB_RESTORE -b $the_backup_id -n 2 -r --promote-attributes $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
77
78 select * from t1 order by a;
79 truncate t1;
80
81 --echo Column nullability change, should fail
82
83 alter table t1 change c c int not null;
84
85 --error 1
86 --exec $NDB_RESTORE -b $the_backup_id -n 1 -r $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
87
88 alter table t1 change c c int;
89
90 # Skip Precision and scale differences - should fail
91
92 --echo Column length change, should fail
93
94 alter table t1 change g g char(22);
95
96 --error 1
97 --exec $NDB_RESTORE -b $the_backup_id -n 1 -r $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
98
99 --echo Character set difference, should fail
100
101 alter table t1 change g g char(20) character set binary;
102
103 --error 1
104 --exec $NDB_RESTORE -b $the_backup_id -n 1 -r $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
105
106 alter table t1 change g g char(20);
107
108 --echo AutoIncrement difference, should fail
109
110 alter table t1 change b b int auto_increment;
111
112 --error 1
113 --exec $NDB_RESTORE -b $the_backup_id -n 1 -r $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
114
115 --echo Default difference, should pass
116 alter table t1 change b b int default 22;
117
118 --exec $NDB_RESTORE -b $the_backup_id -n 1 -r $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
119 --exec $NDB_RESTORE -b $the_backup_id -n 2 -r $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
120
121 select * from t1 order by a;
122 truncate t1;
123
124 alter table t1 change b b int;
125
126 --echo ArrayType difference, should fail
127 alter table t1 change e e varchar(300);
128
129 --error 1
130 --exec $NDB_RESTORE -b $the_backup_id -n 1 -r $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
131
132 alter table t1 change e e varchar(200);
133
134 --echo StorageType difference, should pass
135 CREATE LOGFILE GROUP lg1
136 ADD UNDOFILE 'undofile.dat'
137 INITIAL_SIZE 16M
138 UNDO_BUFFER_SIZE = 1M
139 ENGINE=NDB;
140
141 CREATE TABLESPACE ts1
142 ADD DATAFILE 'datafile.dat'
143 USE LOGFILE GROUP lg1
144 INITIAL_SIZE 12M
145 ENGINE NDB;
146
147 alter table t1 TABLESPACE ts1, change i i int storage disk;
148
149 --exec $NDB_RESTORE -b $the_backup_id -n 1 -r $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
150 --exec $NDB_RESTORE -b $the_backup_id -n 2 -r $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
151
152 select * from t1 order by a;
153
154 alter table t1 change i i int storage memory;
155 truncate t1;
156
157 # Skip BlobType difference (should fail)
158
159 --echo Dynamic property difference, should pass
160
161 alter table t1 change c c int column_format dynamic;
162
163 --exec $NDB_RESTORE -b $the_backup_id -n 1 -r $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
164 --exec $NDB_RESTORE -b $the_backup_id -n 2 -r $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
165
166 select * from t1 order by a;
167
168 drop table t1;
169 alter tablespace ts1 drop datafile 'datafile.dat';
170 drop tablespace ts1;
171 drop logfile group lg1 engine=ndb;
172
173 --echo Different PK columns, should fail
174 create table t1 (
175 a int,
176 b int,
177 c int,
178 d int,
179 e varchar(200),
180 f int,
181 g char(20),
182 h text,
183 i int,
184 primary key (a)) engine = ndb;
185
186 --error 1
187 --exec $NDB_RESTORE -b $the_backup_id -n 1 -r $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
188
189 drop table t1;
190
191 --echo Different distribution keys, should pass
192
193 create table t1 (
194 a int,
195 b int,
196 c int,
197 d int,
198 e varchar(200),
199 f int,
200 g char(20),
201 h text,
202 i int,
203 primary key(a,b)) engine = ndb partition by key(a);
204
205 --exec $NDB_RESTORE -b $the_backup_id -n 1 -r $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
206 --exec $NDB_RESTORE -b $the_backup_id -n 2 -r $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
207
208 select * from t1 order by a;
209
210 drop table t1;
211
212 create table test.t1(id int primary key, val1 int unique, val2 char(20) unique) engine=ndb;
213 --source include/ndb_backup.inc
214 drop table test.t1;
215
216 --let $dump_file= $MYSQLTEST_VARDIR/tmp/restore_out.txt
217
218 --echo Test ndb_restore of backup containing unique index, should not warn since indexes are disabled
219
220 --echo # print metadata+data+log : should not warn
221 --exec $NDB_RESTORE -b $the_backup_id -n 1 --print $NDB_BACKUPS-$the_backup_id > $dump_file 2>&1
222 --source suite/ndb/include/ndb_restore_check_warn.inc
223
224 --echo # print metadata : should not warn
225 --exec $NDB_RESTORE -b $the_backup_id -n 1 --print-meta $NDB_BACKUPS-$the_backup_id > $dump_file 2>&1
226 --source suite/ndb/include/ndb_restore_check_warn.inc
227
228 --echo # metadata restore : should not warn
229 --exec $NDB_RESTORE -b $the_backup_id -n 1 -m $NDB_BACKUPS-$the_backup_id > $dump_file 2>&1
230 --source suite/ndb/include/ndb_restore_check_warn.inc
231
232 --echo # disable-indexes : should not warn
233 --exec $NDB_RESTORE -b $the_backup_id -n 1 --disable-indexes $NDB_BACKUPS-$the_backup_id > $dump_file 2>&1
234 --source suite/ndb/include/ndb_restore_check_warn.inc
235
236 --echo # print data : should not warn
237 --exec $NDB_RESTORE -b $the_backup_id -n 1 --print-data $NDB_BACKUPS-$the_backup_id > $dump_file 2>&1
238 --source suite/ndb/include/ndb_restore_check_warn.inc
239
240 --echo # print log : should not warn
241 --exec $NDB_RESTORE -b $the_backup_id -n 1 --print-log $NDB_BACKUPS-$the_backup_id > $dump_file 2>&1
242 --source suite/ndb/include/ndb_restore_check_warn.inc
243
244 --echo # restore data, but exclude indexed table : should not warn since unique indexes excluded and indexes are disabled
245 --exec $NDB_RESTORE -b $the_backup_id -n 1 -r --exclude-tables=test.t1 $NDB_BACKUPS-$the_backup_id > $dump_file 2>&1
246 --source suite/ndb/include/ndb_restore_check_warn.inc
247
248 --echo # restore data, but exclude database containing indexed table : should not warn since unique indexes excluded and indexes are disabled
249 --exec $NDB_RESTORE -b $the_backup_id -n 1 -r --exclude-databases=test $NDB_BACKUPS-$the_backup_id > $dump_file 2>&1
250 --source suite/ndb/include/ndb_restore_check_warn.inc
251
252 --echo # restore data : should not warn since indexes are disabled in one of the previous steps
253 --exec $NDB_RESTORE -b $the_backup_id -n 1 -r $NDB_BACKUPS-$the_backup_id > $dump_file 2>&1
254 --source suite/ndb/include/ndb_restore_check_warn.inc
255
256 --echo # restore epoch : should not warn
257 --exec $NDB_RESTORE -b $the_backup_id -n 1 -e $NDB_BACKUPS-$the_backup_id > $dump_file 2>&1
258 --source suite/ndb/include/ndb_restore_check_warn.inc
259
260 --echo # rebuild-indexes : should not warn
261 --exec $NDB_RESTORE -b $the_backup_id -n 1 --rebuild-indexes $NDB_BACKUPS-$the_backup_id > $dump_file 2>&1
262 --source suite/ndb/include/ndb_restore_check_warn.inc
263 drop table test.t1;
264
265 --echo Test ndb_restore of backup containing unique index, should warn since indexes are not disabled
266
267 --echo # metadata restore without --disable-indexes
268 --exec $NDB_RESTORE -b $the_backup_id -n 1 -m $NDB_BACKUPS-$the_backup_id > $dump_file 2>&1
269 --source suite/ndb/include/ndb_restore_check_warn.inc
270
271 --echo # restore data : should warn since indexes aren't disabled in the previous step (sprinkle with node id)
272 --exec $NDB_RESTORE --show-node-id -b $the_backup_id -n 1 -r $NDB_BACKUPS-$the_backup_id > $dump_file 2>&1
273 --source suite/ndb/include/ndb_restore_check_warn.inc
274
275 --remove_file $dump_file
276 drop table test.t1;
277
278 --echo Restore table with largest possible descriptor
279
280 create table grp_hssesmusersstoredbytenant(t1 bigint primary key,
281 t2 bigint unique default 65535,
282 t3 bigint unique default 65535,
283 t4 bigint unique default 65535,
284 t5 bigint unique default 65535,
285 t6 bigint unique default 65535,
286 t7 bigint unique default 65535,
287 t8 bigint unique default 65535,
288 t9 bigint unique default 65535,
289 t10 bigint unique default 65535,
290 t11 bigint unique default 65535,
291 t12 bigint unique default 65535,
292 t13 bigint unique default 65535,
293 t14 bigint unique default 65535,
294 t15 bigint unique default 65535,
295 t16 bigint unique default 65535,
296 t17 bigint unique default 65535,
297 t18 bigint unique default 65535,
298 t19 bigint unique default 65535,
299 t20 bigint unique default 65535,
300 t21 bigint unique default 65535,
301 t22 bigint unique default 65535,
302 t23 bigint unique default 65535,
303 t24 bigint unique default 65535,
304 t25 bigint unique default 65535,
305 t26 bigint unique default 65535,
306 t27 bigint unique default 65535,
307 t28 bigint unique default 65535,
308 t29 bigint unique default 65535,
309 t30 bigint unique default 65535,
310 t31 bigint unique default 65535,
311 t32 bigint unique default 65535,
312 t33 bigint unique default 65535,
313 t34 bigint unique default 65535,
314 t35 bigint unique default 65535,
315 t36 bigint unique default 65535,
316 t37 bigint unique default 65535,
317 t38 bigint unique default 65535,
318 t39 bigint unique default 65535,
319 t40 bigint unique default 65535,
320 t41 bigint unique default 65535,
321 t42 bigint unique default 65535,
322 t43 bigint unique default 65535,
323 t44 bigint unique default 65535,
324 t45 bigint unique default 65535,
325 t46 bigint unique default 65535,
326 t47 bigint unique default 65535,
327 t48 bigint unique default 65535,
328 t49 bigint unique default 65535,
329 t50 bigint unique default 65535,
330 t51 bigint unique default 65535,
331 t52 bigint unique default 65535,
332 t53 bigint unique default 65535,
333 t54 bigint unique default 65535,
334 t55 bigint unique default 65535,
335 t56 bigint unique default 65535,
336 t57 bigint unique default 65535,
337 t58 bigint unique default 65535,
338 t59 bigint unique default 65535,
339 t60 bigint unique default 65535,
340 t61 bigint unique default 65535,
341 t62 bigint unique default 65535,
342 t63 bigint unique default 65535,
343 t64 bigint unique default 65535,
344 t65 bigint default 65535,
345 t66 bigint default 65535,
346 t67 bigint default 65535,
347 t68 bigint default 65535,
348 t69 bigint default 65535,
349 t70 bigint default 65535,
350 t71 bigint default 65535,
351 t72 bigint default 65535,
352 t73 bigint default 65535,
353 t74 bigint default 65535,
354 t75 bigint default 65535,
355 t76 bigint default 65535,
356 t77 bigint default 65535,
357 t78 bigint default 65535,
358 t79 bigint default 65535,
359 t80 bigint default 65535,
360 t81 bigint default 65535,
361 t82 bigint default 65535,
362 t83 bigint default 65535,
363 t84 bigint default 65535,
364 t85 bigint default 65535,
365 t86 bigint default 65535,
366 t87 bigint default 65535,
367 t88 bigint default 65535,
368 t89 bigint default 65535,
369 t90 bigint default 65535,
370 t91 bigint default 65535,
371 t92 bigint default 65535,
372 t93 bigint default 65535,
373 t94 bigint default 65535,
374 t95 bigint default 65535,
375 t96 bigint default 65535,
376 t97 bigint default 65535,
377 t98 bigint default 65535,
378 t99 bigint default 65535,
379 t100 bigint default 65535,
380 t101 bigint default 65535,
381 t102 bigint default 65535,
382 t103 bigint default 65535,
383 t104 bigint default 65535,
384 t105 bigint default 65535,
385 t106 bigint default 65535,
386 t107 bigint default 65535,
387 t108 bigint default 65535,
388 t109 bigint default 65535,
389 t110 bigint default 65535,
390 t111 bigint default 65535,
391 t112 bigint default 65535,
392 t113 bigint default 65535,
393 t114 bigint default 65535,
394 t115 bigint default 65535,
395 t116 bigint default 65535,
396 t117 bigint default 65535,
397 t118 bigint default 65535,
398 t119 bigint default 65535,
399 t120 bigint default 65535,
400 t121 bigint default 65535,
401 t122 bigint default 65535,
402 t123 bigint default 65535,
403 t124 bigint default 65535,
404 t125 bigint default 65535,
405 t126 bigint default 65535,
406 t127 bigint default 65535,
407 t128 bigint default 65535,
408 t129 bigint default 65535,
409 t130 bigint default 65535,
410 t131 bigint default 65535,
411 t132 bigint default 65535,
412 t133 bigint default 65535,
413 t134 bigint default 65535,
414 t135 bigint default 65535,
415 t136 bigint default 65535,
416 t137 bigint default 65535,
417 t138 bigint default 65535,
418 t139 bigint default 65535,
419 t140 bigint default 65535,
420 t141 bigint default 65535,
421 t142 bigint default 65535,
422 t143 bigint default 65535,
423 t144 bigint default 65535,
424 t145 bigint default 65535,
425 t146 bigint default 65535,
426 t147 bigint default 65535,
427 t148 bigint default 65535,
428 t149 bigint default 65535,
429 t150 bigint default 65535,
430 t151 bigint default 65535,
431 t152 bigint default 65535,
432 t153 bigint default 65535,
433 t154 bigint default 65535,
434 t155 bigint default 65535,
435 t156 bigint default 65535,
436 t157 bigint default 65535,
437 t158 bigint default 65535,
438 t159 bigint default 65535,
439 t160 bigint default 65535,
440 t161 bigint default 65535,
441 t162 bigint default 65535,
442 t163 bigint default 65535,
443 t164 bigint default 65535,
444 t165 bigint default 65535,
445 t166 bigint default 65535,
446 t167 bigint default 65535,
447 t168 bigint default 65535,
448 t169 bigint default 65535,
449 t170 bigint default 65535,
450 t171 bigint default 65535,
451 t172 bigint default 65535,
452 t173 bigint default 65535,
453 t174 bigint default 65535,
454 t175 bigint default 65535,
455 t176 bigint default 65535,
456 t177 bigint default 65535,
457 t178 bigint default 65535,
458 t179 bigint default 65535,
459 t180 bigint default 65535,
460 t181 bigint default 65535,
461 t182 bigint default 65535,
462 t183 bigint default 65535,
463 t184 bigint default 65535,
464 t185 bigint default 65535,
465 t186 bigint default 65535,
466 t187 bigint default 65535,
467 t188 bigint default 65535,
468 t189 bigint default 65535,
469 t190 bigint default 65535,
470 t191 bigint default 65535,
471 t192 bigint default 65535,
472 t193 bigint default 65535,
473 t194 bigint default 65535,
474 t195 bigint default 65535,
475 t196 bigint default 65535,
476 t197 bigint default 65535,
477 t198 bigint default 65535,
478 t199 bigint default 65535,
479 t200 bigint default 65535,
480 t201 bigint default 65535,
481 t202 bigint default 65535,
482 t203 bigint default 65535,
483 t204 bigint default 65535,
484 t205 bigint default 65535,
485 t206 bigint default 65535,
486 t207 bigint default 65535,
487 t208 bigint default 65535,
488 t209 bigint default 65535,
489 t210 bigint default 65535,
490 t211 bigint default 65535,
491 t212 bigint default 65535,
492 t213 bigint default 65535,
493 t214 bigint default 65535,
494 t215 bigint default 65535,
495 t216 bigint default 65535,
496 t217 bigint default 65535,
497 t218 bigint default 65535,
498 t219 bigint default 65535,
499 t220 bigint default 65535,
500 t221 bigint default 65535,
501 t222 bigint default 65535,
502 t223 bigint default 65535,
503 t224 bigint default 65535,
504 t225 bigint default 65535,
505 t226 bigint default 65535,
506 t227 bigint default 65535,
507 t228 bigint default 65535,
508 t229 bigint default 65535,
509 t230 bigint default 65535,
510 t231 bigint default 65535,
511 t232 bigint default 65535,
512 t233 bigint default 65535,
513 t234 bigint default 65535,
514 t235 bigint default 65535,
515 t236 bigint default 65535,
516 t237 bigint default 65535,
517 t238 bigint default 65535,
518 t239 bigint default 65535,
519 t240 bigint default 65535,
520 t241 bigint default 65535,
521 t242 bigint default 65535,
522 t243 bigint default 65535,
523 t244 bigint default 65535,
524 t245 bigint default 65535,
525 t246 bigint default 65535,
526 t247 bigint default 65535,
527 t248 bigint default 65535,
528 t249 bigint default 65535,
529 t250 bigint default 65535,
530 t251 bigint default 65535,
531 t252 bigint default 65535,
532 t253 bigint default 65535,
533 t254 bigint default 65535,
534 t255 bigint default 65535,
535 t256 bigint default 65535,
536 t257 bigint default 65535,
537 t258 bigint default 65535,
538 t259 bigint default 65535,
539 t260 bigint default 65535,
540 t261 bigint default 65535,
541 t262 bigint default 65535,
542 t263 bigint default 65535,
543 t264 bigint default 65535,
544 t265 bigint default 65535,
545 t266 bigint default 65535,
546 t267 bigint default 65535,
547 t268 bigint default 65535,
548 t269 bigint default 65535,
549 t270 bigint default 65535,
550 t271 bigint default 65535,
551 t272 bigint default 65535,
552 t273 bigint default 65535,
553 t274 bigint default 65535,
554 t275 bigint default 65535,
555 t276 bigint default 65535,
556 t277 bigint default 65535,
557 t278 bigint default 65535,
558 t279 bigint default 65535,
559 t280 bigint default 65535,
560 t281 bigint default 65535,
561 t282 bigint default 65535,
562 t283 bigint default 65535,
563 t284 bigint default 65535,
564 t285 bigint default 65535,
565 t286 bigint default 65535,
566 t287 bigint default 65535,
567 t288 bigint default 65535,
568 t289 bigint default 65535,
569 t290 bigint default 65535,
570 t291 bigint default 65535,
571 t292 bigint default 65535,
572 t293 bigint default 65535,
573 t294 bigint default 65535,
574 t295 bigint default 65535,
575 t296 bigint default 65535,
576 t297 bigint default 65535,
577 t298 bigint default 65535,
578 t299 bigint default 65535,
579 t300 bigint default 65535,
580 t301 bigint default 65535,
581 t302 bigint default 65535,
582 t303 bigint default 65535,
583 t304 bigint default 65535,
584 t305 bigint default 65535,
585 t306 bigint default 65535,
586 t307 bigint default 65535,
587 t308 bigint default 65535,
588 t309 bigint default 65535,
589 t310 bigint default 65535,
590 t311 bigint default 65535,
591 t312 bigint default 65535,
592 t313 bigint default 65535,
593 t314 bigint default 65535,
594 t315 bigint default 65535,
595 t316 bigint default 65535,
596 t317 bigint default 65535,
597 t318 bigint default 65535,
598 t319 bigint default 65535,
599 t320 bigint default 65535,
600 t321 bigint default 65535,
601 t322 bigint default 65535,
602 t323 bigint default 65535,
603 t324 bigint default 65535,
604 t325 bigint default 65535,
605 t326 bigint default 65535,
606 t327 bigint default 65535,
607 t328 bigint default 65535,
608 t329 bigint default 65535,
609 t330 bigint default 65535,
610 t331 bigint default 65535,
611 t332 bigint default 65535,
612 t333 bigint default 65535,
613 t334 bigint default 65535,
614 t335 bigint default 65535,
615 t336 bigint default 65535,
616 t337 bigint default 65535,
617 t338 bigint default 65535,
618 t339 bigint default 65535,
619 t340 bigint default 65535,
620 t341 bigint default 65535,
621 t342 bigint default 65535,
622 t343 bigint default 65535,
623 t344 bigint default 65535,
624 t345 bigint default 65535,
625 t346 bigint default 65535,
626 t347 bigint default 65535,
627 t348 bigint default 65535,
628 t349 bigint default 65535,
629 t350 bigint default 65535,
630 t351 bigint default 65535,
631 t352 bigint default 65535,
632 t353 bigint default 65535,
633 t354 bigint default 65535,
634 t355 bigint default 65535,
635 t356 bigint default 65535,
636 t357 bigint default 65535,
637 t358 bigint default 65535,
638 t359 bigint default 65535,
639 t360 bigint default 65535,
640 t361 bigint default 65535,
641 t362 bigint default 65535,
642 t363 bigint default 65535,
643 t364 bigint default 65535,
644 t365 bigint default 65535,
645 t366 bigint default 65535,
646 t367 bigint default 65535,
647 t368 bigint default 65535,
648 t369 bigint default 65535,
649 t370 bigint default 65535,
650 t371 bigint default 65535,
651 t372 bigint default 65535,
652 t373 bigint default 65535,
653 t374 bigint default 65535,
654 t375 bigint default 65535,
655 t376 bigint default 65535,
656 t377 bigint default 65535,
657 t378 bigint default 65535,
658 t379 bigint default 65535,
659 t380 bigint default 65535,
660 t381 bigint default 65535,
661 t382 bigint default 65535,
662 t383 bigint default 65535,
663 t384 bigint default 65535,
664 t385 bigint default 65535,
665 t386 bigint default 65535,
666 t387 bigint default 65535,
667 t388 bigint default 65535,
668 t389 bigint default 65535,
669 t390 bigint default 65535,
670 t391 bigint default 65535,
671 t392 bigint default 65535,
672 t393 bigint default 65535,
673 t394 bigint default 65535,
674 t395 bigint default 65535,
675 t396 bigint default 65535,
676 t397 bigint default 65535,
677 t398 bigint default 65535,
678 t399 bigint default 65535,
679 t400 bigint default 65535,
680 t401 bigint default 65535,
681 t402 bigint default 65535,
682 t403 bigint default 65535,
683 t404 bigint default 65535,
684 t405 bigint default 65535,
685 t406 bigint default 65535,
686 t407 bigint default 65535,
687 t408 bigint default 65535,
688 t409 bigint default 65535,
689 t410 bigint default 65535,
690 t411 bigint default 65535,
691 t412 bigint default 65535,
692 t413 bigint default 65535,
693 t414 bigint default 65535,
694 t415 bigint default 65535,
695 t416 bigint default 65535,
696 t417 bigint default 65535,
697 t418 bigint default 65535,
698 t419 bigint default 65535,
699 t420 bigint default 65535,
700 t421 bigint default 65535,
701 t422 bigint default 65535,
702 t423 bigint default 65535,
703 t424 bigint default 65535,
704 t425 bigint default 65535,
705 t426 bigint default 65535,
706 t427 bigint default 65535,
707 t428 bigint default 65535,
708 t429 bigint default 65535,
709 t430 bigint default 65535,
710 t431 bigint default 65535,
711 t432 bigint default 65535,
712 t433 bigint default 65535,
713 t434 bigint default 65535,
714 t435 bigint default 65535,
715 t436 bigint default 65535,
716 t437 bigint default 65535,
717 t438 bigint default 65535,
718 t439 bigint default 65535,
719 t440 bigint default 65535,
720 t441 bigint default 65535,
721 t442 bigint default 65535,
722 t443 bigint default 65535,
723 t444 bigint default 65535,
724 t445 bigint default 65535,
725 t446 bigint default 65535,
726 t447 bigint default 65535,
727 t448 bigint default 65535,
728 t449 bigint default 65535,
729 t450 bigint default 65535,
730 t451 bigint default 65535,
731 t452 bigint default 65535,
732 t453 bigint default 65535,
733 t454 bigint default 65535,
734 t455 bigint default 65535,
735 t456 bigint default 65535,
736 t457 bigint default 65535,
737 t458 bigint default 65535,
738 t459 bigint default 65535,
739 t460 bigint default 65535,
740 t461 bigint default 65535,
741 t462 bigint default 65535,
742 t463 bigint default 65535,
743 t464 bigint default 65535,
744 t465 bigint default 65535,
745 t466 bigint default 65535,
746 t467 bigint default 65535,
747 t468 bigint default 65535,
748 t469 bigint default 65535,
749 t470 bigint default 65535,
750 t471 bigint default 65535,
751 t472 bigint default 65535,
752 t473 bigint default 65535,
753 t474 bigint default 65535,
754 t475 bigint default 65535,
755 t476 bigint default 65535,
756 t477 bigint default 65535,
757 t478 bigint default 65535,
758 t479 bigint default 65535,
759 t480 bigint default 65535,
760 t481 bigint default 65535,
761 t482 bigint default 65535,
762 t483 bigint default 65535,
763 t484 bigint default 65535,
764 t485 bigint default 65535,
765 t486 bigint default 65535,
766 t487 bigint default 65535,
767 t488 bigint default 65535,
768 t489 bigint default 65535,
769 t490 bigint default 65535,
770 t491 bigint default 65535,
771 t492 bigint default 65535,
772 t493 bigint default 65535,
773 t494 bigint default 65535,
774 t495 bigint default 65535,
775 t496 bigint default 65535,
776 t497 bigint default 65535,
777 t498 bigint default 65535,
778 t499 bigint default 65535,
779 t500 bigint default 65535,
780 t501 bigint default 65535,
781 t502 bigint default 65535,
782 t503 bigint default 65535,
783 t504 bigint default 65535,
784 t505 bigint default 65535,
785 t506 bigint default 65535,
786 t507 bigint default 65535,
787 t508 bigint default 65535,
788 t509 bigint default 65535,
789 t510 bigint default 65535,
790 t511 bigint default 65535,
791 t512 bigint default 65535
792 ) engine=ndb;
793
794 --echo Backing up data
795 --source include/ndb_backup.inc
796 drop table grp_hssesmusersstoredbytenant;
797
798 --exec $NDB_PRINT_BACKUP_FILE $NDB_BACKUP_DIR/BACKUP/BACKUP-$the_backup_id/BACKUP-$the_backup_id-PART-1-OF-4/BACKUP-$the_backup_id.1.ctl >> $NDB_TOOLS_OUTPUT
799
800 --exec $NDB_RESTORE -b $the_backup_id -n 1 -m --print-log $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
801
802 drop table grp_hssesmusersstoredbytenant;
803 --source suite/ndb/include/backup_restore_cleanup.inc
804 --remove_file $NDB_TOOLS_OUTPUT