Debian Codegraph @

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

raw
1 -- source include/have_ndb.inc
2 -- source include/have_ndb_debug.inc
3 -- source suite/ndb/include/backup_restore_setup.inc
4
5 --disable_query_log
6 set @old_ndb_autoincrement_prefetch_sz = @@session.ndb_autoincrement_prefetch_sz;
7 set ndb_autoincrement_prefetch_sz = 1;
8 --enable_query_log
9
10 use test;
11
12
13 --echo Based on the test in ndb_restore_conv_remap
14 --echo But adds :
15 --echo - Log content (requiring ndb_debug)
16 --echo - Restore by slice
17 --echo - PK changes
18 --echo
19 --echo Schema has multiple tables connected via
20 --echo 'entry_key' which is remapped during restore
21 --echo Some tables also have their own local autoincrement id
22 --echo as part of their PK
23 --echo Some tables have TEXT(Blob) columns requiring staging
24 --echo tables to restore, others have schema changes which
25 --echo can be handled directly inline.
26
27
28 create table idx_tbl (entry_key bigint unsigned not null auto_increment,
29 k1 varchar(100),
30 k2 varchar(100),
31 data int,
32 primary key (k1, k2),
33 unique(entry_key)) engine=ndb;
34
35 create table type1_1 (entry_key bigint unsigned not null primary key,
36 data int) engine=ndb;
37
38 create table type1_2 (entry_key bigint unsigned not null primary key,
39 data int) engine=ndb;
40
41 create table type2_1 (entry_key bigint unsigned not null,
42 mv_idx bigint unsigned not null auto_increment,
43 data int,
44 primary key (entry_key, mv_idx)) engine=ndb;
45
46 create table type2_2 (entry_key bigint unsigned not null,
47 mv_idx bigint unsigned not null auto_increment,
48 data text,
49 primary key (entry_key, mv_idx)) engine=ndb;
50
51 # Old style type2 tables
52
53 # With TEXT (staging)
54 create table type2_3 (mv_idx bigint unsigned not null auto_increment,
55 entry_key bigint unsigned not null,
56 data text,
57 primary key (mv_idx)) engine = ndb;
58
59 # Without TEXT (direct - will use dynamically created pk mapping index)
60 create table type2_4 (mv_idx bigint unsigned not null auto_increment,
61 entry_key bigint unsigned not null,
62 data int,
63 primary key (mv_idx)) engine = ndb;
64
65 --echo Populate a number of entities, each with
66 --echo a couple of type_1 rows and a few sets of type_2 rows
67
68 insert into idx_tbl (k1,k2,data) values ('Edinburgh', 'UK', 1);
69 select last_insert_id() into @ek;
70 insert into type1_1 values (@ek, 11);
71 insert into type1_2 values (@ek, 12);
72 insert into type2_1 (entry_key, data) values (@ek, 110);
73 insert into type2_1 (entry_key, data) values (@ek, 111);
74 insert into type2_1 (entry_key, data) values (@ek, 112);
75 insert into type2_1 (entry_key, data) values (@ek, 113);
76 insert into type2_2 (entry_key, data) values (@ek, repeat("0121", 10000));
77 insert into type2_2 (entry_key, data) values (@ek, repeat("0122", 10000));
78 insert into type2_3 (entry_key, data) values (@ek, repeat("0124", 10000));
79 insert into type2_3 (entry_key, data) values (@ek, repeat("0125", 10000));
80 insert into type2_4 (entry_key, data) values (@ek, 126);
81 insert into type2_4 (entry_key, data) values (@ek, 127);
82
83 insert into idx_tbl (k1,k2,data) values ('Bristol', 'UK', 2);
84 select last_insert_id() into @ek;
85 insert into type1_1 values (@ek, 21);
86 insert into type1_2 values (@ek, 22);
87 insert into type2_1 (entry_key, data) values (@ek, 210);
88 insert into type2_1 (entry_key, data) values (@ek, 211);
89 insert into type2_1 (entry_key, data) values (@ek, 212);
90 insert into type2_1 (entry_key, data) values (@ek, 213);
91 insert into type2_2 (entry_key, data) values (@ek, repeat("0221", 10000));
92 insert into type2_2 (entry_key, data) values (@ek, repeat("0222", 10000));
93 insert into type2_3 (entry_key, data) values (@ek, repeat("0224", 10000));
94 insert into type2_3 (entry_key, data) values (@ek, repeat("0225", 10000));
95 insert into type2_4 (entry_key, data) values (@ek, 226);
96 insert into type2_4 (entry_key, data) values (@ek, 227);
97
98 insert into idx_tbl (k1,k2,data) values ('Glasgow', 'UK', 3);
99 select last_insert_id() into @ek;
100 insert into type1_1 values (@ek, 31);
101 insert into type1_2 values (@ek, 32);
102 insert into type2_1 (entry_key, data) values (@ek, 310);
103 insert into type2_1 (entry_key, data) values (@ek, 311);
104 insert into type2_1 (entry_key, data) values (@ek, 312);
105 insert into type2_1 (entry_key, data) values (@ek, 313);
106 insert into type2_2 (entry_key, data) values (@ek, repeat("0321", 10000));
107 insert into type2_2 (entry_key, data) values (@ek, repeat("0322", 10000));
108 insert into type2_3 (entry_key, data) values (@ek, repeat("0324", 10000));
109 insert into type2_3 (entry_key, data) values (@ek, repeat("0325", 10000));
110 insert into type2_4 (entry_key, data) values (@ek, 326);
111 insert into type2_4 (entry_key, data) values (@ek, 327);
112
113 insert into idx_tbl (k1,k2,data) values ('London', 'UK', 4);
114 select last_insert_id() into @ek;
115 insert into type1_1 values (@ek, 41);
116 insert into type1_2 values (@ek, 42);
117 insert into type2_1 (entry_key, data) values (@ek, 410);
118 insert into type2_1 (entry_key, data) values (@ek, 411);
119 insert into type2_1 (entry_key, data) values (@ek, 412);
120 insert into type2_1 (entry_key, data) values (@ek, 413);
121 insert into type2_2 (entry_key, data) values (@ek, repeat("0421", 10000));
122 insert into type2_2 (entry_key, data) values (@ek, repeat("0422", 10000));
123 insert into type2_3 (entry_key, data) values (@ek, repeat("0424", 10000));
124 insert into type2_3 (entry_key, data) values (@ek, repeat("0425", 10000));
125 insert into type2_4 (entry_key, data) values (@ek, 426);
126 insert into type2_4 (entry_key, data) values (@ek, 427);
127
128 insert into idx_tbl (k1,k2,data) values ('Paris', 'France', 5);
129 select last_insert_id() into @ek;
130 insert into type1_1 values (@ek, 51);
131 insert into type1_2 values (@ek, 52);
132 insert into type2_1 (entry_key, data) values (@ek, 510);
133 insert into type2_1 (entry_key, data) values (@ek, 511);
134 insert into type2_1 (entry_key, data) values (@ek, 512);
135 insert into type2_1 (entry_key, data) values (@ek, 513);
136 insert into type2_2 (entry_key, data) values (@ek, repeat("0521", 10000));
137 insert into type2_2 (entry_key, data) values (@ek, repeat("0522", 10000));
138 insert into type2_3 (entry_key, data) values (@ek, repeat("0524", 10000));
139 insert into type2_3 (entry_key, data) values (@ek, repeat("0525", 10000));
140 insert into type2_4 (entry_key, data) values (@ek, 526);
141 insert into type2_4 (entry_key, data) values (@ek, 527);
142
143 insert into idx_tbl (k1,k2,data) values ('Heidelberg', 'Germany', 6);
144 select last_insert_id() into @ek;
145 insert into type1_1 values (@ek, 61);
146 insert into type1_2 values (@ek, 62);
147 insert into type2_1 (entry_key, data) values (@ek, 610);
148 insert into type2_1 (entry_key, data) values (@ek, 611);
149 insert into type2_1 (entry_key, data) values (@ek, 612);
150 insert into type2_1 (entry_key, data) values (@ek, 613);
151 insert into type2_2 (entry_key, data) values (@ek, repeat("0621", 10000));
152 insert into type2_2 (entry_key, data) values (@ek, repeat("0622", 10000));
153 insert into type2_3 (entry_key, data) values (@ek, repeat("0624", 10000));
154 insert into type2_3 (entry_key, data) values (@ek, repeat("0625", 10000));
155 insert into type2_4 (entry_key, data) values (@ek, 626);
156 insert into type2_4 (entry_key, data) values (@ek, 627);
157
158 insert into idx_tbl (k1,k2,data) values ('Riga', 'Latvia', 7);
159 select last_insert_id() into @ek;
160 insert into type1_1 values (@ek, 71);
161 insert into type1_2 values (@ek, 72);
162 insert into type2_1 (entry_key, data) values (@ek, 710);
163 insert into type2_1 (entry_key, data) values (@ek, 711);
164 insert into type2_1 (entry_key, data) values (@ek, 712);
165 insert into type2_1 (entry_key, data) values (@ek, 713);
166 insert into type2_2 (entry_key, data) values (@ek, repeat("0721", 10000));
167 insert into type2_2 (entry_key, data) values (@ek, repeat("0722", 10000));
168 insert into type2_3 (entry_key, data) values (@ek, repeat("0724", 10000));
169 insert into type2_3 (entry_key, data) values (@ek, repeat("0725", 10000));
170 insert into type2_4 (entry_key, data) values (@ek, 726);
171 insert into type2_4 (entry_key, data) values (@ek, 727);
172
173 insert into idx_tbl (k1,k2,data) values ('Orlando', 'USA', 8);
174 select last_insert_id() into @ek;
175 insert into type1_1 values (@ek, 81);
176 insert into type1_2 values (@ek, 82);
177 insert into type2_1 (entry_key, data) values (@ek, 810);
178 insert into type2_1 (entry_key, data) values (@ek, 811);
179 insert into type2_1 (entry_key, data) values (@ek, 812);
180 insert into type2_1 (entry_key, data) values (@ek, 813);
181 insert into type2_2 (entry_key, data) values (@ek, repeat("0821", 10000));
182 insert into type2_2 (entry_key, data) values (@ek, repeat("0822", 10000));
183 insert into type2_3 (entry_key, data) values (@ek, repeat("0824", 10000));
184 insert into type2_3 (entry_key, data) values (@ek, repeat("0825", 10000));
185 insert into type2_4 (entry_key, data) values (@ek, 826);
186 insert into type2_4 (entry_key, data) values (@ek, 827);
187
188 --echo Start backup
189 --echo Cause backup to stall to allow changes
190 --exec $NDB_MGM -e "all error 10039" >> $NDB_TOOLS_OUTPUT
191 --source suite/ndb/t/ndb_backup_nowait_start.inc
192
193 --echo Now make some changes during the backup
194 update idx_tbl set data = data+10;
195 update type1_1 set data = data+100;
196 update type1_2 set data = data+100;
197 update type2_1 set data = data+1000;
198 update type2_2 set data = repeat(right(data, 4)+1000, 5000);
199 update type2_3 set data = repeat(right(data, 4)+2000, 5000);
200 update type2_4 set data = data + 3000;
201
202 update idx_tbl set data = data-10;
203 update type1_1 set data = data-100;
204 update type1_2 set data = data-100;
205 update type2_1 set data = data-1000;
206 update type2_2 set data = repeat(concat("0", right(data, 4)-1000), 10000);
207 update type2_3 set data = repeat(concat("0", right(data, 4)-2000), 10000);
208 update type2_4 set data = data - 3000;
209
210 --echo Unblock backup
211 --exec $NDB_MGM -e "all error 0" >> $NDB_TOOLS_OUTPUT
212
213 --source suite/ndb/t/ndb_backup_nowait_wait.inc
214 --let first_backup_id=$the_backup_id
215
216
217 select * from idx_tbl order by entry_key;
218 select * from type1_1 order by entry_key;
219 select * from type1_2 order by entry_key;
220 select * from type2_1 order by entry_key, mv_idx;
221 select entry_key, mv_idx, right(data, 4) from type2_2 order by entry_key, mv_idx;
222 select entry_key, mv_idx, right(data, 4) from type2_3 order by entry_key, mv_idx;
223 select * from type2_4 order by entry_key, mv_idx;
224
225 --echo First set of content
226 --echo --------------------
227 select idx_tbl.entry_key,
228 idx_tbl.k1,
229 idx_tbl.k2,
230 idx_tbl.data,
231 type1_1.data,
232 type1_2.data,
233 type2_1.mv_idx,
234 type2_1.data,
235 type2_2.mv_idx,
236 right(type2_2.data, 4),
237 length(type2_2.data),
238 right(type2_3.data, 4),
239 length(type2_3.data),
240 type2_4.mv_idx,
241 type2_4.data
242 from
243 idx_tbl join type1_1 join type1_2 join type2_1 join type2_2 join type2_3 join type2_4
244 on
245 idx_tbl.entry_key = type1_1.entry_key
246 and
247 idx_tbl.entry_key = type1_2.entry_key
248 and
249 idx_tbl.entry_key = type2_1.entry_key
250 and
251 idx_tbl.entry_key = type2_2.entry_key
252 and
253 idx_tbl.entry_key = type2_3.entry_key
254 and
255 idx_tbl.entry_key = type2_4.entry_key
256 order by idx_tbl.entry_key, type2_1.data, right(type2_2.data, 4), right(type2_3.data, 4), type2_4.data;
257
258 --echo Show auto-inc values
259 select count(1), max(entry_key) from test.idx_tbl;
260 show create table idx_tbl;
261 select count(1), max(mv_idx) from test.type2_1;
262 show create table type2_1;
263 select count(1), max(mv_idx) from test.type2_2;
264 show create table type2_2;
265 select count(1), max(mv_idx) from test.type2_3;
266 show create table type2_3;
267 select count(1), max(mv_idx) from test.type2_4;
268 show create table type2_4;
269
270 --echo No mv_idx duplicates in type_2 tables
271 select mv_idx, count(1) as ct
272 from type2_1 group by mv_idx
273 having ct > 1;
274 select mv_idx, count(1) as ct
275 from type2_2 group by mv_idx
276 having ct > 1;
277 select mv_idx, count(1) as ct
278 from type2_3 group by mv_idx
279 having ct > 1;
280 select mv_idx, count(1) as ct
281 from type2_4 group by mv_idx
282 having ct > 1;
283
284 --echo Create a different set of entities, with the same auto-inc
285 --echo keys for entry_key and mv_idx
286 update idx_tbl set k1="Stockholm", k2="Sweden" where entry_key = 1;
287 update idx_tbl set k1="Trondheim", k2="Norway" where entry_key = 2;
288 update idx_tbl set k1="Portland", k2="USA" where entry_key=3;
289 update idx_tbl set k1="Bangalore", k2="India" where entry_key=4;
290 update idx_tbl set k1="Helsinki", k2="Finland" where entry_key=5;
291 update idx_tbl set k1="Lisbon", k2="Portugal" where entry_key=6;
292 update idx_tbl set k1="Norrwaste", k2="Sweden" where entry_key=7;
293 update idx_tbl set k1="ROW", k2="Earth" where entry_key=8;
294
295 --echo Modify data to be distinct
296 update idx_tbl set data = data+10;
297 update type1_1 set data = data+100;
298 update type1_2 set data = data+100;
299 update type2_1 set data = data+1000;
300 update type2_2 set data = repeat(right(data, 4)+1000, 10000);
301 update type2_3 set data = repeat(right(data, 4)+2000, 10000);
302 update type2_4 set data = data+3000;
303
304 --echo Start backup
305 --echo Cause backup to stall to allow changes
306 --exec $NDB_MGM -e "all error 10039" >> $NDB_TOOLS_OUTPUT
307 --source suite/ndb/t/ndb_backup_nowait_start.inc
308
309 --echo Now make some changes during the backup
310 update idx_tbl set data = data+10;
311 update type1_1 set data = data+100;
312 update type1_2 set data = data+100;
313 update type2_1 set data = data+1000;
314 update type2_2 set data = repeat(right(data, 4)+1000, 5000);
315 update type2_3 set data = repeat(right(data, 4)+2000, 5000);
316 update type2_4 set data = data + 3000;
317
318 update idx_tbl set data = data-10;
319 update type1_1 set data = data-100;
320 update type1_2 set data = data-100;
321 update type2_1 set data = data-1000;
322 update type2_2 set data = repeat(right(data, 4)-1000, 10000);
323 update type2_3 set data = repeat(right(data, 4)-2000, 10000);
324 update type2_4 set data = data - 3000;
325
326 --echo Unblock backup
327 --exec $NDB_MGM -e "all error 0" >> $NDB_TOOLS_OUTPUT
328
329 --source suite/ndb/t/ndb_backup_nowait_wait.inc
330 --let second_backup_id=$the_backup_id
331
332 --echo Second set of content
333 --echo ---------------------
334 select idx_tbl.entry_key,
335 idx_tbl.k1,
336 idx_tbl.k2,
337 idx_tbl.data,
338 type1_1.data,
339 type1_2.data,
340 type2_1.mv_idx,
341 type2_1.data,
342 type2_2.mv_idx,
343 right(type2_2.data, 4),
344 length(type2_2.data),
345 right(type2_3.data, 4),
346 length(type2_3.data),
347 type2_4.mv_idx,
348 type2_4.data
349 from
350 idx_tbl join type1_1 join type1_2 join type2_1 join type2_2 join type2_3 join type2_4
351 on
352 idx_tbl.entry_key = type1_1.entry_key
353 and
354 idx_tbl.entry_key = type1_2.entry_key
355 and
356 idx_tbl.entry_key = type2_1.entry_key
357 and
358 idx_tbl.entry_key = type2_2.entry_key
359 and
360 idx_tbl.entry_key = type2_3.entry_key
361 and
362 idx_tbl.entry_key = type2_4.entry_key
363 order by idx_tbl.entry_key, type2_1.data, right(type2_2.data, 4), right(type2_3.data, 4), type2_4.data;
364
365 --echo Show auto-inc values
366 select count(1), max(entry_key) from test.idx_tbl;
367 show create table idx_tbl;
368 select count(1), max(mv_idx) from test.type2_1;
369 show create table type2_1;
370 select count(1), max(mv_idx) from test.type2_2;
371 show create table type2_2;
372 select count(1), max(mv_idx) from test.type2_3;
373 show create table type2_3;
374 select count(1), max(mv_idx) from test.type2_4;
375 show create table type2_4;
376
377 --echo No mv_idx duplicates in type_2 tables
378 select mv_idx, count(1) as ct
379 from type2_1 group by mv_idx
380 having ct > 1;
381 select mv_idx, count(1) as ct
382 from type2_2 group by mv_idx
383 having ct > 1;
384 select mv_idx, count(1) as ct
385 from type2_3 group by mv_idx
386 having ct > 1;
387 select mv_idx, count(1) as ct
388 from type2_4 group by mv_idx
389 having ct > 1;
390
391 select * from idx_tbl order by entry_key;
392 select * from type1_1 order by entry_key;
393 select * from type1_2 order by entry_key;
394 select * from type2_1 order by entry_key, mv_idx;
395 select entry_key, mv_idx, right(data, 4) from type2_2 order by entry_key, mv_idx;
396 select entry_key, mv_idx, right(data, 4) from type2_3 order by entry_key, mv_idx;
397 select * from type2_4 order by entry_key, mv_idx;
398
399 drop table idx_tbl, type1_1, type1_2, type2_1, type2_2, type2_3, type2_4;
400
401 --echo Recreate tables
402 create table idx_tbl (entry_key bigint unsigned not null auto_increment,
403 k1 varchar(100),
404 k2 varchar(100),
405 data int,
406 primary key (k1, k2),
407 unique(entry_key)) engine=ndb;
408
409 create table type1_1 (entry_key bigint unsigned not null primary key,
410 data int) engine=ndb;
411
412 create table type1_2 (entry_key bigint unsigned not null primary key,
413 data int) engine=ndb;
414
415 create table type2_1 (entry_key bigint unsigned not null,
416 mv_idx bigint unsigned not null auto_increment,
417 data int,
418 primary key (entry_key, mv_idx)) engine=ndb;
419
420 create table type2_2 (entry_key bigint unsigned not null,
421 mv_idx bigint unsigned not null auto_increment,
422 data text,
423 primary key (entry_key, mv_idx)) engine=ndb;
424
425 # Convert old type_2 tables to new format
426
427 create table type2_3 (entry_key bigint unsigned not null,
428 mv_idx bigint unsigned not null auto_increment,
429 data text,
430 primary key (entry_key, mv_idx)) engine = ndb;
431
432 create table type2_4 (entry_key bigint unsigned not null,
433 mv_idx bigint unsigned not null auto_increment,
434 data int,
435 primary key (entry_key, mv_idx)) engine = ndb;
436
437 --echo Run normal restore for first set of content
438 # Varying #slices for fun
439 --exec $NDB_RESTORE -b $first_backup_id -n 1 -r --allow-pk-changes --num-slices=3 --slice-id=0 $NDB_BACKUPS-$first_backup_id >> $NDB_TOOLS_OUTPUT
440 --exec $NDB_RESTORE -b $first_backup_id -n 1 -r --allow-pk-changes --num-slices=3 --slice-id=1 $NDB_BACKUPS-$first_backup_id >> $NDB_TOOLS_OUTPUT
441 --exec $NDB_RESTORE -b $first_backup_id -n 1 -r --allow-pk-changes --num-slices=3 --slice-id=2 $NDB_BACKUPS-$first_backup_id >> $NDB_TOOLS_OUTPUT
442
443 --exec $NDB_RESTORE -b $first_backup_id -n 2 -r --allow-pk-changes --num-slices=4 --slice-id=0 $NDB_BACKUPS-$first_backup_id >> $NDB_TOOLS_OUTPUT
444 --exec $NDB_RESTORE -b $first_backup_id -n 2 -r --allow-pk-changes --num-slices=4 --slice-id=1 $NDB_BACKUPS-$first_backup_id >> $NDB_TOOLS_OUTPUT
445 --exec $NDB_RESTORE -b $first_backup_id -n 2 -r --allow-pk-changes --num-slices=4 --slice-id=2 $NDB_BACKUPS-$first_backup_id >> $NDB_TOOLS_OUTPUT
446 --exec $NDB_RESTORE -b $first_backup_id -n 2 -r --allow-pk-changes --num-slices=4 --slice-id=3 $NDB_BACKUPS-$first_backup_id >> $NDB_TOOLS_OUTPUT
447
448 --let next_entry_key=query_get_value(select auto_increment from information_schema.tables where table_schema='test' and table_name='idx_tbl', AUTO_INCREMENT, 1)
449 --let next_type2_1=query_get_value(select auto_increment from information_schema.tables where table_schema='test' and table_name='type2_1', AUTO_INCREMENT, 1)
450 --let next_type2_2=query_get_value(select auto_increment from information_schema.tables where table_schema='test' and table_name='type2_2', AUTO_INCREMENT, 1)
451 --let next_type2_3=query_get_value(select auto_increment from information_schema.tables where table_schema='test' and table_name='type2_3', AUTO_INCREMENT, 1)
452 --let next_type2_4=query_get_value(select auto_increment from information_schema.tables where table_schema='test' and table_name='type2_4', AUTO_INCREMENT, 1)
453
454
455 --let remap_args = -x test.idx_tbl.entry_key:offset:$next_entry_key
456 --let remap_args = $remap_args -x test.type1_1.entry_key:offset:$next_entry_key
457 --let remap_args = $remap_args -x test.type1_2.entry_key:offset:$next_entry_key
458 --let remap_args = $remap_args -x test.type2_1.entry_key:offset:$next_entry_key
459 --let remap_args = $remap_args -x test.type2_1.mv_idx:offset:$next_type2_1
460 --let remap_args = $remap_args -x test.type2_2.entry_key:offset:$next_entry_key
461 --let remap_args = $remap_args -x test.type2_2.mv_idx:offset:$next_type2_2
462 --let remap_args = $remap_args -x test.type2_3.entry_key:offset:$next_entry_key
463 --let remap_args = $remap_args -x test.type2_3.mv_idx:offset:$next_type2_3
464 --let remap_args = $remap_args -x test.type2_4.entry_key:offset:$next_entry_key
465 --let remap_args = $remap_args -x test.type2_4.mv_idx:offset:$next_type2_4
466
467 --echo Remap args : $remap_args
468
469 --echo Run offset restore for second set of content
470 --exec $NDB_RESTORE -b $second_backup_id -n 1 -r --allow-pk-changes --num-slices=5 --slice-id=0 $remap_args $NDB_BACKUPS-$second_backup_id >> $NDB_TOOLS_OUTPUT
471 --exec $NDB_RESTORE -b $second_backup_id -n 1 -r --allow-pk-changes --num-slices=5 --slice-id=1 $remap_args $NDB_BACKUPS-$second_backup_id >> $NDB_TOOLS_OUTPUT
472 --exec $NDB_RESTORE -b $second_backup_id -n 1 -r --allow-pk-changes --num-slices=5 --slice-id=2 $remap_args $NDB_BACKUPS-$second_backup_id >> $NDB_TOOLS_OUTPUT
473 --exec $NDB_RESTORE -b $second_backup_id -n 1 -r --allow-pk-changes --num-slices=5 --slice-id=3 $remap_args $NDB_BACKUPS-$second_backup_id >> $NDB_TOOLS_OUTPUT
474 --exec $NDB_RESTORE -b $second_backup_id -n 1 -r --allow-pk-changes --num-slices=5 --slice-id=4 $remap_args $NDB_BACKUPS-$second_backup_id >> $NDB_TOOLS_OUTPUT
475
476
477 --exec $NDB_RESTORE -b $second_backup_id -n 2 -r --allow-pk-changes --num-slices=3 --slice-id=0 $remap_args $NDB_BACKUPS-$second_backup_id >> $NDB_TOOLS_OUTPUT
478 --exec $NDB_RESTORE -b $second_backup_id -n 2 -r --allow-pk-changes --num-slices=3 --slice-id=1 $remap_args $NDB_BACKUPS-$second_backup_id >> $NDB_TOOLS_OUTPUT
479 --exec $NDB_RESTORE -b $second_backup_id -n 2 -r --allow-pk-changes --num-slices=3 --slice-id=2 $remap_args $NDB_BACKUPS-$second_backup_id >> $NDB_TOOLS_OUTPUT
480
481 --echo Combined dataset
482 --echo -----------------
483 select idx_tbl.entry_key,
484 idx_tbl.k1,
485 idx_tbl.k2,
486 idx_tbl.data,
487 type1_1.data,
488 type1_2.data,
489 type2_1.mv_idx,
490 type2_1.data,
491 type2_2.mv_idx,
492 right(type2_2.data, 4),
493 length(type2_2.data),
494 right(type2_3.data, 4),
495 length(type2_3.data),
496 type2_4.mv_idx,
497 type2_4.data
498 from
499 idx_tbl join type1_1 join type1_2 join type2_1 join type2_2 join type2_3 join type2_4
500 on
501 idx_tbl.entry_key = type1_1.entry_key
502 and
503 idx_tbl.entry_key = type1_2.entry_key
504 and
505 idx_tbl.entry_key = type2_1.entry_key
506 and
507 idx_tbl.entry_key = type2_2.entry_key
508 and
509 idx_tbl.entry_key = type2_3.entry_key
510 and
511 idx_tbl.entry_key = type2_4.entry_key
512 order by idx_tbl.entry_key, type2_1.data, right(type2_2.data, 4), right(type2_3.data, 4), type2_4.data;
513
514 --echo Show auto-inc values
515 select count(1), max(entry_key) from test.idx_tbl;
516 show create table idx_tbl;
517 select count(1), max(mv_idx) from test.type2_1;
518 show create table type2_1;
519 select count(1), max(mv_idx) from test.type2_2;
520 show create table type2_2;
521 select count(1), max(mv_idx) from test.type2_3;
522 show create table type2_3;
523 select count(1), max(mv_idx) from test.type2_4;
524 show create table type2_4;
525
526 --echo No mv_idx duplicates in type_2 tables
527 select mv_idx, count(1) as ct
528 from type2_1 group by mv_idx
529 having ct > 1;
530 select mv_idx, count(1) as ct
531 from type2_2 group by mv_idx
532 having ct > 1;
533 select mv_idx, count(1) as ct
534 from type2_3 group by mv_idx
535 having ct > 1;
536 select mv_idx, count(1) as ct
537 from type2_4 group by mv_idx
538 having ct > 1;
539
540 select * from idx_tbl order by entry_key;
541 select * from type1_1 order by entry_key;
542 select * from type1_2 order by entry_key;
543 select * from type2_1 order by entry_key, mv_idx;
544 select entry_key, mv_idx, right(data, 4) from type2_2 order by entry_key, mv_idx;
545 select entry_key, mv_idx, right(data, 4) from type2_3 order by entry_key, mv_idx;
546 select * from type2_4 order by entry_key, mv_idx;
547
548 --echo Verify the insert of further entity succeeds
549 insert into idx_tbl (k1,k2,data) values ('Sancerre', 'France', 9);
550 select last_insert_id() into @ek;
551 insert into type1_1 values (@ek, 91);
552 insert into type1_2 values (@ek, 92);
553 insert into type2_1 (entry_key, data) values (@ek, 910);
554 insert into type2_1 (entry_key, data) values (@ek, 911);
555 insert into type2_1 (entry_key, data) values (@ek, 912);
556 insert into type2_1 (entry_key, data) values (@ek, 913);
557 insert into type2_2 (entry_key, data) values (@ek, repeat("0921", 10000));
558 insert into type2_2 (entry_key, data) values (@ek, repeat("0922", 10000));
559 insert into type2_3 (entry_key, data) values (@ek, repeat("0923", 10000));
560 insert into type2_3 (entry_key, data) values (@ek, repeat("0924", 10000));
561 insert into type2_4 (entry_key, data) values (@ek, 925);
562 insert into type2_4 (entry_key, data) values (@ek, 926);
563
564 --echo Modified content
565 --echo ----------------
566
567 show create table type2_3;
568
569 --echo No mv_idx duplicates in type_2 tables
570 select mv_idx, count(1) as ct
571 from type2_1 group by mv_idx
572 having ct > 1;
573 select mv_idx, count(1) as ct
574 from type2_2 group by mv_idx
575 having ct > 1;
576 select mv_idx, count(1) as ct
577 from type2_3 group by mv_idx
578 having ct > 1;
579
580 select * from idx_tbl order by entry_key;
581 select * from type1_1 order by entry_key;
582 select * from type1_2 order by entry_key;
583 select * from type2_1 order by entry_key, mv_idx;
584 select entry_key, mv_idx, right(data, 4) from type2_2 order by entry_key, mv_idx;
585 select entry_key, mv_idx, right(data, 4) from type2_3 order by entry_key, mv_idx;
586
587 drop table idx_tbl, type1_1, type1_2, type2_1, type2_2, type2_3, type2_4;
588
589 --disable_query_log
590 set ndb_autoincrement_prefetch_sz = @old_ndb_autoincrement_prefetch_sz;
591 --enable_query_log
592
593 --source suite/ndb/include/backup_restore_cleanup.inc
594 --remove_file $NDB_TOOLS_OUTPUT