2
DROP TABLE IF EXISTS t5;
4
CREATE TABLE t5(c1 CHAR(10) NULL);
6
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
7
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
9
ALTER TABLE t5 ADD c2 CHAR(20) NULL FIRST;
11
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
12
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
13
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
14
CREATE TABLE t5(c1 VARCHAR(10) NULL);
16
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
17
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
19
ALTER TABLE t5 ADD c2 CHAR(20) NULL FIRST;
21
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
22
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
23
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
24
CREATE TABLE t5(c1 BINARY(10) NULL);
26
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
27
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
29
ALTER TABLE t5 ADD c2 CHAR(20) NULL FIRST;
31
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
32
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
33
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
34
CREATE TABLE t5(c1 VARBINARY(10) NULL);
36
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
37
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
39
ALTER TABLE t5 ADD c2 CHAR(20) NULL FIRST;
41
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
42
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
43
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
44
CREATE TABLE t5(c1 CHAR(10) NOT NULL);
46
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
47
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
49
ALTER TABLE t5 ADD c2 CHAR(20) NOT NULL FIRST;
51
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
52
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
53
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
54
CREATE TABLE t5(c1 VARCHAR(10) NOT NULL);
56
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
57
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
59
ALTER TABLE t5 ADD c2 CHAR(20) NOT NULL FIRST;
61
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
62
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
63
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
64
CREATE TABLE t5(c1 BINARY(10) NOT NULL);
66
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
67
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
69
ALTER TABLE t5 ADD c2 CHAR(20) NOT NULL FIRST;
71
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
72
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
73
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
74
CREATE TABLE t5(c1 VARBINARY(10) NOT NULL);
76
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
77
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
79
ALTER TABLE t5 ADD c2 CHAR(20) NOT NULL FIRST;
81
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
82
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
83
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
84
CREATE TABLE t5(c1 CHAR(10) NULL);
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 t5 ADD c2 VARCHAR(20) NULL FIRST;
91
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
92
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
93
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
94
CREATE TABLE t5(c1 VARCHAR(10) NULL);
96
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
97
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
99
ALTER TABLE t5 ADD c2 VARCHAR(20) NULL FIRST;
101
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
102
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
103
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
104
CREATE TABLE t5(c1 BINARY(10) NULL);
106
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
107
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
108
SHOW CREATE TABLE t5;
109
ALTER TABLE t5 ADD c2 VARCHAR(20) NULL FIRST;
111
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
112
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
113
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
114
CREATE TABLE t5(c1 VARBINARY(10) NULL);
116
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
117
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
118
SHOW CREATE TABLE t5;
119
ALTER TABLE t5 ADD c2 VARCHAR(20) NULL FIRST;
121
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
122
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
123
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
124
CREATE TABLE t5(c1 CHAR(10) NOT NULL);
126
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
127
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
128
SHOW CREATE TABLE t5;
129
ALTER TABLE t5 ADD c2 VARCHAR(20) NOT NULL FIRST;
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 t5; DROP TABLE t5; SHOW TABLES;
134
CREATE TABLE t5(c1 VARCHAR(10) NOT NULL);
136
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
137
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
138
SHOW CREATE TABLE t5;
139
ALTER TABLE t5 ADD c2 VARCHAR(20) NOT NULL FIRST;
141
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
142
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
143
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
144
CREATE TABLE t5(c1 BINARY(10) NOT NULL);
146
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
147
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
148
SHOW CREATE TABLE t5;
149
ALTER TABLE t5 ADD c2 VARCHAR(20) NOT NULL FIRST;
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 t5; DROP TABLE t5; SHOW TABLES;
154
CREATE TABLE t5(c1 VARBINARY(10) NOT NULL);
156
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
157
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
158
SHOW CREATE TABLE t5;
159
ALTER TABLE t5 ADD c2 VARCHAR(20) NOT NULL FIRST;
161
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
162
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
163
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
164
CREATE TABLE t5(c1 CHAR(10) NULL);
166
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
167
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
168
SHOW CREATE TABLE t5;
169
ALTER TABLE t5 ADD c2 BINARY(20) NULL FIRST;
171
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
172
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
173
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
174
CREATE TABLE t5(c1 VARCHAR(10) NULL);
176
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
177
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
178
SHOW CREATE TABLE t5;
179
ALTER TABLE t5 ADD c2 BINARY(20) NULL FIRST;
181
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
182
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
183
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
184
CREATE TABLE t5(c1 BINARY(10) NULL);
186
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
187
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
188
SHOW CREATE TABLE t5;
189
ALTER TABLE t5 ADD c2 BINARY(20) NULL FIRST;
191
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
192
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
193
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
194
CREATE TABLE t5(c1 VARBINARY(10) NULL);
196
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
197
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
198
SHOW CREATE TABLE t5;
199
ALTER TABLE t5 ADD c2 BINARY(20) NULL FIRST;
201
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
202
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
203
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
204
CREATE TABLE t5(c1 CHAR(10) NOT NULL);
206
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
207
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
208
SHOW CREATE TABLE t5;
209
ALTER TABLE t5 ADD c2 BINARY(20) NOT NULL FIRST;
211
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
212
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
213
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
214
CREATE TABLE t5(c1 VARCHAR(10) NOT NULL);
216
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
217
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
218
SHOW CREATE TABLE t5;
219
ALTER TABLE t5 ADD c2 BINARY(20) NOT NULL FIRST;
221
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
222
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
223
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
224
CREATE TABLE t5(c1 BINARY(10) NOT NULL);
226
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
227
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
228
SHOW CREATE TABLE t5;
229
ALTER TABLE t5 ADD c2 BINARY(20) NOT NULL FIRST;
231
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
232
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
233
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
234
CREATE TABLE t5(c1 VARBINARY(10) NOT NULL);
236
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
237
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
238
SHOW CREATE TABLE t5;
239
ALTER TABLE t5 ADD c2 BINARY(20) NOT NULL FIRST;
241
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
242
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
243
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
244
CREATE TABLE t5(c1 CHAR(10) NULL);
246
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
247
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
248
SHOW CREATE TABLE t5;
249
ALTER TABLE t5 ADD c2 VARBINARY(20) NULL FIRST;
251
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
252
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
253
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
254
CREATE TABLE t5(c1 VARCHAR(10) NULL);
256
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
257
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
258
SHOW CREATE TABLE t5;
259
ALTER TABLE t5 ADD c2 VARBINARY(20) NULL FIRST;
261
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
262
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
263
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
264
CREATE TABLE t5(c1 BINARY(10) NULL);
266
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
267
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
268
SHOW CREATE TABLE t5;
269
ALTER TABLE t5 ADD c2 VARBINARY(20) NULL FIRST;
271
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
272
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
273
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
274
CREATE TABLE t5(c1 VARBINARY(10) NULL);
276
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
277
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
278
SHOW CREATE TABLE t5;
279
ALTER TABLE t5 ADD c2 VARBINARY(20) NULL FIRST;
281
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
282
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
283
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
284
CREATE TABLE t5(c1 CHAR(10) NOT NULL);
286
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
287
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
288
SHOW CREATE TABLE t5;
289
ALTER TABLE t5 ADD c2 VARBINARY(20) NOT NULL FIRST;
291
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
292
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
293
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
294
CREATE TABLE t5(c1 VARCHAR(10) NOT NULL);
296
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
297
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
298
SHOW CREATE TABLE t5;
299
ALTER TABLE t5 ADD c2 VARBINARY(20) NOT NULL FIRST;
301
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
302
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
303
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
304
CREATE TABLE t5(c1 BINARY(10) NOT NULL);
306
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
307
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
308
SHOW CREATE TABLE t5;
309
ALTER TABLE t5 ADD c2 VARBINARY(20) NOT NULL FIRST;
311
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
312
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
313
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;
314
CREATE TABLE t5(c1 VARBINARY(10) NOT NULL);
316
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
317
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
318
SHOW CREATE TABLE t5;
319
ALTER TABLE t5 ADD c2 VARBINARY(20) NOT NULL FIRST;
321
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
322
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
323
SHOW CREATE TABLE t5; DROP TABLE t5; SHOW TABLES;