2
DROP TABLE IF EXISTS t1;
4
SET SQL_MODE='TRADITIONAL';
5
CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL KEY );
6
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
7
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
10
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
12
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
17
SET SQL_MODE='TRADITIONAL';
18
CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NULL KEY );
19
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
20
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
23
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
25
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
30
SET SQL_MODE='TRADITIONAL';
31
CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL KEY );
32
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
33
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
36
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
38
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
43
SET SQL_MODE='TRADITIONAL';
44
CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL KEY );
45
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
46
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
49
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
51
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
56
SET SQL_MODE='TRADITIONAL';
57
CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL KEY );
58
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
59
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
62
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
64
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
69
SET SQL_MODE='TRADITIONAL';
70
CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL KEY );
71
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
72
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
75
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
77
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
82
SET SQL_MODE='TRADITIONAL';
83
CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL KEY );
84
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
85
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
88
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
90
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
95
SET SQL_MODE='TRADITIONAL';
96
CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL KEY );
97
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
98
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
101
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
103
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
108
SET SQL_MODE='TRADITIONAL';
109
CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL KEY );
110
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
111
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
112
SHOW CREATE TABLE t1;
114
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
116
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
121
SET SQL_MODE='TRADITIONAL';
122
CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL KEY );
123
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
124
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
125
SHOW CREATE TABLE t1;
127
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
129
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
134
SET SQL_MODE='TRADITIONAL';
135
CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL KEY );
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 t1;
140
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
142
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
147
SET SQL_MODE='TRADITIONAL';
148
CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL KEY );
149
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
150
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
151
SHOW CREATE TABLE t1;
153
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
155
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
160
SET SQL_MODE='TRADITIONAL';
161
CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL UNIQUE KEY );
162
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
163
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
164
SHOW CREATE TABLE t1;
166
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
168
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
173
SET SQL_MODE='TRADITIONAL';
174
CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NULL UNIQUE KEY );
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;
179
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
181
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
186
SET SQL_MODE='TRADITIONAL';
187
CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL UNIQUE KEY );
188
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
189
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
190
SHOW CREATE TABLE t1;
192
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
194
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
199
SET SQL_MODE='TRADITIONAL';
200
CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL UNIQUE KEY );
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 t1;
205
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
207
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
212
SET SQL_MODE='TRADITIONAL';
213
CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL UNIQUE KEY );
214
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
215
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
216
SHOW CREATE TABLE t1;
218
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
220
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
225
SET SQL_MODE='TRADITIONAL';
226
CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL UNIQUE KEY );
227
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
228
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
229
SHOW CREATE TABLE t1;
231
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
233
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
238
SET SQL_MODE='TRADITIONAL';
239
CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
240
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
241
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
242
SHOW CREATE TABLE t1;
244
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
246
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
251
SET SQL_MODE='TRADITIONAL';
252
CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
253
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
254
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
255
SHOW CREATE TABLE t1;
257
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
259
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
264
SET SQL_MODE='TRADITIONAL';
265
CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
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 t1;
270
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
272
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
277
SET SQL_MODE='TRADITIONAL';
278
CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL UNIQUE KEY );
279
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
280
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
281
SHOW CREATE TABLE t1;
283
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
285
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
290
SET SQL_MODE='TRADITIONAL';
291
CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL UNIQUE KEY );
292
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
293
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
294
SHOW CREATE TABLE t1;
296
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
298
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
303
SET SQL_MODE='TRADITIONAL';
304
CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
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;
309
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
311
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
316
SET SQL_MODE='TRADITIONAL';
317
CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
318
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
319
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
320
SHOW CREATE TABLE t1;
322
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
324
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
329
SET SQL_MODE='TRADITIONAL';
330
CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
331
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
332
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
333
SHOW CREATE TABLE t1;
335
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
337
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
342
SET SQL_MODE='TRADITIONAL';
343
CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
344
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
345
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
346
SHOW CREATE TABLE t1;
348
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
350
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
355
SET SQL_MODE='TRADITIONAL';
356
CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL PRIMARY KEY );
357
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
358
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
359
SHOW CREATE TABLE t1;
361
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
363
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
368
SET SQL_MODE='TRADITIONAL';
369
CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY );
370
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
371
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
372
SHOW CREATE TABLE t1;
374
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
376
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
381
SET SQL_MODE='TRADITIONAL';
382
CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
383
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
384
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
385
SHOW CREATE TABLE t1;
387
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
389
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
394
SET SQL_MODE='TRADITIONAL';
395
CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL KEY );
396
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
397
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
398
SHOW CREATE TABLE t1;
400
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
402
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
407
SET SQL_MODE='TRADITIONAL';
408
CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL KEY );
409
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
410
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
411
SHOW CREATE TABLE t1;
413
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
415
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
420
SET SQL_MODE='TRADITIONAL';
421
CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL KEY );
422
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
423
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
424
SHOW CREATE TABLE t1;
426
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
428
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
433
SET SQL_MODE='TRADITIONAL';
434
CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL KEY );
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;
439
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
441
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
446
SET SQL_MODE='TRADITIONAL';
447
CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL KEY );
448
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
449
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
450
SHOW CREATE TABLE t1;
452
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
454
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
459
SET SQL_MODE='TRADITIONAL';
460
CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL KEY );
461
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
462
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
463
SHOW CREATE TABLE t1;
465
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
467
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
472
SET SQL_MODE='TRADITIONAL';
473
CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
474
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
475
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
476
SHOW CREATE TABLE t1;
478
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
480
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
485
SET SQL_MODE='TRADITIONAL';
486
CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
487
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
488
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
489
SHOW CREATE TABLE t1;
491
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
493
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
498
SET SQL_MODE='TRADITIONAL';
499
CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
500
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
501
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
502
SHOW CREATE TABLE t1;
504
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
506
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
511
SET SQL_MODE='TRADITIONAL';
512
CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
513
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
514
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
515
SHOW CREATE TABLE t1;
517
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
519
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
524
SET SQL_MODE='TRADITIONAL';
525
CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY );
526
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
527
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
528
SHOW CREATE TABLE t1;
530
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
532
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
537
SET SQL_MODE='TRADITIONAL';
538
CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
539
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
540
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
541
SHOW CREATE TABLE t1;
543
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
545
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
550
SET SQL_MODE='TRADITIONAL';
551
CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
552
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
553
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
554
SHOW CREATE TABLE t1;
556
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
558
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
563
SET SQL_MODE='TRADITIONAL';
564
CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
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;
569
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
571
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
576
SET SQL_MODE='TRADITIONAL';
577
CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
578
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
579
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
580
SHOW CREATE TABLE t1;
582
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
584
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
589
SET SQL_MODE='TRADITIONAL';
590
CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
591
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
592
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
593
SHOW CREATE TABLE t1;
595
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
597
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
602
SET SQL_MODE='TRADITIONAL';
603
CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
604
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
605
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
606
SHOW CREATE TABLE t1;
608
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
610
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
615
SET SQL_MODE='TRADITIONAL';
616
CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
617
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
618
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
619
SHOW CREATE TABLE t1;
621
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
623
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
628
SET SQL_MODE='TRADITIONAL';
629
CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
630
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
631
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
632
SHOW CREATE TABLE t1;
634
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
636
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
641
SET SQL_MODE='TRADITIONAL';
642
CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
643
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
644
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
645
SHOW CREATE TABLE t1;
647
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
649
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
654
SET SQL_MODE='TRADITIONAL';
655
CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
656
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
657
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
658
SHOW CREATE TABLE t1;
660
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
662
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
667
SET SQL_MODE='TRADITIONAL';
668
CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
669
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
670
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
671
SHOW CREATE TABLE t1;
673
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
675
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
680
SET SQL_MODE='TRADITIONAL';
681
CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
682
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
683
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
684
SHOW CREATE TABLE t1;
686
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
688
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
693
SET SQL_MODE='TRADITIONAL';
694
CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
695
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
696
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
697
SHOW CREATE TABLE t1;
699
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
701
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
706
SET SQL_MODE='TRADITIONAL';
707
CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
708
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
709
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
710
SHOW CREATE TABLE t1;
712
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
714
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
719
SET SQL_MODE='TRADITIONAL';
720
CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
721
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
722
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
723
SHOW CREATE TABLE t1;
725
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
727
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
732
SET SQL_MODE='TRADITIONAL';
733
CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
734
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
735
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
736
SHOW CREATE TABLE t1;
738
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
740
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
745
SET SQL_MODE='TRADITIONAL';
746
CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
747
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
748
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
749
SHOW CREATE TABLE t1;
751
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
753
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
758
SET SQL_MODE='TRADITIONAL';
759
CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
760
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
761
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
762
SHOW CREATE TABLE t1;
764
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
766
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
771
SET SQL_MODE='TRADITIONAL';
772
CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
773
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
774
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
775
SHOW CREATE TABLE t1;
777
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
779
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);