2
DROP TABLE IF EXISTS t1;
4
CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
5
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
6
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
8
INSERT INTO t1 VALUES(null);
9
INSERT INTO t1 VALUES(null);
10
INSERT INTO t1 VALUES(null);
14
CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
15
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
16
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
18
INSERT INTO t1 VALUES(null);
19
INSERT INTO t1 VALUES(null);
20
INSERT INTO t1 VALUES(null);
24
CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
25
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
26
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
28
INSERT INTO t1 VALUES(null);
29
INSERT INTO t1 VALUES(null);
30
INSERT INTO t1 VALUES(null);
34
CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
35
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
36
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
38
INSERT INTO t1 VALUES(null);
39
INSERT INTO t1 VALUES(null);
40
INSERT INTO t1 VALUES(null);
44
CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
45
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
46
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
48
INSERT INTO t1 VALUES(null);
49
INSERT INTO t1 VALUES(null);
50
INSERT INTO t1 VALUES(null);
54
CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
55
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
56
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
58
INSERT INTO t1 VALUES(null);
59
INSERT INTO t1 VALUES(null);
60
INSERT INTO t1 VALUES(null);
64
CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
65
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
66
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
68
INSERT INTO t1 VALUES(null);
69
INSERT INTO t1 VALUES(null);
70
INSERT INTO t1 VALUES(null);
74
CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
75
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
76
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
78
INSERT INTO t1 VALUES(null);
79
INSERT INTO t1 VALUES(null);
80
INSERT INTO t1 VALUES(null);
84
CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
85
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
86
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
88
INSERT INTO t1 VALUES(null);
89
INSERT INTO t1 VALUES(null);
90
INSERT INTO t1 VALUES(null);
94
CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
95
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
96
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
98
INSERT INTO t1 VALUES(null);
99
INSERT INTO t1 VALUES(null);
100
INSERT INTO t1 VALUES(null);
104
CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
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;
108
INSERT INTO t1 VALUES(null);
109
INSERT INTO t1 VALUES(null);
110
INSERT INTO t1 VALUES(null);
114
CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
115
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
116
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
117
SHOW CREATE TABLE t1;
118
INSERT INTO t1 VALUES(null);
119
INSERT INTO t1 VALUES(null);
120
INSERT INTO t1 VALUES(null);
124
CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
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
INSERT INTO t1 VALUES(null);
129
INSERT INTO t1 VALUES(null);
130
INSERT INTO t1 VALUES(null);
134
CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
135
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
136
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
137
SHOW CREATE TABLE t1;
138
INSERT INTO t1 VALUES(null);
139
INSERT INTO t1 VALUES(null);
140
INSERT INTO t1 VALUES(null);
144
CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
145
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
146
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
147
SHOW CREATE TABLE t1;
148
INSERT INTO t1 VALUES(null);
149
INSERT INTO t1 VALUES(null);
150
INSERT INTO t1 VALUES(null);
154
CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
155
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
156
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
157
SHOW CREATE TABLE t1;
158
INSERT INTO t1 VALUES(null);
159
INSERT INTO t1 VALUES(null);
160
INSERT INTO t1 VALUES(null);
164
CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
165
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
166
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
167
SHOW CREATE TABLE t1;
168
INSERT INTO t1 VALUES(null);
169
INSERT INTO t1 VALUES(null);
170
INSERT INTO t1 VALUES(null);
174
CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
175
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
176
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
177
SHOW CREATE TABLE t1;
178
INSERT INTO t1 VALUES(null);
179
INSERT INTO t1 VALUES(null);
180
INSERT INTO t1 VALUES(null);
184
CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
185
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
186
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
187
SHOW CREATE TABLE t1;
188
INSERT INTO t1 VALUES(null);
189
INSERT INTO t1 VALUES(null);
190
INSERT INTO t1 VALUES(null);
194
CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
195
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
196
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
197
SHOW CREATE TABLE t1;
198
INSERT INTO t1 VALUES(null);
199
INSERT INTO t1 VALUES(null);
200
INSERT INTO t1 VALUES(null);
204
CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
205
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
206
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
207
SHOW CREATE TABLE t1;
208
INSERT INTO t1 VALUES(null);
209
INSERT INTO t1 VALUES(null);
210
INSERT INTO t1 VALUES(null);
214
CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
215
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
216
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
217
SHOW CREATE TABLE t1;
218
INSERT INTO t1 VALUES(null);
219
INSERT INTO t1 VALUES(null);
220
INSERT INTO t1 VALUES(null);
224
CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
225
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
226
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
227
SHOW CREATE TABLE t1;
228
INSERT INTO t1 VALUES(null);
229
INSERT INTO t1 VALUES(null);
230
INSERT INTO t1 VALUES(null);
234
CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
235
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
236
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
237
SHOW CREATE TABLE t1;
238
INSERT INTO t1 VALUES(null);
239
INSERT INTO t1 VALUES(null);
240
INSERT INTO t1 VALUES(null);
244
CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
245
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
246
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
247
SHOW CREATE TABLE t1;
248
INSERT INTO t1 VALUES(null);
249
INSERT INTO t1 VALUES(null);
250
INSERT INTO t1 VALUES(null);
254
CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
255
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
256
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
257
SHOW CREATE TABLE t1;
258
INSERT INTO t1 VALUES(null);
259
INSERT INTO t1 VALUES(null);
260
INSERT INTO t1 VALUES(null);
264
CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
265
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
266
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
267
SHOW CREATE TABLE t1;
268
INSERT INTO t1 VALUES(null);
269
INSERT INTO t1 VALUES(null);
270
INSERT INTO t1 VALUES(null);
274
CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
275
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
276
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
277
SHOW CREATE TABLE t1;
278
INSERT INTO t1 VALUES(null);
279
INSERT INTO t1 VALUES(null);
280
INSERT INTO t1 VALUES(null);
284
CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
285
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
286
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
287
SHOW CREATE TABLE t1;
288
INSERT INTO t1 VALUES(null);
289
INSERT INTO t1 VALUES(null);
290
INSERT INTO t1 VALUES(null);
294
CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
295
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
296
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
297
SHOW CREATE TABLE t1;
298
INSERT INTO t1 VALUES(null);
299
INSERT INTO t1 VALUES(null);
300
INSERT INTO t1 VALUES(null);
304
CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
305
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
306
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
307
SHOW CREATE TABLE t1;
308
INSERT INTO t1 VALUES(null);
309
INSERT INTO t1 VALUES(null);
310
INSERT INTO t1 VALUES(null);
314
CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
315
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
316
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
317
SHOW CREATE TABLE t1;
318
INSERT INTO t1 VALUES(null);
319
INSERT INTO t1 VALUES(null);
320
INSERT INTO t1 VALUES(null);
324
CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
325
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
326
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
327
SHOW CREATE TABLE t1;
328
INSERT INTO t1 VALUES(null);
329
INSERT INTO t1 VALUES(null);
330
INSERT INTO t1 VALUES(null);
334
CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
335
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
336
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
337
SHOW CREATE TABLE t1;
338
INSERT INTO t1 VALUES(null);
339
INSERT INTO t1 VALUES(null);
340
INSERT INTO t1 VALUES(null);
344
CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
345
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
346
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
347
SHOW CREATE TABLE t1;
348
INSERT INTO t1 VALUES(null);
349
INSERT INTO t1 VALUES(null);
350
INSERT INTO t1 VALUES(null);
354
CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL KEY ) AUTO_INCREMENT=10;
355
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
356
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
357
SHOW CREATE TABLE t1;
358
INSERT INTO t1 VALUES(null);
359
INSERT INTO t1 VALUES(null);
360
INSERT INTO t1 VALUES(null);
364
CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
365
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
366
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
367
SHOW CREATE TABLE t1;
368
INSERT INTO t1 VALUES(null);
369
INSERT INTO t1 VALUES(null);
370
INSERT INTO t1 VALUES(null);
374
CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
375
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
376
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
377
SHOW CREATE TABLE t1;
378
INSERT INTO t1 VALUES(null);
379
INSERT INTO t1 VALUES(null);
380
INSERT INTO t1 VALUES(null);
384
CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
385
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
386
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
387
SHOW CREATE TABLE t1;
388
INSERT INTO t1 VALUES(null);
389
INSERT INTO t1 VALUES(null);
390
INSERT INTO t1 VALUES(null);
394
CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
395
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
396
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
397
SHOW CREATE TABLE t1;
398
INSERT INTO t1 VALUES(null);
399
INSERT INTO t1 VALUES(null);
400
INSERT INTO t1 VALUES(null);
404
CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
405
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
406
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
407
SHOW CREATE TABLE t1;
408
INSERT INTO t1 VALUES(null);
409
INSERT INTO t1 VALUES(null);
410
INSERT INTO t1 VALUES(null);
414
CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL KEY ) AUTO_INCREMENT=10;
415
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
416
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
417
SHOW CREATE TABLE t1;
418
INSERT INTO t1 VALUES(null);
419
INSERT INTO t1 VALUES(null);
420
INSERT INTO t1 VALUES(null);
424
CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
425
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
426
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
427
SHOW CREATE TABLE t1;
428
INSERT INTO t1 VALUES(null);
429
INSERT INTO t1 VALUES(null);
430
INSERT INTO t1 VALUES(null);
434
CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
435
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
436
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
437
SHOW CREATE TABLE t1;
438
INSERT INTO t1 VALUES(null);
439
INSERT INTO t1 VALUES(null);
440
INSERT INTO t1 VALUES(null);
444
CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
445
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
446
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
447
SHOW CREATE TABLE t1;
448
INSERT INTO t1 VALUES(null);
449
INSERT INTO t1 VALUES(null);
450
INSERT INTO t1 VALUES(null);
454
CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
455
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
456
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
457
SHOW CREATE TABLE t1;
458
INSERT INTO t1 VALUES(null);
459
INSERT INTO t1 VALUES(null);
460
INSERT INTO t1 VALUES(null);
464
CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
465
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
466
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
467
SHOW CREATE TABLE t1;
468
INSERT INTO t1 VALUES(null);
469
INSERT INTO t1 VALUES(null);
470
INSERT INTO t1 VALUES(null);
474
CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
475
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
476
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
477
SHOW CREATE TABLE t1;
478
INSERT INTO t1 VALUES(null);
479
INSERT INTO t1 VALUES(null);
480
INSERT INTO t1 VALUES(null);
484
CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
485
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
486
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
487
SHOW CREATE TABLE t1;
488
INSERT INTO t1 VALUES(null);
489
INSERT INTO t1 VALUES(null);
490
INSERT INTO t1 VALUES(null);
494
CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
495
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
496
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
497
SHOW CREATE TABLE t1;
498
INSERT INTO t1 VALUES(null);
499
INSERT INTO t1 VALUES(null);
500
INSERT INTO t1 VALUES(null);
504
CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
505
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
506
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
507
SHOW CREATE TABLE t1;
508
INSERT INTO t1 VALUES(null);
509
INSERT INTO t1 VALUES(null);
510
INSERT INTO t1 VALUES(null);
514
CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
515
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
516
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
517
SHOW CREATE TABLE t1;
518
INSERT INTO t1 VALUES(null);
519
INSERT INTO t1 VALUES(null);
520
INSERT INTO t1 VALUES(null);
524
CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
525
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
526
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
527
SHOW CREATE TABLE t1;
528
INSERT INTO t1 VALUES(null);
529
INSERT INTO t1 VALUES(null);
530
INSERT INTO t1 VALUES(null);
534
CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY ) AUTO_INCREMENT=10;
535
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
536
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
537
SHOW CREATE TABLE t1;
538
INSERT INTO t1 VALUES(null);
539
INSERT INTO t1 VALUES(null);
540
INSERT INTO t1 VALUES(null);
544
CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
545
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
546
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
547
SHOW CREATE TABLE t1;
548
INSERT INTO t1 VALUES(null);
549
INSERT INTO t1 VALUES(null);
550
INSERT INTO t1 VALUES(null);
554
CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
555
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
556
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
557
SHOW CREATE TABLE t1;
558
INSERT INTO t1 VALUES(null);
559
INSERT INTO t1 VALUES(null);
560
INSERT INTO t1 VALUES(null);
564
CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
565
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
566
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
567
SHOW CREATE TABLE t1;
568
INSERT INTO t1 VALUES(null);
569
INSERT INTO t1 VALUES(null);
570
INSERT INTO t1 VALUES(null);
574
CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
575
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
576
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
577
SHOW CREATE TABLE t1;
578
INSERT INTO t1 VALUES(null);
579
INSERT INTO t1 VALUES(null);
580
INSERT INTO t1 VALUES(null);
584
CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
585
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
586
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
587
SHOW CREATE TABLE t1;
588
INSERT INTO t1 VALUES(null);
589
INSERT INTO t1 VALUES(null);
590
INSERT INTO t1 VALUES(null);
594
CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY ) AUTO_INCREMENT=10;
595
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
596
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
597
SHOW CREATE TABLE t1;
598
INSERT INTO t1 VALUES(null);
599
INSERT INTO t1 VALUES(null);
600
INSERT INTO t1 VALUES(null);