2
DROP TABLE IF EXISTS t1;
4
CREATE TABLE t1 (c1 TINYINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
5
INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
6
SELECT * FROM t1 ORDER BY c1;
8
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
9
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
11
ALTER TABLE t1 REMOVE PARTITIONING;
12
SELECT * FROM t1 ORDER BY c1;
14
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
15
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
16
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
17
CREATE TABLE t1 (c1 SMALLINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
18
INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
19
SELECT * FROM t1 ORDER BY c1;
21
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
22
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
24
ALTER TABLE t1 REMOVE PARTITIONING;
25
SELECT * FROM t1 ORDER BY c1;
27
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
28
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
29
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
30
CREATE TABLE t1 (c1 MEDIUMINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
31
INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
32
SELECT * FROM t1 ORDER BY c1;
34
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
35
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
37
ALTER TABLE t1 REMOVE PARTITIONING;
38
SELECT * FROM t1 ORDER BY c1;
40
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
41
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
42
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
43
CREATE TABLE t1 (c1 INT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
44
INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
45
SELECT * FROM t1 ORDER BY c1;
47
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
48
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
50
ALTER TABLE t1 REMOVE PARTITIONING;
51
SELECT * FROM t1 ORDER BY c1;
53
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
54
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
55
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
56
CREATE TABLE t1 (c1 INTEGER NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
57
INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
58
SELECT * FROM t1 ORDER BY c1;
60
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
61
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
63
ALTER TABLE t1 REMOVE PARTITIONING;
64
SELECT * FROM t1 ORDER BY c1;
66
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
67
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
68
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
69
CREATE TABLE t1 (c1 BIGINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
70
INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
71
SELECT * FROM t1 ORDER BY c1;
73
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
74
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
76
ALTER TABLE t1 REMOVE PARTITIONING;
77
SELECT * FROM t1 ORDER BY c1;
79
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
80
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
81
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
82
CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
83
INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
84
SELECT * FROM t1 ORDER BY c1;
86
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
87
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
89
ALTER TABLE t1 REMOVE PARTITIONING;
90
SELECT * FROM t1 ORDER BY c1;
92
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
93
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
94
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
95
CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
96
INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
97
SELECT * FROM t1 ORDER BY c1;
99
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
100
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
101
SHOW CREATE TABLE t1;
102
ALTER TABLE t1 REMOVE PARTITIONING;
103
SELECT * FROM t1 ORDER BY c1;
105
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
106
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
107
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
108
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
109
INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
110
SELECT * FROM t1 ORDER BY c1;
112
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
113
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
114
SHOW CREATE TABLE t1;
115
ALTER TABLE t1 REMOVE PARTITIONING;
116
SELECT * FROM t1 ORDER BY c1;
118
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
119
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
120
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
121
CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
122
INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
123
SELECT * FROM t1 ORDER BY c1;
125
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
126
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
127
SHOW CREATE TABLE t1;
128
ALTER TABLE t1 REMOVE PARTITIONING;
129
SELECT * FROM t1 ORDER BY c1;
131
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
132
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
133
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
134
CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
135
INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
136
SELECT * FROM t1 ORDER BY c1;
138
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
139
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
140
SHOW CREATE TABLE t1;
141
ALTER TABLE t1 REMOVE PARTITIONING;
142
SELECT * FROM t1 ORDER BY c1;
144
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
145
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
146
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
147
CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1);
148
INSERT INTO t1 VALUES(0,'abc'),(100,'abc'),(200,'abc'),(300,'abc'),(400,'abc');
149
SELECT * FROM t1 ORDER BY c1;
151
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
152
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
153
SHOW CREATE TABLE t1;
154
ALTER TABLE t1 REMOVE PARTITIONING;
155
SELECT * FROM t1 ORDER BY c1;
157
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
158
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
159
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;