Debian Codegraph @

mysql-test/suite/ndb/r/ndb_restore_conv_pk_slice_remap.result

raw
1 use test;
2 Based on the test in ndb_restore_conv_remap
3 But adds :
4 - Log content (requiring ndb_debug)
5 - Restore by slice
6 - PK changes
7
8 Schema has multiple tables connected via
9 'entry_key' which is remapped during restore
10 Some tables also have their own local autoincrement id
11 as part of their PK
12 Some tables have TEXT(Blob) columns requiring staging
13 tables to restore, others have schema changes which
14 can be handled directly inline.
15 create table idx_tbl (entry_key bigint unsigned not null auto_increment,
16 k1 varchar(100),
17 k2 varchar(100),
18 data int,
19 primary key (k1, k2),
20 unique(entry_key)) engine=ndb;
21 create table type1_1 (entry_key bigint unsigned not null primary key,
22 data int) engine=ndb;
23 create table type1_2 (entry_key bigint unsigned not null primary key,
24 data int) engine=ndb;
25 create table type2_1 (entry_key bigint unsigned not null,
26 mv_idx bigint unsigned not null auto_increment,
27 data int,
28 primary key (entry_key, mv_idx)) engine=ndb;
29 create table type2_2 (entry_key bigint unsigned not null,
30 mv_idx bigint unsigned not null auto_increment,
31 data text,
32 primary key (entry_key, mv_idx)) engine=ndb;
33 create table type2_3 (mv_idx bigint unsigned not null auto_increment,
34 entry_key bigint unsigned not null,
35 data text,
36 primary key (mv_idx)) engine = ndb;
37 create table type2_4 (mv_idx bigint unsigned not null auto_increment,
38 entry_key bigint unsigned not null,
39 data int,
40 primary key (mv_idx)) engine = ndb;
41 Populate a number of entities, each with
42 a couple of type_1 rows and a few sets of type_2 rows
43 insert into idx_tbl (k1,k2,data) values ('Edinburgh', 'UK', 1);
44 select last_insert_id() into @ek;
45 insert into type1_1 values (@ek, 11);
46 insert into type1_2 values (@ek, 12);
47 insert into type2_1 (entry_key, data) values (@ek, 110);
48 insert into type2_1 (entry_key, data) values (@ek, 111);
49 insert into type2_1 (entry_key, data) values (@ek, 112);
50 insert into type2_1 (entry_key, data) values (@ek, 113);
51 insert into type2_2 (entry_key, data) values (@ek, repeat("0121", 10000));
52 insert into type2_2 (entry_key, data) values (@ek, repeat("0122", 10000));
53 insert into type2_3 (entry_key, data) values (@ek, repeat("0124", 10000));
54 insert into type2_3 (entry_key, data) values (@ek, repeat("0125", 10000));
55 insert into type2_4 (entry_key, data) values (@ek, 126);
56 insert into type2_4 (entry_key, data) values (@ek, 127);
57 insert into idx_tbl (k1,k2,data) values ('Bristol', 'UK', 2);
58 select last_insert_id() into @ek;
59 insert into type1_1 values (@ek, 21);
60 insert into type1_2 values (@ek, 22);
61 insert into type2_1 (entry_key, data) values (@ek, 210);
62 insert into type2_1 (entry_key, data) values (@ek, 211);
63 insert into type2_1 (entry_key, data) values (@ek, 212);
64 insert into type2_1 (entry_key, data) values (@ek, 213);
65 insert into type2_2 (entry_key, data) values (@ek, repeat("0221", 10000));
66 insert into type2_2 (entry_key, data) values (@ek, repeat("0222", 10000));
67 insert into type2_3 (entry_key, data) values (@ek, repeat("0224", 10000));
68 insert into type2_3 (entry_key, data) values (@ek, repeat("0225", 10000));
69 insert into type2_4 (entry_key, data) values (@ek, 226);
70 insert into type2_4 (entry_key, data) values (@ek, 227);
71 insert into idx_tbl (k1,k2,data) values ('Glasgow', 'UK', 3);
72 select last_insert_id() into @ek;
73 insert into type1_1 values (@ek, 31);
74 insert into type1_2 values (@ek, 32);
75 insert into type2_1 (entry_key, data) values (@ek, 310);
76 insert into type2_1 (entry_key, data) values (@ek, 311);
77 insert into type2_1 (entry_key, data) values (@ek, 312);
78 insert into type2_1 (entry_key, data) values (@ek, 313);
79 insert into type2_2 (entry_key, data) values (@ek, repeat("0321", 10000));
80 insert into type2_2 (entry_key, data) values (@ek, repeat("0322", 10000));
81 insert into type2_3 (entry_key, data) values (@ek, repeat("0324", 10000));
82 insert into type2_3 (entry_key, data) values (@ek, repeat("0325", 10000));
83 insert into type2_4 (entry_key, data) values (@ek, 326);
84 insert into type2_4 (entry_key, data) values (@ek, 327);
85 insert into idx_tbl (k1,k2,data) values ('London', 'UK', 4);
86 select last_insert_id() into @ek;
87 insert into type1_1 values (@ek, 41);
88 insert into type1_2 values (@ek, 42);
89 insert into type2_1 (entry_key, data) values (@ek, 410);
90 insert into type2_1 (entry_key, data) values (@ek, 411);
91 insert into type2_1 (entry_key, data) values (@ek, 412);
92 insert into type2_1 (entry_key, data) values (@ek, 413);
93 insert into type2_2 (entry_key, data) values (@ek, repeat("0421", 10000));
94 insert into type2_2 (entry_key, data) values (@ek, repeat("0422", 10000));
95 insert into type2_3 (entry_key, data) values (@ek, repeat("0424", 10000));
96 insert into type2_3 (entry_key, data) values (@ek, repeat("0425", 10000));
97 insert into type2_4 (entry_key, data) values (@ek, 426);
98 insert into type2_4 (entry_key, data) values (@ek, 427);
99 insert into idx_tbl (k1,k2,data) values ('Paris', 'France', 5);
100 select last_insert_id() into @ek;
101 insert into type1_1 values (@ek, 51);
102 insert into type1_2 values (@ek, 52);
103 insert into type2_1 (entry_key, data) values (@ek, 510);
104 insert into type2_1 (entry_key, data) values (@ek, 511);
105 insert into type2_1 (entry_key, data) values (@ek, 512);
106 insert into type2_1 (entry_key, data) values (@ek, 513);
107 insert into type2_2 (entry_key, data) values (@ek, repeat("0521", 10000));
108 insert into type2_2 (entry_key, data) values (@ek, repeat("0522", 10000));
109 insert into type2_3 (entry_key, data) values (@ek, repeat("0524", 10000));
110 insert into type2_3 (entry_key, data) values (@ek, repeat("0525", 10000));
111 insert into type2_4 (entry_key, data) values (@ek, 526);
112 insert into type2_4 (entry_key, data) values (@ek, 527);
113 insert into idx_tbl (k1,k2,data) values ('Heidelberg', 'Germany', 6);
114 select last_insert_id() into @ek;
115 insert into type1_1 values (@ek, 61);
116 insert into type1_2 values (@ek, 62);
117 insert into type2_1 (entry_key, data) values (@ek, 610);
118 insert into type2_1 (entry_key, data) values (@ek, 611);
119 insert into type2_1 (entry_key, data) values (@ek, 612);
120 insert into type2_1 (entry_key, data) values (@ek, 613);
121 insert into type2_2 (entry_key, data) values (@ek, repeat("0621", 10000));
122 insert into type2_2 (entry_key, data) values (@ek, repeat("0622", 10000));
123 insert into type2_3 (entry_key, data) values (@ek, repeat("0624", 10000));
124 insert into type2_3 (entry_key, data) values (@ek, repeat("0625", 10000));
125 insert into type2_4 (entry_key, data) values (@ek, 626);
126 insert into type2_4 (entry_key, data) values (@ek, 627);
127 insert into idx_tbl (k1,k2,data) values ('Riga', 'Latvia', 7);
128 select last_insert_id() into @ek;
129 insert into type1_1 values (@ek, 71);
130 insert into type1_2 values (@ek, 72);
131 insert into type2_1 (entry_key, data) values (@ek, 710);
132 insert into type2_1 (entry_key, data) values (@ek, 711);
133 insert into type2_1 (entry_key, data) values (@ek, 712);
134 insert into type2_1 (entry_key, data) values (@ek, 713);
135 insert into type2_2 (entry_key, data) values (@ek, repeat("0721", 10000));
136 insert into type2_2 (entry_key, data) values (@ek, repeat("0722", 10000));
137 insert into type2_3 (entry_key, data) values (@ek, repeat("0724", 10000));
138 insert into type2_3 (entry_key, data) values (@ek, repeat("0725", 10000));
139 insert into type2_4 (entry_key, data) values (@ek, 726);
140 insert into type2_4 (entry_key, data) values (@ek, 727);
141 insert into idx_tbl (k1,k2,data) values ('Orlando', 'USA', 8);
142 select last_insert_id() into @ek;
143 insert into type1_1 values (@ek, 81);
144 insert into type1_2 values (@ek, 82);
145 insert into type2_1 (entry_key, data) values (@ek, 810);
146 insert into type2_1 (entry_key, data) values (@ek, 811);
147 insert into type2_1 (entry_key, data) values (@ek, 812);
148 insert into type2_1 (entry_key, data) values (@ek, 813);
149 insert into type2_2 (entry_key, data) values (@ek, repeat("0821", 10000));
150 insert into type2_2 (entry_key, data) values (@ek, repeat("0822", 10000));
151 insert into type2_3 (entry_key, data) values (@ek, repeat("0824", 10000));
152 insert into type2_3 (entry_key, data) values (@ek, repeat("0825", 10000));
153 insert into type2_4 (entry_key, data) values (@ek, 826);
154 insert into type2_4 (entry_key, data) values (@ek, 827);
155 Start backup
156 Cause backup to stall to allow changes
157 Starting backup
158 Backup started
159 Now make some changes during the backup
160 update idx_tbl set data = data+10;
161 update type1_1 set data = data+100;
162 update type1_2 set data = data+100;
163 update type2_1 set data = data+1000;
164 update type2_2 set data = repeat(right(data, 4)+1000, 5000);
165 update type2_3 set data = repeat(right(data, 4)+2000, 5000);
166 update type2_4 set data = data + 3000;
167 update idx_tbl set data = data-10;
168 update type1_1 set data = data-100;
169 update type1_2 set data = data-100;
170 update type2_1 set data = data-1000;
171 update type2_2 set data = repeat(concat("0", right(data, 4)-1000), 10000);
172 update type2_3 set data = repeat(concat("0", right(data, 4)-2000), 10000);
173 update type2_4 set data = data - 3000;
174 Unblock backup
175 Waiting for backup to complete
176 Backup completed
177 select * from idx_tbl order by entry_key;
178 entry_key k1 k2 data
179 1 Edinburgh UK 1
180 2 Bristol UK 2
181 3 Glasgow UK 3
182 4 London UK 4
183 5 Paris France 5
184 6 Heidelberg Germany 6
185 7 Riga Latvia 7
186 8 Orlando USA 8
187 select * from type1_1 order by entry_key;
188 entry_key data
189 1 11
190 2 21
191 3 31
192 4 41
193 5 51
194 6 61
195 7 71
196 8 81
197 select * from type1_2 order by entry_key;
198 entry_key data
199 1 12
200 2 22
201 3 32
202 4 42
203 5 52
204 6 62
205 7 72
206 8 82
207 select * from type2_1 order by entry_key, mv_idx;
208 entry_key mv_idx data
209 1 1 110
210 1 2 111
211 1 3 112
212 1 4 113
213 2 5 210
214 2 6 211
215 2 7 212
216 2 8 213
217 3 9 310
218 3 10 311
219 3 11 312
220 3 12 313
221 4 13 410
222 4 14 411
223 4 15 412
224 4 16 413
225 5 17 510
226 5 18 511
227 5 19 512
228 5 20 513
229 6 21 610
230 6 22 611
231 6 23 612
232 6 24 613
233 7 25 710
234 7 26 711
235 7 27 712
236 7 28 713
237 8 29 810
238 8 30 811
239 8 31 812
240 8 32 813
241 select entry_key, mv_idx, right(data, 4) from type2_2 order by entry_key, mv_idx;
242 entry_key mv_idx right(data, 4)
243 1 1 0121
244 1 2 0122
245 2 3 0221
246 2 4 0222
247 3 5 0321
248 3 6 0322
249 4 7 0421
250 4 8 0422
251 5 9 0521
252 5 10 0522
253 6 11 0621
254 6 12 0622
255 7 13 0721
256 7 14 0722
257 8 15 0821
258 8 16 0822
259 select entry_key, mv_idx, right(data, 4) from type2_3 order by entry_key, mv_idx;
260 entry_key mv_idx right(data, 4)
261 1 1 0124
262 1 2 0125
263 2 3 0224
264 2 4 0225
265 3 5 0324
266 3 6 0325
267 4 7 0424
268 4 8 0425
269 5 9 0524
270 5 10 0525
271 6 11 0624
272 6 12 0625
273 7 13 0724
274 7 14 0725
275 8 15 0824
276 8 16 0825
277 select * from type2_4 order by entry_key, mv_idx;
278 mv_idx entry_key data
279 1 1 126
280 2 1 127
281 3 2 226
282 4 2 227
283 5 3 326
284 6 3 327
285 7 4 426
286 8 4 427
287 9 5 526
288 10 5 527
289 11 6 626
290 12 6 627
291 13 7 726
292 14 7 727
293 15 8 826
294 16 8 827
295 First set of content
296 --------------------
297 select idx_tbl.entry_key,
298 idx_tbl.k1,
299 idx_tbl.k2,
300 idx_tbl.data,
301 type1_1.data,
302 type1_2.data,
303 type2_1.mv_idx,
304 type2_1.data,
305 type2_2.mv_idx,
306 right(type2_2.data, 4),
307 length(type2_2.data),
308 right(type2_3.data, 4),
309 length(type2_3.data),
310 type2_4.mv_idx,
311 type2_4.data
312 from
313 idx_tbl join type1_1 join type1_2 join type2_1 join type2_2 join type2_3 join type2_4
314 on
315 idx_tbl.entry_key = type1_1.entry_key
316 and
317 idx_tbl.entry_key = type1_2.entry_key
318 and
319 idx_tbl.entry_key = type2_1.entry_key
320 and
321 idx_tbl.entry_key = type2_2.entry_key
322 and
323 idx_tbl.entry_key = type2_3.entry_key
324 and
325 idx_tbl.entry_key = type2_4.entry_key
326 order by idx_tbl.entry_key, type2_1.data, right(type2_2.data, 4), right(type2_3.data, 4), type2_4.data;
327 entry_key k1 k2 data data data mv_idx data mv_idx right(type2_2.data, 4) length(type2_2.data) right(type2_3.data, 4) length(type2_3.data) mv_idx data
328 1 Edinburgh UK 1 11 12 1 110 1 0121 40000 0124 40000 1 126
329 1 Edinburgh UK 1 11 12 1 110 1 0121 40000 0124 40000 2 127
330 1 Edinburgh UK 1 11 12 1 110 1 0121 40000 0125 40000 1 126
331 1 Edinburgh UK 1 11 12 1 110 1 0121 40000 0125 40000 2 127
332 1 Edinburgh UK 1 11 12 1 110 2 0122 40000 0124 40000 1 126
333 1 Edinburgh UK 1 11 12 1 110 2 0122 40000 0124 40000 2 127
334 1 Edinburgh UK 1 11 12 1 110 2 0122 40000 0125 40000 1 126
335 1 Edinburgh UK 1 11 12 1 110 2 0122 40000 0125 40000 2 127
336 1 Edinburgh UK 1 11 12 2 111 1 0121 40000 0124 40000 1 126
337 1 Edinburgh UK 1 11 12 2 111 1 0121 40000 0124 40000 2 127
338 1 Edinburgh UK 1 11 12 2 111 1 0121 40000 0125 40000 1 126
339 1 Edinburgh UK 1 11 12 2 111 1 0121 40000 0125 40000 2 127
340 1 Edinburgh UK 1 11 12 2 111 2 0122 40000 0124 40000 1 126
341 1 Edinburgh UK 1 11 12 2 111 2 0122 40000 0124 40000 2 127
342 1 Edinburgh UK 1 11 12 2 111 2 0122 40000 0125 40000 1 126
343 1 Edinburgh UK 1 11 12 2 111 2 0122 40000 0125 40000 2 127
344 1 Edinburgh UK 1 11 12 3 112 1 0121 40000 0124 40000 1 126
345 1 Edinburgh UK 1 11 12 3 112 1 0121 40000 0124 40000 2 127
346 1 Edinburgh UK 1 11 12 3 112 1 0121 40000 0125 40000 1 126
347 1 Edinburgh UK 1 11 12 3 112 1 0121 40000 0125 40000 2 127
348 1 Edinburgh UK 1 11 12 3 112 2 0122 40000 0124 40000 1 126
349 1 Edinburgh UK 1 11 12 3 112 2 0122 40000 0124 40000 2 127
350 1 Edinburgh UK 1 11 12 3 112 2 0122 40000 0125 40000 1 126
351 1 Edinburgh UK 1 11 12 3 112 2 0122 40000 0125 40000 2 127
352 1 Edinburgh UK 1 11 12 4 113 1 0121 40000 0124 40000 1 126
353 1 Edinburgh UK 1 11 12 4 113 1 0121 40000 0124 40000 2 127
354 1 Edinburgh UK 1 11 12 4 113 1 0121 40000 0125 40000 1 126
355 1 Edinburgh UK 1 11 12 4 113 1 0121 40000 0125 40000 2 127
356 1 Edinburgh UK 1 11 12 4 113 2 0122 40000 0124 40000 1 126
357 1 Edinburgh UK 1 11 12 4 113 2 0122 40000 0124 40000 2 127
358 1 Edinburgh UK 1 11 12 4 113 2 0122 40000 0125 40000 1 126
359 1 Edinburgh UK 1 11 12 4 113 2 0122 40000 0125 40000 2 127
360 2 Bristol UK 2 21 22 5 210 3 0221 40000 0224 40000 3 226
361 2 Bristol UK 2 21 22 5 210 3 0221 40000 0224 40000 4 227
362 2 Bristol UK 2 21 22 5 210 3 0221 40000 0225 40000 3 226
363 2 Bristol UK 2 21 22 5 210 3 0221 40000 0225 40000 4 227
364 2 Bristol UK 2 21 22 5 210 4 0222 40000 0224 40000 3 226
365 2 Bristol UK 2 21 22 5 210 4 0222 40000 0224 40000 4 227
366 2 Bristol UK 2 21 22 5 210 4 0222 40000 0225 40000 3 226
367 2 Bristol UK 2 21 22 5 210 4 0222 40000 0225 40000 4 227
368 2 Bristol UK 2 21 22 6 211 3 0221 40000 0224 40000 3 226
369 2 Bristol UK 2 21 22 6 211 3 0221 40000 0224 40000 4 227
370 2 Bristol UK 2 21 22 6 211 3 0221 40000 0225 40000 3 226
371 2 Bristol UK 2 21 22 6 211 3 0221 40000 0225 40000 4 227
372 2 Bristol UK 2 21 22 6 211 4 0222 40000 0224 40000 3 226
373 2 Bristol UK 2 21 22 6 211 4 0222 40000 0224 40000 4 227
374 2 Bristol UK 2 21 22 6 211 4 0222 40000 0225 40000 3 226
375 2 Bristol UK 2 21 22 6 211 4 0222 40000 0225 40000 4 227
376 2 Bristol UK 2 21 22 7 212 3 0221 40000 0224 40000 3 226
377 2 Bristol UK 2 21 22 7 212 3 0221 40000 0224 40000 4 227
378 2 Bristol UK 2 21 22 7 212 3 0221 40000 0225 40000 3 226
379 2 Bristol UK 2 21 22 7 212 3 0221 40000 0225 40000 4 227
380 2 Bristol UK 2 21 22 7 212 4 0222 40000 0224 40000 3 226
381 2 Bristol UK 2 21 22 7 212 4 0222 40000 0224 40000 4 227
382 2 Bristol UK 2 21 22 7 212 4 0222 40000 0225 40000 3 226
383 2 Bristol UK 2 21 22 7 212 4 0222 40000 0225 40000 4 227
384 2 Bristol UK 2 21 22 8 213 3 0221 40000 0224 40000 3 226
385 2 Bristol UK 2 21 22 8 213 3 0221 40000 0224 40000 4 227
386 2 Bristol UK 2 21 22 8 213 3 0221 40000 0225 40000 3 226
387 2 Bristol UK 2 21 22 8 213 3 0221 40000 0225 40000 4 227
388 2 Bristol UK 2 21 22 8 213 4 0222 40000 0224 40000 3 226
389 2 Bristol UK 2 21 22 8 213 4 0222 40000 0224 40000 4 227
390 2 Bristol UK 2 21 22 8 213 4 0222 40000 0225 40000 3 226
391 2 Bristol UK 2 21 22 8 213 4 0222 40000 0225 40000 4 227
392 3 Glasgow UK 3 31 32 9 310 5 0321 40000 0324 40000 5 326
393 3 Glasgow UK 3 31 32 9 310 5 0321 40000 0324 40000 6 327
394 3 Glasgow UK 3 31 32 9 310 5 0321 40000 0325 40000 5 326
395 3 Glasgow UK 3 31 32 9 310 5 0321 40000 0325 40000 6 327
396 3 Glasgow UK 3 31 32 9 310 6 0322 40000 0324 40000 5 326
397 3 Glasgow UK 3 31 32 9 310 6 0322 40000 0324 40000 6 327
398 3 Glasgow UK 3 31 32 9 310 6 0322 40000 0325 40000 5 326
399 3 Glasgow UK 3 31 32 9 310 6 0322 40000 0325 40000 6 327
400 3 Glasgow UK 3 31 32 10 311 5 0321 40000 0324 40000 5 326
401 3 Glasgow UK 3 31 32 10 311 5 0321 40000 0324 40000 6 327
402 3 Glasgow UK 3 31 32 10 311 5 0321 40000 0325 40000 5 326
403 3 Glasgow UK 3 31 32 10 311 5 0321 40000 0325 40000 6 327
404 3 Glasgow UK 3 31 32 10 311 6 0322 40000 0324 40000 5 326
405 3 Glasgow UK 3 31 32 10 311 6 0322 40000 0324 40000 6 327
406 3 Glasgow UK 3 31 32 10 311 6 0322 40000 0325 40000 5 326
407 3 Glasgow UK 3 31 32 10 311 6 0322 40000 0325 40000 6 327
408 3 Glasgow UK 3 31 32 11 312 5 0321 40000 0324 40000 5 326
409 3 Glasgow UK 3 31 32 11 312 5 0321 40000 0324 40000 6 327
410 3 Glasgow UK 3 31 32 11 312 5 0321 40000 0325 40000 5 326
411 3 Glasgow UK 3 31 32 11 312 5 0321 40000 0325 40000 6 327
412 3 Glasgow UK 3 31 32 11 312 6 0322 40000 0324 40000 5 326
413 3 Glasgow UK 3 31 32 11 312 6 0322 40000 0324 40000 6 327
414 3 Glasgow UK 3 31 32 11 312 6 0322 40000 0325 40000 5 326
415 3 Glasgow UK 3 31 32 11 312 6 0322 40000 0325 40000 6 327
416 3 Glasgow UK 3 31 32 12 313 5 0321 40000 0324 40000 5 326
417 3 Glasgow UK 3 31 32 12 313 5 0321 40000 0324 40000 6 327
418 3 Glasgow UK 3 31 32 12 313 5 0321 40000 0325 40000 5 326
419 3 Glasgow UK 3 31 32 12 313 5 0321 40000 0325 40000 6 327
420 3 Glasgow UK 3 31 32 12 313 6 0322 40000 0324 40000 5 326
421 3 Glasgow UK 3 31 32 12 313 6 0322 40000 0324 40000 6 327
422 3 Glasgow UK 3 31 32 12 313 6 0322 40000 0325 40000 5 326
423 3 Glasgow UK 3 31 32 12 313 6 0322 40000 0325 40000 6 327
424 4 London UK 4 41 42 13 410 7 0421 40000 0424 40000 7 426
425 4 London UK 4 41 42 13 410 7 0421 40000 0424 40000 8 427
426 4 London UK 4 41 42 13 410 7 0421 40000 0425 40000 7 426
427 4 London UK 4 41 42 13 410 7 0421 40000 0425 40000 8 427
428 4 London UK 4 41 42 13 410 8 0422 40000 0424 40000 7 426
429 4 London UK 4 41 42 13 410 8 0422 40000 0424 40000 8 427
430 4 London UK 4 41 42 13 410 8 0422 40000 0425 40000 7 426
431 4 London UK 4 41 42 13 410 8 0422 40000 0425 40000 8 427
432 4 London UK 4 41 42 14 411 7 0421 40000 0424 40000 7 426
433 4 London UK 4 41 42 14 411 7 0421 40000 0424 40000 8 427
434 4 London UK 4 41 42 14 411 7 0421 40000 0425 40000 7 426
435 4 London UK 4 41 42 14 411 7 0421 40000 0425 40000 8 427
436 4 London UK 4 41 42 14 411 8 0422 40000 0424 40000 7 426
437 4 London UK 4 41 42 14 411 8 0422 40000 0424 40000 8 427
438 4 London UK 4 41 42 14 411 8 0422 40000 0425 40000 7 426
439 4 London UK 4 41 42 14 411 8 0422 40000 0425 40000 8 427
440 4 London UK 4 41 42 15 412 7 0421 40000 0424 40000 7 426
441 4 London UK 4 41 42 15 412 7 0421 40000 0424 40000 8 427
442 4 London UK 4 41 42 15 412 7 0421 40000 0425 40000 7 426
443 4 London UK 4 41 42 15 412 7 0421 40000 0425 40000 8 427
444 4 London UK 4 41 42 15 412 8 0422 40000 0424 40000 7 426
445 4 London UK 4 41 42 15 412 8 0422 40000 0424 40000 8 427
446 4 London UK 4 41 42 15 412 8 0422 40000 0425 40000 7 426
447 4 London UK 4 41 42 15 412 8 0422 40000 0425 40000 8 427
448 4 London UK 4 41 42 16 413 7 0421 40000 0424 40000 7 426
449 4 London UK 4 41 42 16 413 7 0421 40000 0424 40000 8 427
450 4 London UK 4 41 42 16 413 7 0421 40000 0425 40000 7 426
451 4 London UK 4 41 42 16 413 7 0421 40000 0425 40000 8 427
452 4 London UK 4 41 42 16 413 8 0422 40000 0424 40000 7 426
453 4 London UK 4 41 42 16 413 8 0422 40000 0424 40000 8 427
454 4 London UK 4 41 42 16 413 8 0422 40000 0425 40000 7 426
455 4 London UK 4 41 42 16 413 8 0422 40000 0425 40000 8 427
456 5 Paris France 5 51 52 17 510 9 0521 40000 0524 40000 9 526
457 5 Paris France 5 51 52 17 510 9 0521 40000 0524 40000 10 527
458 5 Paris France 5 51 52 17 510 9 0521 40000 0525 40000 9 526
459 5 Paris France 5 51 52 17 510 9 0521 40000 0525 40000 10 527
460 5 Paris France 5 51 52 17 510 10 0522 40000 0524 40000 9 526
461 5 Paris France 5 51 52 17 510 10 0522 40000 0524 40000 10 527
462 5 Paris France 5 51 52 17 510 10 0522 40000 0525 40000 9 526
463 5 Paris France 5 51 52 17 510 10 0522 40000 0525 40000 10 527
464 5 Paris France 5 51 52 18 511 9 0521 40000 0524 40000 9 526
465 5 Paris France 5 51 52 18 511 9 0521 40000 0524 40000 10 527
466 5 Paris France 5 51 52 18 511 9 0521 40000 0525 40000 9 526
467 5 Paris France 5 51 52 18 511 9 0521 40000 0525 40000 10 527
468 5 Paris France 5 51 52 18 511 10 0522 40000 0524 40000 9 526
469 5 Paris France 5 51 52 18 511 10 0522 40000 0524 40000 10 527
470 5 Paris France 5 51 52 18 511 10 0522 40000 0525 40000 9 526
471 5 Paris France 5 51 52 18 511 10 0522 40000 0525 40000 10 527
472 5 Paris France 5 51 52 19 512 9 0521 40000 0524 40000 9 526
473 5 Paris France 5 51 52 19 512 9 0521 40000 0524 40000 10 527
474 5 Paris France 5 51 52 19 512 9 0521 40000 0525 40000 9 526
475 5 Paris France 5 51 52 19 512 9 0521 40000 0525 40000 10 527
476 5 Paris France 5 51 52 19 512 10 0522 40000 0524 40000 9 526
477 5 Paris France 5 51 52 19 512 10 0522 40000 0524 40000 10 527
478 5 Paris France 5 51 52 19 512 10 0522 40000 0525 40000 9 526
479 5 Paris France 5 51 52 19 512 10 0522 40000 0525 40000 10 527
480 5 Paris France 5 51 52 20 513 9 0521 40000 0524 40000 9 526
481 5 Paris France 5 51 52 20 513 9 0521 40000 0524 40000 10 527
482 5 Paris France 5 51 52 20 513 9 0521 40000 0525 40000 9 526
483 5 Paris France 5 51 52 20 513 9 0521 40000 0525 40000 10 527
484 5 Paris France 5 51 52 20 513 10 0522 40000 0524 40000 9 526
485 5 Paris France 5 51 52 20 513 10 0522 40000 0524 40000 10 527
486 5 Paris France 5 51 52 20 513 10 0522 40000 0525 40000 9 526
487 5 Paris France 5 51 52 20 513 10 0522 40000 0525 40000 10 527
488 6 Heidelberg Germany 6 61 62 21 610 11 0621 40000 0624 40000 11 626
489 6 Heidelberg Germany 6 61 62 21 610 11 0621 40000 0624 40000 12 627
490 6 Heidelberg Germany 6 61 62 21 610 11 0621 40000 0625 40000 11 626
491 6 Heidelberg Germany 6 61 62 21 610 11 0621 40000 0625 40000 12 627
492 6 Heidelberg Germany 6 61 62 21 610 12 0622 40000 0624 40000 11 626
493 6 Heidelberg Germany 6 61 62 21 610 12 0622 40000 0624 40000 12 627
494 6 Heidelberg Germany 6 61 62 21 610 12 0622 40000 0625 40000 11 626
495 6 Heidelberg Germany 6 61 62 21 610 12 0622 40000 0625 40000 12 627
496 6 Heidelberg Germany 6 61 62 22 611 11 0621 40000 0624 40000 11 626
497 6 Heidelberg Germany 6 61 62 22 611 11 0621 40000 0624 40000 12 627
498 6 Heidelberg Germany 6 61 62 22 611 11 0621 40000 0625 40000 11 626
499 6 Heidelberg Germany 6 61 62 22 611 11 0621 40000 0625 40000 12 627
500 6 Heidelberg Germany 6 61 62 22 611 12 0622 40000 0624 40000 11 626
501 6 Heidelberg Germany 6 61 62 22 611 12 0622 40000 0624 40000 12 627
502 6 Heidelberg Germany 6 61 62 22 611 12 0622 40000 0625 40000 11 626
503 6 Heidelberg Germany 6 61 62 22 611 12 0622 40000 0625 40000 12 627
504 6 Heidelberg Germany 6 61 62 23 612 11 0621 40000 0624 40000 11 626
505 6 Heidelberg Germany 6 61 62 23 612 11 0621 40000 0624 40000 12 627
506 6 Heidelberg Germany 6 61 62 23 612 11 0621 40000 0625 40000 11 626
507 6 Heidelberg Germany 6 61 62 23 612 11 0621 40000 0625 40000 12 627
508 6 Heidelberg Germany 6 61 62 23 612 12 0622 40000 0624 40000 11 626
509 6 Heidelberg Germany 6 61 62 23 612 12 0622 40000 0624 40000 12 627
510 6 Heidelberg Germany 6 61 62 23 612 12 0622 40000 0625 40000 11 626
511 6 Heidelberg Germany 6 61 62 23 612 12 0622 40000 0625 40000 12 627
512 6 Heidelberg Germany 6 61 62 24 613 11 0621 40000 0624 40000 11 626
513 6 Heidelberg Germany 6 61 62 24 613 11 0621 40000 0624 40000 12 627
514 6 Heidelberg Germany 6 61 62 24 613 11 0621 40000 0625 40000 11 626
515 6 Heidelberg Germany 6 61 62 24 613 11 0621 40000 0625 40000 12 627
516 6 Heidelberg Germany 6 61 62 24 613 12 0622 40000 0624 40000 11 626
517 6 Heidelberg Germany 6 61 62 24 613 12 0622 40000 0624 40000 12 627
518 6 Heidelberg Germany 6 61 62 24 613 12 0622 40000 0625 40000 11 626
519 6 Heidelberg Germany 6 61 62 24 613 12 0622 40000 0625 40000 12 627
520 7 Riga Latvia 7 71 72 25 710 13 0721 40000 0724 40000 13 726
521 7 Riga Latvia 7 71 72 25 710 13 0721 40000 0724 40000 14 727
522 7 Riga Latvia 7 71 72 25 710 13 0721 40000 0725 40000 13 726
523 7 Riga Latvia 7 71 72 25 710 13 0721 40000 0725 40000 14 727
524 7 Riga Latvia 7 71 72 25 710 14 0722 40000 0724 40000 13 726
525 7 Riga Latvia 7 71 72 25 710 14 0722 40000 0724 40000 14 727
526 7 Riga Latvia 7 71 72 25 710 14 0722 40000 0725 40000 13 726
527 7 Riga Latvia 7 71 72 25 710 14 0722 40000 0725 40000 14 727
528 7 Riga Latvia 7 71 72 26 711 13 0721 40000 0724 40000 13 726
529 7 Riga Latvia 7 71 72 26 711 13 0721 40000 0724 40000 14 727
530 7 Riga Latvia 7 71 72 26 711 13 0721 40000 0725 40000 13 726
531 7 Riga Latvia 7 71 72 26 711 13 0721 40000 0725 40000 14 727
532 7 Riga Latvia 7 71 72 26 711 14 0722 40000 0724 40000 13 726
533 7 Riga Latvia 7 71 72 26 711 14 0722 40000 0724 40000 14 727
534 7 Riga Latvia 7 71 72 26 711 14 0722 40000 0725 40000 13 726
535 7 Riga Latvia 7 71 72 26 711 14 0722 40000 0725 40000 14 727
536 7 Riga Latvia 7 71 72 27 712 13 0721 40000 0724 40000 13 726
537 7 Riga Latvia 7 71 72 27 712 13 0721 40000 0724 40000 14 727
538 7 Riga Latvia 7 71 72 27 712 13 0721 40000 0725 40000 13 726
539 7 Riga Latvia 7 71 72 27 712 13 0721 40000 0725 40000 14 727
540 7 Riga Latvia 7 71 72 27 712 14 0722 40000 0724 40000 13 726
541 7 Riga Latvia 7 71 72 27 712 14 0722 40000 0724 40000 14 727
542 7 Riga Latvia 7 71 72 27 712 14 0722 40000 0725 40000 13 726
543 7 Riga Latvia 7 71 72 27 712 14 0722 40000 0725 40000 14 727
544 7 Riga Latvia 7 71 72 28 713 13 0721 40000 0724 40000 13 726
545 7 Riga Latvia 7 71 72 28 713 13 0721 40000 0724 40000 14 727
546 7 Riga Latvia 7 71 72 28 713 13 0721 40000 0725 40000 13 726
547 7 Riga Latvia 7 71 72 28 713 13 0721 40000 0725 40000 14 727
548 7 Riga Latvia 7 71 72 28 713 14 0722 40000 0724 40000 13 726
549 7 Riga Latvia 7 71 72 28 713 14 0722 40000 0724 40000 14 727
550 7 Riga Latvia 7 71 72 28 713 14 0722 40000 0725 40000 13 726
551 7 Riga Latvia 7 71 72 28 713 14 0722 40000 0725 40000 14 727
552 8 Orlando USA 8 81 82 29 810 15 0821 40000 0824 40000 15 826
553 8 Orlando USA 8 81 82 29 810 15 0821 40000 0824 40000 16 827
554 8 Orlando USA 8 81 82 29 810 15 0821 40000 0825 40000 15 826
555 8 Orlando USA 8 81 82 29 810 15 0821 40000 0825 40000 16 827
556 8 Orlando USA 8 81 82 29 810 16 0822 40000 0824 40000 15 826
557 8 Orlando USA 8 81 82 29 810 16 0822 40000 0824 40000 16 827
558 8 Orlando USA 8 81 82 29 810 16 0822 40000 0825 40000 15 826
559 8 Orlando USA 8 81 82 29 810 16 0822 40000 0825 40000 16 827
560 8 Orlando USA 8 81 82 30 811 15 0821 40000 0824 40000 15 826
561 8 Orlando USA 8 81 82 30 811 15 0821 40000 0824 40000 16 827
562 8 Orlando USA 8 81 82 30 811 15 0821 40000 0825 40000 15 826
563 8 Orlando USA 8 81 82 30 811 15 0821 40000 0825 40000 16 827
564 8 Orlando USA 8 81 82 30 811 16 0822 40000 0824 40000 15 826
565 8 Orlando USA 8 81 82 30 811 16 0822 40000 0824 40000 16 827
566 8 Orlando USA 8 81 82 30 811 16 0822 40000 0825 40000 15 826
567 8 Orlando USA 8 81 82 30 811 16 0822 40000 0825 40000 16 827
568 8 Orlando USA 8 81 82 31 812 15 0821 40000 0824 40000 15 826
569 8 Orlando USA 8 81 82 31 812 15 0821 40000 0824 40000 16 827
570 8 Orlando USA 8 81 82 31 812 15 0821 40000 0825 40000 15 826
571 8 Orlando USA 8 81 82 31 812 15 0821 40000 0825 40000 16 827
572 8 Orlando USA 8 81 82 31 812 16 0822 40000 0824 40000 15 826
573 8 Orlando USA 8 81 82 31 812 16 0822 40000 0824 40000 16 827
574 8 Orlando USA 8 81 82 31 812 16 0822 40000 0825 40000 15 826
575 8 Orlando USA 8 81 82 31 812 16 0822 40000 0825 40000 16 827
576 8 Orlando USA 8 81 82 32 813 15 0821 40000 0824 40000 15 826
577 8 Orlando USA 8 81 82 32 813 15 0821 40000 0824 40000 16 827
578 8 Orlando USA 8 81 82 32 813 15 0821 40000 0825 40000 15 826
579 8 Orlando USA 8 81 82 32 813 15 0821 40000 0825 40000 16 827
580 8 Orlando USA 8 81 82 32 813 16 0822 40000 0824 40000 15 826
581 8 Orlando USA 8 81 82 32 813 16 0822 40000 0824 40000 16 827
582 8 Orlando USA 8 81 82 32 813 16 0822 40000 0825 40000 15 826
583 8 Orlando USA 8 81 82 32 813 16 0822 40000 0825 40000 16 827
584 Show auto-inc values
585 select count(1), max(entry_key) from test.idx_tbl;
586 count(1) max(entry_key)
587 8 8
588 show create table idx_tbl;
589 Table Create Table
590 idx_tbl CREATE TABLE `idx_tbl` (
591 `entry_key` bigint unsigned NOT NULL AUTO_INCREMENT,
592 `k1` varchar(100) NOT NULL,
593 `k2` varchar(100) NOT NULL,
594 `data` int DEFAULT NULL,
595 PRIMARY KEY (`k1`,`k2`),
596 UNIQUE KEY `entry_key` (`entry_key`)
597 ) ENGINE=ndbcluster AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
598 select count(1), max(mv_idx) from test.type2_1;
599 count(1) max(mv_idx)
600 32 32
601 show create table type2_1;
602 Table Create Table
603 type2_1 CREATE TABLE `type2_1` (
604 `entry_key` bigint unsigned NOT NULL,
605 `mv_idx` bigint unsigned NOT NULL AUTO_INCREMENT,
606 `data` int DEFAULT NULL,
607 PRIMARY KEY (`entry_key`,`mv_idx`)
608 ) ENGINE=ndbcluster AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
609 select count(1), max(mv_idx) from test.type2_2;
610 count(1) max(mv_idx)
611 16 16
612 show create table type2_2;
613 Table Create Table
614 type2_2 CREATE TABLE `type2_2` (
615 `entry_key` bigint unsigned NOT NULL,
616 `mv_idx` bigint unsigned NOT NULL AUTO_INCREMENT,
617 `data` text,
618 PRIMARY KEY (`entry_key`,`mv_idx`)
619 ) ENGINE=ndbcluster AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
620 select count(1), max(mv_idx) from test.type2_3;
621 count(1) max(mv_idx)
622 16 16
623 show create table type2_3;
624 Table Create Table
625 type2_3 CREATE TABLE `type2_3` (
626 `mv_idx` bigint unsigned NOT NULL AUTO_INCREMENT,
627 `entry_key` bigint unsigned NOT NULL,
628 `data` text,
629 PRIMARY KEY (`mv_idx`)
630 ) ENGINE=ndbcluster AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
631 select count(1), max(mv_idx) from test.type2_4;
632 count(1) max(mv_idx)
633 16 16
634 show create table type2_4;
635 Table Create Table
636 type2_4 CREATE TABLE `type2_4` (
637 `mv_idx` bigint unsigned NOT NULL AUTO_INCREMENT,
638 `entry_key` bigint unsigned NOT NULL,
639 `data` int DEFAULT NULL,
640 PRIMARY KEY (`mv_idx`)
641 ) ENGINE=ndbcluster AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
642 No mv_idx duplicates in type_2 tables
643 select mv_idx, count(1) as ct
644 from type2_1 group by mv_idx
645 having ct > 1;
646 mv_idx ct
647 select mv_idx, count(1) as ct
648 from type2_2 group by mv_idx
649 having ct > 1;
650 mv_idx ct
651 select mv_idx, count(1) as ct
652 from type2_3 group by mv_idx
653 having ct > 1;
654 mv_idx ct
655 select mv_idx, count(1) as ct
656 from type2_4 group by mv_idx
657 having ct > 1;
658 mv_idx ct
659 Create a different set of entities, with the same auto-inc
660 keys for entry_key and mv_idx
661 update idx_tbl set k1="Stockholm", k2="Sweden" where entry_key = 1;
662 update idx_tbl set k1="Trondheim", k2="Norway" where entry_key = 2;
663 update idx_tbl set k1="Portland", k2="USA" where entry_key=3;
664 update idx_tbl set k1="Bangalore", k2="India" where entry_key=4;
665 update idx_tbl set k1="Helsinki", k2="Finland" where entry_key=5;
666 update idx_tbl set k1="Lisbon", k2="Portugal" where entry_key=6;
667 update idx_tbl set k1="Norrwaste", k2="Sweden" where entry_key=7;
668 update idx_tbl set k1="ROW", k2="Earth" where entry_key=8;
669 Modify data to be distinct
670 update idx_tbl set data = data+10;
671 update type1_1 set data = data+100;
672 update type1_2 set data = data+100;
673 update type2_1 set data = data+1000;
674 update type2_2 set data = repeat(right(data, 4)+1000, 10000);
675 update type2_3 set data = repeat(right(data, 4)+2000, 10000);
676 update type2_4 set data = data+3000;
677 Start backup
678 Cause backup to stall to allow changes
679 Starting backup
680 Backup started
681 Now make some changes during the backup
682 update idx_tbl set data = data+10;
683 update type1_1 set data = data+100;
684 update type1_2 set data = data+100;
685 update type2_1 set data = data+1000;
686 update type2_2 set data = repeat(right(data, 4)+1000, 5000);
687 update type2_3 set data = repeat(right(data, 4)+2000, 5000);
688 update type2_4 set data = data + 3000;
689 update idx_tbl set data = data-10;
690 update type1_1 set data = data-100;
691 update type1_2 set data = data-100;
692 update type2_1 set data = data-1000;
693 update type2_2 set data = repeat(right(data, 4)-1000, 10000);
694 update type2_3 set data = repeat(right(data, 4)-2000, 10000);
695 update type2_4 set data = data - 3000;
696 Unblock backup
697 Waiting for backup to complete
698 Backup completed
699 Second set of content
700 ---------------------
701 select idx_tbl.entry_key,
702 idx_tbl.k1,
703 idx_tbl.k2,
704 idx_tbl.data,
705 type1_1.data,
706 type1_2.data,
707 type2_1.mv_idx,
708 type2_1.data,
709 type2_2.mv_idx,
710 right(type2_2.data, 4),
711 length(type2_2.data),
712 right(type2_3.data, 4),
713 length(type2_3.data),
714 type2_4.mv_idx,
715 type2_4.data
716 from
717 idx_tbl join type1_1 join type1_2 join type2_1 join type2_2 join type2_3 join type2_4
718 on
719 idx_tbl.entry_key = type1_1.entry_key
720 and
721 idx_tbl.entry_key = type1_2.entry_key
722 and
723 idx_tbl.entry_key = type2_1.entry_key
724 and
725 idx_tbl.entry_key = type2_2.entry_key
726 and
727 idx_tbl.entry_key = type2_3.entry_key
728 and
729 idx_tbl.entry_key = type2_4.entry_key
730 order by idx_tbl.entry_key, type2_1.data, right(type2_2.data, 4), right(type2_3.data, 4), type2_4.data;
731 entry_key k1 k2 data data data mv_idx data mv_idx right(type2_2.data, 4) length(type2_2.data) right(type2_3.data, 4) length(type2_3.data) mv_idx data
732 1 Stockholm Sweden 11 111 112 1 1110 1 1121 40000 2124 40000 1 3126
733 1 Stockholm Sweden 11 111 112 1 1110 1 1121 40000 2124 40000 2 3127
734 1 Stockholm Sweden 11 111 112 1 1110 1 1121 40000 2125 40000 1 3126
735 1 Stockholm Sweden 11 111 112 1 1110 1 1121 40000 2125 40000 2 3127
736 1 Stockholm Sweden 11 111 112 1 1110 2 1122 40000 2124 40000 1 3126
737 1 Stockholm Sweden 11 111 112 1 1110 2 1122 40000 2124 40000 2 3127
738 1 Stockholm Sweden 11 111 112 1 1110 2 1122 40000 2125 40000 1 3126
739 1 Stockholm Sweden 11 111 112 1 1110 2 1122 40000 2125 40000 2 3127
740 1 Stockholm Sweden 11 111 112 2 1111 1 1121 40000 2124 40000 1 3126
741 1 Stockholm Sweden 11 111 112 2 1111 1 1121 40000 2124 40000 2 3127
742 1 Stockholm Sweden 11 111 112 2 1111 1 1121 40000 2125 40000 1 3126
743 1 Stockholm Sweden 11 111 112 2 1111 1 1121 40000 2125 40000 2 3127
744 1 Stockholm Sweden 11 111 112 2 1111 2 1122 40000 2124 40000 1 3126
745 1 Stockholm Sweden 11 111 112 2 1111 2 1122 40000 2124 40000 2 3127
746 1 Stockholm Sweden 11 111 112 2 1111 2 1122 40000 2125 40000 1 3126
747 1 Stockholm Sweden 11 111 112 2 1111 2 1122 40000 2125 40000 2 3127
748 1 Stockholm Sweden 11 111 112 3 1112 1 1121 40000 2124 40000 1 3126
749 1 Stockholm Sweden 11 111 112 3 1112 1 1121 40000 2124 40000 2 3127
750 1 Stockholm Sweden 11 111 112 3 1112 1 1121 40000 2125 40000 1 3126
751 1 Stockholm Sweden 11 111 112 3 1112 1 1121 40000 2125 40000 2 3127
752 1 Stockholm Sweden 11 111 112 3 1112 2 1122 40000 2124 40000 1 3126
753 1 Stockholm Sweden 11 111 112 3 1112 2 1122 40000 2124 40000 2 3127
754 1 Stockholm Sweden 11 111 112 3 1112 2 1122 40000 2125 40000 1 3126
755 1 Stockholm Sweden 11 111 112 3 1112 2 1122 40000 2125 40000 2 3127
756 1 Stockholm Sweden 11 111 112 4 1113 1 1121 40000 2124 40000 1 3126
757 1 Stockholm Sweden 11 111 112 4 1113 1 1121 40000 2124 40000 2 3127
758 1 Stockholm Sweden 11 111 112 4 1113 1 1121 40000 2125 40000 1 3126
759 1 Stockholm Sweden 11 111 112 4 1113 1 1121 40000 2125 40000 2 3127
760 1 Stockholm Sweden 11 111 112 4 1113 2 1122 40000 2124 40000 1 3126
761 1 Stockholm Sweden 11 111 112 4 1113 2 1122 40000 2124 40000 2 3127
762 1 Stockholm Sweden 11 111 112 4 1113 2 1122 40000 2125 40000 1 3126
763 1 Stockholm Sweden 11 111 112 4 1113 2 1122 40000 2125 40000 2 3127
764 2 Trondheim Norway 12 121 122 5 1210 3 1221 40000 2224 40000 3 3226
765 2 Trondheim Norway 12 121 122 5 1210 3 1221 40000 2224 40000 4 3227
766 2 Trondheim Norway 12 121 122 5 1210 3 1221 40000 2225 40000 3 3226
767 2 Trondheim Norway 12 121 122 5 1210 3 1221 40000 2225 40000 4 3227
768 2 Trondheim Norway 12 121 122 5 1210 4 1222 40000 2224 40000 3 3226
769 2 Trondheim Norway 12 121 122 5 1210 4 1222 40000 2224 40000 4 3227
770 2 Trondheim Norway 12 121 122 5 1210 4 1222 40000 2225 40000 3 3226
771 2 Trondheim Norway 12 121 122 5 1210 4 1222 40000 2225 40000 4 3227
772 2 Trondheim Norway 12 121 122 6 1211 3 1221 40000 2224 40000 3 3226
773 2 Trondheim Norway 12 121 122 6 1211 3 1221 40000 2224 40000 4 3227
774 2 Trondheim Norway 12 121 122 6 1211 3 1221 40000 2225 40000 3 3226
775 2 Trondheim Norway 12 121 122 6 1211 3 1221 40000 2225 40000 4 3227
776 2 Trondheim Norway 12 121 122 6 1211 4 1222 40000 2224 40000 3 3226
777 2 Trondheim Norway 12 121 122 6 1211 4 1222 40000 2224 40000 4 3227
778 2 Trondheim Norway 12 121 122 6 1211 4 1222 40000 2225 40000 3 3226
779 2 Trondheim Norway 12 121 122 6 1211 4 1222 40000 2225 40000 4 3227
780 2 Trondheim Norway 12 121 122 7 1212 3 1221 40000 2224 40000 3 3226
781 2 Trondheim Norway 12 121 122 7 1212 3 1221 40000 2224 40000 4 3227
782 2 Trondheim Norway 12 121 122 7 1212 3 1221 40000 2225 40000 3 3226
783 2 Trondheim Norway 12 121 122 7 1212 3 1221 40000 2225 40000 4 3227
784 2 Trondheim Norway 12 121 122 7 1212 4 1222 40000 2224 40000 3 3226
785 2 Trondheim Norway 12 121 122 7 1212 4 1222 40000 2224 40000 4 3227
786 2 Trondheim Norway 12 121 122 7 1212 4 1222 40000 2225 40000 3 3226
787 2 Trondheim Norway 12 121 122 7 1212 4 1222 40000 2225 40000 4 3227
788 2 Trondheim Norway 12 121 122 8 1213 3 1221 40000 2224 40000 3 3226
789 2 Trondheim Norway 12 121 122 8 1213 3 1221 40000 2224 40000 4 3227
790 2 Trondheim Norway 12 121 122 8 1213 3 1221 40000 2225 40000 3 3226
791 2 Trondheim Norway 12 121 122 8 1213 3 1221 40000 2225 40000 4 3227
792 2 Trondheim Norway 12 121 122 8 1213 4 1222 40000 2224 40000 3 3226
793 2 Trondheim Norway 12 121 122 8 1213 4 1222 40000 2224 40000 4 3227
794 2 Trondheim Norway 12 121 122 8 1213 4 1222 40000 2225 40000 3 3226
795 2 Trondheim Norway 12 121 122 8 1213 4 1222 40000 2225 40000 4 3227
796 3 Portland USA 13 131 132 9 1310 5 1321 40000 2324 40000 5 3326
797 3 Portland USA 13 131 132 9 1310 5 1321 40000 2324 40000 6 3327
798 3 Portland USA 13 131 132 9 1310 5 1321 40000 2325 40000 5 3326
799 3 Portland USA 13 131 132 9 1310 5 1321 40000 2325 40000 6 3327
800 3 Portland USA 13 131 132 9 1310 6 1322 40000 2324 40000 5 3326
801 3 Portland USA 13 131 132 9 1310 6 1322 40000 2324 40000 6 3327
802 3 Portland USA 13 131 132 9 1310 6 1322 40000 2325 40000 5 3326
803 3 Portland USA 13 131 132 9 1310 6 1322 40000 2325 40000 6 3327
804 3 Portland USA 13 131 132 10 1311 5 1321 40000 2324 40000 5 3326
805 3 Portland USA 13 131 132 10 1311 5 1321 40000 2324 40000 6 3327
806 3 Portland USA 13 131 132 10 1311 5 1321 40000 2325 40000 5 3326
807 3 Portland USA 13 131 132 10 1311 5 1321 40000 2325 40000 6 3327
808 3 Portland USA 13 131 132 10 1311 6 1322 40000 2324 40000 5 3326
809 3 Portland USA 13 131 132 10 1311 6 1322 40000 2324 40000 6 3327
810 3 Portland USA 13 131 132 10 1311 6 1322 40000 2325 40000 5 3326
811 3 Portland USA 13 131 132 10 1311 6 1322 40000 2325 40000 6 3327
812 3 Portland USA 13 131 132 11 1312 5 1321 40000 2324 40000 5 3326
813 3 Portland USA 13 131 132 11 1312 5 1321 40000 2324 40000 6 3327
814 3 Portland USA 13 131 132 11 1312 5 1321 40000 2325 40000 5 3326
815 3 Portland USA 13 131 132 11 1312 5 1321 40000 2325 40000 6 3327
816 3 Portland USA 13 131 132 11 1312 6 1322 40000 2324 40000 5 3326
817 3 Portland USA 13 131 132 11 1312 6 1322 40000 2324 40000 6 3327
818 3 Portland USA 13 131 132 11 1312 6 1322 40000 2325 40000 5 3326
819 3 Portland USA 13 131 132 11 1312 6 1322 40000 2325 40000 6 3327
820 3 Portland USA 13 131 132 12 1313 5 1321 40000 2324 40000 5 3326
821 3 Portland USA 13 131 132 12 1313 5 1321 40000 2324 40000 6 3327
822 3 Portland USA 13 131 132 12 1313 5 1321 40000 2325 40000 5 3326
823 3 Portland USA 13 131 132 12 1313 5 1321 40000 2325 40000 6 3327
824 3 Portland USA 13 131 132 12 1313 6 1322 40000 2324 40000 5 3326
825 3 Portland USA 13 131 132 12 1313 6 1322 40000 2324 40000 6 3327
826 3 Portland USA 13 131 132 12 1313 6 1322 40000 2325 40000 5 3326
827 3 Portland USA 13 131 132 12 1313 6 1322 40000 2325 40000 6 3327
828 4 Bangalore India 14 141 142 13 1410 7 1421 40000 2424 40000 7 3426
829 4 Bangalore India 14 141 142 13 1410 7 1421 40000 2424 40000 8 3427
830 4 Bangalore India 14 141 142 13 1410 7 1421 40000 2425 40000 7 3426
831 4 Bangalore India 14 141 142 13 1410 7 1421 40000 2425 40000 8 3427
832 4 Bangalore India 14 141 142 13 1410 8 1422 40000 2424 40000 7 3426
833 4 Bangalore India 14 141 142 13 1410 8 1422 40000 2424 40000 8 3427
834 4 Bangalore India 14 141 142 13 1410 8 1422 40000 2425 40000 7 3426
835 4 Bangalore India 14 141 142 13 1410 8 1422 40000 2425 40000 8 3427
836 4 Bangalore India 14 141 142 14 1411 7 1421 40000 2424 40000 7 3426
837 4 Bangalore India 14 141 142 14 1411 7 1421 40000 2424 40000 8 3427
838 4 Bangalore India 14 141 142 14 1411 7 1421 40000 2425 40000 7 3426
839 4 Bangalore India 14 141 142 14 1411 7 1421 40000 2425 40000 8 3427
840 4 Bangalore India 14 141 142 14 1411 8 1422 40000 2424 40000 7 3426
841 4 Bangalore India 14 141 142 14 1411 8 1422 40000 2424 40000 8 3427
842 4 Bangalore India 14 141 142 14 1411 8 1422 40000 2425 40000 7 3426
843 4 Bangalore India 14 141 142 14 1411 8 1422 40000 2425 40000 8 3427
844 4 Bangalore India 14 141 142 15 1412 7 1421 40000 2424 40000 7 3426
845 4 Bangalore India 14 141 142 15 1412 7 1421 40000 2424 40000 8 3427
846 4 Bangalore India 14 141 142 15 1412 7 1421 40000 2425 40000 7 3426
847 4 Bangalore India 14 141 142 15 1412 7 1421 40000 2425 40000 8 3427
848 4 Bangalore India 14 141 142 15 1412 8 1422 40000 2424 40000 7 3426
849 4 Bangalore India 14 141 142 15 1412 8 1422 40000 2424 40000 8 3427
850 4 Bangalore India 14 141 142 15 1412 8 1422 40000 2425 40000 7 3426
851 4 Bangalore India 14 141 142 15 1412 8 1422 40000 2425 40000 8 3427
852 4 Bangalore India 14 141 142 16 1413 7 1421 40000 2424 40000 7 3426
853 4 Bangalore India 14 141 142 16 1413 7 1421 40000 2424 40000 8 3427
854 4 Bangalore India 14 141 142 16 1413 7 1421 40000 2425 40000 7 3426
855 4 Bangalore India 14 141 142 16 1413 7 1421 40000 2425 40000 8 3427
856 4 Bangalore India 14 141 142 16 1413 8 1422 40000 2424 40000 7 3426
857 4 Bangalore India 14 141 142 16 1413 8 1422 40000 2424 40000 8 3427
858 4 Bangalore India 14 141 142 16 1413 8 1422 40000 2425 40000 7 3426
859 4 Bangalore India 14 141 142 16 1413 8 1422 40000 2425 40000 8 3427
860 5 Helsinki Finland 15 151 152 17 1510 9 1521 40000 2524 40000 9 3526
861 5 Helsinki Finland 15 151 152 17 1510 9 1521 40000 2524 40000 10 3527
862 5 Helsinki Finland 15 151 152 17 1510 9 1521 40000 2525 40000 9 3526
863 5 Helsinki Finland 15 151 152 17 1510 9 1521 40000 2525 40000 10 3527
864 5 Helsinki Finland 15 151 152 17 1510 10 1522 40000 2524 40000 9 3526
865 5 Helsinki Finland 15 151 152 17 1510 10 1522 40000 2524 40000 10 3527
866 5 Helsinki Finland 15 151 152 17 1510 10 1522 40000 2525 40000 9 3526
867 5 Helsinki Finland 15 151 152 17 1510 10 1522 40000 2525 40000 10 3527
868 5 Helsinki Finland 15 151 152 18 1511 9 1521 40000 2524 40000 9 3526
869 5 Helsinki Finland 15 151 152 18 1511 9 1521 40000 2524 40000 10 3527
870 5 Helsinki Finland 15 151 152 18 1511 9 1521 40000 2525 40000 9 3526
871 5 Helsinki Finland 15 151 152 18 1511 9 1521 40000 2525 40000 10 3527
872 5 Helsinki Finland 15 151 152 18 1511 10 1522 40000 2524 40000 9 3526
873 5 Helsinki Finland 15 151 152 18 1511 10 1522 40000 2524 40000 10 3527
874 5 Helsinki Finland 15 151 152 18 1511 10 1522 40000 2525 40000 9 3526
875 5 Helsinki Finland 15 151 152 18 1511 10 1522 40000 2525 40000 10 3527
876 5 Helsinki Finland 15 151 152 19 1512 9 1521 40000 2524 40000 9 3526
877 5 Helsinki Finland 15 151 152 19 1512 9 1521 40000 2524 40000 10 3527
878 5 Helsinki Finland 15 151 152 19 1512 9 1521 40000 2525 40000 9 3526
879 5 Helsinki Finland 15 151 152 19 1512 9 1521 40000 2525 40000 10 3527
880 5 Helsinki Finland 15 151 152 19 1512 10 1522 40000 2524 40000 9 3526
881 5 Helsinki Finland 15 151 152 19 1512 10 1522 40000 2524 40000 10 3527
882 5 Helsinki Finland 15 151 152 19 1512 10 1522 40000 2525 40000 9 3526
883 5 Helsinki Finland 15 151 152 19 1512 10 1522 40000 2525 40000 10 3527
884 5 Helsinki Finland 15 151 152 20 1513 9 1521 40000 2524 40000 9 3526
885 5 Helsinki Finland 15 151 152 20 1513 9 1521 40000 2524 40000 10 3527
886 5 Helsinki Finland 15 151 152 20 1513 9 1521 40000 2525 40000 9 3526
887 5 Helsinki Finland 15 151 152 20 1513 9 1521 40000 2525 40000 10 3527
888 5 Helsinki Finland 15 151 152 20 1513 10 1522 40000 2524 40000 9 3526
889 5 Helsinki Finland 15 151 152 20 1513 10 1522 40000 2524 40000 10 3527
890 5 Helsinki Finland 15 151 152 20 1513 10 1522 40000 2525 40000 9 3526
891 5 Helsinki Finland 15 151 152 20 1513 10 1522 40000 2525 40000 10 3527
892 6 Lisbon Portugal 16 161 162 21 1610 11 1621 40000 2624 40000 11 3626
893 6 Lisbon Portugal 16 161 162 21 1610 11 1621 40000 2624 40000 12 3627
894 6 Lisbon Portugal 16 161 162 21 1610 11 1621 40000 2625 40000 11 3626
895 6 Lisbon Portugal 16 161 162 21 1610 11 1621 40000 2625 40000 12 3627
896 6 Lisbon Portugal 16 161 162 21 1610 12 1622 40000 2624 40000 11 3626
897 6 Lisbon Portugal 16 161 162 21 1610 12 1622 40000 2624 40000 12 3627
898 6 Lisbon Portugal 16 161 162 21 1610 12 1622 40000 2625 40000 11 3626
899 6 Lisbon Portugal 16 161 162 21 1610 12 1622 40000 2625 40000 12 3627
900 6 Lisbon Portugal 16 161 162 22 1611 11 1621 40000 2624 40000 11 3626
901 6 Lisbon Portugal 16 161 162 22 1611 11 1621 40000 2624 40000 12 3627
902 6 Lisbon Portugal 16 161 162 22 1611 11 1621 40000 2625 40000 11 3626
903 6 Lisbon Portugal 16 161 162 22 1611 11 1621 40000 2625 40000 12 3627
904 6 Lisbon Portugal 16 161 162 22 1611 12 1622 40000 2624 40000 11 3626
905 6 Lisbon Portugal 16 161 162 22 1611 12 1622 40000 2624 40000 12 3627
906 6 Lisbon Portugal 16 161 162 22 1611 12 1622 40000 2625 40000 11 3626
907 6 Lisbon Portugal 16 161 162 22 1611 12 1622 40000 2625 40000 12 3627
908 6 Lisbon Portugal 16 161 162 23 1612 11 1621 40000 2624 40000 11 3626
909 6 Lisbon Portugal 16 161 162 23 1612 11 1621 40000 2624 40000 12 3627
910 6 Lisbon Portugal 16 161 162 23 1612 11 1621 40000 2625 40000 11 3626
911 6 Lisbon Portugal 16 161 162 23 1612 11 1621 40000 2625 40000 12 3627
912 6 Lisbon Portugal 16 161 162 23 1612 12 1622 40000 2624 40000 11 3626
913 6 Lisbon Portugal 16 161 162 23 1612 12 1622 40000 2624 40000 12 3627
914 6 Lisbon Portugal 16 161 162 23 1612 12 1622 40000 2625 40000 11 3626
915 6 Lisbon Portugal 16 161 162 23 1612 12 1622 40000 2625 40000 12 3627
916 6 Lisbon Portugal 16 161 162 24 1613 11 1621 40000 2624 40000 11 3626
917 6 Lisbon Portugal 16 161 162 24 1613 11 1621 40000 2624 40000 12 3627
918 6 Lisbon Portugal 16 161 162 24 1613 11 1621 40000 2625 40000 11 3626
919 6 Lisbon Portugal 16 161 162 24 1613 11 1621 40000 2625 40000 12 3627
920 6 Lisbon Portugal 16 161 162 24 1613 12 1622 40000 2624 40000 11 3626
921 6 Lisbon Portugal 16 161 162 24 1613 12 1622 40000 2624 40000 12 3627
922 6 Lisbon Portugal 16 161 162 24 1613 12 1622 40000 2625 40000 11 3626
923 6 Lisbon Portugal 16 161 162 24 1613 12 1622 40000 2625 40000 12 3627
924 7 Norrwaste Sweden 17 171 172 25 1710 13 1721 40000 2724 40000 13 3726
925 7 Norrwaste Sweden 17 171 172 25 1710 13 1721 40000 2724 40000 14 3727
926 7 Norrwaste Sweden 17 171 172 25 1710 13 1721 40000 2725 40000 13 3726
927 7 Norrwaste Sweden 17 171 172 25 1710 13 1721 40000 2725 40000 14 3727
928 7 Norrwaste Sweden 17 171 172 25 1710 14 1722 40000 2724 40000 13 3726
929 7 Norrwaste Sweden 17 171 172 25 1710 14 1722 40000 2724 40000 14 3727
930 7 Norrwaste Sweden 17 171 172 25 1710 14 1722 40000 2725 40000 13 3726
931 7 Norrwaste Sweden 17 171 172 25 1710 14 1722 40000 2725 40000 14 3727
932 7 Norrwaste Sweden 17 171 172 26 1711 13 1721 40000 2724 40000 13 3726
933 7 Norrwaste Sweden 17 171 172 26 1711 13 1721 40000 2724 40000 14 3727
934 7 Norrwaste Sweden 17 171 172 26 1711 13 1721 40000 2725 40000 13 3726
935 7 Norrwaste Sweden 17 171 172 26 1711 13 1721 40000 2725 40000 14 3727
936 7 Norrwaste Sweden 17 171 172 26 1711 14 1722 40000 2724 40000 13 3726
937 7 Norrwaste Sweden 17 171 172 26 1711 14 1722 40000 2724 40000 14 3727
938 7 Norrwaste Sweden 17 171 172 26 1711 14 1722 40000 2725 40000 13 3726
939 7 Norrwaste Sweden 17 171 172 26 1711 14 1722 40000 2725 40000 14 3727
940 7 Norrwaste Sweden 17 171 172 27 1712 13 1721 40000 2724 40000 13 3726
941 7 Norrwaste Sweden 17 171 172 27 1712 13 1721 40000 2724 40000 14 3727
942 7 Norrwaste Sweden 17 171 172 27 1712 13 1721 40000 2725 40000 13 3726
943 7 Norrwaste Sweden 17 171 172 27 1712 13 1721 40000 2725 40000 14 3727
944 7 Norrwaste Sweden 17 171 172 27 1712 14 1722 40000 2724 40000 13 3726
945 7 Norrwaste Sweden 17 171 172 27 1712 14 1722 40000 2724 40000 14 3727
946 7 Norrwaste Sweden 17 171 172 27 1712 14 1722 40000 2725 40000 13 3726
947 7 Norrwaste Sweden 17 171 172 27 1712 14 1722 40000 2725 40000 14 3727
948 7 Norrwaste Sweden 17 171 172 28 1713 13 1721 40000 2724 40000 13 3726
949 7 Norrwaste Sweden 17 171 172 28 1713 13 1721 40000 2724 40000 14 3727
950 7 Norrwaste Sweden 17 171 172 28 1713 13 1721 40000 2725 40000 13 3726
951 7 Norrwaste Sweden 17 171 172 28 1713 13 1721 40000 2725 40000 14 3727
952 7 Norrwaste Sweden 17 171 172 28 1713 14 1722 40000 2724 40000 13 3726
953 7 Norrwaste Sweden 17 171 172 28 1713 14 1722 40000 2724 40000 14 3727
954 7 Norrwaste Sweden 17 171 172 28 1713 14 1722 40000 2725 40000 13 3726
955 7 Norrwaste Sweden 17 171 172 28 1713 14 1722 40000 2725 40000 14 3727
956 8 ROW Earth 18 181 182 29 1810 15 1821 40000 2824 40000 15 3826
957 8 ROW Earth 18 181 182 29 1810 15 1821 40000 2824 40000 16 3827
958 8 ROW Earth 18 181 182 29 1810 15 1821 40000 2825 40000 15 3826
959 8 ROW Earth 18 181 182 29 1810 15 1821 40000 2825 40000 16 3827
960 8 ROW Earth 18 181 182 29 1810 16 1822 40000 2824 40000 15 3826
961 8 ROW Earth 18 181 182 29 1810 16 1822 40000 2824 40000 16 3827
962 8 ROW Earth 18 181 182 29 1810 16 1822 40000 2825 40000 15 3826
963 8 ROW Earth 18 181 182 29 1810 16 1822 40000 2825 40000 16 3827
964 8 ROW Earth 18 181 182 30 1811 15 1821 40000 2824 40000 15 3826
965 8 ROW Earth 18 181 182 30 1811 15 1821 40000 2824 40000 16 3827
966 8 ROW Earth 18 181 182 30 1811 15 1821 40000 2825 40000 15 3826
967 8 ROW Earth 18 181 182 30 1811 15 1821 40000 2825 40000 16 3827
968 8 ROW Earth 18 181 182 30 1811 16 1822 40000 2824 40000 15 3826
969 8 ROW Earth 18 181 182 30 1811 16 1822 40000 2824 40000 16 3827
970 8 ROW Earth 18 181 182 30 1811 16 1822 40000 2825 40000 15 3826
971 8 ROW Earth 18 181 182 30 1811 16 1822 40000 2825 40000 16 3827
972 8 ROW Earth 18 181 182 31 1812 15 1821 40000 2824 40000 15 3826
973 8 ROW Earth 18 181 182 31 1812 15 1821 40000 2824 40000 16 3827
974 8 ROW Earth 18 181 182 31 1812 15 1821 40000 2825 40000 15 3826
975 8 ROW Earth 18 181 182 31 1812 15 1821 40000 2825 40000 16 3827
976 8 ROW Earth 18 181 182 31 1812 16 1822 40000 2824 40000 15 3826
977 8 ROW Earth 18 181 182 31 1812 16 1822 40000 2824 40000 16 3827
978 8 ROW Earth 18 181 182 31 1812 16 1822 40000 2825 40000 15 3826
979 8 ROW Earth 18 181 182 31 1812 16 1822 40000 2825 40000 16 3827
980 8 ROW Earth 18 181 182 32 1813 15 1821 40000 2824 40000 15 3826
981 8 ROW Earth 18 181 182 32 1813 15 1821 40000 2824 40000 16 3827
982 8 ROW Earth 18 181 182 32 1813 15 1821 40000 2825 40000 15 3826
983 8 ROW Earth 18 181 182 32 1813 15 1821 40000 2825 40000 16 3827
984 8 ROW Earth 18 181 182 32 1813 16 1822 40000 2824 40000 15 3826
985 8 ROW Earth 18 181 182 32 1813 16 1822 40000 2824 40000 16 3827
986 8 ROW Earth 18 181 182 32 1813 16 1822 40000 2825 40000 15 3826
987 8 ROW Earth 18 181 182 32 1813 16 1822 40000 2825 40000 16 3827
988 Show auto-inc values
989 select count(1), max(entry_key) from test.idx_tbl;
990 count(1) max(entry_key)
991 8 8
992 show create table idx_tbl;
993 Table Create Table
994 idx_tbl CREATE TABLE `idx_tbl` (
995 `entry_key` bigint unsigned NOT NULL AUTO_INCREMENT,
996 `k1` varchar(100) NOT NULL,
997 `k2` varchar(100) NOT NULL,
998 `data` int DEFAULT NULL,
999 PRIMARY KEY (`k1`,`k2`),
1000 UNIQUE KEY `entry_key` (`entry_key`)
1001 ) ENGINE=ndbcluster AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1002 select count(1), max(mv_idx) from test.type2_1;
1003 count(1) max(mv_idx)
1004 32 32
1005 show create table type2_1;
1006 Table Create Table
1007 type2_1 CREATE TABLE `type2_1` (
1008 `entry_key` bigint unsigned NOT NULL,
1009 `mv_idx` bigint unsigned NOT NULL AUTO_INCREMENT,
1010 `data` int DEFAULT NULL,
1011 PRIMARY KEY (`entry_key`,`mv_idx`)
1012 ) ENGINE=ndbcluster AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1013 select count(1), max(mv_idx) from test.type2_2;
1014 count(1) max(mv_idx)
1015 16 16
1016 show create table type2_2;
1017 Table Create Table
1018 type2_2 CREATE TABLE `type2_2` (
1019 `entry_key` bigint unsigned NOT NULL,
1020 `mv_idx` bigint unsigned NOT NULL AUTO_INCREMENT,
1021 `data` text,
1022 PRIMARY KEY (`entry_key`,`mv_idx`)
1023 ) ENGINE=ndbcluster AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1024 select count(1), max(mv_idx) from test.type2_3;
1025 count(1) max(mv_idx)
1026 16 16
1027 show create table type2_3;
1028 Table Create Table
1029 type2_3 CREATE TABLE `type2_3` (
1030 `mv_idx` bigint unsigned NOT NULL AUTO_INCREMENT,
1031 `entry_key` bigint unsigned NOT NULL,
1032 `data` text,
1033 PRIMARY KEY (`mv_idx`)
1034 ) ENGINE=ndbcluster AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1035 select count(1), max(mv_idx) from test.type2_4;
1036 count(1) max(mv_idx)
1037 16 16
1038 show create table type2_4;
1039 Table Create Table
1040 type2_4 CREATE TABLE `type2_4` (
1041 `mv_idx` bigint unsigned NOT NULL AUTO_INCREMENT,
1042 `entry_key` bigint unsigned NOT NULL,
1043 `data` int DEFAULT NULL,
1044 PRIMARY KEY (`mv_idx`)
1045 ) ENGINE=ndbcluster AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1046 No mv_idx duplicates in type_2 tables
1047 select mv_idx, count(1) as ct
1048 from type2_1 group by mv_idx
1049 having ct > 1;
1050 mv_idx ct
1051 select mv_idx, count(1) as ct
1052 from type2_2 group by mv_idx
1053 having ct > 1;
1054 mv_idx ct
1055 select mv_idx, count(1) as ct
1056 from type2_3 group by mv_idx
1057 having ct > 1;
1058 mv_idx ct
1059 select mv_idx, count(1) as ct
1060 from type2_4 group by mv_idx
1061 having ct > 1;
1062 mv_idx ct
1063 select * from idx_tbl order by entry_key;
1064 entry_key k1 k2 data
1065 1 Stockholm Sweden 11
1066 2 Trondheim Norway 12
1067 3 Portland USA 13
1068 4 Bangalore India 14
1069 5 Helsinki Finland 15
1070 6 Lisbon Portugal 16
1071 7 Norrwaste Sweden 17
1072 8 ROW Earth 18
1073 select * from type1_1 order by entry_key;
1074 entry_key data
1075 1 111
1076 2 121
1077 3 131
1078 4 141
1079 5 151
1080 6 161
1081 7 171
1082 8 181
1083 select * from type1_2 order by entry_key;
1084 entry_key data
1085 1 112
1086 2 122
1087 3 132
1088 4 142
1089 5 152
1090 6 162
1091 7 172
1092 8 182
1093 select * from type2_1 order by entry_key, mv_idx;
1094 entry_key mv_idx data
1095 1 1 1110
1096 1 2 1111
1097 1 3 1112
1098 1 4 1113
1099 2 5 1210
1100 2 6 1211
1101 2 7 1212
1102 2 8 1213
1103 3 9 1310
1104 3 10 1311
1105 3 11 1312
1106 3 12 1313
1107 4 13 1410
1108 4 14 1411
1109 4 15 1412
1110 4 16 1413
1111 5 17 1510
1112 5 18 1511
1113 5 19 1512
1114 5 20 1513
1115 6 21 1610
1116 6 22 1611
1117 6 23 1612
1118 6 24 1613
1119 7 25 1710
1120 7 26 1711
1121 7 27 1712
1122 7 28 1713
1123 8 29 1810
1124 8 30 1811
1125 8 31 1812
1126 8 32 1813
1127 select entry_key, mv_idx, right(data, 4) from type2_2 order by entry_key, mv_idx;
1128 entry_key mv_idx right(data, 4)
1129 1 1 1121
1130 1 2 1122
1131 2 3 1221
1132 2 4 1222
1133 3 5 1321
1134 3 6 1322
1135 4 7 1421
1136 4 8 1422
1137 5 9 1521
1138 5 10 1522
1139 6 11 1621
1140 6 12 1622
1141 7 13 1721
1142 7 14 1722
1143 8 15 1821
1144 8 16 1822
1145 select entry_key, mv_idx, right(data, 4) from type2_3 order by entry_key, mv_idx;
1146 entry_key mv_idx right(data, 4)
1147 1 1 2124
1148 1 2 2125
1149 2 3 2224
1150 2 4 2225
1151 3 5 2324
1152 3 6 2325
1153 4 7 2424
1154 4 8 2425
1155 5 9 2524
1156 5 10 2525
1157 6 11 2624
1158 6 12 2625
1159 7 13 2724
1160 7 14 2725
1161 8 15 2824
1162 8 16 2825
1163 select * from type2_4 order by entry_key, mv_idx;
1164 mv_idx entry_key data
1165 1 1 3126
1166 2 1 3127
1167 3 2 3226
1168 4 2 3227
1169 5 3 3326
1170 6 3 3327
1171 7 4 3426
1172 8 4 3427
1173 9 5 3526
1174 10 5 3527
1175 11 6 3626
1176 12 6 3627
1177 13 7 3726
1178 14 7 3727
1179 15 8 3826
1180 16 8 3827
1181 drop table idx_tbl, type1_1, type1_2, type2_1, type2_2, type2_3, type2_4;
1182 Recreate tables
1183 create table idx_tbl (entry_key bigint unsigned not null auto_increment,
1184 k1 varchar(100),
1185 k2 varchar(100),
1186 data int,
1187 primary key (k1, k2),
1188 unique(entry_key)) engine=ndb;
1189 create table type1_1 (entry_key bigint unsigned not null primary key,
1190 data int) engine=ndb;
1191 create table type1_2 (entry_key bigint unsigned not null primary key,
1192 data int) engine=ndb;
1193 create table type2_1 (entry_key bigint unsigned not null,
1194 mv_idx bigint unsigned not null auto_increment,
1195 data int,
1196 primary key (entry_key, mv_idx)) engine=ndb;
1197 create table type2_2 (entry_key bigint unsigned not null,
1198 mv_idx bigint unsigned not null auto_increment,
1199 data text,
1200 primary key (entry_key, mv_idx)) engine=ndb;
1201 create table type2_3 (entry_key bigint unsigned not null,
1202 mv_idx bigint unsigned not null auto_increment,
1203 data text,
1204 primary key (entry_key, mv_idx)) engine = ndb;
1205 create table type2_4 (entry_key bigint unsigned not null,
1206 mv_idx bigint unsigned not null auto_increment,
1207 data int,
1208 primary key (entry_key, mv_idx)) engine = ndb;
1209 Run normal restore for first set of content
1210 Remap args : -x test.idx_tbl.entry_key:offset:9 -x test.type1_1.entry_key:offset:9 -x test.type1_2.entry_key:offset:9 -x test.type2_1.entry_key:offset:9 -x test.type2_1.mv_idx:offset:33 -x test.type2_2.entry_key:offset:9 -x test.type2_2.mv_idx:offset:17 -x test.type2_3.entry_key:offset:9 -x test.type2_3.mv_idx:offset:17 -x test.type2_4.entry_key:offset:9 -x test.type2_4.mv_idx:offset:17
1211 Run offset restore for second set of content
1212 Combined dataset
1213 -----------------
1214 select idx_tbl.entry_key,
1215 idx_tbl.k1,
1216 idx_tbl.k2,
1217 idx_tbl.data,
1218 type1_1.data,
1219 type1_2.data,
1220 type2_1.mv_idx,
1221 type2_1.data,
1222 type2_2.mv_idx,
1223 right(type2_2.data, 4),
1224 length(type2_2.data),
1225 right(type2_3.data, 4),
1226 length(type2_3.data),
1227 type2_4.mv_idx,
1228 type2_4.data
1229 from
1230 idx_tbl join type1_1 join type1_2 join type2_1 join type2_2 join type2_3 join type2_4
1231 on
1232 idx_tbl.entry_key = type1_1.entry_key
1233 and
1234 idx_tbl.entry_key = type1_2.entry_key
1235 and
1236 idx_tbl.entry_key = type2_1.entry_key
1237 and
1238 idx_tbl.entry_key = type2_2.entry_key
1239 and
1240 idx_tbl.entry_key = type2_3.entry_key
1241 and
1242 idx_tbl.entry_key = type2_4.entry_key
1243 order by idx_tbl.entry_key, type2_1.data, right(type2_2.data, 4), right(type2_3.data, 4), type2_4.data;
1244 entry_key k1 k2 data data data mv_idx data mv_idx right(type2_2.data, 4) length(type2_2.data) right(type2_3.data, 4) length(type2_3.data) mv_idx data
1245 1 Edinburgh UK 1 11 12 1 110 1 0121 40000 0124 40000 1 126
1246 1 Edinburgh UK 1 11 12 1 110 1 0121 40000 0124 40000 2 127
1247 1 Edinburgh UK 1 11 12 1 110 1 0121 40000 0125 40000 1 126
1248 1 Edinburgh UK 1 11 12 1 110 1 0121 40000 0125 40000 2 127
1249 1 Edinburgh UK 1 11 12 1 110 2 0122 40000 0124 40000 1 126
1250 1 Edinburgh UK 1 11 12 1 110 2 0122 40000 0124 40000 2 127
1251 1 Edinburgh UK 1 11 12 1 110 2 0122 40000 0125 40000 1 126
1252 1 Edinburgh UK 1 11 12 1 110 2 0122 40000 0125 40000 2 127
1253 1 Edinburgh UK 1 11 12 2 111 1 0121 40000 0124 40000 1 126
1254 1 Edinburgh UK 1 11 12 2 111 1 0121 40000 0124 40000 2 127
1255 1 Edinburgh UK 1 11 12 2 111 1 0121 40000 0125 40000 1 126
1256 1 Edinburgh UK 1 11 12 2 111 1 0121 40000 0125 40000 2 127
1257 1 Edinburgh UK 1 11 12 2 111 2 0122 40000 0124 40000 1 126
1258 1 Edinburgh UK 1 11 12 2 111 2 0122 40000 0124 40000 2 127
1259 1 Edinburgh UK 1 11 12 2 111 2 0122 40000 0125 40000 1 126
1260 1 Edinburgh UK 1 11 12 2 111 2 0122 40000 0125 40000 2 127
1261 1 Edinburgh UK 1 11 12 3 112 1 0121 40000 0124 40000 1 126
1262 1 Edinburgh UK 1 11 12 3 112 1 0121 40000 0124 40000 2 127
1263 1 Edinburgh UK 1 11 12 3 112 1 0121 40000 0125 40000 1 126
1264 1 Edinburgh UK 1 11 12 3 112 1 0121 40000 0125 40000 2 127
1265 1 Edinburgh UK 1 11 12 3 112 2 0122 40000 0124 40000 1 126
1266 1 Edinburgh UK 1 11 12 3 112 2 0122 40000 0124 40000 2 127
1267 1 Edinburgh UK 1 11 12 3 112 2 0122 40000 0125 40000 1 126
1268 1 Edinburgh UK 1 11 12 3 112 2 0122 40000 0125 40000 2 127
1269 1 Edinburgh UK 1 11 12 4 113 1 0121 40000 0124 40000 1 126
1270 1 Edinburgh UK 1 11 12 4 113 1 0121 40000 0124 40000 2 127
1271 1 Edinburgh UK 1 11 12 4 113 1 0121 40000 0125 40000 1 126
1272 1 Edinburgh UK 1 11 12 4 113 1 0121 40000 0125 40000 2 127
1273 1 Edinburgh UK 1 11 12 4 113 2 0122 40000 0124 40000 1 126
1274 1 Edinburgh UK 1 11 12 4 113 2 0122 40000 0124 40000 2 127
1275 1 Edinburgh UK 1 11 12 4 113 2 0122 40000 0125 40000 1 126
1276 1 Edinburgh UK 1 11 12 4 113 2 0122 40000 0125 40000 2 127
1277 2 Bristol UK 2 21 22 5 210 3 0221 40000 0224 40000 3 226
1278 2 Bristol UK 2 21 22 5 210 3 0221 40000 0224 40000 4 227
1279 2 Bristol UK 2 21 22 5 210 3 0221 40000 0225 40000 3 226
1280 2 Bristol UK 2 21 22 5 210 3 0221 40000 0225 40000 4 227
1281 2 Bristol UK 2 21 22 5 210 4 0222 40000 0224 40000 3 226
1282 2 Bristol UK 2 21 22 5 210 4 0222 40000 0224 40000 4 227
1283 2 Bristol UK 2 21 22 5 210 4 0222 40000 0225 40000 3 226
1284 2 Bristol UK 2 21 22 5 210 4 0222 40000 0225 40000 4 227
1285 2 Bristol UK 2 21 22 6 211 3 0221 40000 0224 40000 3 226
1286 2 Bristol UK 2 21 22 6 211 3 0221 40000 0224 40000 4 227
1287 2 Bristol UK 2 21 22 6 211 3 0221 40000 0225 40000 3 226
1288 2 Bristol UK 2 21 22 6 211 3 0221 40000 0225 40000 4 227
1289 2 Bristol UK 2 21 22 6 211 4 0222 40000 0224 40000 3 226
1290 2 Bristol UK 2 21 22 6 211 4 0222 40000 0224 40000 4 227
1291 2 Bristol UK 2 21 22 6 211 4 0222 40000 0225 40000 3 226
1292 2 Bristol UK 2 21 22 6 211 4 0222 40000 0225 40000 4 227
1293 2 Bristol UK 2 21 22 7 212 3 0221 40000 0224 40000 3 226
1294 2 Bristol UK 2 21 22 7 212 3 0221 40000 0224 40000 4 227
1295 2 Bristol UK 2 21 22 7 212 3 0221 40000 0225 40000 3 226
1296 2 Bristol UK 2 21 22 7 212 3 0221 40000 0225 40000 4 227
1297 2 Bristol UK 2 21 22 7 212 4 0222 40000 0224 40000 3 226
1298 2 Bristol UK 2 21 22 7 212 4 0222 40000 0224 40000 4 227
1299 2 Bristol UK 2 21 22 7 212 4 0222 40000 0225 40000 3 226
1300 2 Bristol UK 2 21 22 7 212 4 0222 40000 0225 40000 4 227
1301 2 Bristol UK 2 21 22 8 213 3 0221 40000 0224 40000 3 226
1302 2 Bristol UK 2 21 22 8 213 3 0221 40000 0224 40000 4 227
1303 2 Bristol UK 2 21 22 8 213 3 0221 40000 0225 40000 3 226
1304 2 Bristol UK 2 21 22 8 213 3 0221 40000 0225 40000 4 227
1305 2 Bristol UK 2 21 22 8 213 4 0222 40000 0224 40000 3 226
1306 2 Bristol UK 2 21 22 8 213 4 0222 40000 0224 40000 4 227
1307 2 Bristol UK 2 21 22 8 213 4 0222 40000 0225 40000 3 226
1308 2 Bristol UK 2 21 22 8 213 4 0222 40000 0225 40000 4 227
1309 3 Glasgow UK 3 31 32 9 310 5 0321 40000 0324 40000 5 326
1310 3 Glasgow UK 3 31 32 9 310 5 0321 40000 0324 40000 6 327
1311 3 Glasgow UK 3 31 32 9 310 5 0321 40000 0325 40000 5 326
1312 3 Glasgow UK 3 31 32 9 310 5 0321 40000 0325 40000 6 327
1313 3 Glasgow UK 3 31 32 9 310 6 0322 40000 0324 40000 5 326
1314 3 Glasgow UK 3 31 32 9 310 6 0322 40000 0324 40000 6 327
1315 3 Glasgow UK 3 31 32 9 310 6 0322 40000 0325 40000 5 326
1316 3 Glasgow UK 3 31 32 9 310 6 0322 40000 0325 40000 6 327
1317 3 Glasgow UK 3 31 32 10 311 5 0321 40000 0324 40000 5 326
1318 3 Glasgow UK 3 31 32 10 311 5 0321 40000 0324 40000 6 327
1319 3 Glasgow UK 3 31 32 10 311 5 0321 40000 0325 40000 5 326
1320 3 Glasgow UK 3 31 32 10 311 5 0321 40000 0325 40000 6 327
1321 3 Glasgow UK 3 31 32 10 311 6 0322 40000 0324 40000 5 326
1322 3 Glasgow UK 3 31 32 10 311 6 0322 40000 0324 40000 6 327
1323 3 Glasgow UK 3 31 32 10 311 6 0322 40000 0325 40000 5 326
1324 3 Glasgow UK 3 31 32 10 311 6 0322 40000 0325 40000 6 327
1325 3 Glasgow UK 3 31 32 11 312 5 0321 40000 0324 40000 5 326
1326 3 Glasgow UK 3 31 32 11 312 5 0321 40000 0324 40000 6 327
1327 3 Glasgow UK 3 31 32 11 312 5 0321 40000 0325 40000 5 326
1328 3 Glasgow UK 3 31 32 11 312 5 0321 40000 0325 40000 6 327
1329 3 Glasgow UK 3 31 32 11 312 6 0322 40000 0324 40000 5 326
1330 3 Glasgow UK 3 31 32 11 312 6 0322 40000 0324 40000 6 327
1331 3 Glasgow UK 3 31 32 11 312 6 0322 40000 0325 40000 5 326
1332 3 Glasgow UK 3 31 32 11 312 6 0322 40000 0325 40000 6 327
1333 3 Glasgow UK 3 31 32 12 313 5 0321 40000 0324 40000 5 326
1334 3 Glasgow UK 3 31 32 12 313 5 0321 40000 0324 40000 6 327
1335 3 Glasgow UK 3 31 32 12 313 5 0321 40000 0325 40000 5 326
1336 3 Glasgow UK 3 31 32 12 313 5 0321 40000 0325 40000 6 327
1337 3 Glasgow UK 3 31 32 12 313 6 0322 40000 0324 40000 5 326
1338 3 Glasgow UK 3 31 32 12 313 6 0322 40000 0324 40000 6 327
1339 3 Glasgow UK 3 31 32 12 313 6 0322 40000 0325 40000 5 326
1340 3 Glasgow UK 3 31 32 12 313 6 0322 40000 0325 40000 6 327
1341 4 London UK 4 41 42 13 410 7 0421 40000 0424 40000 7 426
1342 4 London UK 4 41 42 13 410 7 0421 40000 0424 40000 8 427
1343 4 London UK 4 41 42 13 410 7 0421 40000 0425 40000 7 426
1344 4 London UK 4 41 42 13 410 7 0421 40000 0425 40000 8 427
1345 4 London UK 4 41 42 13 410 8 0422 40000 0424 40000 7 426
1346 4 London UK 4 41 42 13 410 8 0422 40000 0424 40000 8 427
1347 4 London UK 4 41 42 13 410 8 0422 40000 0425 40000 7 426
1348 4 London UK 4 41 42 13 410 8 0422 40000 0425 40000 8 427
1349 4 London UK 4 41 42 14 411 7 0421 40000 0424 40000 7 426
1350 4 London UK 4 41 42 14 411 7 0421 40000 0424 40000 8 427
1351 4 London UK 4 41 42 14 411 7 0421 40000 0425 40000 7 426
1352 4 London UK 4 41 42 14 411 7 0421 40000 0425 40000 8 427
1353 4 London UK 4 41 42 14 411 8 0422 40000 0424 40000 7 426
1354 4 London UK 4 41 42 14 411 8 0422 40000 0424 40000 8 427
1355 4 London UK 4 41 42 14 411 8 0422 40000 0425 40000 7 426
1356 4 London UK 4 41 42 14 411 8 0422 40000 0425 40000 8 427
1357 4 London UK 4 41 42 15 412 7 0421 40000 0424 40000 7 426
1358 4 London UK 4 41 42 15 412 7 0421 40000 0424 40000 8 427
1359 4 London UK 4 41 42 15 412 7 0421 40000 0425 40000 7 426
1360 4 London UK 4 41 42 15 412 7 0421 40000 0425 40000 8 427
1361 4 London UK 4 41 42 15 412 8 0422 40000 0424 40000 7 426
1362 4 London UK 4 41 42 15 412 8 0422 40000 0424 40000 8 427
1363 4 London UK 4 41 42 15 412 8 0422 40000 0425 40000 7 426
1364 4 London UK 4 41 42 15 412 8 0422 40000 0425 40000 8 427
1365 4 London UK 4 41 42 16 413 7 0421 40000 0424 40000 7 426
1366 4 London UK 4 41 42 16 413 7 0421 40000 0424 40000 8 427
1367 4 London UK 4 41 42 16 413 7 0421 40000 0425 40000 7 426
1368 4 London UK 4 41 42 16 413 7 0421 40000 0425 40000 8 427
1369 4 London UK 4 41 42 16 413 8 0422 40000 0424 40000 7 426
1370 4 London UK 4 41 42 16 413 8 0422 40000 0424 40000 8 427
1371 4 London UK 4 41 42 16 413 8 0422 40000 0425 40000 7 426
1372 4 London UK 4 41 42 16 413 8 0422 40000 0425 40000 8 427
1373 5 Paris France 5 51 52 17 510 9 0521 40000 0524 40000 9 526
1374 5 Paris France 5 51 52 17 510 9 0521 40000 0524 40000 10 527
1375 5 Paris France 5 51 52 17 510 9 0521 40000 0525 40000 9 526
1376 5 Paris France 5 51 52 17 510 9 0521 40000 0525 40000 10 527
1377 5 Paris France 5 51 52 17 510 10 0522 40000 0524 40000 9 526
1378 5 Paris France 5 51 52 17 510 10 0522 40000 0524 40000 10 527
1379 5 Paris France 5 51 52 17 510 10 0522 40000 0525 40000 9 526
1380 5 Paris France 5 51 52 17 510 10 0522 40000 0525 40000 10 527
1381 5 Paris France 5 51 52 18 511 9 0521 40000 0524 40000 9 526
1382 5 Paris France 5 51 52 18 511 9 0521 40000 0524 40000 10 527
1383 5 Paris France 5 51 52 18 511 9 0521 40000 0525 40000 9 526
1384 5 Paris France 5 51 52 18 511 9 0521 40000 0525 40000 10 527
1385 5 Paris France 5 51 52 18 511 10 0522 40000 0524 40000 9 526
1386 5 Paris France 5 51 52 18 511 10 0522 40000 0524 40000 10 527
1387 5 Paris France 5 51 52 18 511 10 0522 40000 0525 40000 9 526
1388 5 Paris France 5 51 52 18 511 10 0522 40000 0525 40000 10 527
1389 5 Paris France 5 51 52 19 512 9 0521 40000 0524 40000 9 526
1390 5 Paris France 5 51 52 19 512 9 0521 40000 0524 40000 10 527
1391 5 Paris France 5 51 52 19 512 9 0521 40000 0525 40000 9 526
1392 5 Paris France 5 51 52 19 512 9 0521 40000 0525 40000 10 527
1393 5 Paris France 5 51 52 19 512 10 0522 40000 0524 40000 9 526
1394 5 Paris France 5 51 52 19 512 10 0522 40000 0524 40000 10 527
1395 5 Paris France 5 51 52 19 512 10 0522 40000 0525 40000 9 526
1396 5 Paris France 5 51 52 19 512 10 0522 40000 0525 40000 10 527
1397 5 Paris France 5 51 52 20 513 9 0521 40000 0524 40000 9 526
1398 5 Paris France 5 51 52 20 513 9 0521 40000 0524 40000 10 527
1399 5 Paris France 5 51 52 20 513 9 0521 40000 0525 40000 9 526
1400 5 Paris France 5 51 52 20 513 9 0521 40000 0525 40000 10 527
1401 5 Paris France 5 51 52 20 513 10 0522 40000 0524 40000 9 526
1402 5 Paris France 5 51 52 20 513 10 0522 40000 0524 40000 10 527
1403 5 Paris France 5 51 52 20 513 10 0522 40000 0525 40000 9 526
1404 5 Paris France 5 51 52 20 513 10 0522 40000 0525 40000 10 527
1405 6 Heidelberg Germany 6 61 62 21 610 11 0621 40000 0624 40000 11 626
1406 6 Heidelberg Germany 6 61 62 21 610 11 0621 40000 0624 40000 12 627
1407 6 Heidelberg Germany 6 61 62 21 610 11 0621 40000 0625 40000 11 626
1408 6 Heidelberg Germany 6 61 62 21 610 11 0621 40000 0625 40000 12 627
1409 6 Heidelberg Germany 6 61 62 21 610 12 0622 40000 0624 40000 11 626
1410 6 Heidelberg Germany 6 61 62 21 610 12 0622 40000 0624 40000 12 627
1411 6 Heidelberg Germany 6 61 62 21 610 12 0622 40000 0625 40000 11 626
1412 6 Heidelberg Germany 6 61 62 21 610 12 0622 40000 0625 40000 12 627
1413 6 Heidelberg Germany 6 61 62 22 611 11 0621 40000 0624 40000 11 626
1414 6 Heidelberg Germany 6 61 62 22 611 11 0621 40000 0624 40000 12 627
1415 6 Heidelberg Germany 6 61 62 22 611 11 0621 40000 0625 40000 11 626
1416 6 Heidelberg Germany 6 61 62 22 611 11 0621 40000 0625 40000 12 627
1417 6 Heidelberg Germany 6 61 62 22 611 12 0622 40000 0624 40000 11 626
1418 6 Heidelberg Germany 6 61 62 22 611 12 0622 40000 0624 40000 12 627
1419 6 Heidelberg Germany 6 61 62 22 611 12 0622 40000 0625 40000 11 626
1420 6 Heidelberg Germany 6 61 62 22 611 12 0622 40000 0625 40000 12 627
1421 6 Heidelberg Germany 6 61 62 23 612 11 0621 40000 0624 40000 11 626
1422 6 Heidelberg Germany 6 61 62 23 612 11 0621 40000 0624 40000 12 627
1423 6 Heidelberg Germany 6 61 62 23 612 11 0621 40000 0625 40000 11 626
1424 6 Heidelberg Germany 6 61 62 23 612 11 0621 40000 0625 40000 12 627
1425 6 Heidelberg Germany 6 61 62 23 612 12 0622 40000 0624 40000 11 626
1426 6 Heidelberg Germany 6 61 62 23 612 12 0622 40000 0624 40000 12 627
1427 6 Heidelberg Germany 6 61 62 23 612 12 0622 40000 0625 40000 11 626
1428 6 Heidelberg Germany 6 61 62 23 612 12 0622 40000 0625 40000 12 627
1429 6 Heidelberg Germany 6 61 62 24 613 11 0621 40000 0624 40000 11 626
1430 6 Heidelberg Germany 6 61 62 24 613 11 0621 40000 0624 40000 12 627
1431 6 Heidelberg Germany 6 61 62 24 613 11 0621 40000 0625 40000 11 626
1432 6 Heidelberg Germany 6 61 62 24 613 11 0621 40000 0625 40000 12 627
1433 6 Heidelberg Germany 6 61 62 24 613 12 0622 40000 0624 40000 11 626
1434 6 Heidelberg Germany 6 61 62 24 613 12 0622 40000 0624 40000 12 627
1435 6 Heidelberg Germany 6 61 62 24 613 12 0622 40000 0625 40000 11 626
1436 6 Heidelberg Germany 6 61 62 24 613 12 0622 40000 0625 40000 12 627
1437 7 Riga Latvia 7 71 72 25 710 13 0721 40000 0724 40000 13 726
1438 7 Riga Latvia 7 71 72 25 710 13 0721 40000 0724 40000 14 727
1439 7 Riga Latvia 7 71 72 25 710 13 0721 40000 0725 40000 13 726
1440 7 Riga Latvia 7 71 72 25 710 13 0721 40000 0725 40000 14 727
1441 7 Riga Latvia 7 71 72 25 710 14 0722 40000 0724 40000 13 726
1442 7 Riga Latvia 7 71 72 25 710 14 0722 40000 0724 40000 14 727
1443 7 Riga Latvia 7 71 72 25 710 14 0722 40000 0725 40000 13 726
1444 7 Riga Latvia 7 71 72 25 710 14 0722 40000 0725 40000 14 727
1445 7 Riga Latvia 7 71 72 26 711 13 0721 40000 0724 40000 13 726
1446 7 Riga Latvia 7 71 72 26 711 13 0721 40000 0724 40000 14 727
1447 7 Riga Latvia 7 71 72 26 711 13 0721 40000 0725 40000 13 726
1448 7 Riga Latvia 7 71 72 26 711 13 0721 40000 0725 40000 14 727
1449 7 Riga Latvia 7 71 72 26 711 14 0722 40000 0724 40000 13 726
1450 7 Riga Latvia 7 71 72 26 711 14 0722 40000 0724 40000 14 727
1451 7 Riga Latvia 7 71 72 26 711 14 0722 40000 0725 40000 13 726
1452 7 Riga Latvia 7 71 72 26 711 14 0722 40000 0725 40000 14 727
1453 7 Riga Latvia 7 71 72 27 712 13 0721 40000 0724 40000 13 726
1454 7 Riga Latvia 7 71 72 27 712 13 0721 40000 0724 40000 14 727
1455 7 Riga Latvia 7 71 72 27 712 13 0721 40000 0725 40000 13 726
1456 7 Riga Latvia 7 71 72 27 712 13 0721 40000 0725 40000 14 727
1457 7 Riga Latvia 7 71 72 27 712 14 0722 40000 0724 40000 13 726
1458 7 Riga Latvia 7 71 72 27 712 14 0722 40000 0724 40000 14 727
1459 7 Riga Latvia 7 71 72 27 712 14 0722 40000 0725 40000 13 726
1460 7 Riga Latvia 7 71 72 27 712 14 0722 40000 0725 40000 14 727
1461 7 Riga Latvia 7 71 72 28 713 13 0721 40000 0724 40000 13 726
1462 7 Riga Latvia 7 71 72 28 713 13 0721 40000 0724 40000 14 727
1463 7 Riga Latvia 7 71 72 28 713 13 0721 40000 0725 40000 13 726
1464 7 Riga Latvia 7 71 72 28 713 13 0721 40000 0725 40000 14 727
1465 7 Riga Latvia 7 71 72 28 713 14 0722 40000 0724 40000 13 726
1466 7 Riga Latvia 7 71 72 28 713 14 0722 40000 0724 40000 14 727
1467 7 Riga Latvia 7 71 72 28 713 14 0722 40000 0725 40000 13 726
1468 7 Riga Latvia 7 71 72 28 713 14 0722 40000 0725 40000 14 727
1469 8 Orlando USA 8 81 82 29 810 15 0821 40000 0824 40000 15 826
1470 8 Orlando USA 8 81 82 29 810 15 0821 40000 0824 40000 16 827
1471 8 Orlando USA 8 81 82 29 810 15 0821 40000 0825 40000 15 826
1472 8 Orlando USA 8 81 82 29 810 15 0821 40000 0825 40000 16 827
1473 8 Orlando USA 8 81 82 29 810 16 0822 40000 0824 40000 15 826
1474 8 Orlando USA 8 81 82 29 810 16 0822 40000 0824 40000 16 827
1475 8 Orlando USA 8 81 82 29 810 16 0822 40000 0825 40000 15 826
1476 8 Orlando USA 8 81 82 29 810 16 0822 40000 0825 40000 16 827
1477 8 Orlando USA 8 81 82 30 811 15 0821 40000 0824 40000 15 826
1478 8 Orlando USA 8 81 82 30 811 15 0821 40000 0824 40000 16 827
1479 8 Orlando USA 8 81 82 30 811 15 0821 40000 0825 40000 15 826
1480 8 Orlando USA 8 81 82 30 811 15 0821 40000 0825 40000 16 827
1481 8 Orlando USA 8 81 82 30 811 16 0822 40000 0824 40000 15 826
1482 8 Orlando USA 8 81 82 30 811 16 0822 40000 0824 40000 16 827
1483 8 Orlando USA 8 81 82 30 811 16 0822 40000 0825 40000 15 826
1484 8 Orlando USA 8 81 82 30 811 16 0822 40000 0825 40000 16 827
1485 8 Orlando USA 8 81 82 31 812 15 0821 40000 0824 40000 15 826
1486 8 Orlando USA 8 81 82 31 812 15 0821 40000 0824 40000 16 827
1487 8 Orlando USA 8 81 82 31 812 15 0821 40000 0825 40000 15 826
1488 8 Orlando USA 8 81 82 31 812 15 0821 40000 0825 40000 16 827
1489 8 Orlando USA 8 81 82 31 812 16 0822 40000 0824 40000 15 826
1490 8 Orlando USA 8 81 82 31 812 16 0822 40000 0824 40000 16 827
1491 8 Orlando USA 8 81 82 31 812 16 0822 40000 0825 40000 15 826
1492 8 Orlando USA 8 81 82 31 812 16 0822 40000 0825 40000 16 827
1493 8 Orlando USA 8 81 82 32 813 15 0821 40000 0824 40000 15 826
1494 8 Orlando USA 8 81 82 32 813 15 0821 40000 0824 40000 16 827
1495 8 Orlando USA 8 81 82 32 813 15 0821 40000 0825 40000 15 826
1496 8 Orlando USA 8 81 82 32 813 15 0821 40000 0825 40000 16 827
1497 8 Orlando USA 8 81 82 32 813 16 0822 40000 0824 40000 15 826
1498 8 Orlando USA 8 81 82 32 813 16 0822 40000 0824 40000 16 827
1499 8 Orlando USA 8 81 82 32 813 16 0822 40000 0825 40000 15 826
1500 8 Orlando USA 8 81 82 32 813 16 0822 40000 0825 40000 16 827
1501 10 Stockholm Sweden 11 111 112 34 1110 18 1121 40000 2124 40000 18 3126
1502 10 Stockholm Sweden 11 111 112 34 1110 18 1121 40000 2124 40000 19 3127
1503 10 Stockholm Sweden 11 111 112 34 1110 18 1121 40000 2125 40000 18 3126
1504 10 Stockholm Sweden 11 111 112 34 1110 18 1121 40000 2125 40000 19 3127
1505 10 Stockholm Sweden 11 111 112 34 1110 19 1122 40000 2124 40000 18 3126
1506 10 Stockholm Sweden 11 111 112 34 1110 19 1122 40000 2124 40000 19 3127
1507 10 Stockholm Sweden 11 111 112 34 1110 19 1122 40000 2125 40000 18 3126
1508 10 Stockholm Sweden 11 111 112 34 1110 19 1122 40000 2125 40000 19 3127
1509 10 Stockholm Sweden 11 111 112 35 1111 18 1121 40000 2124 40000 18 3126
1510 10 Stockholm Sweden 11 111 112 35 1111 18 1121 40000 2124 40000 19 3127
1511 10 Stockholm Sweden 11 111 112 35 1111 18 1121 40000 2125 40000 18 3126
1512 10 Stockholm Sweden 11 111 112 35 1111 18 1121 40000 2125 40000 19 3127
1513 10 Stockholm Sweden 11 111 112 35 1111 19 1122 40000 2124 40000 18 3126
1514 10 Stockholm Sweden 11 111 112 35 1111 19 1122 40000 2124 40000 19 3127
1515 10 Stockholm Sweden 11 111 112 35 1111 19 1122 40000 2125 40000 18 3126
1516 10 Stockholm Sweden 11 111 112 35 1111 19 1122 40000 2125 40000 19 3127
1517 10 Stockholm Sweden 11 111 112 36 1112 18 1121 40000 2124 40000 18 3126
1518 10 Stockholm Sweden 11 111 112 36 1112 18 1121 40000 2124 40000 19 3127
1519 10 Stockholm Sweden 11 111 112 36 1112 18 1121 40000 2125 40000 18 3126
1520 10 Stockholm Sweden 11 111 112 36 1112 18 1121 40000 2125 40000 19 3127
1521 10 Stockholm Sweden 11 111 112 36 1112 19 1122 40000 2124 40000 18 3126
1522 10 Stockholm Sweden 11 111 112 36 1112 19 1122 40000 2124 40000 19 3127
1523 10 Stockholm Sweden 11 111 112 36 1112 19 1122 40000 2125 40000 18 3126
1524 10 Stockholm Sweden 11 111 112 36 1112 19 1122 40000 2125 40000 19 3127
1525 10 Stockholm Sweden 11 111 112 37 1113 18 1121 40000 2124 40000 18 3126
1526 10 Stockholm Sweden 11 111 112 37 1113 18 1121 40000 2124 40000 19 3127
1527 10 Stockholm Sweden 11 111 112 37 1113 18 1121 40000 2125 40000 18 3126
1528 10 Stockholm Sweden 11 111 112 37 1113 18 1121 40000 2125 40000 19 3127
1529 10 Stockholm Sweden 11 111 112 37 1113 19 1122 40000 2124 40000 18 3126
1530 10 Stockholm Sweden 11 111 112 37 1113 19 1122 40000 2124 40000 19 3127
1531 10 Stockholm Sweden 11 111 112 37 1113 19 1122 40000 2125 40000 18 3126
1532 10 Stockholm Sweden 11 111 112 37 1113 19 1122 40000 2125 40000 19 3127
1533 11 Trondheim Norway 12 121 122 38 1210 20 1221 40000 2224 40000 20 3226
1534 11 Trondheim Norway 12 121 122 38 1210 20 1221 40000 2224 40000 21 3227
1535 11 Trondheim Norway 12 121 122 38 1210 20 1221 40000 2225 40000 20 3226
1536 11 Trondheim Norway 12 121 122 38 1210 20 1221 40000 2225 40000 21 3227
1537 11 Trondheim Norway 12 121 122 38 1210 21 1222 40000 2224 40000 20 3226
1538 11 Trondheim Norway 12 121 122 38 1210 21 1222 40000 2224 40000 21 3227
1539 11 Trondheim Norway 12 121 122 38 1210 21 1222 40000 2225 40000 20 3226
1540 11 Trondheim Norway 12 121 122 38 1210 21 1222 40000 2225 40000 21 3227
1541 11 Trondheim Norway 12 121 122 39 1211 20 1221 40000 2224 40000 20 3226
1542 11 Trondheim Norway 12 121 122 39 1211 20 1221 40000 2224 40000 21 3227
1543 11 Trondheim Norway 12 121 122 39 1211 20 1221 40000 2225 40000 20 3226
1544 11 Trondheim Norway 12 121 122 39 1211 20 1221 40000 2225 40000 21 3227
1545 11 Trondheim Norway 12 121 122 39 1211 21 1222 40000 2224 40000 20 3226
1546 11 Trondheim Norway 12 121 122 39 1211 21 1222 40000 2224 40000 21 3227
1547 11 Trondheim Norway 12 121 122 39 1211 21 1222 40000 2225 40000 20 3226
1548 11 Trondheim Norway 12 121 122 39 1211 21 1222 40000 2225 40000 21 3227
1549 11 Trondheim Norway 12 121 122 40 1212 20 1221 40000 2224 40000 20 3226
1550 11 Trondheim Norway 12 121 122 40 1212 20 1221 40000 2224 40000 21 3227
1551 11 Trondheim Norway 12 121 122 40 1212 20 1221 40000 2225 40000 20 3226
1552 11 Trondheim Norway 12 121 122 40 1212 20 1221 40000 2225 40000 21 3227
1553 11 Trondheim Norway 12 121 122 40 1212 21 1222 40000 2224 40000 20 3226
1554 11 Trondheim Norway 12 121 122 40 1212 21 1222 40000 2224 40000 21 3227
1555 11 Trondheim Norway 12 121 122 40 1212 21 1222 40000 2225 40000 20 3226
1556 11 Trondheim Norway 12 121 122 40 1212 21 1222 40000 2225 40000 21 3227
1557 11 Trondheim Norway 12 121 122 41 1213 20 1221 40000 2224 40000 20 3226
1558 11 Trondheim Norway 12 121 122 41 1213 20 1221 40000 2224 40000 21 3227
1559 11 Trondheim Norway 12 121 122 41 1213 20 1221 40000 2225 40000 20 3226
1560 11 Trondheim Norway 12 121 122 41 1213 20 1221 40000 2225 40000 21 3227
1561 11 Trondheim Norway 12 121 122 41 1213 21 1222 40000 2224 40000 20 3226
1562 11 Trondheim Norway 12 121 122 41 1213 21 1222 40000 2224 40000 21 3227
1563 11 Trondheim Norway 12 121 122 41 1213 21 1222 40000 2225 40000 20 3226
1564 11 Trondheim Norway 12 121 122 41 1213 21 1222 40000 2225 40000 21 3227
1565 12 Portland USA 13 131 132 42 1310 22 1321 40000 2324 40000 22 3326
1566 12 Portland USA 13 131 132 42 1310 22 1321 40000 2324 40000 23 3327
1567 12 Portland USA 13 131 132 42 1310 22 1321 40000 2325 40000 22 3326
1568 12 Portland USA 13 131 132 42 1310 22 1321 40000 2325 40000 23 3327
1569 12 Portland USA 13 131 132 42 1310 23 1322 40000 2324 40000 22 3326
1570 12 Portland USA 13 131 132 42 1310 23 1322 40000 2324 40000 23 3327
1571 12 Portland USA 13 131 132 42 1310 23 1322 40000 2325 40000 22 3326
1572 12 Portland USA 13 131 132 42 1310 23 1322 40000 2325 40000 23 3327
1573 12 Portland USA 13 131 132 43 1311 22 1321 40000 2324 40000 22 3326
1574 12 Portland USA 13 131 132 43 1311 22 1321 40000 2324 40000 23 3327
1575 12 Portland USA 13 131 132 43 1311 22 1321 40000 2325 40000 22 3326
1576 12 Portland USA 13 131 132 43 1311 22 1321 40000 2325 40000 23 3327
1577 12 Portland USA 13 131 132 43 1311 23 1322 40000 2324 40000 22 3326
1578 12 Portland USA 13 131 132 43 1311 23 1322 40000 2324 40000 23 3327
1579 12 Portland USA 13 131 132 43 1311 23 1322 40000 2325 40000 22 3326
1580 12 Portland USA 13 131 132 43 1311 23 1322 40000 2325 40000 23 3327
1581 12 Portland USA 13 131 132 44 1312 22 1321 40000 2324 40000 22 3326
1582 12 Portland USA 13 131 132 44 1312 22 1321 40000 2324 40000 23 3327
1583 12 Portland USA 13 131 132 44 1312 22 1321 40000 2325 40000 22 3326
1584 12 Portland USA 13 131 132 44 1312 22 1321 40000 2325 40000 23 3327
1585 12 Portland USA 13 131 132 44 1312 23 1322 40000 2324 40000 22 3326
1586 12 Portland USA 13 131 132 44 1312 23 1322 40000 2324 40000 23 3327
1587 12 Portland USA 13 131 132 44 1312 23 1322 40000 2325 40000 22 3326
1588 12 Portland USA 13 131 132 44 1312 23 1322 40000 2325 40000 23 3327
1589 12 Portland USA 13 131 132 45 1313 22 1321 40000 2324 40000 22 3326
1590 12 Portland USA 13 131 132 45 1313 22 1321 40000 2324 40000 23 3327
1591 12 Portland USA 13 131 132 45 1313 22 1321 40000 2325 40000 22 3326
1592 12 Portland USA 13 131 132 45 1313 22 1321 40000 2325 40000 23 3327
1593 12 Portland USA 13 131 132 45 1313 23 1322 40000 2324 40000 22 3326
1594 12 Portland USA 13 131 132 45 1313 23 1322 40000 2324 40000 23 3327
1595 12 Portland USA 13 131 132 45 1313 23 1322 40000 2325 40000 22 3326
1596 12 Portland USA 13 131 132 45 1313 23 1322 40000 2325 40000 23 3327
1597 13 Bangalore India 14 141 142 46 1410 24 1421 40000 2424 40000 24 3426
1598 13 Bangalore India 14 141 142 46 1410 24 1421 40000 2424 40000 25 3427
1599 13 Bangalore India 14 141 142 46 1410 24 1421 40000 2425 40000 24 3426
1600 13 Bangalore India 14 141 142 46 1410 24 1421 40000 2425 40000 25 3427
1601 13 Bangalore India 14 141 142 46 1410 25 1422 40000 2424 40000 24 3426
1602 13 Bangalore India 14 141 142 46 1410 25 1422 40000 2424 40000 25 3427
1603 13 Bangalore India 14 141 142 46 1410 25 1422 40000 2425 40000 24 3426
1604 13 Bangalore India 14 141 142 46 1410 25 1422 40000 2425 40000 25 3427
1605 13 Bangalore India 14 141 142 47 1411 24 1421 40000 2424 40000 24 3426
1606 13 Bangalore India 14 141 142 47 1411 24 1421 40000 2424 40000 25 3427
1607 13 Bangalore India 14 141 142 47 1411 24 1421 40000 2425 40000 24 3426
1608 13 Bangalore India 14 141 142 47 1411 24 1421 40000 2425 40000 25 3427
1609 13 Bangalore India 14 141 142 47 1411 25 1422 40000 2424 40000 24 3426
1610 13 Bangalore India 14 141 142 47 1411 25 1422 40000 2424 40000 25 3427
1611 13 Bangalore India 14 141 142 47 1411 25 1422 40000 2425 40000 24 3426
1612 13 Bangalore India 14 141 142 47 1411 25 1422 40000 2425 40000 25 3427
1613 13 Bangalore India 14 141 142 48 1412 24 1421 40000 2424 40000 24 3426
1614 13 Bangalore India 14 141 142 48 1412 24 1421 40000 2424 40000 25 3427
1615 13 Bangalore India 14 141 142 48 1412 24 1421 40000 2425 40000 24 3426
1616 13 Bangalore India 14 141 142 48 1412 24 1421 40000 2425 40000 25 3427
1617 13 Bangalore India 14 141 142 48 1412 25 1422 40000 2424 40000 24 3426
1618 13 Bangalore India 14 141 142 48 1412 25 1422 40000 2424 40000 25 3427
1619 13 Bangalore India 14 141 142 48 1412 25 1422 40000 2425 40000 24 3426
1620 13 Bangalore India 14 141 142 48 1412 25 1422 40000 2425 40000 25 3427
1621 13 Bangalore India 14 141 142 49 1413 24 1421 40000 2424 40000 24 3426
1622 13 Bangalore India 14 141 142 49 1413 24 1421 40000 2424 40000 25 3427
1623 13 Bangalore India 14 141 142 49 1413 24 1421 40000 2425 40000 24 3426
1624 13 Bangalore India 14 141 142 49 1413 24 1421 40000 2425 40000 25 3427
1625 13 Bangalore India 14 141 142 49 1413 25 1422 40000 2424 40000 24 3426
1626 13 Bangalore India 14 141 142 49 1413 25 1422 40000 2424 40000 25 3427
1627 13 Bangalore India 14 141 142 49 1413 25 1422 40000 2425 40000 24 3426
1628 13 Bangalore India 14 141 142 49 1413 25 1422 40000 2425 40000 25 3427
1629 14 Helsinki Finland 15 151 152 50 1510 26 1521 40000 2524 40000 26 3526
1630 14 Helsinki Finland 15 151 152 50 1510 26 1521 40000 2524 40000 27 3527
1631 14 Helsinki Finland 15 151 152 50 1510 26 1521 40000 2525 40000 26 3526
1632 14 Helsinki Finland 15 151 152 50 1510 26 1521 40000 2525 40000 27 3527
1633 14 Helsinki Finland 15 151 152 50 1510 27 1522 40000 2524 40000 26 3526
1634 14 Helsinki Finland 15 151 152 50 1510 27 1522 40000 2524 40000 27 3527
1635 14 Helsinki Finland 15 151 152 50 1510 27 1522 40000 2525 40000 26 3526
1636 14 Helsinki Finland 15 151 152 50 1510 27 1522 40000 2525 40000 27 3527
1637 14 Helsinki Finland 15 151 152 51 1511 26 1521 40000 2524 40000 26 3526
1638 14 Helsinki Finland 15 151 152 51 1511 26 1521 40000 2524 40000 27 3527
1639 14 Helsinki Finland 15 151 152 51 1511 26 1521 40000 2525 40000 26 3526
1640 14 Helsinki Finland 15 151 152 51 1511 26 1521 40000 2525 40000 27 3527
1641 14 Helsinki Finland 15 151 152 51 1511 27 1522 40000 2524 40000 26 3526
1642 14 Helsinki Finland 15 151 152 51 1511 27 1522 40000 2524 40000 27 3527
1643 14 Helsinki Finland 15 151 152 51 1511 27 1522 40000 2525 40000 26 3526
1644 14 Helsinki Finland 15 151 152 51 1511 27 1522 40000 2525 40000 27 3527
1645 14 Helsinki Finland 15 151 152 52 1512 26 1521 40000 2524 40000 26 3526
1646 14 Helsinki Finland 15 151 152 52 1512 26 1521 40000 2524 40000 27 3527
1647 14 Helsinki Finland 15 151 152 52 1512 26 1521 40000 2525 40000 26 3526
1648 14 Helsinki Finland 15 151 152 52 1512 26 1521 40000 2525 40000 27 3527
1649 14 Helsinki Finland 15 151 152 52 1512 27 1522 40000 2524 40000 26 3526
1650 14 Helsinki Finland 15 151 152 52 1512 27 1522 40000 2524 40000 27 3527
1651 14 Helsinki Finland 15 151 152 52 1512 27 1522 40000 2525 40000 26 3526
1652 14 Helsinki Finland 15 151 152 52 1512 27 1522 40000 2525 40000 27 3527
1653 14 Helsinki Finland 15 151 152 53 1513 26 1521 40000 2524 40000 26 3526
1654 14 Helsinki Finland 15 151 152 53 1513 26 1521 40000 2524 40000 27 3527
1655 14 Helsinki Finland 15 151 152 53 1513 26 1521 40000 2525 40000 26 3526
1656 14 Helsinki Finland 15 151 152 53 1513 26 1521 40000 2525 40000 27 3527
1657 14 Helsinki Finland 15 151 152 53 1513 27 1522 40000 2524 40000 26 3526
1658 14 Helsinki Finland 15 151 152 53 1513 27 1522 40000 2524 40000 27 3527
1659 14 Helsinki Finland 15 151 152 53 1513 27 1522 40000 2525 40000 26 3526
1660 14 Helsinki Finland 15 151 152 53 1513 27 1522 40000 2525 40000 27 3527
1661 15 Lisbon Portugal 16 161 162 54 1610 28 1621 40000 2624 40000 28 3626
1662 15 Lisbon Portugal 16 161 162 54 1610 28 1621 40000 2624 40000 29 3627
1663 15 Lisbon Portugal 16 161 162 54 1610 28 1621 40000 2625 40000 28 3626
1664 15 Lisbon Portugal 16 161 162 54 1610 28 1621 40000 2625 40000 29 3627
1665 15 Lisbon Portugal 16 161 162 54 1610 29 1622 40000 2624 40000 28 3626
1666 15 Lisbon Portugal 16 161 162 54 1610 29 1622 40000 2624 40000 29 3627
1667 15 Lisbon Portugal 16 161 162 54 1610 29 1622 40000 2625 40000 28 3626
1668 15 Lisbon Portugal 16 161 162 54 1610 29 1622 40000 2625 40000 29 3627
1669 15 Lisbon Portugal 16 161 162 55 1611 28 1621 40000 2624 40000 28 3626
1670 15 Lisbon Portugal 16 161 162 55 1611 28 1621 40000 2624 40000 29 3627
1671 15 Lisbon Portugal 16 161 162 55 1611 28 1621 40000 2625 40000 28 3626
1672 15 Lisbon Portugal 16 161 162 55 1611 28 1621 40000 2625 40000 29 3627
1673 15 Lisbon Portugal 16 161 162 55 1611 29 1622 40000 2624 40000 28 3626
1674 15 Lisbon Portugal 16 161 162 55 1611 29 1622 40000 2624 40000 29 3627
1675 15 Lisbon Portugal 16 161 162 55 1611 29 1622 40000 2625 40000 28 3626
1676 15 Lisbon Portugal 16 161 162 55 1611 29 1622 40000 2625 40000 29 3627
1677 15 Lisbon Portugal 16 161 162 56 1612 28 1621 40000 2624 40000 28 3626
1678 15 Lisbon Portugal 16 161 162 56 1612 28 1621 40000 2624 40000 29 3627
1679 15 Lisbon Portugal 16 161 162 56 1612 28 1621 40000 2625 40000 28 3626
1680 15 Lisbon Portugal 16 161 162 56 1612 28 1621 40000 2625 40000 29 3627
1681 15 Lisbon Portugal 16 161 162 56 1612 29 1622 40000 2624 40000 28 3626
1682 15 Lisbon Portugal 16 161 162 56 1612 29 1622 40000 2624 40000 29 3627
1683 15 Lisbon Portugal 16 161 162 56 1612 29 1622 40000 2625 40000 28 3626
1684 15 Lisbon Portugal 16 161 162 56 1612 29 1622 40000 2625 40000 29 3627
1685 15 Lisbon Portugal 16 161 162 57 1613 28 1621 40000 2624 40000 28 3626
1686 15 Lisbon Portugal 16 161 162 57 1613 28 1621 40000 2624 40000 29 3627
1687 15 Lisbon Portugal 16 161 162 57 1613 28 1621 40000 2625 40000 28 3626
1688 15 Lisbon Portugal 16 161 162 57 1613 28 1621 40000 2625 40000 29 3627
1689 15 Lisbon Portugal 16 161 162 57 1613 29 1622 40000 2624 40000 28 3626
1690 15 Lisbon Portugal 16 161 162 57 1613 29 1622 40000 2624 40000 29 3627
1691 15 Lisbon Portugal 16 161 162 57 1613 29 1622 40000 2625 40000 28 3626
1692 15 Lisbon Portugal 16 161 162 57 1613 29 1622 40000 2625 40000 29 3627
1693 16 Norrwaste Sweden 17 171 172 58 1710 30 1721 40000 2724 40000 30 3726
1694 16 Norrwaste Sweden 17 171 172 58 1710 30 1721 40000 2724 40000 31 3727
1695 16 Norrwaste Sweden 17 171 172 58 1710 30 1721 40000 2725 40000 30 3726
1696 16 Norrwaste Sweden 17 171 172 58 1710 30 1721 40000 2725 40000 31 3727
1697 16 Norrwaste Sweden 17 171 172 58 1710 31 1722 40000 2724 40000 30 3726
1698 16 Norrwaste Sweden 17 171 172 58 1710 31 1722 40000 2724 40000 31 3727
1699 16 Norrwaste Sweden 17 171 172 58 1710 31 1722 40000 2725 40000 30 3726
1700 16 Norrwaste Sweden 17 171 172 58 1710 31 1722 40000 2725 40000 31 3727
1701 16 Norrwaste Sweden 17 171 172 59 1711 30 1721 40000 2724 40000 30 3726
1702 16 Norrwaste Sweden 17 171 172 59 1711 30 1721 40000 2724 40000 31 3727
1703 16 Norrwaste Sweden 17 171 172 59 1711 30 1721 40000 2725 40000 30 3726
1704 16 Norrwaste Sweden 17 171 172 59 1711 30 1721 40000 2725 40000 31 3727
1705 16 Norrwaste Sweden 17 171 172 59 1711 31 1722 40000 2724 40000 30 3726
1706 16 Norrwaste Sweden 17 171 172 59 1711 31 1722 40000 2724 40000 31 3727
1707 16 Norrwaste Sweden 17 171 172 59 1711 31 1722 40000 2725 40000 30 3726
1708 16 Norrwaste Sweden 17 171 172 59 1711 31 1722 40000 2725 40000 31 3727
1709 16 Norrwaste Sweden 17 171 172 60 1712 30 1721 40000 2724 40000 30 3726
1710 16 Norrwaste Sweden 17 171 172 60 1712 30 1721 40000 2724 40000 31 3727
1711 16 Norrwaste Sweden 17 171 172 60 1712 30 1721 40000 2725 40000 30 3726
1712 16 Norrwaste Sweden 17 171 172 60 1712 30 1721 40000 2725 40000 31 3727
1713 16 Norrwaste Sweden 17 171 172 60 1712 31 1722 40000 2724 40000 30 3726
1714 16 Norrwaste Sweden 17 171 172 60 1712 31 1722 40000 2724 40000 31 3727
1715 16 Norrwaste Sweden 17 171 172 60 1712 31 1722 40000 2725 40000 30 3726
1716 16 Norrwaste Sweden 17 171 172 60 1712 31 1722 40000 2725 40000 31 3727
1717 16 Norrwaste Sweden 17 171 172 61 1713 30 1721 40000 2724 40000 30 3726
1718 16 Norrwaste Sweden 17 171 172 61 1713 30 1721 40000 2724 40000 31 3727
1719 16 Norrwaste Sweden 17 171 172 61 1713 30 1721 40000 2725 40000 30 3726
1720 16 Norrwaste Sweden 17 171 172 61 1713 30 1721 40000 2725 40000 31 3727
1721 16 Norrwaste Sweden 17 171 172 61 1713 31 1722 40000 2724 40000 30 3726
1722 16 Norrwaste Sweden 17 171 172 61 1713 31 1722 40000 2724 40000 31 3727
1723 16 Norrwaste Sweden 17 171 172 61 1713 31 1722 40000 2725 40000 30 3726
1724 16 Norrwaste Sweden 17 171 172 61 1713 31 1722 40000 2725 40000 31 3727
1725 17 ROW Earth 18 181 182 62 1810 32 1821 40000 2824 40000 32 3826
1726 17 ROW Earth 18 181 182 62 1810 32 1821 40000 2824 40000 33 3827
1727 17 ROW Earth 18 181 182 62 1810 32 1821 40000 2825 40000 32 3826
1728 17 ROW Earth 18 181 182 62 1810 32 1821 40000 2825 40000 33 3827
1729 17 ROW Earth 18 181 182 62 1810 33 1822 40000 2824 40000 32 3826
1730 17 ROW Earth 18 181 182 62 1810 33 1822 40000 2824 40000 33 3827
1731 17 ROW Earth 18 181 182 62 1810 33 1822 40000 2825 40000 32 3826
1732 17 ROW Earth 18 181 182 62 1810 33 1822 40000 2825 40000 33 3827
1733 17 ROW Earth 18 181 182 63 1811 32 1821 40000 2824 40000 32 3826
1734 17 ROW Earth 18 181 182 63 1811 32 1821 40000 2824 40000 33 3827
1735 17 ROW Earth 18 181 182 63 1811 32 1821 40000 2825 40000 32 3826
1736 17 ROW Earth 18 181 182 63 1811 32 1821 40000 2825 40000 33 3827
1737 17 ROW Earth 18 181 182 63 1811 33 1822 40000 2824 40000 32 3826
1738 17 ROW Earth 18 181 182 63 1811 33 1822 40000 2824 40000 33 3827
1739 17 ROW Earth 18 181 182 63 1811 33 1822 40000 2825 40000 32 3826
1740 17 ROW Earth 18 181 182 63 1811 33 1822 40000 2825 40000 33 3827
1741 17 ROW Earth 18 181 182 64 1812 32 1821 40000 2824 40000 32 3826
1742 17 ROW Earth 18 181 182 64 1812 32 1821 40000 2824 40000 33 3827
1743 17 ROW Earth 18 181 182 64 1812 32 1821 40000 2825 40000 32 3826
1744 17 ROW Earth 18 181 182 64 1812 32 1821 40000 2825 40000 33 3827
1745 17 ROW Earth 18 181 182 64 1812 33 1822 40000 2824 40000 32 3826
1746 17 ROW Earth 18 181 182 64 1812 33 1822 40000 2824 40000 33 3827
1747 17 ROW Earth 18 181 182 64 1812 33 1822 40000 2825 40000 32 3826
1748 17 ROW Earth 18 181 182 64 1812 33 1822 40000 2825 40000 33 3827
1749 17 ROW Earth 18 181 182 65 1813 32 1821 40000 2824 40000 32 3826
1750 17 ROW Earth 18 181 182 65 1813 32 1821 40000 2824 40000 33 3827
1751 17 ROW Earth 18 181 182 65 1813 32 1821 40000 2825 40000 32 3826
1752 17 ROW Earth 18 181 182 65 1813 32 1821 40000 2825 40000 33 3827
1753 17 ROW Earth 18 181 182 65 1813 33 1822 40000 2824 40000 32 3826
1754 17 ROW Earth 18 181 182 65 1813 33 1822 40000 2824 40000 33 3827
1755 17 ROW Earth 18 181 182 65 1813 33 1822 40000 2825 40000 32 3826
1756 17 ROW Earth 18 181 182 65 1813 33 1822 40000 2825 40000 33 3827
1757 Show auto-inc values
1758 select count(1), max(entry_key) from test.idx_tbl;
1759 count(1) max(entry_key)
1760 16 17
1761 show create table idx_tbl;
1762 Table Create Table
1763 idx_tbl CREATE TABLE `idx_tbl` (
1764 `entry_key` bigint unsigned NOT NULL AUTO_INCREMENT,
1765 `k1` varchar(100) NOT NULL,
1766 `k2` varchar(100) NOT NULL,
1767 `data` int DEFAULT NULL,
1768 PRIMARY KEY (`k1`,`k2`),
1769 UNIQUE KEY `entry_key` (`entry_key`)
1770 ) ENGINE=ndbcluster AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1771 select count(1), max(mv_idx) from test.type2_1;
1772 count(1) max(mv_idx)
1773 64 65
1774 show create table type2_1;
1775 Table Create Table
1776 type2_1 CREATE TABLE `type2_1` (
1777 `entry_key` bigint unsigned NOT NULL,
1778 `mv_idx` bigint unsigned NOT NULL AUTO_INCREMENT,
1779 `data` int DEFAULT NULL,
1780 PRIMARY KEY (`entry_key`,`mv_idx`)
1781 ) ENGINE=ndbcluster AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1782 select count(1), max(mv_idx) from test.type2_2;
1783 count(1) max(mv_idx)
1784 32 33
1785 show create table type2_2;
1786 Table Create Table
1787 type2_2 CREATE TABLE `type2_2` (
1788 `entry_key` bigint unsigned NOT NULL,
1789 `mv_idx` bigint unsigned NOT NULL AUTO_INCREMENT,
1790 `data` text,
1791 PRIMARY KEY (`entry_key`,`mv_idx`)
1792 ) ENGINE=ndbcluster AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1793 select count(1), max(mv_idx) from test.type2_3;
1794 count(1) max(mv_idx)
1795 32 33
1796 show create table type2_3;
1797 Table Create Table
1798 type2_3 CREATE TABLE `type2_3` (
1799 `entry_key` bigint unsigned NOT NULL,
1800 `mv_idx` bigint unsigned NOT NULL AUTO_INCREMENT,
1801 `data` text,
1802 PRIMARY KEY (`entry_key`,`mv_idx`)
1803 ) ENGINE=ndbcluster AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1804 select count(1), max(mv_idx) from test.type2_4;
1805 count(1) max(mv_idx)
1806 32 33
1807 show create table type2_4;
1808 Table Create Table
1809 type2_4 CREATE TABLE `type2_4` (
1810 `entry_key` bigint unsigned NOT NULL,
1811 `mv_idx` bigint unsigned NOT NULL AUTO_INCREMENT,
1812 `data` int DEFAULT NULL,
1813 PRIMARY KEY (`entry_key`,`mv_idx`)
1814 ) ENGINE=ndbcluster AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1815 No mv_idx duplicates in type_2 tables
1816 select mv_idx, count(1) as ct
1817 from type2_1 group by mv_idx
1818 having ct > 1;
1819 mv_idx ct
1820 select mv_idx, count(1) as ct
1821 from type2_2 group by mv_idx
1822 having ct > 1;
1823 mv_idx ct
1824 select mv_idx, count(1) as ct
1825 from type2_3 group by mv_idx
1826 having ct > 1;
1827 mv_idx ct
1828 select mv_idx, count(1) as ct
1829 from type2_4 group by mv_idx
1830 having ct > 1;
1831 mv_idx ct
1832 select * from idx_tbl order by entry_key;
1833 entry_key k1 k2 data
1834 1 Edinburgh UK 1
1835 2 Bristol UK 2
1836 3 Glasgow UK 3
1837 4 London UK 4
1838 5 Paris France 5
1839 6 Heidelberg Germany 6
1840 7 Riga Latvia 7
1841 8 Orlando USA 8
1842 10 Stockholm Sweden 11
1843 11 Trondheim Norway 12
1844 12 Portland USA 13
1845 13 Bangalore India 14
1846 14 Helsinki Finland 15
1847 15 Lisbon Portugal 16
1848 16 Norrwaste Sweden 17
1849 17 ROW Earth 18
1850 select * from type1_1 order by entry_key;
1851 entry_key data
1852 1 11
1853 2 21
1854 3 31
1855 4 41
1856 5 51
1857 6 61
1858 7 71
1859 8 81
1860 10 111
1861 11 121
1862 12 131
1863 13 141
1864 14 151
1865 15 161
1866 16 171
1867 17 181
1868 select * from type1_2 order by entry_key;
1869 entry_key data
1870 1 12
1871 2 22
1872 3 32
1873 4 42
1874 5 52
1875 6 62
1876 7 72
1877 8 82
1878 10 112
1879 11 122
1880 12 132
1881 13 142
1882 14 152
1883 15 162
1884 16 172
1885 17 182
1886 select * from type2_1 order by entry_key, mv_idx;
1887 entry_key mv_idx data
1888 1 1 110
1889 1 2 111
1890 1 3 112
1891 1 4 113
1892 2 5 210
1893 2 6 211
1894 2 7 212
1895 2 8 213
1896 3 9 310
1897 3 10 311
1898 3 11 312
1899 3 12 313
1900 4 13 410
1901 4 14 411
1902 4 15 412
1903 4 16 413
1904 5 17 510
1905 5 18 511
1906 5 19 512
1907 5 20 513
1908 6 21 610
1909 6 22 611
1910 6 23 612
1911 6 24 613
1912 7 25 710
1913 7 26 711
1914 7 27 712
1915 7 28 713
1916 8 29 810
1917 8 30 811
1918 8 31 812
1919 8 32 813
1920 10 34 1110
1921 10 35 1111
1922 10 36 1112
1923 10 37 1113
1924 11 38 1210
1925 11 39 1211
1926 11 40 1212
1927 11 41 1213
1928 12 42 1310
1929 12 43 1311
1930 12 44 1312
1931 12 45 1313
1932 13 46 1410
1933 13 47 1411
1934 13 48 1412
1935 13 49 1413
1936 14 50 1510
1937 14 51 1511
1938 14 52 1512
1939 14 53 1513
1940 15 54 1610
1941 15 55 1611
1942 15 56 1612
1943 15 57 1613
1944 16 58 1710
1945 16 59 1711
1946 16 60 1712
1947 16 61 1713
1948 17 62 1810
1949 17 63 1811
1950 17 64 1812
1951 17 65 1813
1952 select entry_key, mv_idx, right(data, 4) from type2_2 order by entry_key, mv_idx;
1953 entry_key mv_idx right(data, 4)
1954 1 1 0121
1955 1 2 0122
1956 2 3 0221
1957 2 4 0222
1958 3 5 0321
1959 3 6 0322
1960 4 7 0421
1961 4 8 0422
1962 5 9 0521
1963 5 10 0522
1964 6 11 0621
1965 6 12 0622
1966 7 13 0721
1967 7 14 0722
1968 8 15 0821
1969 8 16 0822
1970 10 18 1121
1971 10 19 1122
1972 11 20 1221
1973 11 21 1222
1974 12 22 1321
1975 12 23 1322
1976 13 24 1421
1977 13 25 1422
1978 14 26 1521
1979 14 27 1522
1980 15 28 1621
1981 15 29 1622
1982 16 30 1721
1983 16 31 1722
1984 17 32 1821
1985 17 33 1822
1986 select entry_key, mv_idx, right(data, 4) from type2_3 order by entry_key, mv_idx;
1987 entry_key mv_idx right(data, 4)
1988 1 1 0124
1989 1 2 0125
1990 2 3 0224
1991 2 4 0225
1992 3 5 0324
1993 3 6 0325
1994 4 7 0424
1995 4 8 0425
1996 5 9 0524
1997 5 10 0525
1998 6 11 0624
1999 6 12 0625
2000 7 13 0724
2001 7 14 0725
2002 8 15 0824
2003 8 16 0825
2004 10 18 2124
2005 10 19 2125
2006 11 20 2224
2007 11 21 2225
2008 12 22 2324
2009 12 23 2325
2010 13 24 2424
2011 13 25 2425
2012 14 26 2524
2013 14 27 2525
2014 15 28 2624
2015 15 29 2625
2016 16 30 2724
2017 16 31 2725
2018 17 32 2824
2019 17 33 2825
2020 select * from type2_4 order by entry_key, mv_idx;
2021 entry_key mv_idx data
2022 1 1 126
2023 1 2 127
2024 2 3 226
2025 2 4 227
2026 3 5 326
2027 3 6 327
2028 4 7 426
2029 4 8 427
2030 5 9 526
2031 5 10 527
2032 6 11 626
2033 6 12 627
2034 7 13 726
2035 7 14 727
2036 8 15 826
2037 8 16 827
2038 10 18 3126
2039 10 19 3127
2040 11 20 3226
2041 11 21 3227
2042 12 22 3326
2043 12 23 3327
2044 13 24 3426
2045 13 25 3427
2046 14 26 3526
2047 14 27 3527
2048 15 28 3626
2049 15 29 3627
2050 16 30 3726
2051 16 31 3727
2052 17 32 3826
2053 17 33 3827
2054 Verify the insert of further entity succeeds
2055 insert into idx_tbl (k1,k2,data) values ('Sancerre', 'France', 9);
2056 select last_insert_id() into @ek;
2057 insert into type1_1 values (@ek, 91);
2058 insert into type1_2 values (@ek, 92);
2059 insert into type2_1 (entry_key, data) values (@ek, 910);
2060 insert into type2_1 (entry_key, data) values (@ek, 911);
2061 insert into type2_1 (entry_key, data) values (@ek, 912);
2062 insert into type2_1 (entry_key, data) values (@ek, 913);
2063 insert into type2_2 (entry_key, data) values (@ek, repeat("0921", 10000));
2064 insert into type2_2 (entry_key, data) values (@ek, repeat("0922", 10000));
2065 insert into type2_3 (entry_key, data) values (@ek, repeat("0923", 10000));
2066 insert into type2_3 (entry_key, data) values (@ek, repeat("0924", 10000));
2067 insert into type2_4 (entry_key, data) values (@ek, 925);
2068 insert into type2_4 (entry_key, data) values (@ek, 926);
2069 Modified content
2070 ----------------
2071 show create table type2_3;
2072 Table Create Table
2073 type2_3 CREATE TABLE `type2_3` (
2074 `entry_key` bigint unsigned NOT NULL,
2075 `mv_idx` bigint unsigned NOT NULL AUTO_INCREMENT,
2076 `data` text,
2077 PRIMARY KEY (`entry_key`,`mv_idx`)
2078 ) ENGINE=ndbcluster AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
2079 No mv_idx duplicates in type_2 tables
2080 select mv_idx, count(1) as ct
2081 from type2_1 group by mv_idx
2082 having ct > 1;
2083 mv_idx ct
2084 select mv_idx, count(1) as ct
2085 from type2_2 group by mv_idx
2086 having ct > 1;
2087 mv_idx ct
2088 select mv_idx, count(1) as ct
2089 from type2_3 group by mv_idx
2090 having ct > 1;
2091 mv_idx ct
2092 select * from idx_tbl order by entry_key;
2093 entry_key k1 k2 data
2094 1 Edinburgh UK 1
2095 2 Bristol UK 2
2096 3 Glasgow UK 3
2097 4 London UK 4
2098 5 Paris France 5
2099 6 Heidelberg Germany 6
2100 7 Riga Latvia 7
2101 8 Orlando USA 8
2102 10 Stockholm Sweden 11
2103 11 Trondheim Norway 12
2104 12 Portland USA 13
2105 13 Bangalore India 14
2106 14 Helsinki Finland 15
2107 15 Lisbon Portugal 16
2108 16 Norrwaste Sweden 17
2109 17 ROW Earth 18
2110 18 Sancerre France 9
2111 select * from type1_1 order by entry_key;
2112 entry_key data
2113 1 11
2114 2 21
2115 3 31
2116 4 41
2117 5 51
2118 6 61
2119 7 71
2120 8 81
2121 10 111
2122 11 121
2123 12 131
2124 13 141
2125 14 151
2126 15 161
2127 16 171
2128 17 181
2129 18 91
2130 select * from type1_2 order by entry_key;
2131 entry_key data
2132 1 12
2133 2 22
2134 3 32
2135 4 42
2136 5 52
2137 6 62
2138 7 72
2139 8 82
2140 10 112
2141 11 122
2142 12 132
2143 13 142
2144 14 152
2145 15 162
2146 16 172
2147 17 182
2148 18 92
2149 select * from type2_1 order by entry_key, mv_idx;
2150 entry_key mv_idx data
2151 1 1 110
2152 1 2 111
2153 1 3 112
2154 1 4 113
2155 2 5 210
2156 2 6 211
2157 2 7 212
2158 2 8 213
2159 3 9 310
2160 3 10 311
2161 3 11 312
2162 3 12 313
2163 4 13 410
2164 4 14 411
2165 4 15 412
2166 4 16 413
2167 5 17 510
2168 5 18 511
2169 5 19 512
2170 5 20 513
2171 6 21 610
2172 6 22 611
2173 6 23 612
2174 6 24 613
2175 7 25 710
2176 7 26 711
2177 7 27 712
2178 7 28 713
2179 8 29 810
2180 8 30 811
2181 8 31 812
2182 8 32 813
2183 10 34 1110
2184 10 35 1111
2185 10 36 1112
2186 10 37 1113
2187 11 38 1210
2188 11 39 1211
2189 11 40 1212
2190 11 41 1213
2191 12 42 1310
2192 12 43 1311
2193 12 44 1312
2194 12 45 1313
2195 13 46 1410
2196 13 47 1411
2197 13 48 1412
2198 13 49 1413
2199 14 50 1510
2200 14 51 1511
2201 14 52 1512
2202 14 53 1513
2203 15 54 1610
2204 15 55 1611
2205 15 56 1612
2206 15 57 1613
2207 16 58 1710
2208 16 59 1711
2209 16 60 1712
2210 16 61 1713
2211 17 62 1810
2212 17 63 1811
2213 17 64 1812
2214 17 65 1813
2215 18 66 910
2216 18 67 911
2217 18 68 912
2218 18 69 913
2219 select entry_key, mv_idx, right(data, 4) from type2_2 order by entry_key, mv_idx;
2220 entry_key mv_idx right(data, 4)
2221 1 1 0121
2222 1 2 0122
2223 2 3 0221
2224 2 4 0222
2225 3 5 0321
2226 3 6 0322
2227 4 7 0421
2228 4 8 0422
2229 5 9 0521
2230 5 10 0522
2231 6 11 0621
2232 6 12 0622
2233 7 13 0721
2234 7 14 0722
2235 8 15 0821
2236 8 16 0822
2237 10 18 1121
2238 10 19 1122
2239 11 20 1221
2240 11 21 1222
2241 12 22 1321
2242 12 23 1322
2243 13 24 1421
2244 13 25 1422
2245 14 26 1521
2246 14 27 1522
2247 15 28 1621
2248 15 29 1622
2249 16 30 1721
2250 16 31 1722
2251 17 32 1821
2252 17 33 1822
2253 18 34 0921
2254 18 35 0922
2255 select entry_key, mv_idx, right(data, 4) from type2_3 order by entry_key, mv_idx;
2256 entry_key mv_idx right(data, 4)
2257 1 1 0124
2258 1 2 0125
2259 2 3 0224
2260 2 4 0225
2261 3 5 0324
2262 3 6 0325
2263 4 7 0424
2264 4 8 0425
2265 5 9 0524
2266 5 10 0525
2267 6 11 0624
2268 6 12 0625
2269 7 13 0724
2270 7 14 0725
2271 8 15 0824
2272 8 16 0825
2273 10 18 2124
2274 10 19 2125
2275 11 20 2224
2276 11 21 2225
2277 12 22 2324
2278 12 23 2325
2279 13 24 2424
2280 13 25 2425
2281 14 26 2524
2282 14 27 2525
2283 15 28 2624
2284 15 29 2625
2285 16 30 2724
2286 16 31 2725
2287 17 32 2824
2288 17 33 2825
2289 18 34 0923
2290 18 35 0924
2291 drop table idx_tbl, type1_1, type1_2, type2_1, type2_2, type2_3, type2_4;