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;
8
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
12
--replace_result $ENGINE ENGINE
14
ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
15
SELECT * FROM t1 ORDER BY c1;
20
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
24
--replace_result $ENGINE ENGINE
26
ALTER TABLE t1 COALESCE PARTITION 18;
32
SELECT * FROM t1 ORDER BY c1;
33
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
37
--replace_result $ENGINE ENGINE
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;
51
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
55
--replace_result $ENGINE ENGINE
57
ALTER TABLE t1 ADD PARTITION PARTITIONS 10;
58
SELECT * FROM t1 ORDER BY c1;
63
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
67
--replace_result $ENGINE ENGINE
69
ALTER TABLE t1 COALESCE PARTITION 18;
70
SELECT * FROM t1 ORDER BY c1;
75
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
80
--replace_result $ENGINE ENGINE
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;
94
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
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;
107
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
112
--replace_result $ENGINE ENGINE
113
SHOW CREATE TABLE t1;
114
ALTER TABLE t1 COALESCE PARTITION 18;
115
SELECT * FROM t1 ORDER BY c1;
120
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
125
--replace_result $ENGINE ENGINE
126
SHOW CREATE TABLE t1;
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;
139
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
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;
152
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
157
--replace_result $ENGINE ENGINE
158
SHOW CREATE TABLE t1;
159
ALTER TABLE t1 COALESCE PARTITION 18;
160
SELECT * FROM t1 ORDER BY c1;
165
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
170
--replace_result $ENGINE ENGINE
171
SHOW CREATE TABLE t1;
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;
184
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
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;
197
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
202
--replace_result $ENGINE ENGINE
203
SHOW CREATE TABLE t1;
204
ALTER TABLE t1 COALESCE PARTITION 18;
205
SELECT * FROM t1 ORDER BY c1;
210
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
215
--replace_result $ENGINE ENGINE
216
SHOW CREATE TABLE t1;
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;
229
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
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;
242
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
247
--replace_result $ENGINE ENGINE
248
SHOW CREATE TABLE t1;
249
ALTER TABLE t1 COALESCE PARTITION 18;
250
SELECT * FROM t1 ORDER BY c1;
255
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
260
--replace_result $ENGINE ENGINE
261
SHOW CREATE TABLE t1;
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;
274
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
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;
287
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
292
--replace_result $ENGINE ENGINE
293
SHOW CREATE TABLE t1;
294
ALTER TABLE t1 COALESCE PARTITION 18;
295
SELECT * FROM t1 ORDER BY c1;
300
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
305
--replace_result $ENGINE ENGINE
306
SHOW CREATE TABLE t1;
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;
319
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
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;
332
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
337
--replace_result $ENGINE ENGINE
338
SHOW CREATE TABLE t1;
339
ALTER TABLE t1 COALESCE PARTITION 18;
340
SELECT * FROM t1 ORDER BY c1;
345
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
350
--replace_result $ENGINE ENGINE
351
SHOW CREATE TABLE t1;
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;
364
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
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;
377
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
382
--replace_result $ENGINE ENGINE
383
SHOW CREATE TABLE t1;
384
ALTER TABLE t1 COALESCE PARTITION 18;
385
SELECT * FROM t1 ORDER BY c1;
390
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
395
--replace_result $ENGINE ENGINE
396
SHOW CREATE TABLE t1;
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;
409
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
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;
422
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
427
--replace_result $ENGINE ENGINE
428
SHOW CREATE TABLE t1;
429
ALTER TABLE t1 COALESCE PARTITION 18;
430
SELECT * FROM t1 ORDER BY c1;
435
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
440
--replace_result $ENGINE ENGINE
441
SHOW CREATE TABLE t1;
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;
454
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
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;
467
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
472
--replace_result $ENGINE ENGINE
473
SHOW CREATE TABLE t1;
474
ALTER TABLE t1 COALESCE PARTITION 18;
475
SELECT * FROM t1 ORDER BY c1;
480
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
485
--replace_result $ENGINE ENGINE
486
SHOW CREATE TABLE t1;
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;
499
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
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;
512
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
517
--replace_result $ENGINE ENGINE
518
SHOW CREATE TABLE t1;
519
ALTER TABLE t1 COALESCE PARTITION 18;
520
SELECT * FROM t1 ORDER BY c1;
525
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
530
--replace_result $ENGINE ENGINE
531
SHOW CREATE TABLE t1;
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;
544
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
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;
557
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
562
--replace_result $ENGINE ENGINE
563
SHOW CREATE TABLE t1;
564
ALTER TABLE t1 COALESCE PARTITION 18;
565
SELECT * FROM t1 ORDER BY c1;
570
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
575
--replace_result $ENGINE ENGINE
576
SHOW CREATE TABLE t1;
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;
589
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
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;
602
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
607
--replace_result $ENGINE ENGINE
608
SHOW CREATE TABLE t1;
609
ALTER TABLE t1 COALESCE PARTITION 18;
610
SELECT * FROM t1 ORDER BY c1;
615
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
620
--replace_result $ENGINE ENGINE
621
SHOW CREATE TABLE t1;
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;
634
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
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;
647
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
652
--replace_result $ENGINE ENGINE
653
SHOW CREATE TABLE t1;
654
ALTER TABLE t1 COALESCE PARTITION 18;
655
SELECT * FROM t1 ORDER BY c1;
660
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
665
--replace_result $ENGINE ENGINE
666
SHOW CREATE TABLE t1;
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;
679
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
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;
692
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
697
--replace_result $ENGINE ENGINE
698
SHOW CREATE TABLE t1;
699
ALTER TABLE t1 COALESCE PARTITION 18;
700
SELECT * FROM t1 ORDER BY c1;
705
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
710
--replace_result $ENGINE ENGINE
711
SHOW CREATE TABLE t1;
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;
724
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
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;
737
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
742
--replace_result $ENGINE ENGINE
743
SHOW CREATE TABLE t1;
744
ALTER TABLE t1 COALESCE PARTITION 18;
745
SELECT * FROM t1 ORDER BY c1;
750
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
755
--replace_result $ENGINE ENGINE
756
SHOW CREATE TABLE t1;
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;
769
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
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;
782
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
787
--replace_result $ENGINE ENGINE
788
SHOW CREATE TABLE t1;
789
ALTER TABLE t1 COALESCE PARTITION 18;
790
SELECT * FROM t1 ORDER BY c1;
795
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
800
--replace_result $ENGINE ENGINE
801
SHOW CREATE TABLE t1;
805
--replace_result $ENGINE ENGINE
806
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;