Debian Codegraph @

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

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