Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1,t2;
2 CREATE LOGFILE GROUP lg1
3 ADD UNDOFILE 'undofile.dat'
4 INITIAL_SIZE 16M
5 UNDO_BUFFER_SIZE = 1M ENGINE=NDB;
6 CREATE TABLESPACE ts1
7 ADD DATAFILE 'datafile.dat'
8 USE LOGFILE GROUP lg1
9 INITIAL_SIZE 64M
10 ENGINE NDB;
11 CREATE TABLE t1 (a int unsigned not null,
12 b int unsigned not null,
13 c int unsigned not null,
14 primary key(a,c),
15 unique (b))
16 ENGINE = NDB
17 COMMENT="NDB_TABLE=PARTITION_BALANCE=FOR_RP_BY_LDM"
18 partition by key(a);
19 -- t1 --
20 Version: Any
21 Fragment type: HashMapPartition
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: 2
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: 2
35 FragmentCount: 2
36 PartitionBalance: FOR_RP_BY_LDM
37 ExtraRowGciBits: 0
38 ExtraRowAuthorBits: 0
39 TableStatus: Retrieved
40 Table options: readbackup
41 HashMap: DEFAULT-HASHMAP-3840-2
42 -- Attributes --
43 a Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
44 b Unsigned NOT NULL AT=FIXED ST=MEMORY
45 c Unsigned PRIMARY KEY AT=FIXED ST=MEMORY
46 -- Indexes --
47 PRIMARY KEY(a, c) - UniqueHashIndex
48 PRIMARY(a, c) - OrderedIndex
49 b(b) - OrderedIndex
50 b$unique(b) - UniqueHashIndex
51 -- t1/PRIMARY --
52 Version: Any
53 Base table: t1
54 Number of attributes: 2
55 Logging: 0
56 Index type: OrderedIndex
57 Index status: Retrieved
58 -- Attributes --
59 a Unsigned NOT NULL AT=FIXED ST=MEMORY
60 c Unsigned NOT NULL AT=FIXED ST=MEMORY
61 -- IndexTable XX/PRIMARY --
62 Version: Any
63 Fragment type: FragUndefined
64 K Value: 6
65 Min load factor: 78
66 Max load factor: 80
67 Temporary table: yes
68 Number of attributes: 3
69 Number of primary keys: 1
70 Length of frm data: XXX
71 Max Rows: 0
72 Row Checksum: 1
73 Row GCI: 1
74 SingleUserMode: 2
75 ForceVarPart: 0
76 PartitionCount: 2
77 FragmentCount: 2
78 PartitionBalance: FOR_RP_BY_LDM
79 ExtraRowGciBits: 0
80 ExtraRowAuthorBits: 0
81 TableStatus: Retrieved
82 Table options:
83 -- Attributes --
84 a Unsigned NOT NULL DISTRIBUTION KEY AT=FIXED ST=MEMORY
85 c Unsigned NOT NULL AT=FIXED ST=MEMORY
86 NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
87 -- Indexes --
88 PRIMARY KEY(NDB$TNODE) - UniqueHashIndex
89
90 -- t1/b --
91 Version: Any
92 Base table: t1
93 Number of attributes: 1
94 Logging: 0
95 Index type: OrderedIndex
96 Index status: Retrieved
97 -- Attributes --
98 b Unsigned NOT NULL AT=FIXED ST=MEMORY
99 -- IndexTable XX/b --
100 Version: Any
101 Fragment type: FragUndefined
102 K Value: 6
103 Min load factor: 78
104 Max load factor: 80
105 Temporary table: yes
106 Number of attributes: 2
107 Number of primary keys: 1
108 Length of frm data: XXX
109 Max Rows: 0
110 Row Checksum: 1
111 Row GCI: 1
112 SingleUserMode: 2
113 ForceVarPart: 0
114 PartitionCount: 2
115 FragmentCount: 2
116 PartitionBalance: FOR_RP_BY_LDM
117 ExtraRowGciBits: 0
118 ExtraRowAuthorBits: 0
119 TableStatus: Retrieved
120 Table options:
121 -- Attributes --
122 b Unsigned NOT NULL AT=FIXED ST=MEMORY
123 NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
124 -- Indexes --
125 PRIMARY KEY(NDB$TNODE) - UniqueHashIndex
126
127 -- t1/b$unique --
128 Version: Any
129 Base table: t1
130 Number of attributes: 1
131 Logging: 1
132 Index type: UniqueHashIndex
133 Index status: Retrieved
134 -- Attributes --
135 b Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
136 -- IndexTable XX/b$unique --
137 Version: Any
138 Fragment type: HashMapPartition
139 K Value: 6
140 Min load factor: 78
141 Max load factor: 80
142 Temporary table: no
143 Number of attributes: 2
144 Number of primary keys: 1
145 Length of frm data: XXX
146 Max Rows: 0
147 Row Checksum: 1
148 Row GCI: 1
149 SingleUserMode: 2
150 ForceVarPart: 0
151 PartitionCount: 2
152 FragmentCount: 2
153 PartitionBalance: FOR_RP_BY_LDM
154 ExtraRowGciBits: 0
155 ExtraRowAuthorBits: 0
156 TableStatus: Retrieved
157 Table options: readbackup
158 HashMap: DEFAULT-HASHMAP-3840-2
159 -- Attributes --
160 b Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
161 NDB$PK Unsigned [3] NOT NULL AT=FIXED ST=MEMORY
162 -- Indexes --
163 PRIMARY KEY(b) - UniqueHashIndex
164
165 CREATE TABLE t2 (a int unsigned not null,
166 b int unsigned not null,
167 c int unsigned not null,
168 primary key(a,b),
169 unique (b))
170 ENGINE = NDB
171 COMMENT="NDB_TABLE=PARTITION_BALANCE=FOR_RP_BY_LDM"
172 STORAGE DISK
173 TABLESPACE ts1
174 partition by key(a);
175 -- t2 --
176 Version: Any
177 Fragment type: HashMapPartition
178 K Value: 6
179 Min load factor: 78
180 Max load factor: 80
181 Temporary table: no
182 Number of attributes: 3
183 Number of primary keys: 2
184 Length of frm data: XXX
185 Max Rows: 0
186 Row Checksum: 1
187 Row GCI: 1
188 SingleUserMode: 0
189 ForceVarPart: 1
190 PartitionCount: 2
191 FragmentCount: 2
192 PartitionBalance: FOR_RP_BY_LDM
193 ExtraRowGciBits: 0
194 ExtraRowAuthorBits: 0
195 TableStatus: Retrieved
196 Table options: readbackup
197 HashMap: DEFAULT-HASHMAP-3840-2
198 Tablespace id: XX
199 Tablespace: ts1
200 -- Attributes --
201 a Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
202 b Unsigned PRIMARY KEY AT=FIXED ST=MEMORY
203 c Unsigned NOT NULL AT=FIXED ST=DISK
204 -- Indexes --
205 PRIMARY KEY(a, b) - UniqueHashIndex
206 PRIMARY(a, b) - OrderedIndex
207 b(b) - OrderedIndex
208 b$unique(b) - UniqueHashIndex
209 -- t2/PRIMARY --
210 Version: Any
211 Base table: t2
212 Number of attributes: 2
213 Logging: 0
214 Index type: OrderedIndex
215 Index status: Retrieved
216 -- Attributes --
217 a Unsigned NOT NULL AT=FIXED ST=MEMORY
218 b Unsigned NOT NULL AT=FIXED ST=MEMORY
219 -- IndexTable XX/PRIMARY --
220 Version: Any
221 Fragment type: FragUndefined
222 K Value: 6
223 Min load factor: 78
224 Max load factor: 80
225 Temporary table: yes
226 Number of attributes: 3
227 Number of primary keys: 1
228 Length of frm data: XXX
229 Max Rows: 0
230 Row Checksum: 1
231 Row GCI: 1
232 SingleUserMode: 2
233 ForceVarPart: 0
234 PartitionCount: 2
235 FragmentCount: 2
236 PartitionBalance: FOR_RP_BY_LDM
237 ExtraRowGciBits: 0
238 ExtraRowAuthorBits: 0
239 TableStatus: Retrieved
240 Table options:
241 -- Attributes --
242 a Unsigned NOT NULL DISTRIBUTION KEY AT=FIXED ST=MEMORY
243 b Unsigned NOT NULL AT=FIXED ST=MEMORY
244 NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
245 -- Indexes --
246 PRIMARY KEY(NDB$TNODE) - UniqueHashIndex
247
248 -- t2/b --
249 Version: Any
250 Base table: t2
251 Number of attributes: 1
252 Logging: 0
253 Index type: OrderedIndex
254 Index status: Retrieved
255 -- Attributes --
256 b Unsigned NOT NULL AT=FIXED ST=MEMORY
257 -- IndexTable XX/b --
258 Version: Any
259 Fragment type: FragUndefined
260 K Value: 6
261 Min load factor: 78
262 Max load factor: 80
263 Temporary table: yes
264 Number of attributes: 2
265 Number of primary keys: 1
266 Length of frm data: XXX
267 Max Rows: 0
268 Row Checksum: 1
269 Row GCI: 1
270 SingleUserMode: 2
271 ForceVarPart: 0
272 PartitionCount: 2
273 FragmentCount: 2
274 PartitionBalance: FOR_RP_BY_LDM
275 ExtraRowGciBits: 0
276 ExtraRowAuthorBits: 0
277 TableStatus: Retrieved
278 Table options:
279 -- Attributes --
280 b Unsigned NOT NULL AT=FIXED ST=MEMORY
281 NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
282 -- Indexes --
283 PRIMARY KEY(NDB$TNODE) - UniqueHashIndex
284
285 -- t2/b$unique --
286 Version: Any
287 Base table: t2
288 Number of attributes: 1
289 Logging: 1
290 Index type: UniqueHashIndex
291 Index status: Retrieved
292 -- Attributes --
293 b Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
294 -- IndexTable XX/b$unique --
295 Version: Any
296 Fragment type: HashMapPartition
297 K Value: 6
298 Min load factor: 78
299 Max load factor: 80
300 Temporary table: no
301 Number of attributes: 2
302 Number of primary keys: 1
303 Length of frm data: XXX
304 Max Rows: 0
305 Row Checksum: 1
306 Row GCI: 1
307 SingleUserMode: 2
308 ForceVarPart: 0
309 PartitionCount: 2
310 FragmentCount: 2
311 PartitionBalance: FOR_RP_BY_LDM
312 ExtraRowGciBits: 0
313 ExtraRowAuthorBits: 0
314 TableStatus: Retrieved
315 Table options: readbackup
316 HashMap: DEFAULT-HASHMAP-3840-2
317 -- Attributes --
318 b Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
319 NDB$PK Unsigned [3] NOT NULL AT=FIXED ST=MEMORY
320 -- Indexes --
321 PRIMARY KEY(b) - UniqueHashIndex
322
323 CREATE TABLE t3 (a int unsigned not null,
324 b int unsigned not null,
325 c int unsigned not null,
326 primary key(a,b),
327 unique (b))
328 MAX_ROWS=50000000
329 ENGINE = NDB;
330 -- t3 --
331 Version: Any
332 Fragment type: HashMapPartition
333 K Value: 6
334 Min load factor: 78
335 Max load factor: 80
336 Temporary table: no
337 Number of attributes: 3
338 Number of primary keys: 2
339 Length of frm data: XXX
340 Max Rows: 50000000
341 Row Checksum: 1
342 Row GCI: 1
343 SingleUserMode: 0
344 ForceVarPart: 1
345 PartitionCount: 4
346 FragmentCount: 4
347 PartitionBalance: SPECIFIC
348 ExtraRowGciBits: 0
349 ExtraRowAuthorBits: 0
350 TableStatus: Retrieved
351 Table options: readbackup
352 HashMap: DEFAULT-HASHMAP-3840-4
353 -- Attributes --
354 a Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
355 b Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
356 c Unsigned NOT NULL AT=FIXED ST=MEMORY
357 -- Indexes --
358 PRIMARY KEY(a, b) - UniqueHashIndex
359 PRIMARY(a, b) - OrderedIndex
360 b(b) - OrderedIndex
361 b$unique(b) - UniqueHashIndex
362 -- t3/PRIMARY --
363 Version: Any
364 Base table: t3
365 Number of attributes: 2
366 Logging: 0
367 Index type: OrderedIndex
368 Index status: Retrieved
369 -- Attributes --
370 a Unsigned NOT NULL AT=FIXED ST=MEMORY
371 b Unsigned NOT NULL AT=FIXED ST=MEMORY
372 -- IndexTable XX/PRIMARY --
373 Version: Any
374 Fragment type: FragUndefined
375 K Value: 6
376 Min load factor: 78
377 Max load factor: 80
378 Temporary table: yes
379 Number of attributes: 3
380 Number of primary keys: 1
381 Length of frm data: XXX
382 Max Rows: 0
383 Row Checksum: 1
384 Row GCI: 1
385 SingleUserMode: 2
386 ForceVarPart: 0
387 PartitionCount: 4
388 FragmentCount: 4
389 PartitionBalance: FOR_RP_BY_LDM
390 ExtraRowGciBits: 0
391 ExtraRowAuthorBits: 0
392 TableStatus: Retrieved
393 Table options:
394 -- Attributes --
395 a Unsigned NOT NULL DISTRIBUTION KEY AT=FIXED ST=MEMORY
396 b Unsigned NOT NULL DISTRIBUTION KEY AT=FIXED ST=MEMORY
397 NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
398 -- Indexes --
399 PRIMARY KEY(NDB$TNODE) - UniqueHashIndex
400
401 -- t3/b --
402 Version: Any
403 Base table: t3
404 Number of attributes: 1
405 Logging: 0
406 Index type: OrderedIndex
407 Index status: Retrieved
408 -- Attributes --
409 b Unsigned NOT NULL AT=FIXED ST=MEMORY
410 -- IndexTable XX/b --
411 Version: Any
412 Fragment type: FragUndefined
413 K Value: 6
414 Min load factor: 78
415 Max load factor: 80
416 Temporary table: yes
417 Number of attributes: 2
418 Number of primary keys: 1
419 Length of frm data: XXX
420 Max Rows: 0
421 Row Checksum: 1
422 Row GCI: 1
423 SingleUserMode: 2
424 ForceVarPart: 0
425 PartitionCount: 4
426 FragmentCount: 4
427 PartitionBalance: FOR_RP_BY_LDM
428 ExtraRowGciBits: 0
429 ExtraRowAuthorBits: 0
430 TableStatus: Retrieved
431 Table options:
432 -- Attributes --
433 b Unsigned NOT NULL AT=FIXED ST=MEMORY
434 NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
435 -- Indexes --
436 PRIMARY KEY(NDB$TNODE) - UniqueHashIndex
437
438 -- t3/b$unique --
439 Version: Any
440 Base table: t3
441 Number of attributes: 1
442 Logging: 1
443 Index type: UniqueHashIndex
444 Index status: Retrieved
445 -- Attributes --
446 b Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
447 -- IndexTable XX/b$unique --
448 Version: Any
449 Fragment type: HashMapPartition
450 K Value: 6
451 Min load factor: 78
452 Max load factor: 80
453 Temporary table: no
454 Number of attributes: 2
455 Number of primary keys: 1
456 Length of frm data: XXX
457 Max Rows: 0
458 Row Checksum: 1
459 Row GCI: 1
460 SingleUserMode: 2
461 ForceVarPart: 0
462 PartitionCount: 4
463 FragmentCount: 4
464 PartitionBalance: SPECIFIC
465 ExtraRowGciBits: 0
466 ExtraRowAuthorBits: 0
467 TableStatus: Retrieved
468 Table options: readbackup
469 HashMap: DEFAULT-HASHMAP-3840-4
470 -- Attributes --
471 b Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
472 NDB$PK Unsigned [3] NOT NULL AT=FIXED ST=MEMORY
473 -- Indexes --
474 PRIMARY KEY(b) - UniqueHashIndex
475
476 CREATE TABLE t4 (a int unsigned not null,
477 b int unsigned not null,
478 c int unsigned not null,
479 primary key(a,b),
480 unique (b))
481 ENGINE = NDB
482 COMMENT="NDB_TABLE=PARTITION_BALANCE=FOR_RP_BY_LDM";
483 CREATE TABLE t5 (a int unsigned not null,
484 b int unsigned not null,
485 c int unsigned null,
486 primary key(a,b),
487 unique (b),
488 unique (c))
489 ENGINE = NDB
490 partition by key(a) partitions 3;
491 Table: test.t1
492 PartitionCount: 2
493 FragmentCount: 2
494
495 b$unique(b) - UniqueHashIndex
496 FragmentCount: 2
497 Table: test.t2
498 PartitionCount: 2
499 FragmentCount: 2
500
501 b$unique(b) - UniqueHashIndex
502 FragmentCount: 2
503 Table: test.t3
504 PartitionCount: 4
505 FragmentCount: 4
506
507 b$unique(b) - UniqueHashIndex
508 FragmentCount: 4
509 Table: test.t4
510 PartitionCount: 2
511 FragmentCount: 2
512
513 b$unique(b) - UniqueHashIndex
514 FragmentCount: 2
515 Table: test.t5
516 PartitionCount: 3
517 FragmentCount: 3
518
519 b$unique(b) - UniqueHashIndex
520 FragmentCount: 3
521 c$unique(c) - UniqueHashIndex
522 FragmentCount: 3
523 INSERT INTO t1 VALUES
524 (1,1,1),(2,2,2),(3,3,3),(4,4,4),(5,5,5),
525 (6,6,6),(7,7,7),(8,8,8),(9,9,9),(10,10,10),
526 (11,11,11),(12,12,12),(13,13,13),(14,14,14),(15,15,15),
527 (16,16,16),(17,17,17),(18,18,18),(19,19,19),(20,20,20),
528 (21,21,21),(22,22,22),(23,23,23),(24,24,24),(25,25,25),
529 (26,26,26),(27,27,27),(28,28,28),(29,29,29),(30,30,30),
530 (31,31,31),(32,32,32),(33,33,33),(34,34,34),(35,35,35),
531 (36,36,36),(37,37,37),(38,38,38),(39,39,39),(40,40,40),
532 (41,41,41),(42,42,42),(43,43,43),(44,44,44),(45,45,45),
533 (46,46,46),(47,47,47),(48,48,48),(49,49,49),(50,50,50),
534 (51,51,51),(52,52,52),(53,53,53),(54,54,54),(55,55,55),
535 (56,56,56),(57,57,57),(58,58,58),(59,59,59),(60,60,60),
536 (61,61,61),(62,62,62),(63,63,63),(64,64,64),(65,65,65),
537 (66,66,66),(67,67,67),(68,68,68),(69,69,69),(70,70,70),
538 (71,71,71),(72,72,72),(73,73,73),(74,74,74),(75,75,75),
539 (76,76,76),(77,77,77),(78,78,78),(79,79,79),(80,80,80),
540 (81,81,81),(82,82,82),(83,83,83),(84,84,84),(85,85,85),
541 (86,86,86),(87,87,87),(88,88,88),(89,89,89),(90,90,90),
542 (91,91,91),(92,92,92),(93,93,93),(94,94,94),(95,95,95),
543 (96,96,96),(97,97,97),(98,98,98),(99,99,99),(100,100,100);
544 insert into t2 select * from t1;
545 insert into t3 select * from t1;
546 insert into t4 select * from t1;
547 insert into t5 (a,b,c) select a,b,if(a%2,b,NULL) as c from t1;
548 select count(*) from t1;
549 count(*)
550 100
551 select count(*) from t2;
552 count(*)
553 100
554 select count(*) from t3;
555 count(*)
556 100
557 select count(*) from t4;
558 count(*)
559 100
560 select count(*) from t5;
561 count(*)
562 100
563 select * from t1 where a < 20;
564 a b c
565 1 1 1
566 10 10 10
567 11 11 11
568 12 12 12
569 13 13 13
570 14 14 14
571 15 15 15
572 16 16 16
573 17 17 17
574 18 18 18
575 19 19 19
576 2 2 2
577 3 3 3
578 4 4 4
579 5 5 5
580 6 6 6
581 7 7 7
582 8 8 8
583 9 9 9
584 select * from t1 where a = 20;
585 a b c
586 20 20 20
587 select * from t1 where a = 30;
588 a b c
589 30 30 30
590 select * from t1 where a = 40;
591 a b c
592 40 40 40
593 select * from t1 where a = 50;
594 a b c
595 50 50 50
596 select * from t1 where b = 20;
597 a b c
598 20 20 20
599 select * from t1 where b = 30;
600 a b c
601 30 30 30
602 select * from t1 where b = 40;
603 a b c
604 40 40 40
605 select * from t1 where b = 50;
606 a b c
607 50 50 50
608 select * from t2 where a < 20;
609 a b c
610 1 1 1
611 10 10 10
612 11 11 11
613 12 12 12
614 13 13 13
615 14 14 14
616 15 15 15
617 16 16 16
618 17 17 17
619 18 18 18
620 19 19 19
621 2 2 2
622 3 3 3
623 4 4 4
624 5 5 5
625 6 6 6
626 7 7 7
627 8 8 8
628 9 9 9
629 select * from t2 where a = 20;
630 a b c
631 20 20 20
632 select * from t2 where a = 30;
633 a b c
634 30 30 30
635 select * from t2 where a = 40;
636 a b c
637 40 40 40
638 select * from t2 where a = 50;
639 a b c
640 50 50 50
641 select * from t2 where b = 20;
642 a b c
643 20 20 20
644 select * from t2 where b = 30;
645 a b c
646 30 30 30
647 select * from t2 where b = 40;
648 a b c
649 40 40 40
650 select * from t2 where b = 50;
651 a b c
652 50 50 50
653 select * from t3 where a < 20;
654 a b c
655 1 1 1
656 10 10 10
657 11 11 11
658 12 12 12
659 13 13 13
660 14 14 14
661 15 15 15
662 16 16 16
663 17 17 17
664 18 18 18
665 19 19 19
666 2 2 2
667 3 3 3
668 4 4 4
669 5 5 5
670 6 6 6
671 7 7 7
672 8 8 8
673 9 9 9
674 select * from t3 where a = 20;
675 a b c
676 20 20 20
677 select * from t3 where a = 30;
678 a b c
679 30 30 30
680 select * from t3 where a = 40;
681 a b c
682 40 40 40
683 select * from t3 where a = 50;
684 a b c
685 50 50 50
686 select * from t3 where b = 20;
687 a b c
688 20 20 20
689 select * from t3 where b = 30;
690 a b c
691 30 30 30
692 select * from t3 where b = 40;
693 a b c
694 40 40 40
695 select * from t3 where b = 50;
696 a b c
697 50 50 50
698 select * from t4 where a < 20;
699 a b c
700 1 1 1
701 10 10 10
702 11 11 11
703 12 12 12
704 13 13 13
705 14 14 14
706 15 15 15
707 16 16 16
708 17 17 17
709 18 18 18
710 19 19 19
711 2 2 2
712 3 3 3
713 4 4 4
714 5 5 5
715 6 6 6
716 7 7 7
717 8 8 8
718 9 9 9
719 select * from t4 where a = 20;
720 a b c
721 20 20 20
722 select * from t4 where a = 30;
723 a b c
724 30 30 30
725 select * from t4 where a = 40;
726 a b c
727 40 40 40
728 select * from t4 where a = 50;
729 a b c
730 50 50 50
731 select * from t4 where b = 20;
732 a b c
733 20 20 20
734 select * from t4 where b = 30;
735 a b c
736 30 30 30
737 select * from t4 where b = 40;
738 a b c
739 40 40 40
740 select * from t4 where b = 50;
741 a b c
742 50 50 50
743 alter table t1 algorithm=inplace, reorganize partition;
744 -- t1 --
745 Version: Any
746 Fragment type: HashMapPartition
747 K Value: 6
748 Min load factor: 78
749 Max load factor: 80
750 Temporary table: no
751 Number of attributes: 3
752 Number of primary keys: 2
753 Length of frm data: XXX
754 Max Rows: 0
755 Row Checksum: 1
756 Row GCI: 1
757 SingleUserMode: 0
758 ForceVarPart: 1
759 PartitionCount: 2
760 FragmentCount: 2
761 PartitionBalance: FOR_RP_BY_LDM
762 ExtraRowGciBits: 0
763 ExtraRowAuthorBits: 0
764 TableStatus: Retrieved
765 Table options: readbackup
766 HashMap: DEFAULT-HASHMAP-3840-2
767 -- Attributes --
768 a Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
769 b Unsigned NOT NULL AT=FIXED ST=MEMORY
770 c Unsigned PRIMARY KEY AT=FIXED ST=MEMORY
771 -- Indexes --
772 PRIMARY KEY(a, c) - UniqueHashIndex
773 PRIMARY(a, c) - OrderedIndex
774 b(b) - OrderedIndex
775 b$unique(b) - UniqueHashIndex
776 -- t1/PRIMARY --
777 Version: Any
778 Base table: t1
779 Number of attributes: 2
780 Logging: 0
781 Index type: OrderedIndex
782 Index status: Retrieved
783 -- Attributes --
784 a Unsigned NOT NULL AT=FIXED ST=MEMORY
785 c Unsigned NOT NULL AT=FIXED ST=MEMORY
786 -- IndexTable XX/PRIMARY --
787 Version: Any
788 Fragment type: FragUndefined
789 K Value: 6
790 Min load factor: 78
791 Max load factor: 80
792 Temporary table: yes
793 Number of attributes: 3
794 Number of primary keys: 1
795 Length of frm data: XXX
796 Max Rows: 0
797 Row Checksum: 1
798 Row GCI: 1
799 SingleUserMode: 2
800 ForceVarPart: 0
801 PartitionCount: 2
802 FragmentCount: 2
803 PartitionBalance: FOR_RP_BY_LDM
804 ExtraRowGciBits: 0
805 ExtraRowAuthorBits: 0
806 TableStatus: Retrieved
807 Table options:
808 -- Attributes --
809 a Unsigned NOT NULL DISTRIBUTION KEY AT=FIXED ST=MEMORY
810 c Unsigned NOT NULL AT=FIXED ST=MEMORY
811 NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
812 -- Indexes --
813 PRIMARY KEY(NDB$TNODE) - UniqueHashIndex
814
815 -- t1/b --
816 Version: Any
817 Base table: t1
818 Number of attributes: 1
819 Logging: 0
820 Index type: OrderedIndex
821 Index status: Retrieved
822 -- Attributes --
823 b Unsigned NOT NULL AT=FIXED ST=MEMORY
824 -- IndexTable XX/b --
825 Version: Any
826 Fragment type: FragUndefined
827 K Value: 6
828 Min load factor: 78
829 Max load factor: 80
830 Temporary table: yes
831 Number of attributes: 2
832 Number of primary keys: 1
833 Length of frm data: XXX
834 Max Rows: 0
835 Row Checksum: 1
836 Row GCI: 1
837 SingleUserMode: 2
838 ForceVarPart: 0
839 PartitionCount: 2
840 FragmentCount: 2
841 PartitionBalance: FOR_RP_BY_LDM
842 ExtraRowGciBits: 0
843 ExtraRowAuthorBits: 0
844 TableStatus: Retrieved
845 Table options:
846 -- Attributes --
847 b Unsigned NOT NULL AT=FIXED ST=MEMORY
848 NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
849 -- Indexes --
850 PRIMARY KEY(NDB$TNODE) - UniqueHashIndex
851
852 -- t1/b$unique --
853 Version: Any
854 Base table: t1
855 Number of attributes: 1
856 Logging: 1
857 Index type: UniqueHashIndex
858 Index status: Retrieved
859 -- Attributes --
860 b Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
861 -- IndexTable XX/b$unique --
862 Version: Any
863 Fragment type: HashMapPartition
864 K Value: 6
865 Min load factor: 78
866 Max load factor: 80
867 Temporary table: no
868 Number of attributes: 2
869 Number of primary keys: 1
870 Length of frm data: XXX
871 Max Rows: 0
872 Row Checksum: 1
873 Row GCI: 1
874 SingleUserMode: 2
875 ForceVarPart: 0
876 PartitionCount: 2
877 FragmentCount: 2
878 PartitionBalance: FOR_RP_BY_LDM
879 ExtraRowGciBits: 0
880 ExtraRowAuthorBits: 0
881 TableStatus: Retrieved
882 Table options: readbackup
883 HashMap: DEFAULT-HASHMAP-3840-2
884 -- Attributes --
885 b Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
886 NDB$PK Unsigned [3] NOT NULL AT=FIXED ST=MEMORY
887 -- Indexes --
888 PRIMARY KEY(b) - UniqueHashIndex
889
890 alter table t2 algorithm=inplace, reorganize partition;
891 -- t2 --
892 Version: Any
893 Fragment type: HashMapPartition
894 K Value: 6
895 Min load factor: 78
896 Max load factor: 80
897 Temporary table: no
898 Number of attributes: 3
899 Number of primary keys: 2
900 Length of frm data: XXX
901 Max Rows: 0
902 Row Checksum: 1
903 Row GCI: 1
904 SingleUserMode: 0
905 ForceVarPart: 1
906 PartitionCount: 2
907 FragmentCount: 2
908 PartitionBalance: FOR_RP_BY_LDM
909 ExtraRowGciBits: 0
910 ExtraRowAuthorBits: 0
911 TableStatus: Retrieved
912 Table options: readbackup
913 HashMap: DEFAULT-HASHMAP-3840-2
914 Tablespace id: XX
915 Tablespace: ts1
916 -- Attributes --
917 a Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
918 b Unsigned PRIMARY KEY AT=FIXED ST=MEMORY
919 c Unsigned NOT NULL AT=FIXED ST=DISK
920 -- Indexes --
921 PRIMARY KEY(a, b) - UniqueHashIndex
922 PRIMARY(a, b) - OrderedIndex
923 b(b) - OrderedIndex
924 b$unique(b) - UniqueHashIndex
925 -- t2/PRIMARY --
926 Version: Any
927 Base table: t2
928 Number of attributes: 2
929 Logging: 0
930 Index type: OrderedIndex
931 Index status: Retrieved
932 -- Attributes --
933 a Unsigned NOT NULL AT=FIXED ST=MEMORY
934 b Unsigned NOT NULL AT=FIXED ST=MEMORY
935 -- IndexTable XX/PRIMARY --
936 Version: Any
937 Fragment type: FragUndefined
938 K Value: 6
939 Min load factor: 78
940 Max load factor: 80
941 Temporary table: yes
942 Number of attributes: 3
943 Number of primary keys: 1
944 Length of frm data: XXX
945 Max Rows: 0
946 Row Checksum: 1
947 Row GCI: 1
948 SingleUserMode: 2
949 ForceVarPart: 0
950 PartitionCount: 2
951 FragmentCount: 2
952 PartitionBalance: FOR_RP_BY_LDM
953 ExtraRowGciBits: 0
954 ExtraRowAuthorBits: 0
955 TableStatus: Retrieved
956 Table options:
957 -- Attributes --
958 a Unsigned NOT NULL DISTRIBUTION KEY AT=FIXED ST=MEMORY
959 b Unsigned NOT NULL AT=FIXED ST=MEMORY
960 NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
961 -- Indexes --
962 PRIMARY KEY(NDB$TNODE) - UniqueHashIndex
963
964 -- t2/b --
965 Version: Any
966 Base table: t2
967 Number of attributes: 1
968 Logging: 0
969 Index type: OrderedIndex
970 Index status: Retrieved
971 -- Attributes --
972 b Unsigned NOT NULL AT=FIXED ST=MEMORY
973 -- IndexTable XX/b --
974 Version: Any
975 Fragment type: FragUndefined
976 K Value: 6
977 Min load factor: 78
978 Max load factor: 80
979 Temporary table: yes
980 Number of attributes: 2
981 Number of primary keys: 1
982 Length of frm data: XXX
983 Max Rows: 0
984 Row Checksum: 1
985 Row GCI: 1
986 SingleUserMode: 2
987 ForceVarPart: 0
988 PartitionCount: 2
989 FragmentCount: 2
990 PartitionBalance: FOR_RP_BY_LDM
991 ExtraRowGciBits: 0
992 ExtraRowAuthorBits: 0
993 TableStatus: Retrieved
994 Table options:
995 -- Attributes --
996 b Unsigned NOT NULL AT=FIXED ST=MEMORY
997 NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
998 -- Indexes --
999 PRIMARY KEY(NDB$TNODE) - UniqueHashIndex
1000
1001 -- t2/b$unique --
1002 Version: Any
1003 Base table: t2
1004 Number of attributes: 1
1005 Logging: 1
1006 Index type: UniqueHashIndex
1007 Index status: Retrieved
1008 -- Attributes --
1009 b Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
1010 -- IndexTable XX/b$unique --
1011 Version: Any
1012 Fragment type: HashMapPartition
1013 K Value: 6
1014 Min load factor: 78
1015 Max load factor: 80
1016 Temporary table: no
1017 Number of attributes: 2
1018 Number of primary keys: 1
1019 Length of frm data: XXX
1020 Max Rows: 0
1021 Row Checksum: 1
1022 Row GCI: 1
1023 SingleUserMode: 2
1024 ForceVarPart: 0
1025 PartitionCount: 2
1026 FragmentCount: 2
1027 PartitionBalance: FOR_RP_BY_LDM
1028 ExtraRowGciBits: 0
1029 ExtraRowAuthorBits: 0
1030 TableStatus: Retrieved
1031 Table options: readbackup
1032 HashMap: DEFAULT-HASHMAP-3840-2
1033 -- Attributes --
1034 b Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
1035 NDB$PK Unsigned [3] NOT NULL AT=FIXED ST=MEMORY
1036 -- Indexes --
1037 PRIMARY KEY(b) - UniqueHashIndex
1038
1039 Cannot use inplace reorganize partition on t3 as it has explicit MAX_ROWS set
1040 alter table t3 algorithm=inplace, reorganize partition;
1041 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: REORGANIZE of table with MAX_ROWS. Try ALGORITHM=COPY.
1042 show warnings;
1043 Level Code Message
1044 Error 1846 ALGORITHM=INPLACE is not supported. Reason: REORGANIZE of table with MAX_ROWS. Try ALGORITHM=COPY.
1045 alter table t3 algorithm=inplace, max_rows=50000000;
1046 -- t3 --
1047 Version: Any
1048 Fragment type: HashMapPartition
1049 K Value: 6
1050 Min load factor: 78
1051 Max load factor: 80
1052 Temporary table: no
1053 Number of attributes: 3
1054 Number of primary keys: 2
1055 Length of frm data: XXX
1056 Max Rows: 50000000
1057 Row Checksum: 1
1058 Row GCI: 1
1059 SingleUserMode: 0
1060 ForceVarPart: 1
1061 PartitionCount: 4
1062 FragmentCount: 4
1063 PartitionBalance: SPECIFIC
1064 ExtraRowGciBits: 0
1065 ExtraRowAuthorBits: 0
1066 TableStatus: Retrieved
1067 Table options: readbackup
1068 HashMap: DEFAULT-HASHMAP-3840-4
1069 -- Attributes --
1070 a Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
1071 b Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
1072 c Unsigned NOT NULL AT=FIXED ST=MEMORY
1073 -- Indexes --
1074 PRIMARY KEY(a, b) - UniqueHashIndex
1075 PRIMARY(a, b) - OrderedIndex
1076 b(b) - OrderedIndex
1077 b$unique(b) - UniqueHashIndex
1078 -- t3/PRIMARY --
1079 Version: Any
1080 Base table: t3
1081 Number of attributes: 2
1082 Logging: 0
1083 Index type: OrderedIndex
1084 Index status: Retrieved
1085 -- Attributes --
1086 a Unsigned NOT NULL AT=FIXED ST=MEMORY
1087 b Unsigned NOT NULL AT=FIXED ST=MEMORY
1088 -- IndexTable XX/PRIMARY --
1089 Version: Any
1090 Fragment type: FragUndefined
1091 K Value: 6
1092 Min load factor: 78
1093 Max load factor: 80
1094 Temporary table: yes
1095 Number of attributes: 3
1096 Number of primary keys: 1
1097 Length of frm data: XXX
1098 Max Rows: 0
1099 Row Checksum: 1
1100 Row GCI: 1
1101 SingleUserMode: 2
1102 ForceVarPart: 0
1103 PartitionCount: 4
1104 FragmentCount: 4
1105 PartitionBalance: FOR_RP_BY_LDM
1106 ExtraRowGciBits: 0
1107 ExtraRowAuthorBits: 0
1108 TableStatus: Retrieved
1109 Table options:
1110 -- Attributes --
1111 a Unsigned NOT NULL DISTRIBUTION KEY AT=FIXED ST=MEMORY
1112 b Unsigned NOT NULL DISTRIBUTION KEY AT=FIXED ST=MEMORY
1113 NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
1114 -- Indexes --
1115 PRIMARY KEY(NDB$TNODE) - UniqueHashIndex
1116
1117 -- t3/b --
1118 Version: Any
1119 Base table: t3
1120 Number of attributes: 1
1121 Logging: 0
1122 Index type: OrderedIndex
1123 Index status: Retrieved
1124 -- Attributes --
1125 b Unsigned NOT NULL AT=FIXED ST=MEMORY
1126 -- IndexTable XX/b --
1127 Version: Any
1128 Fragment type: FragUndefined
1129 K Value: 6
1130 Min load factor: 78
1131 Max load factor: 80
1132 Temporary table: yes
1133 Number of attributes: 2
1134 Number of primary keys: 1
1135 Length of frm data: XXX
1136 Max Rows: 0
1137 Row Checksum: 1
1138 Row GCI: 1
1139 SingleUserMode: 2
1140 ForceVarPart: 0
1141 PartitionCount: 4
1142 FragmentCount: 4
1143 PartitionBalance: FOR_RP_BY_LDM
1144 ExtraRowGciBits: 0
1145 ExtraRowAuthorBits: 0
1146 TableStatus: Retrieved
1147 Table options:
1148 -- Attributes --
1149 b Unsigned NOT NULL AT=FIXED ST=MEMORY
1150 NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
1151 -- Indexes --
1152 PRIMARY KEY(NDB$TNODE) - UniqueHashIndex
1153
1154 -- t3/b$unique --
1155 Version: Any
1156 Base table: t3
1157 Number of attributes: 1
1158 Logging: 1
1159 Index type: UniqueHashIndex
1160 Index status: Retrieved
1161 -- Attributes --
1162 b Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
1163 -- IndexTable XX/b$unique --
1164 Version: Any
1165 Fragment type: HashMapPartition
1166 K Value: 6
1167 Min load factor: 78
1168 Max load factor: 80
1169 Temporary table: no
1170 Number of attributes: 2
1171 Number of primary keys: 1
1172 Length of frm data: XXX
1173 Max Rows: 0
1174 Row Checksum: 1
1175 Row GCI: 1
1176 SingleUserMode: 2
1177 ForceVarPart: 0
1178 PartitionCount: 4
1179 FragmentCount: 4
1180 PartitionBalance: SPECIFIC
1181 ExtraRowGciBits: 0
1182 ExtraRowAuthorBits: 0
1183 TableStatus: Retrieved
1184 Table options: readbackup
1185 HashMap: DEFAULT-HASHMAP-3840-4
1186 -- Attributes --
1187 b Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
1188 NDB$PK Unsigned [3] NOT NULL AT=FIXED ST=MEMORY
1189 -- Indexes --
1190 PRIMARY KEY(b) - UniqueHashIndex
1191
1192 alter table t4 algorithm=inplace, reorganize partition;
1193 alter table t5 algorithm=inplace partition by key() partitions 6;
1194 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Detected unsupported change. Try ALGORITHM=COPY.
1195 Check partitions added, expect 0 in all cases
1196 partitions added to t1
1197 t1_added
1198 0
1199 partitions added to t2
1200 t2_added
1201 0
1202 partitions added to t3
1203 t3_added
1204 0
1205 partitions added to t4
1206 t4_added
1207 0
1208 alter table t1 algorithm=inplace, add partition partitions 1;
1209 -- t1 --
1210 Version: Any
1211 Fragment type: HashMapPartition
1212 K Value: 6
1213 Min load factor: 78
1214 Max load factor: 80
1215 Temporary table: no
1216 Number of attributes: 3
1217 Number of primary keys: 2
1218 Length of frm data: XXX
1219 Max Rows: 0
1220 Row Checksum: 1
1221 Row GCI: 1
1222 SingleUserMode: 0
1223 ForceVarPart: 1
1224 PartitionCount: 3
1225 FragmentCount: 3
1226 PartitionBalance: SPECIFIC
1227 ExtraRowGciBits: 0
1228 ExtraRowAuthorBits: 0
1229 TableStatus: Retrieved
1230 Table options: readbackup
1231 HashMap: HASHMAP-3840-2-3
1232 -- Attributes --
1233 a Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
1234 b Unsigned NOT NULL AT=FIXED ST=MEMORY
1235 c Unsigned PRIMARY KEY AT=FIXED ST=MEMORY
1236 -- Indexes --
1237 PRIMARY KEY(a, c) - UniqueHashIndex
1238 PRIMARY(a, c) - OrderedIndex
1239 b(b) - OrderedIndex
1240 b$unique(b) - UniqueHashIndex
1241 -- t1/PRIMARY --
1242 Version: Any
1243 Base table: t1
1244 Number of attributes: 2
1245 Logging: 0
1246 Index type: OrderedIndex
1247 Index status: Retrieved
1248 -- Attributes --
1249 a Unsigned NOT NULL AT=FIXED ST=MEMORY
1250 c Unsigned NOT NULL AT=FIXED ST=MEMORY
1251 -- IndexTable XX/PRIMARY --
1252 Version: Any
1253 Fragment type: FragUndefined
1254 K Value: 6
1255 Min load factor: 78
1256 Max load factor: 80
1257 Temporary table: yes
1258 Number of attributes: 3
1259 Number of primary keys: 1
1260 Length of frm data: XXX
1261 Max Rows: 0
1262 Row Checksum: 1
1263 Row GCI: 1
1264 SingleUserMode: 2
1265 ForceVarPart: 0
1266 PartitionCount: 2
1267 FragmentCount: 3
1268 PartitionBalance: FOR_RP_BY_LDM
1269 ExtraRowGciBits: 0
1270 ExtraRowAuthorBits: 0
1271 TableStatus: Retrieved
1272 Table options:
1273 -- Attributes --
1274 a Unsigned NOT NULL DISTRIBUTION KEY AT=FIXED ST=MEMORY
1275 c Unsigned NOT NULL AT=FIXED ST=MEMORY
1276 NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
1277 -- Indexes --
1278 PRIMARY KEY(NDB$TNODE) - UniqueHashIndex
1279
1280 -- t1/b --
1281 Version: Any
1282 Base table: t1
1283 Number of attributes: 1
1284 Logging: 0
1285 Index type: OrderedIndex
1286 Index status: Retrieved
1287 -- Attributes --
1288 b Unsigned NOT NULL AT=FIXED ST=MEMORY
1289 -- IndexTable XX/b --
1290 Version: Any
1291 Fragment type: FragUndefined
1292 K Value: 6
1293 Min load factor: 78
1294 Max load factor: 80
1295 Temporary table: yes
1296 Number of attributes: 2
1297 Number of primary keys: 1
1298 Length of frm data: XXX
1299 Max Rows: 0
1300 Row Checksum: 1
1301 Row GCI: 1
1302 SingleUserMode: 2
1303 ForceVarPart: 0
1304 PartitionCount: 2
1305 FragmentCount: 3
1306 PartitionBalance: FOR_RP_BY_LDM
1307 ExtraRowGciBits: 0
1308 ExtraRowAuthorBits: 0
1309 TableStatus: Retrieved
1310 Table options:
1311 -- Attributes --
1312 b Unsigned NOT NULL AT=FIXED ST=MEMORY
1313 NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
1314 -- Indexes --
1315 PRIMARY KEY(NDB$TNODE) - UniqueHashIndex
1316
1317 -- t1/b$unique --
1318 Version: Any
1319 Base table: t1
1320 Number of attributes: 1
1321 Logging: 1
1322 Index type: UniqueHashIndex
1323 Index status: Retrieved
1324 -- Attributes --
1325 b Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
1326 -- IndexTable XX/b$unique --
1327 Version: Any
1328 Fragment type: HashMapPartition
1329 K Value: 6
1330 Min load factor: 78
1331 Max load factor: 80
1332 Temporary table: no
1333 Number of attributes: 2
1334 Number of primary keys: 1
1335 Length of frm data: XXX
1336 Max Rows: 0
1337 Row Checksum: 1
1338 Row GCI: 1
1339 SingleUserMode: 2
1340 ForceVarPart: 0
1341 PartitionCount: 3
1342 FragmentCount: 3
1343 PartitionBalance: SPECIFIC
1344 ExtraRowGciBits: 0
1345 ExtraRowAuthorBits: 0
1346 TableStatus: Retrieved
1347 Table options: readbackup
1348 HashMap: HASHMAP-3840-2-3
1349 -- Attributes --
1350 b Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
1351 NDB$PK Unsigned [3] NOT NULL AT=FIXED ST=MEMORY
1352 -- Indexes --
1353 PRIMARY KEY(b) - UniqueHashIndex
1354
1355 alter table t2 algorithm=inplace, add partition partitions 4;
1356 -- t2 --
1357 Version: Any
1358 Fragment type: HashMapPartition
1359 K Value: 6
1360 Min load factor: 78
1361 Max load factor: 80
1362 Temporary table: no
1363 Number of attributes: 3
1364 Number of primary keys: 2
1365 Length of frm data: XXX
1366 Max Rows: 0
1367 Row Checksum: 1
1368 Row GCI: 1
1369 SingleUserMode: 0
1370 ForceVarPart: 1
1371 PartitionCount: 6
1372 FragmentCount: 6
1373 PartitionBalance: SPECIFIC
1374 ExtraRowGciBits: 0
1375 ExtraRowAuthorBits: 0
1376 TableStatus: Retrieved
1377 Table options: readbackup
1378 HashMap: DEFAULT-HASHMAP-3840-6
1379 Tablespace id: XX
1380 Tablespace: ts1
1381 -- Attributes --
1382 a Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
1383 b Unsigned PRIMARY KEY AT=FIXED ST=MEMORY
1384 c Unsigned NOT NULL AT=FIXED ST=DISK
1385 -- Indexes --
1386 PRIMARY KEY(a, b) - UniqueHashIndex
1387 PRIMARY(a, b) - OrderedIndex
1388 b(b) - OrderedIndex
1389 b$unique(b) - UniqueHashIndex
1390 -- t2/PRIMARY --
1391 Version: Any
1392 Base table: t2
1393 Number of attributes: 2
1394 Logging: 0
1395 Index type: OrderedIndex
1396 Index status: Retrieved
1397 -- Attributes --
1398 a Unsigned NOT NULL AT=FIXED ST=MEMORY
1399 b Unsigned NOT NULL AT=FIXED ST=MEMORY
1400 -- IndexTable XX/PRIMARY --
1401 Version: Any
1402 Fragment type: FragUndefined
1403 K Value: 6
1404 Min load factor: 78
1405 Max load factor: 80
1406 Temporary table: yes
1407 Number of attributes: 3
1408 Number of primary keys: 1
1409 Length of frm data: XXX
1410 Max Rows: 0
1411 Row Checksum: 1
1412 Row GCI: 1
1413 SingleUserMode: 2
1414 ForceVarPart: 0
1415 PartitionCount: 2
1416 FragmentCount: 6
1417 PartitionBalance: FOR_RP_BY_LDM
1418 ExtraRowGciBits: 0
1419 ExtraRowAuthorBits: 0
1420 TableStatus: Retrieved
1421 Table options:
1422 -- Attributes --
1423 a Unsigned NOT NULL DISTRIBUTION KEY AT=FIXED ST=MEMORY
1424 b Unsigned NOT NULL AT=FIXED ST=MEMORY
1425 NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
1426 -- Indexes --
1427 PRIMARY KEY(NDB$TNODE) - UniqueHashIndex
1428
1429 -- t2/b --
1430 Version: Any
1431 Base table: t2
1432 Number of attributes: 1
1433 Logging: 0
1434 Index type: OrderedIndex
1435 Index status: Retrieved
1436 -- Attributes --
1437 b Unsigned NOT NULL AT=FIXED ST=MEMORY
1438 -- IndexTable XX/b --
1439 Version: Any
1440 Fragment type: FragUndefined
1441 K Value: 6
1442 Min load factor: 78
1443 Max load factor: 80
1444 Temporary table: yes
1445 Number of attributes: 2
1446 Number of primary keys: 1
1447 Length of frm data: XXX
1448 Max Rows: 0
1449 Row Checksum: 1
1450 Row GCI: 1
1451 SingleUserMode: 2
1452 ForceVarPart: 0
1453 PartitionCount: 2
1454 FragmentCount: 6
1455 PartitionBalance: FOR_RP_BY_LDM
1456 ExtraRowGciBits: 0
1457 ExtraRowAuthorBits: 0
1458 TableStatus: Retrieved
1459 Table options:
1460 -- Attributes --
1461 b Unsigned NOT NULL AT=FIXED ST=MEMORY
1462 NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
1463 -- Indexes --
1464 PRIMARY KEY(NDB$TNODE) - UniqueHashIndex
1465
1466 -- t2/b$unique --
1467 Version: Any
1468 Base table: t2
1469 Number of attributes: 1
1470 Logging: 1
1471 Index type: UniqueHashIndex
1472 Index status: Retrieved
1473 -- Attributes --
1474 b Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
1475 -- IndexTable XX/b$unique --
1476 Version: Any
1477 Fragment type: HashMapPartition
1478 K Value: 6
1479 Min load factor: 78
1480 Max load factor: 80
1481 Temporary table: no
1482 Number of attributes: 2
1483 Number of primary keys: 1
1484 Length of frm data: XXX
1485 Max Rows: 0
1486 Row Checksum: 1
1487 Row GCI: 1
1488 SingleUserMode: 2
1489 ForceVarPart: 0
1490 PartitionCount: 6
1491 FragmentCount: 6
1492 PartitionBalance: SPECIFIC
1493 ExtraRowGciBits: 0
1494 ExtraRowAuthorBits: 0
1495 TableStatus: Retrieved
1496 Table options: readbackup
1497 HashMap: DEFAULT-HASHMAP-3840-6
1498 -- Attributes --
1499 b Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
1500 NDB$PK Unsigned [3] NOT NULL AT=FIXED ST=MEMORY
1501 -- Indexes --
1502 PRIMARY KEY(b) - UniqueHashIndex
1503
1504 alter table t3 algorithm=inplace, max_rows=100000000;
1505 -- t3 --
1506 Version: Any
1507 Fragment type: HashMapPartition
1508 K Value: 6
1509 Min load factor: 78
1510 Max load factor: 80
1511 Temporary table: no
1512 Number of attributes: 3
1513 Number of primary keys: 2
1514 Length of frm data: XXX
1515 Max Rows: 50000000
1516 Row Checksum: 1
1517 Row GCI: 1
1518 SingleUserMode: 0
1519 ForceVarPart: 1
1520 PartitionCount: 6
1521 FragmentCount: 6
1522 PartitionBalance: SPECIFIC
1523 ExtraRowGciBits: 0
1524 ExtraRowAuthorBits: 0
1525 TableStatus: Retrieved
1526 Table options: readbackup
1527 HashMap: HASHMAP-3840-4-6
1528 -- Attributes --
1529 a Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
1530 b Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
1531 c Unsigned NOT NULL AT=FIXED ST=MEMORY
1532 -- Indexes --
1533 PRIMARY KEY(a, b) - UniqueHashIndex
1534 PRIMARY(a, b) - OrderedIndex
1535 b(b) - OrderedIndex
1536 b$unique(b) - UniqueHashIndex
1537 -- t3/PRIMARY --
1538 Version: Any
1539 Base table: t3
1540 Number of attributes: 2
1541 Logging: 0
1542 Index type: OrderedIndex
1543 Index status: Retrieved
1544 -- Attributes --
1545 a Unsigned NOT NULL AT=FIXED ST=MEMORY
1546 b Unsigned NOT NULL AT=FIXED ST=MEMORY
1547 -- IndexTable XX/PRIMARY --
1548 Version: Any
1549 Fragment type: FragUndefined
1550 K Value: 6
1551 Min load factor: 78
1552 Max load factor: 80
1553 Temporary table: yes
1554 Number of attributes: 3
1555 Number of primary keys: 1
1556 Length of frm data: XXX
1557 Max Rows: 0
1558 Row Checksum: 1
1559 Row GCI: 1
1560 SingleUserMode: 2
1561 ForceVarPart: 0
1562 PartitionCount: 4
1563 FragmentCount: 6
1564 PartitionBalance: FOR_RP_BY_LDM
1565 ExtraRowGciBits: 0
1566 ExtraRowAuthorBits: 0
1567 TableStatus: Retrieved
1568 Table options:
1569 -- Attributes --
1570 a Unsigned NOT NULL DISTRIBUTION KEY AT=FIXED ST=MEMORY
1571 b Unsigned NOT NULL DISTRIBUTION KEY AT=FIXED ST=MEMORY
1572 NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
1573 -- Indexes --
1574 PRIMARY KEY(NDB$TNODE) - UniqueHashIndex
1575
1576 -- t3/b --
1577 Version: Any
1578 Base table: t3
1579 Number of attributes: 1
1580 Logging: 0
1581 Index type: OrderedIndex
1582 Index status: Retrieved
1583 -- Attributes --
1584 b Unsigned NOT NULL AT=FIXED ST=MEMORY
1585 -- IndexTable XX/b --
1586 Version: Any
1587 Fragment type: FragUndefined
1588 K Value: 6
1589 Min load factor: 78
1590 Max load factor: 80
1591 Temporary table: yes
1592 Number of attributes: 2
1593 Number of primary keys: 1
1594 Length of frm data: XXX
1595 Max Rows: 0
1596 Row Checksum: 1
1597 Row GCI: 1
1598 SingleUserMode: 2
1599 ForceVarPart: 0
1600 PartitionCount: 4
1601 FragmentCount: 6
1602 PartitionBalance: FOR_RP_BY_LDM
1603 ExtraRowGciBits: 0
1604 ExtraRowAuthorBits: 0
1605 TableStatus: Retrieved
1606 Table options:
1607 -- Attributes --
1608 b Unsigned NOT NULL AT=FIXED ST=MEMORY
1609 NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
1610 -- Indexes --
1611 PRIMARY KEY(NDB$TNODE) - UniqueHashIndex
1612
1613 -- t3/b$unique --
1614 Version: Any
1615 Base table: t3
1616 Number of attributes: 1
1617 Logging: 1
1618 Index type: UniqueHashIndex
1619 Index status: Retrieved
1620 -- Attributes --
1621 b Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
1622 -- IndexTable XX/b$unique --
1623 Version: Any
1624 Fragment type: HashMapPartition
1625 K Value: 6
1626 Min load factor: 78
1627 Max load factor: 80
1628 Temporary table: no
1629 Number of attributes: 2
1630 Number of primary keys: 1
1631 Length of frm data: XXX
1632 Max Rows: 0
1633 Row Checksum: 1
1634 Row GCI: 1
1635 SingleUserMode: 2
1636 ForceVarPart: 0
1637 PartitionCount: 6
1638 FragmentCount: 6
1639 PartitionBalance: SPECIFIC
1640 ExtraRowGciBits: 0
1641 ExtraRowAuthorBits: 0
1642 TableStatus: Retrieved
1643 Table options: readbackup
1644 HashMap: HASHMAP-3840-4-6
1645 -- Attributes --
1646 b Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
1647 NDB$PK Unsigned [3] NOT NULL AT=FIXED ST=MEMORY
1648 -- Indexes --
1649 PRIMARY KEY(b) - UniqueHashIndex
1650
1651 alter table t4 algorithm=inplace, max_rows=100000000;
1652 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: setting MAX_ROWS on table without MAX_ROWS. Try ALGORITHM=COPY.
1653 partitions added to t1 (expect 1)
1654 t1_added
1655 1
1656 partitions added to t2 (expect 4)
1657 t2_added
1658 4
1659 partitions added to t3 (expect 4)
1660 t3_added
1661 2
1662 partitions added to t4 (expect 0)
1663 t4_added
1664 0
1665 alter table t1 algorithm=inplace, reorganize partition;
1666 ERROR HY000: REORGANIZE PARTITION without parameters can only be used on auto-partitioned tables using HASH PARTITIONs
1667 alter table t3 algorithm=inplace, reorganize partition;
1668 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: REORGANIZE of table with MAX_ROWS. Try ALGORITHM=COPY.
1669 show warnings;
1670 Level Code Message
1671 Error 1846 ALGORITHM=INPLACE is not supported. Reason: REORGANIZE of table with MAX_ROWS. Try ALGORITHM=COPY.
1672 alter table t4 algorithm=inplace, reorganize partition;
1673 select count(*) from t1;
1674 count(*)
1675 100
1676 select count(*) from t2;
1677 count(*)
1678 100
1679 select * from t1 where a < 20;
1680 a b c
1681 1 1 1
1682 10 10 10
1683 11 11 11
1684 12 12 12
1685 13 13 13
1686 14 14 14
1687 15 15 15
1688 16 16 16
1689 17 17 17
1690 18 18 18
1691 19 19 19
1692 2 2 2
1693 3 3 3
1694 4 4 4
1695 5 5 5
1696 6 6 6
1697 7 7 7
1698 8 8 8
1699 9 9 9
1700 select * from t1 where a = 20;
1701 a b c
1702 20 20 20
1703 select * from t1 where a = 30;
1704 a b c
1705 30 30 30
1706 select * from t1 where a = 40;
1707 a b c
1708 40 40 40
1709 select * from t1 where a = 50;
1710 a b c
1711 50 50 50
1712 select * from t1 where b = 20;
1713 a b c
1714 20 20 20
1715 select * from t1 where b = 30;
1716 a b c
1717 30 30 30
1718 select * from t1 where b = 40;
1719 a b c
1720 40 40 40
1721 select * from t1 where b = 50;
1722 a b c
1723 50 50 50
1724 select * from t2 where a < 20;
1725 a b c
1726 1 1 1
1727 10 10 10
1728 11 11 11
1729 12 12 12
1730 13 13 13
1731 14 14 14
1732 15 15 15
1733 16 16 16
1734 17 17 17
1735 18 18 18
1736 19 19 19
1737 2 2 2
1738 3 3 3
1739 4 4 4
1740 5 5 5
1741 6 6 6
1742 7 7 7
1743 8 8 8
1744 9 9 9
1745 select * from t2 where a = 20;
1746 a b c
1747 20 20 20
1748 select * from t2 where a = 30;
1749 a b c
1750 30 30 30
1751 select * from t2 where a = 40;
1752 a b c
1753 40 40 40
1754 select * from t2 where a = 50;
1755 a b c
1756 50 50 50
1757 select * from t2 where b = 20;
1758 a b c
1759 20 20 20
1760 select * from t2 where b = 30;
1761 a b c
1762 30 30 30
1763 select * from t2 where b = 40;
1764 a b c
1765 40 40 40
1766 select * from t2 where b = 50;
1767 a b c
1768 50 50 50
1769 select * from t3 where a < 20;
1770 a b c
1771 1 1 1
1772 10 10 10
1773 11 11 11
1774 12 12 12
1775 13 13 13
1776 14 14 14
1777 15 15 15
1778 16 16 16
1779 17 17 17
1780 18 18 18
1781 19 19 19
1782 2 2 2
1783 3 3 3
1784 4 4 4
1785 5 5 5
1786 6 6 6
1787 7 7 7
1788 8 8 8
1789 9 9 9
1790 select * from t3 where a = 20;
1791 a b c
1792 20 20 20
1793 select * from t3 where a = 30;
1794 a b c
1795 30 30 30
1796 select * from t3 where a = 40;
1797 a b c
1798 40 40 40
1799 select * from t3 where a = 50;
1800 a b c
1801 50 50 50
1802 select * from t3 where b = 20;
1803 a b c
1804 20 20 20
1805 select * from t3 where b = 30;
1806 a b c
1807 30 30 30
1808 select * from t3 where b = 40;
1809 a b c
1810 40 40 40
1811 select * from t3 where b = 50;
1812 a b c
1813 50 50 50
1814 select * from t4 where a < 20;
1815 a b c
1816 1 1 1
1817 10 10 10
1818 11 11 11
1819 12 12 12
1820 13 13 13
1821 14 14 14
1822 15 15 15
1823 16 16 16
1824 17 17 17
1825 18 18 18
1826 19 19 19
1827 2 2 2
1828 3 3 3
1829 4 4 4
1830 5 5 5
1831 6 6 6
1832 7 7 7
1833 8 8 8
1834 9 9 9
1835 select * from t4 where a = 20;
1836 a b c
1837 20 20 20
1838 select * from t4 where a = 30;
1839 a b c
1840 30 30 30
1841 select * from t4 where a = 40;
1842 a b c
1843 40 40 40
1844 select * from t4 where a = 50;
1845 a b c
1846 50 50 50
1847 select * from t4 where b = 20;
1848 a b c
1849 20 20 20
1850 select * from t4 where b = 30;
1851 a b c
1852 30 30 30
1853 select * from t4 where b = 40;
1854 a b c
1855 40 40 40
1856 select * from t4 where b = 50;
1857 a b c
1858 50 50 50
1859 Table: test.t4
1860 PartitionCount: 2
1861 FragmentCount: 2
1862
1863 b$unique(b) - UniqueHashIndex
1864 FragmentCount: 2
1865 drop table t4;
1866 alter table t1 algorithm=inplace, add partition partitions 2;
1867 -- t1 --
1868 Version: Any
1869 Fragment type: HashMapPartition
1870 K Value: 6
1871 Min load factor: 78
1872 Max load factor: 80
1873 Temporary table: no
1874 Number of attributes: 3
1875 Number of primary keys: 2
1876 Length of frm data: XXX
1877 Max Rows: 0
1878 Row Checksum: 1
1879 Row GCI: 1
1880 SingleUserMode: 0
1881 ForceVarPart: 1
1882 PartitionCount: 5
1883 FragmentCount: 5
1884 PartitionBalance: SPECIFIC
1885 ExtraRowGciBits: 0
1886 ExtraRowAuthorBits: 0
1887 TableStatus: Retrieved
1888 Table options: readbackup
1889 HashMap: HASHMAP-3840-3-5
1890 -- Attributes --
1891 a Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
1892 b Unsigned NOT NULL AT=FIXED ST=MEMORY
1893 c Unsigned PRIMARY KEY AT=FIXED ST=MEMORY
1894 -- Indexes --
1895 PRIMARY KEY(a, c) - UniqueHashIndex
1896 PRIMARY(a, c) - OrderedIndex
1897 b(b) - OrderedIndex
1898 b$unique(b) - UniqueHashIndex
1899 -- t1/PRIMARY --
1900 Version: Any
1901 Base table: t1
1902 Number of attributes: 2
1903 Logging: 0
1904 Index type: OrderedIndex
1905 Index status: Retrieved
1906 -- Attributes --
1907 a Unsigned NOT NULL AT=FIXED ST=MEMORY
1908 c Unsigned NOT NULL AT=FIXED ST=MEMORY
1909 -- IndexTable XX/PRIMARY --
1910 Version: Any
1911 Fragment type: FragUndefined
1912 K Value: 6
1913 Min load factor: 78
1914 Max load factor: 80
1915 Temporary table: yes
1916 Number of attributes: 3
1917 Number of primary keys: 1
1918 Length of frm data: XXX
1919 Max Rows: 0
1920 Row Checksum: 1
1921 Row GCI: 1
1922 SingleUserMode: 2
1923 ForceVarPart: 0
1924 PartitionCount: 2
1925 FragmentCount: 5
1926 PartitionBalance: FOR_RP_BY_LDM
1927 ExtraRowGciBits: 0
1928 ExtraRowAuthorBits: 0
1929 TableStatus: Retrieved
1930 Table options:
1931 -- Attributes --
1932 a Unsigned NOT NULL DISTRIBUTION KEY AT=FIXED ST=MEMORY
1933 c Unsigned NOT NULL AT=FIXED ST=MEMORY
1934 NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
1935 -- Indexes --
1936 PRIMARY KEY(NDB$TNODE) - UniqueHashIndex
1937
1938 -- t1/b --
1939 Version: Any
1940 Base table: t1
1941 Number of attributes: 1
1942 Logging: 0
1943 Index type: OrderedIndex
1944 Index status: Retrieved
1945 -- Attributes --
1946 b Unsigned NOT NULL AT=FIXED ST=MEMORY
1947 -- IndexTable XX/b --
1948 Version: Any
1949 Fragment type: FragUndefined
1950 K Value: 6
1951 Min load factor: 78
1952 Max load factor: 80
1953 Temporary table: yes
1954 Number of attributes: 2
1955 Number of primary keys: 1
1956 Length of frm data: XXX
1957 Max Rows: 0
1958 Row Checksum: 1
1959 Row GCI: 1
1960 SingleUserMode: 2
1961 ForceVarPart: 0
1962 PartitionCount: 2
1963 FragmentCount: 5
1964 PartitionBalance: FOR_RP_BY_LDM
1965 ExtraRowGciBits: 0
1966 ExtraRowAuthorBits: 0
1967 TableStatus: Retrieved
1968 Table options:
1969 -- Attributes --
1970 b Unsigned NOT NULL AT=FIXED ST=MEMORY
1971 NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
1972 -- Indexes --
1973 PRIMARY KEY(NDB$TNODE) - UniqueHashIndex
1974
1975 -- t1/b$unique --
1976 Version: Any
1977 Base table: t1
1978 Number of attributes: 1
1979 Logging: 1
1980 Index type: UniqueHashIndex
1981 Index status: Retrieved
1982 -- Attributes --
1983 b Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
1984 -- IndexTable XX/b$unique --
1985 Version: Any
1986 Fragment type: HashMapPartition
1987 K Value: 6
1988 Min load factor: 78
1989 Max load factor: 80
1990 Temporary table: no
1991 Number of attributes: 2
1992 Number of primary keys: 1
1993 Length of frm data: XXX
1994 Max Rows: 0
1995 Row Checksum: 1
1996 Row GCI: 1
1997 SingleUserMode: 2
1998 ForceVarPart: 0
1999 PartitionCount: 5
2000 FragmentCount: 5
2001 PartitionBalance: SPECIFIC
2002 ExtraRowGciBits: 0
2003 ExtraRowAuthorBits: 0
2004 TableStatus: Retrieved
2005 Table options: readbackup
2006 HashMap: HASHMAP-3840-3-5
2007 -- Attributes --
2008 b Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
2009 NDB$PK Unsigned [3] NOT NULL AT=FIXED ST=MEMORY
2010 -- Indexes --
2011 PRIMARY KEY(b) - UniqueHashIndex
2012
2013 alter table t2 algorithm=inplace, add partition partitions 1;
2014 -- t2 --
2015 Version: Any
2016 Fragment type: HashMapPartition
2017 K Value: 6
2018 Min load factor: 78
2019 Max load factor: 80
2020 Temporary table: no
2021 Number of attributes: 3
2022 Number of primary keys: 2
2023 Length of frm data: XXX
2024 Max Rows: 0
2025 Row Checksum: 1
2026 Row GCI: 1
2027 SingleUserMode: 0
2028 ForceVarPart: 1
2029 PartitionCount: 7
2030 FragmentCount: 7
2031 PartitionBalance: SPECIFIC
2032 ExtraRowGciBits: 0
2033 ExtraRowAuthorBits: 0
2034 TableStatus: Retrieved
2035 Table options: readbackup
2036 HashMap: HASHMAP-3840-6-7
2037 Tablespace id: XX
2038 Tablespace: ts1
2039 -- Attributes --
2040 a Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
2041 b Unsigned PRIMARY KEY AT=FIXED ST=MEMORY
2042 c Unsigned NOT NULL AT=FIXED ST=DISK
2043 -- Indexes --
2044 PRIMARY KEY(a, b) - UniqueHashIndex
2045 PRIMARY(a, b) - OrderedIndex
2046 b(b) - OrderedIndex
2047 b$unique(b) - UniqueHashIndex
2048 -- t2/PRIMARY --
2049 Version: Any
2050 Base table: t2
2051 Number of attributes: 2
2052 Logging: 0
2053 Index type: OrderedIndex
2054 Index status: Retrieved
2055 -- Attributes --
2056 a Unsigned NOT NULL AT=FIXED ST=MEMORY
2057 b Unsigned NOT NULL AT=FIXED ST=MEMORY
2058 -- IndexTable XX/PRIMARY --
2059 Version: Any
2060 Fragment type: FragUndefined
2061 K Value: 6
2062 Min load factor: 78
2063 Max load factor: 80
2064 Temporary table: yes
2065 Number of attributes: 3
2066 Number of primary keys: 1
2067 Length of frm data: XXX
2068 Max Rows: 0
2069 Row Checksum: 1
2070 Row GCI: 1
2071 SingleUserMode: 2
2072 ForceVarPart: 0
2073 PartitionCount: 2
2074 FragmentCount: 7
2075 PartitionBalance: FOR_RP_BY_LDM
2076 ExtraRowGciBits: 0
2077 ExtraRowAuthorBits: 0
2078 TableStatus: Retrieved
2079 Table options:
2080 -- Attributes --
2081 a Unsigned NOT NULL DISTRIBUTION KEY AT=FIXED ST=MEMORY
2082 b Unsigned NOT NULL AT=FIXED ST=MEMORY
2083 NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
2084 -- Indexes --
2085 PRIMARY KEY(NDB$TNODE) - UniqueHashIndex
2086
2087 -- t2/b --
2088 Version: Any
2089 Base table: t2
2090 Number of attributes: 1
2091 Logging: 0
2092 Index type: OrderedIndex
2093 Index status: Retrieved
2094 -- Attributes --
2095 b Unsigned NOT NULL AT=FIXED ST=MEMORY
2096 -- IndexTable XX/b --
2097 Version: Any
2098 Fragment type: FragUndefined
2099 K Value: 6
2100 Min load factor: 78
2101 Max load factor: 80
2102 Temporary table: yes
2103 Number of attributes: 2
2104 Number of primary keys: 1
2105 Length of frm data: XXX
2106 Max Rows: 0
2107 Row Checksum: 1
2108 Row GCI: 1
2109 SingleUserMode: 2
2110 ForceVarPart: 0
2111 PartitionCount: 2
2112 FragmentCount: 7
2113 PartitionBalance: FOR_RP_BY_LDM
2114 ExtraRowGciBits: 0
2115 ExtraRowAuthorBits: 0
2116 TableStatus: Retrieved
2117 Table options:
2118 -- Attributes --
2119 b Unsigned NOT NULL AT=FIXED ST=MEMORY
2120 NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
2121 -- Indexes --
2122 PRIMARY KEY(NDB$TNODE) - UniqueHashIndex
2123
2124 -- t2/b$unique --
2125 Version: Any
2126 Base table: t2
2127 Number of attributes: 1
2128 Logging: 1
2129 Index type: UniqueHashIndex
2130 Index status: Retrieved
2131 -- Attributes --
2132 b Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
2133 -- IndexTable XX/b$unique --
2134 Version: Any
2135 Fragment type: HashMapPartition
2136 K Value: 6
2137 Min load factor: 78
2138 Max load factor: 80
2139 Temporary table: no
2140 Number of attributes: 2
2141 Number of primary keys: 1
2142 Length of frm data: XXX
2143 Max Rows: 0
2144 Row Checksum: 1
2145 Row GCI: 1
2146 SingleUserMode: 2
2147 ForceVarPart: 0
2148 PartitionCount: 7
2149 FragmentCount: 7
2150 PartitionBalance: SPECIFIC
2151 ExtraRowGciBits: 0
2152 ExtraRowAuthorBits: 0
2153 TableStatus: Retrieved
2154 Table options: readbackup
2155 HashMap: HASHMAP-3840-6-7
2156 -- Attributes --
2157 b Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
2158 NDB$PK Unsigned [3] NOT NULL AT=FIXED ST=MEMORY
2159 -- Indexes --
2160 PRIMARY KEY(b) - UniqueHashIndex
2161
2162 alter table t3 algorithm=inplace, max_rows=150000000;
2163 -- t3 --
2164 Version: Any
2165 Fragment type: HashMapPartition
2166 K Value: 6
2167 Min load factor: 78
2168 Max load factor: 80
2169 Temporary table: no
2170 Number of attributes: 3
2171 Number of primary keys: 2
2172 Length of frm data: XXX
2173 Max Rows: 50000000
2174 Row Checksum: 1
2175 Row GCI: 1
2176 SingleUserMode: 0
2177 ForceVarPart: 1
2178 PartitionCount: 8
2179 FragmentCount: 8
2180 PartitionBalance: SPECIFIC
2181 ExtraRowGciBits: 0
2182 ExtraRowAuthorBits: 0
2183 TableStatus: Retrieved
2184 Table options: readbackup
2185 HashMap: HASHMAP-3840-6-8
2186 -- Attributes --
2187 a Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
2188 b Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
2189 c Unsigned NOT NULL AT=FIXED ST=MEMORY
2190 -- Indexes --
2191 PRIMARY KEY(a, b) - UniqueHashIndex
2192 PRIMARY(a, b) - OrderedIndex
2193 b(b) - OrderedIndex
2194 b$unique(b) - UniqueHashIndex
2195 -- t3/PRIMARY --
2196 Version: Any
2197 Base table: t3
2198 Number of attributes: 2
2199 Logging: 0
2200 Index type: OrderedIndex
2201 Index status: Retrieved
2202 -- Attributes --
2203 a Unsigned NOT NULL AT=FIXED ST=MEMORY
2204 b Unsigned NOT NULL AT=FIXED ST=MEMORY
2205 -- IndexTable XX/PRIMARY --
2206 Version: Any
2207 Fragment type: FragUndefined
2208 K Value: 6
2209 Min load factor: 78
2210 Max load factor: 80
2211 Temporary table: yes
2212 Number of attributes: 3
2213 Number of primary keys: 1
2214 Length of frm data: XXX
2215 Max Rows: 0
2216 Row Checksum: 1
2217 Row GCI: 1
2218 SingleUserMode: 2
2219 ForceVarPart: 0
2220 PartitionCount: 4
2221 FragmentCount: 8
2222 PartitionBalance: FOR_RP_BY_LDM
2223 ExtraRowGciBits: 0
2224 ExtraRowAuthorBits: 0
2225 TableStatus: Retrieved
2226 Table options:
2227 -- Attributes --
2228 a Unsigned NOT NULL DISTRIBUTION KEY AT=FIXED ST=MEMORY
2229 b Unsigned NOT NULL DISTRIBUTION KEY AT=FIXED ST=MEMORY
2230 NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
2231 -- Indexes --
2232 PRIMARY KEY(NDB$TNODE) - UniqueHashIndex
2233
2234 -- t3/b --
2235 Version: Any
2236 Base table: t3
2237 Number of attributes: 1
2238 Logging: 0
2239 Index type: OrderedIndex
2240 Index status: Retrieved
2241 -- Attributes --
2242 b Unsigned NOT NULL AT=FIXED ST=MEMORY
2243 -- IndexTable XX/b --
2244 Version: Any
2245 Fragment type: FragUndefined
2246 K Value: 6
2247 Min load factor: 78
2248 Max load factor: 80
2249 Temporary table: yes
2250 Number of attributes: 2
2251 Number of primary keys: 1
2252 Length of frm data: XXX
2253 Max Rows: 0
2254 Row Checksum: 1
2255 Row GCI: 1
2256 SingleUserMode: 2
2257 ForceVarPart: 0
2258 PartitionCount: 4
2259 FragmentCount: 8
2260 PartitionBalance: FOR_RP_BY_LDM
2261 ExtraRowGciBits: 0
2262 ExtraRowAuthorBits: 0
2263 TableStatus: Retrieved
2264 Table options:
2265 -- Attributes --
2266 b Unsigned NOT NULL AT=FIXED ST=MEMORY
2267 NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
2268 -- Indexes --
2269 PRIMARY KEY(NDB$TNODE) - UniqueHashIndex
2270
2271 -- t3/b$unique --
2272 Version: Any
2273 Base table: t3
2274 Number of attributes: 1
2275 Logging: 1
2276 Index type: UniqueHashIndex
2277 Index status: Retrieved
2278 -- Attributes --
2279 b Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
2280 -- IndexTable XX/b$unique --
2281 Version: Any
2282 Fragment type: HashMapPartition
2283 K Value: 6
2284 Min load factor: 78
2285 Max load factor: 80
2286 Temporary table: no
2287 Number of attributes: 2
2288 Number of primary keys: 1
2289 Length of frm data: XXX
2290 Max Rows: 0
2291 Row Checksum: 1
2292 Row GCI: 1
2293 SingleUserMode: 2
2294 ForceVarPart: 0
2295 PartitionCount: 8
2296 FragmentCount: 8
2297 PartitionBalance: SPECIFIC
2298 ExtraRowGciBits: 0
2299 ExtraRowAuthorBits: 0
2300 TableStatus: Retrieved
2301 Table options: readbackup
2302 HashMap: HASHMAP-3840-6-8
2303 -- Attributes --
2304 b Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
2305 NDB$PK Unsigned [3] NOT NULL AT=FIXED ST=MEMORY
2306 -- Indexes --
2307 PRIMARY KEY(b) - UniqueHashIndex
2308
2309 partitions added to t1 (expect 3)
2310 t1_added
2311 3
2312 partitions added to t2 (expect 5)
2313 t2_added
2314 5
2315 partitions added to t3 (expect 4)
2316 t3_added
2317 4
2318 select count(*) from t1;
2319 count(*)
2320 100
2321 select count(*) from t2;
2322 count(*)
2323 100
2324 select * from t1 where a < 20;
2325 a b c
2326 1 1 1
2327 10 10 10
2328 11 11 11
2329 12 12 12
2330 13 13 13
2331 14 14 14
2332 15 15 15
2333 16 16 16
2334 17 17 17
2335 18 18 18
2336 19 19 19
2337 2 2 2
2338 3 3 3
2339 4 4 4
2340 5 5 5
2341 6 6 6
2342 7 7 7
2343 8 8 8
2344 9 9 9
2345 select * from t1 where a = 20;
2346 a b c
2347 20 20 20
2348 select * from t1 where a = 30;
2349 a b c
2350 30 30 30
2351 select * from t1 where a = 40;
2352 a b c
2353 40 40 40
2354 select * from t1 where a = 50;
2355 a b c
2356 50 50 50
2357 select * from t1 where b = 20;
2358 a b c
2359 20 20 20
2360 select * from t1 where b = 30;
2361 a b c
2362 30 30 30
2363 select * from t1 where b = 40;
2364 a b c
2365 40 40 40
2366 select * from t1 where b = 50;
2367 a b c
2368 50 50 50
2369 select * from t2 where a < 20;
2370 a b c
2371 1 1 1
2372 10 10 10
2373 11 11 11
2374 12 12 12
2375 13 13 13
2376 14 14 14
2377 15 15 15
2378 16 16 16
2379 17 17 17
2380 18 18 18
2381 19 19 19
2382 2 2 2
2383 3 3 3
2384 4 4 4
2385 5 5 5
2386 6 6 6
2387 7 7 7
2388 8 8 8
2389 9 9 9
2390 select * from t2 where a = 20;
2391 a b c
2392 20 20 20
2393 select * from t2 where a = 30;
2394 a b c
2395 30 30 30
2396 select * from t2 where a = 40;
2397 a b c
2398 40 40 40
2399 select * from t2 where a = 50;
2400 a b c
2401 50 50 50
2402 select * from t2 where b = 20;
2403 a b c
2404 20 20 20
2405 select * from t2 where b = 30;
2406 a b c
2407 30 30 30
2408 select * from t2 where b = 40;
2409 a b c
2410 40 40 40
2411 select * from t2 where b = 50;
2412 a b c
2413 50 50 50
2414 select * from t3 where a < 20;
2415 a b c
2416 1 1 1
2417 10 10 10
2418 11 11 11
2419 12 12 12
2420 13 13 13
2421 14 14 14
2422 15 15 15
2423 16 16 16
2424 17 17 17
2425 18 18 18
2426 19 19 19
2427 2 2 2
2428 3 3 3
2429 4 4 4
2430 5 5 5
2431 6 6 6
2432 7 7 7
2433 8 8 8
2434 9 9 9
2435 select * from t3 where a = 20;
2436 a b c
2437 20 20 20
2438 select * from t3 where a = 30;
2439 a b c
2440 30 30 30
2441 select * from t3 where a = 40;
2442 a b c
2443 40 40 40
2444 select * from t3 where a = 50;
2445 a b c
2446 50 50 50
2447 select * from t3 where b = 20;
2448 a b c
2449 20 20 20
2450 select * from t3 where b = 30;
2451 a b c
2452 30 30 30
2453 select * from t3 where b = 40;
2454 a b c
2455 40 40 40
2456 select * from t3 where b = 50;
2457 a b c
2458 50 50 50
2459 Table: test.t1
2460 PartitionCount: 5
2461 FragmentCount: 5
2462
2463 b$unique(b) - UniqueHashIndex
2464 FragmentCount: 5
2465 Table: test.t2
2466 PartitionCount: 7
2467 FragmentCount: 7
2468
2469 b$unique(b) - UniqueHashIndex
2470 FragmentCount: 7
2471 Table: test.t3
2472 PartitionCount: 8
2473 FragmentCount: 8
2474
2475 b$unique(b) - UniqueHashIndex
2476 FragmentCount: 8
2477 Table: test.t5
2478 PartitionCount: 3
2479 FragmentCount: 3
2480
2481 b$unique(b) - UniqueHashIndex
2482 FragmentCount: 3
2483 c$unique(c) - UniqueHashIndex
2484 FragmentCount: 3
2485 alter table t5 algorithm=inplace, add partition partitions 1;
2486 -- t5 --
2487 Version: Any
2488 Fragment type: HashMapPartition
2489 K Value: 6
2490 Min load factor: 78
2491 Max load factor: 80
2492 Temporary table: no
2493 Number of attributes: 3
2494 Number of primary keys: 2
2495 Length of frm data: XXX
2496 Max Rows: 0
2497 Row Checksum: 1
2498 Row GCI: 1
2499 SingleUserMode: 0
2500 ForceVarPart: 1
2501 PartitionCount: 4
2502 FragmentCount: 4
2503 PartitionBalance: SPECIFIC
2504 ExtraRowGciBits: 0
2505 ExtraRowAuthorBits: 0
2506 TableStatus: Retrieved
2507 Table options: readbackup
2508 HashMap: HASHMAP-3840-3-4
2509 -- Attributes --
2510 a Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
2511 b Unsigned PRIMARY KEY AT=FIXED ST=MEMORY
2512 c Unsigned NULL AT=FIXED ST=MEMORY
2513 -- Indexes --
2514 PRIMARY KEY(a, b) - UniqueHashIndex
2515 PRIMARY(a, b) - OrderedIndex
2516 b(b) - OrderedIndex
2517 b$unique(b) - UniqueHashIndex
2518 c(c) - OrderedIndex
2519 c$unique(c) - UniqueHashIndex
2520 -- t5/PRIMARY --
2521 Version: Any
2522 Base table: t5
2523 Number of attributes: 2
2524 Logging: 0
2525 Index type: OrderedIndex
2526 Index status: Retrieved
2527 -- Attributes --
2528 a Unsigned NOT NULL AT=FIXED ST=MEMORY
2529 b Unsigned NOT NULL AT=FIXED ST=MEMORY
2530 -- IndexTable XX/PRIMARY --
2531 Version: Any
2532 Fragment type: FragUndefined
2533 K Value: 6
2534 Min load factor: 78
2535 Max load factor: 80
2536 Temporary table: yes
2537 Number of attributes: 3
2538 Number of primary keys: 1
2539 Length of frm data: XXX
2540 Max Rows: 0
2541 Row Checksum: 1
2542 Row GCI: 1
2543 SingleUserMode: 2
2544 ForceVarPart: 0
2545 PartitionCount: 3
2546 FragmentCount: 4
2547 PartitionBalance: FOR_RP_BY_LDM
2548 ExtraRowGciBits: 0
2549 ExtraRowAuthorBits: 0
2550 TableStatus: Retrieved
2551 Table options:
2552 -- Attributes --
2553 a Unsigned NOT NULL DISTRIBUTION KEY AT=FIXED ST=MEMORY
2554 b Unsigned NOT NULL AT=FIXED ST=MEMORY
2555 NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
2556 -- Indexes --
2557 PRIMARY KEY(NDB$TNODE) - UniqueHashIndex
2558
2559 -- t5/b --
2560 Version: Any
2561 Base table: t5
2562 Number of attributes: 1
2563 Logging: 0
2564 Index type: OrderedIndex
2565 Index status: Retrieved
2566 -- Attributes --
2567 b Unsigned NOT NULL AT=FIXED ST=MEMORY
2568 -- IndexTable XX/b --
2569 Version: Any
2570 Fragment type: FragUndefined
2571 K Value: 6
2572 Min load factor: 78
2573 Max load factor: 80
2574 Temporary table: yes
2575 Number of attributes: 2
2576 Number of primary keys: 1
2577 Length of frm data: XXX
2578 Max Rows: 0
2579 Row Checksum: 1
2580 Row GCI: 1
2581 SingleUserMode: 2
2582 ForceVarPart: 0
2583 PartitionCount: 3
2584 FragmentCount: 4
2585 PartitionBalance: FOR_RP_BY_LDM
2586 ExtraRowGciBits: 0
2587 ExtraRowAuthorBits: 0
2588 TableStatus: Retrieved
2589 Table options:
2590 -- Attributes --
2591 b Unsigned NOT NULL AT=FIXED ST=MEMORY
2592 NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
2593 -- Indexes --
2594 PRIMARY KEY(NDB$TNODE) - UniqueHashIndex
2595
2596 -- t5/b$unique --
2597 Version: Any
2598 Base table: t5
2599 Number of attributes: 1
2600 Logging: 1
2601 Index type: UniqueHashIndex
2602 Index status: Retrieved
2603 -- Attributes --
2604 b Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
2605 -- IndexTable XX/b$unique --
2606 Version: Any
2607 Fragment type: HashMapPartition
2608 K Value: 6
2609 Min load factor: 78
2610 Max load factor: 80
2611 Temporary table: no
2612 Number of attributes: 2
2613 Number of primary keys: 1
2614 Length of frm data: XXX
2615 Max Rows: 0
2616 Row Checksum: 1
2617 Row GCI: 1
2618 SingleUserMode: 2
2619 ForceVarPart: 0
2620 PartitionCount: 4
2621 FragmentCount: 4
2622 PartitionBalance: SPECIFIC
2623 ExtraRowGciBits: 0
2624 ExtraRowAuthorBits: 0
2625 TableStatus: Retrieved
2626 Table options: readbackup
2627 HashMap: HASHMAP-3840-3-4
2628 -- Attributes --
2629 b Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
2630 NDB$PK Unsigned [3] NOT NULL AT=FIXED ST=MEMORY
2631 -- Indexes --
2632 PRIMARY KEY(b) - UniqueHashIndex
2633
2634 -- t5/c --
2635 Version: Any
2636 Base table: t5
2637 Number of attributes: 1
2638 Logging: 0
2639 Index type: OrderedIndex
2640 Index status: Retrieved
2641 -- Attributes --
2642 c Unsigned NULL AT=FIXED ST=MEMORY
2643 -- IndexTable XX/c --
2644 Version: Any
2645 Fragment type: FragUndefined
2646 K Value: 6
2647 Min load factor: 78
2648 Max load factor: 80
2649 Temporary table: yes
2650 Number of attributes: 2
2651 Number of primary keys: 1
2652 Length of frm data: XXX
2653 Max Rows: 0
2654 Row Checksum: 1
2655 Row GCI: 1
2656 SingleUserMode: 2
2657 ForceVarPart: 0
2658 PartitionCount: 3
2659 FragmentCount: 4
2660 PartitionBalance: FOR_RP_BY_LDM
2661 ExtraRowGciBits: 0
2662 ExtraRowAuthorBits: 0
2663 TableStatus: Retrieved
2664 Table options:
2665 -- Attributes --
2666 c Unsigned NULL AT=FIXED ST=MEMORY
2667 NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
2668 -- Indexes --
2669 PRIMARY KEY(NDB$TNODE) - UniqueHashIndex
2670
2671 -- t5/c$unique --
2672 Version: Any
2673 Base table: t5
2674 Number of attributes: 1
2675 Logging: 1
2676 Index type: UniqueHashIndex
2677 Index status: Retrieved
2678 -- Attributes --
2679 c Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
2680 -- IndexTable XX/c$unique --
2681 Version: Any
2682 Fragment type: HashMapPartition
2683 K Value: 6
2684 Min load factor: 78
2685 Max load factor: 80
2686 Temporary table: no
2687 Number of attributes: 2
2688 Number of primary keys: 1
2689 Length of frm data: XXX
2690 Max Rows: 0
2691 Row Checksum: 1
2692 Row GCI: 1
2693 SingleUserMode: 2
2694 ForceVarPart: 0
2695 PartitionCount: 4
2696 FragmentCount: 4
2697 PartitionBalance: SPECIFIC
2698 ExtraRowGciBits: 0
2699 ExtraRowAuthorBits: 0
2700 TableStatus: Retrieved
2701 Table options: readbackup
2702 HashMap: HASHMAP-3840-3-4
2703 -- Attributes --
2704 c Unsigned PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
2705 NDB$PK Unsigned [3] NOT NULL AT=FIXED ST=MEMORY
2706 -- Indexes --
2707 PRIMARY KEY(c) - UniqueHashIndex
2708
2709 drop table t1,t2,t3,t5;
2710 Bug 33523991 Ndb online reorg : Scan count verification
2711 Scan count issue on complete phase of reorg
2712 create table t1 (a int primary key, b int, c int, d int, unique(b), unique(c)) engine=ndb;
2713 Populate some data
2714 insert into t1 values (1,1,1,1);
2715 insert into t1 select a+1, b+1, c+1, d+1 from t1;
2716 insert into t1 select a+2, b+2, c+2, d+2 from t1;
2717 insert into t1 select a+4, b+4, c+4, d+4 from t1;
2718 insert into t1 select a+8, b+8, c+8, d+8 from t1;
2719 insert into t1 select a+16, b+16, c+16, d+16 from t1;
2720 insert into t1 select a+32, b+32, c+32, d+32 from t1;
2721 insert into t1 select a+64, b+64, c+64, d+64 from t1;
2722 insert into t1 select a+128, b+128, c+128, d+128 from t1;
2723 insert into t1 select a+256, b+256, c+256, d+256 from t1;
2724 insert into t1 select a+512, b+512, c+512, d+512 from t1;
2725 insert into t1 select a+1024, b+1024, c+1024, d+1024 from t1;
2726 insert into t1 select a+2048, b+2048, c+2048, d+2048 from t1;
2727 create procedure scans (max_iterations int)
2728 sp: begin
2729 DECLARE sum_d int;
2730 set @x=0;
2731 repeat
2732 select sum(d) into sum_d from t1;
2733 set @x = @x + 1;
2734 if sum_d = 0
2735 then
2736 leave sp;
2737 end if;
2738 until @x=max_iterations
2739 end repeat;
2740 end%
2741 call scans(20000);;
2742 alter table t1 algorithm=inplace, add partition partitions 1;
2743 Alter ok, run again
2744 alter table t1 algorithm=inplace, add partition partitions 1;
2745 Second alter ok, finish scans
2746 select sum(d) into @sum_d from t1;
2747 insert into t1 values (20000,20000,20000, 0 - @sum_d);
2748 drop procedure scans;
2749 drop table t1;
2750 alter tablespace ts1 drop datafile 'datafile.dat';
2751 drop tablespace ts1;
2752 drop logfile group lg1 engine = ndb;