2
DROP TABLE IF EXISTS t1;
4
CREATE TABLE t1 (c1 TINYINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 2;
6
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
7
--replace_result $ENGINE ENGINE
8
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
9
CREATE TABLE t1 (c1 SMALLINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 2;
11
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
12
--replace_result $ENGINE ENGINE
13
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
14
CREATE TABLE t1 (c1 MEDIUMINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 2;
16
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
17
--replace_result $ENGINE ENGINE
18
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
19
CREATE TABLE t1 (c1 INT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 2;
21
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
22
--replace_result $ENGINE ENGINE
23
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
24
CREATE TABLE t1 (c1 INTEGER NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 2;
26
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
27
--replace_result $ENGINE ENGINE
28
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
29
CREATE TABLE t1 (c1 BIGINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 2;
31
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
32
--replace_result $ENGINE ENGINE
33
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
34
CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 2;
36
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
37
--replace_result $ENGINE ENGINE
38
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
39
CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 2;
41
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
42
--replace_result $ENGINE ENGINE
43
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
44
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 2;
46
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
47
--replace_result $ENGINE ENGINE
48
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
49
CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 2;
51
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
52
--replace_result $ENGINE ENGINE
53
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
54
CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 2;
56
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
57
--replace_result $ENGINE ENGINE
58
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
59
CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 2;
61
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
62
--replace_result $ENGINE ENGINE
63
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
64
CREATE TABLE t1 (c1 TINYINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 4;
66
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
67
--replace_result $ENGINE ENGINE
68
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
69
CREATE TABLE t1 (c1 SMALLINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 4;
71
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
72
--replace_result $ENGINE ENGINE
73
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
74
CREATE TABLE t1 (c1 MEDIUMINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 4;
76
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
77
--replace_result $ENGINE ENGINE
78
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
79
CREATE TABLE t1 (c1 INT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 4;
81
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
82
--replace_result $ENGINE ENGINE
83
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
84
CREATE TABLE t1 (c1 INTEGER NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 4;
86
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
87
--replace_result $ENGINE ENGINE
88
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
89
CREATE TABLE t1 (c1 BIGINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 4;
91
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
92
--replace_result $ENGINE ENGINE
93
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
94
CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 4;
96
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
97
--replace_result $ENGINE ENGINE
98
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
99
CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 4;
101
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
102
--replace_result $ENGINE ENGINE
103
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
104
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 4;
106
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
107
--replace_result $ENGINE ENGINE
108
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
109
CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 4;
111
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; DROP TABLE t1; SHOW TABLES;
114
CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 4;
116
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
117
--replace_result $ENGINE ENGINE
118
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
119
CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 4;
121
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
122
--replace_result $ENGINE ENGINE
123
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
124
CREATE TABLE t1 (c1 TINYINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 5;
126
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
127
--replace_result $ENGINE ENGINE
128
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
129
CREATE TABLE t1 (c1 SMALLINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 5;
131
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
132
--replace_result $ENGINE ENGINE
133
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
134
CREATE TABLE t1 (c1 MEDIUMINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 5;
136
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
137
--replace_result $ENGINE ENGINE
138
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
139
CREATE TABLE t1 (c1 INT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 5;
141
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
142
--replace_result $ENGINE ENGINE
143
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
144
CREATE TABLE t1 (c1 INTEGER NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 5;
146
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
147
--replace_result $ENGINE ENGINE
148
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
149
CREATE TABLE t1 (c1 BIGINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 5;
151
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
152
--replace_result $ENGINE ENGINE
153
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
154
CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 5;
156
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; DROP TABLE t1; SHOW TABLES;
159
CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 5;
161
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
162
--replace_result $ENGINE ENGINE
163
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
164
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 5;
166
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
167
--replace_result $ENGINE ENGINE
168
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
169
CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 5;
171
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
172
--replace_result $ENGINE ENGINE
173
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
174
CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 5;
176
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
177
--replace_result $ENGINE ENGINE
178
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
179
CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 5;
181
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
182
--replace_result $ENGINE ENGINE
183
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
184
CREATE TABLE t1 (c1 TINYINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 99;
186
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
187
--replace_result $ENGINE ENGINE
188
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
189
CREATE TABLE t1 (c1 SMALLINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 99;
191
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
192
--replace_result $ENGINE ENGINE
193
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
194
CREATE TABLE t1 (c1 MEDIUMINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 99;
196
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
197
--replace_result $ENGINE ENGINE
198
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
199
CREATE TABLE t1 (c1 INT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 99;
201
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; DROP TABLE t1; SHOW TABLES;
204
CREATE TABLE t1 (c1 INTEGER NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 99;
206
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
207
--replace_result $ENGINE ENGINE
208
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
209
CREATE TABLE t1 (c1 BIGINT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 99;
211
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
212
--replace_result $ENGINE ENGINE
213
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
214
CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 99;
216
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
217
--replace_result $ENGINE ENGINE
218
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
219
CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 99;
221
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
222
--replace_result $ENGINE ENGINE
223
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
224
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 99;
226
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
227
--replace_result $ENGINE ENGINE
228
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
229
CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 99;
231
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
232
--replace_result $ENGINE ENGINE
233
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
234
CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 99;
236
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
237
--replace_result $ENGINE ENGINE
238
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
239
CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY LINEAR KEY(c1) PARTITIONS 99;
241
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
242
--replace_result $ENGINE ENGINE
243
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;