Debian Codegraph @

mysql-test/suite/engines/funcs/t/tc_partition_reorg_hash_key.test

raw
1 CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
2 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
3 SELECT * FROM t1 ORDER BY c1;
4
5
6
7 SHOW TABLES;
8 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
9
10
11
12 --replace_result $ENGINE ENGINE
13 SHOW CREATE TABLE t1;
14 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
15 SELECT * FROM t1 ORDER BY c1;
16
17
18
19 SHOW TABLES;
20 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
21
22
23
24 --replace_result $ENGINE ENGINE
25 SHOW CREATE TABLE t1;
26 ALTER TABLE t1 COALESCE PARTITION 18;
27
28
29
30
31 SHOW TABLES;
32 SELECT * FROM t1 ORDER BY c1;
33 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
34
35
36
37 --replace_result $ENGINE ENGINE
38 SHOW CREATE TABLE t1;
39
40
41
42 --replace_result $ENGINE ENGINE
43 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
44 CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
45 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
46 SELECT * FROM t1 ORDER BY c1;
47
48
49
50 SHOW TABLES;
51 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
52
53
54
55 --replace_result $ENGINE ENGINE
56 SHOW CREATE TABLE t1;
57 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
58 SELECT * FROM t1 ORDER BY c1;
59
60
61
62 SHOW TABLES;
63 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
64
65
66
67 --replace_result $ENGINE ENGINE
68 SHOW CREATE TABLE t1;
69 ALTER TABLE t1 COALESCE PARTITION 18;
70 SELECT * FROM t1 ORDER BY c1;
71
72
73
74 SHOW TABLES;
75 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
76
77
78
79
80 --replace_result $ENGINE ENGINE
81 SHOW CREATE TABLE t1;
82
83
84
85 --replace_result $ENGINE ENGINE
86 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
87 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
88 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
89 SELECT * FROM t1 ORDER BY c1;
90
91
92
93 SHOW TABLES;
94 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
95
96
97
98
99 --replace_result $ENGINE ENGINE
100 SHOW CREATE TABLE t1;
101 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
102 SELECT * FROM t1 ORDER BY c1;
103
104
105
106 SHOW TABLES;
107 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
108
109
110
111
112 --replace_result $ENGINE ENGINE
113 SHOW CREATE TABLE t1;
114 ALTER TABLE t1 COALESCE PARTITION 18;
115 SELECT * FROM t1 ORDER BY c1;
116
117
118
119 SHOW TABLES;
120 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
121
122
123
124
125 --replace_result $ENGINE ENGINE
126 SHOW CREATE TABLE t1;
127
128
129
130 --replace_result $ENGINE ENGINE
131 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
132 CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
133 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
134 SELECT * FROM t1 ORDER BY c1;
135
136
137
138 SHOW TABLES;
139 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
140
141
142
143
144 --replace_result $ENGINE ENGINE
145 SHOW CREATE TABLE t1;
146 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
147 SELECT * FROM t1 ORDER BY c1;
148
149
150
151 SHOW TABLES;
152 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
153
154
155
156
157 --replace_result $ENGINE ENGINE
158 SHOW CREATE TABLE t1;
159 ALTER TABLE t1 COALESCE PARTITION 18;
160 SELECT * FROM t1 ORDER BY c1;
161
162
163
164 SHOW TABLES;
165 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
166
167
168
169
170 --replace_result $ENGINE ENGINE
171 SHOW CREATE TABLE t1;
172
173
174
175 --replace_result $ENGINE ENGINE
176 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
177 CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
178 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
179 SELECT * FROM t1 ORDER BY c1;
180
181
182
183 SHOW TABLES;
184 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
185
186
187
188
189 --replace_result $ENGINE ENGINE
190 SHOW CREATE TABLE t1;
191 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
192 SELECT * FROM t1 ORDER BY c1;
193
194
195
196 SHOW TABLES;
197 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
198
199
200
201
202 --replace_result $ENGINE ENGINE
203 SHOW CREATE TABLE t1;
204 ALTER TABLE t1 COALESCE PARTITION 18;
205 SELECT * FROM t1 ORDER BY c1;
206
207
208
209 SHOW TABLES;
210 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
211
212
213
214
215 --replace_result $ENGINE ENGINE
216 SHOW CREATE TABLE t1;
217
218
219
220 --replace_result $ENGINE ENGINE
221 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
222 CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
223 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
224 SELECT * FROM t1 ORDER BY c1;
225
226
227
228 SHOW TABLES;
229 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
230
231
232
233
234 --replace_result $ENGINE ENGINE
235 SHOW CREATE TABLE t1;
236 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
237 SELECT * FROM t1 ORDER BY c1;
238
239
240
241 SHOW TABLES;
242 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
243
244
245
246
247 --replace_result $ENGINE ENGINE
248 SHOW CREATE TABLE t1;
249 ALTER TABLE t1 COALESCE PARTITION 18;
250 SELECT * FROM t1 ORDER BY c1;
251
252
253
254 SHOW TABLES;
255 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
256
257
258
259
260 --replace_result $ENGINE ENGINE
261 SHOW CREATE TABLE t1;
262
263
264
265 --replace_result $ENGINE ENGINE
266 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
267 CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY KEY(c1) PARTITIONS 10;
268 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
269 SELECT * FROM t1 ORDER BY c1;
270
271
272
273 SHOW TABLES;
274 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
275
276
277
278
279 --replace_result $ENGINE ENGINE
280 SHOW CREATE TABLE t1;
281 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
282 SELECT * FROM t1 ORDER BY c1;
283
284
285
286 SHOW TABLES;
287 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
288
289
290
291
292 --replace_result $ENGINE ENGINE
293 SHOW CREATE TABLE t1;
294 ALTER TABLE t1 COALESCE PARTITION 18;
295 SELECT * FROM t1 ORDER BY c1;
296
297
298
299 SHOW TABLES;
300 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
301
302
303
304
305 --replace_result $ENGINE ENGINE
306 SHOW CREATE TABLE t1;
307
308
309
310 --replace_result $ENGINE ENGINE
311 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
312 CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY KEY(c1) PARTITIONS 10;
313 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
314 SELECT * FROM t1 ORDER BY c1;
315
316
317
318 SHOW TABLES;
319 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
320
321
322
323
324 --replace_result $ENGINE ENGINE
325 SHOW CREATE TABLE t1;
326 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
327 SELECT * FROM t1 ORDER BY c1;
328
329
330
331 SHOW TABLES;
332 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
333
334
335
336
337 --replace_result $ENGINE ENGINE
338 SHOW CREATE TABLE t1;
339 ALTER TABLE t1 COALESCE PARTITION 18;
340 SELECT * FROM t1 ORDER BY c1;
341
342
343
344 SHOW TABLES;
345 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
346
347
348
349
350 --replace_result $ENGINE ENGINE
351 SHOW CREATE TABLE t1;
352
353
354
355 --replace_result $ENGINE ENGINE
356 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
357 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY KEY(c1) PARTITIONS 10;
358 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
359 SELECT * FROM t1 ORDER BY c1;
360
361
362
363 SHOW TABLES;
364 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
365
366
367
368
369 --replace_result $ENGINE ENGINE
370 SHOW CREATE TABLE t1;
371 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
372 SELECT * FROM t1 ORDER BY c1;
373
374
375
376 SHOW TABLES;
377 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
378
379
380
381
382 --replace_result $ENGINE ENGINE
383 SHOW CREATE TABLE t1;
384 ALTER TABLE t1 COALESCE PARTITION 18;
385 SELECT * FROM t1 ORDER BY c1;
386
387
388
389 SHOW TABLES;
390 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
391
392
393
394
395 --replace_result $ENGINE ENGINE
396 SHOW CREATE TABLE t1;
397
398
399
400 --replace_result $ENGINE ENGINE
401 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
402 CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY KEY(c1) PARTITIONS 10;
403 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
404 SELECT * FROM t1 ORDER BY c1;
405
406
407
408 SHOW TABLES;
409 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
410
411
412
413
414 --replace_result $ENGINE ENGINE
415 SHOW CREATE TABLE t1;
416 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
417 SELECT * FROM t1 ORDER BY c1;
418
419
420
421 SHOW TABLES;
422 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
423
424
425
426
427 --replace_result $ENGINE ENGINE
428 SHOW CREATE TABLE t1;
429 ALTER TABLE t1 COALESCE PARTITION 18;
430 SELECT * FROM t1 ORDER BY c1;
431
432
433
434 SHOW TABLES;
435 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
436
437
438
439
440 --replace_result $ENGINE ENGINE
441 SHOW CREATE TABLE t1;
442
443
444
445 --replace_result $ENGINE ENGINE
446 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
447 CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY KEY(c1) PARTITIONS 10;
448 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
449 SELECT * FROM t1 ORDER BY c1;
450
451
452
453 SHOW TABLES;
454 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
455
456
457
458
459 --replace_result $ENGINE ENGINE
460 SHOW CREATE TABLE t1;
461 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
462 SELECT * FROM t1 ORDER BY c1;
463
464
465
466 SHOW TABLES;
467 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
468
469
470
471
472 --replace_result $ENGINE ENGINE
473 SHOW CREATE TABLE t1;
474 ALTER TABLE t1 COALESCE PARTITION 18;
475 SELECT * FROM t1 ORDER BY c1;
476
477
478
479 SHOW TABLES;
480 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
481
482
483
484
485 --replace_result $ENGINE ENGINE
486 SHOW CREATE TABLE t1;
487
488
489
490 --replace_result $ENGINE ENGINE
491 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
492 CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY KEY(c1) PARTITIONS 10;
493 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
494 SELECT * FROM t1 ORDER BY c1;
495
496
497
498 SHOW TABLES;
499 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
500
501
502
503
504 --replace_result $ENGINE ENGINE
505 SHOW CREATE TABLE t1;
506 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
507 SELECT * FROM t1 ORDER BY c1;
508
509
510
511 SHOW TABLES;
512 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
513
514
515
516
517 --replace_result $ENGINE ENGINE
518 SHOW CREATE TABLE t1;
519 ALTER TABLE t1 COALESCE PARTITION 18;
520 SELECT * FROM t1 ORDER BY c1;
521
522
523
524 SHOW TABLES;
525 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
526
527
528
529
530 --replace_result $ENGINE ENGINE
531 SHOW CREATE TABLE t1;
532
533
534
535 --replace_result $ENGINE ENGINE
536 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
537 CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 10;
538 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
539 SELECT * FROM t1 ORDER BY c1;
540
541
542
543 SHOW TABLES;
544 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
545
546
547
548
549 --replace_result $ENGINE ENGINE
550 SHOW CREATE TABLE t1;
551 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
552 SELECT * FROM t1 ORDER BY c1;
553
554
555
556 SHOW TABLES;
557 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
558
559
560
561
562 --replace_result $ENGINE ENGINE
563 SHOW CREATE TABLE t1;
564 ALTER TABLE t1 COALESCE PARTITION 18;
565 SELECT * FROM t1 ORDER BY c1;
566
567
568
569 SHOW TABLES;
570 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
571
572
573
574
575 --replace_result $ENGINE ENGINE
576 SHOW CREATE TABLE t1;
577
578
579
580 --replace_result $ENGINE ENGINE
581 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
582 CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 10;
583 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
584 SELECT * FROM t1 ORDER BY c1;
585
586
587
588 SHOW TABLES;
589 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
590
591
592
593
594 --replace_result $ENGINE ENGINE
595 SHOW CREATE TABLE t1;
596 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
597 SELECT * FROM t1 ORDER BY c1;
598
599
600
601 SHOW TABLES;
602 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
603
604
605
606
607 --replace_result $ENGINE ENGINE
608 SHOW CREATE TABLE t1;
609 ALTER TABLE t1 COALESCE PARTITION 18;
610 SELECT * FROM t1 ORDER BY c1;
611
612
613
614 SHOW TABLES;
615 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
616
617
618
619
620 --replace_result $ENGINE ENGINE
621 SHOW CREATE TABLE t1;
622
623
624
625 --replace_result $ENGINE ENGINE
626 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
627 CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 10;
628 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
629 SELECT * FROM t1 ORDER BY c1;
630
631
632
633 SHOW TABLES;
634 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
635
636
637
638
639 --replace_result $ENGINE ENGINE
640 SHOW CREATE TABLE t1;
641 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
642 SELECT * FROM t1 ORDER BY c1;
643
644
645
646 SHOW TABLES;
647 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
648
649
650
651
652 --replace_result $ENGINE ENGINE
653 SHOW CREATE TABLE t1;
654 ALTER TABLE t1 COALESCE PARTITION 18;
655 SELECT * FROM t1 ORDER BY c1;
656
657
658
659 SHOW TABLES;
660 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
661
662
663
664
665 --replace_result $ENGINE ENGINE
666 SHOW CREATE TABLE t1;
667
668
669
670 --replace_result $ENGINE ENGINE
671 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
672 CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 10;
673 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
674 SELECT * FROM t1 ORDER BY c1;
675
676
677
678 SHOW TABLES;
679 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
680
681
682
683
684 --replace_result $ENGINE ENGINE
685 SHOW CREATE TABLE t1;
686 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
687 SELECT * FROM t1 ORDER BY c1;
688
689
690
691 SHOW TABLES;
692 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
693
694
695
696
697 --replace_result $ENGINE ENGINE
698 SHOW CREATE TABLE t1;
699 ALTER TABLE t1 COALESCE PARTITION 18;
700 SELECT * FROM t1 ORDER BY c1;
701
702
703
704 SHOW TABLES;
705 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
706
707
708
709
710 --replace_result $ENGINE ENGINE
711 SHOW CREATE TABLE t1;
712
713
714
715 --replace_result $ENGINE ENGINE
716 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
717 CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 10;
718 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
719 SELECT * FROM t1 ORDER BY c1;
720
721
722
723 SHOW TABLES;
724 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
725
726
727
728
729 --replace_result $ENGINE ENGINE
730 SHOW CREATE TABLE t1;
731 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
732 SELECT * FROM t1 ORDER BY c1;
733
734
735
736 SHOW TABLES;
737 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
738
739
740
741
742 --replace_result $ENGINE ENGINE
743 SHOW CREATE TABLE t1;
744 ALTER TABLE t1 COALESCE PARTITION 18;
745 SELECT * FROM t1 ORDER BY c1;
746
747
748
749 SHOW TABLES;
750 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
751
752
753
754
755 --replace_result $ENGINE ENGINE
756 SHOW CREATE TABLE t1;
757
758
759
760 --replace_result $ENGINE ENGINE
761 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
762 CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 10;
763 INSERT INTO t1 VALUES(0,'abc'),(5,'abc'),(10,'abc'),(15,'abc'),(20,'abc'),(25,'abc'),(30,'abc'),(35,'abc');
764 SELECT * FROM t1 ORDER BY c1;
765
766
767
768 SHOW TABLES;
769 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
770
771
772
773
774 --replace_result $ENGINE ENGINE
775 SHOW CREATE TABLE t1;
776 ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
777 SELECT * FROM t1 ORDER BY c1;
778
779
780
781 SHOW TABLES;
782 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
783
784
785
786
787 --replace_result $ENGINE ENGINE
788 SHOW CREATE TABLE t1;
789 ALTER TABLE t1 COALESCE PARTITION 18;
790 SELECT * FROM t1 ORDER BY c1;
791
792
793
794 SHOW TABLES;
795 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
796
797
798
799
800 --replace_result $ENGINE ENGINE
801 SHOW CREATE TABLE t1;
802
803
804
805 --replace_result $ENGINE ENGINE
806 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
807