1
DROP TABLE IF EXISTS t1;
2
SET SQL_MODE='TRADITIONAL';
3
CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL KEY );
7
`c1` tinyint(4) NOT NULL AUTO_INCREMENT,
9
) ENGINE=ENGINE DEFAULT CHARSET=latin1
10
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
11
ERROR 22003: Out of range value for column 'c1' at row 1
12
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
13
ERROR 22003: Out of range value for column 'c1' at row 1
20
SET SQL_MODE='TRADITIONAL';
21
CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NULL KEY );
24
t1 CREATE TABLE `t1` (
25
`c1` smallint(6) NOT NULL AUTO_INCREMENT,
27
) ENGINE=ENGINE DEFAULT CHARSET=latin1
28
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
29
ERROR 22003: Out of range value for column 'c1' at row 1
30
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
31
ERROR 22003: Out of range value for column 'c1' at row 1
38
SET SQL_MODE='TRADITIONAL';
39
CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL KEY );
42
t1 CREATE TABLE `t1` (
43
`c1` mediumint(9) NOT NULL AUTO_INCREMENT,
45
) ENGINE=ENGINE DEFAULT CHARSET=latin1
46
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
47
ERROR 22003: Out of range value for column 'c1' at row 1
48
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
49
ERROR 22003: Out of range value for column 'c1' at row 1
56
SET SQL_MODE='TRADITIONAL';
57
CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL KEY );
60
t1 CREATE TABLE `t1` (
61
`c1` int(11) NOT NULL AUTO_INCREMENT,
63
) ENGINE=ENGINE DEFAULT CHARSET=latin1
64
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
65
ERROR 22003: Out of range value for column 'c1' at row 1
66
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
67
ERROR 22003: Out of range value for column 'c1' at row 1
74
SET SQL_MODE='TRADITIONAL';
75
CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL KEY );
78
t1 CREATE TABLE `t1` (
79
`c1` int(11) NOT NULL AUTO_INCREMENT,
81
) ENGINE=ENGINE DEFAULT CHARSET=latin1
82
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
83
ERROR 22003: Out of range value for column 'c1' at row 1
84
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
85
ERROR 22003: Out of range value for column 'c1' at row 1
92
SET SQL_MODE='TRADITIONAL';
93
CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL KEY );
96
t1 CREATE TABLE `t1` (
97
`c1` bigint(20) NOT NULL AUTO_INCREMENT,
99
) ENGINE=ENGINE DEFAULT CHARSET=latin1
100
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
101
ERROR 22003: Out of range value for column 'c1' at row 1
102
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
103
ERROR 22003: Out of range value for column 'c1' at row 1
110
SET SQL_MODE='TRADITIONAL';
111
CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL KEY );
112
SHOW CREATE TABLE t1;
114
t1 CREATE TABLE `t1` (
115
`c1` tinyint(4) NOT NULL AUTO_INCREMENT,
117
) ENGINE=ENGINE DEFAULT CHARSET=latin1
118
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
119
ERROR 22003: Out of range value for column 'c1' at row 1
120
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
121
ERROR 22003: Out of range value for column 'c1' at row 1
128
SET SQL_MODE='TRADITIONAL';
129
CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL KEY );
130
SHOW CREATE TABLE t1;
132
t1 CREATE TABLE `t1` (
133
`c1` smallint(6) NOT NULL AUTO_INCREMENT,
135
) ENGINE=ENGINE DEFAULT CHARSET=latin1
136
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
137
ERROR 22003: Out of range value for column 'c1' at row 1
138
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
139
ERROR 22003: Out of range value for column 'c1' at row 1
146
SET SQL_MODE='TRADITIONAL';
147
CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL KEY );
148
SHOW CREATE TABLE t1;
150
t1 CREATE TABLE `t1` (
151
`c1` mediumint(9) NOT NULL AUTO_INCREMENT,
153
) ENGINE=ENGINE DEFAULT CHARSET=latin1
154
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
155
ERROR 22003: Out of range value for column 'c1' at row 1
156
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
157
ERROR 22003: Out of range value for column 'c1' at row 1
164
SET SQL_MODE='TRADITIONAL';
165
CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL KEY );
166
SHOW CREATE TABLE t1;
168
t1 CREATE TABLE `t1` (
169
`c1` int(11) NOT NULL AUTO_INCREMENT,
171
) ENGINE=ENGINE DEFAULT CHARSET=latin1
172
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
173
ERROR 22003: Out of range value for column 'c1' at row 1
174
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
175
ERROR 22003: Out of range value for column 'c1' at row 1
182
SET SQL_MODE='TRADITIONAL';
183
CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL KEY );
184
SHOW CREATE TABLE t1;
186
t1 CREATE TABLE `t1` (
187
`c1` int(11) NOT NULL AUTO_INCREMENT,
189
) ENGINE=ENGINE DEFAULT CHARSET=latin1
190
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
191
ERROR 22003: Out of range value for column 'c1' at row 1
192
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
193
ERROR 22003: Out of range value for column 'c1' at row 1
200
SET SQL_MODE='TRADITIONAL';
201
CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL KEY );
202
SHOW CREATE TABLE t1;
204
t1 CREATE TABLE `t1` (
205
`c1` bigint(20) NOT NULL AUTO_INCREMENT,
207
) ENGINE=ENGINE DEFAULT CHARSET=latin1
208
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
209
ERROR 22003: Out of range value for column 'c1' at row 1
210
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
211
ERROR 22003: Out of range value for column 'c1' at row 1
218
SET SQL_MODE='TRADITIONAL';
219
CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL UNIQUE KEY );
220
SHOW CREATE TABLE t1;
222
t1 CREATE TABLE `t1` (
223
`c1` tinyint(4) AUTO_INCREMENT,
224
UNIQUE KEY `c1` (`c1`)
225
) ENGINE=ENGINE DEFAULT CHARSET=latin1
226
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
227
ERROR 22003: Out of range value for column 'c1' at row 1
228
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
229
ERROR 22003: Out of range value for column 'c1' at row 1
236
SET SQL_MODE='TRADITIONAL';
237
CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NULL UNIQUE KEY );
238
SHOW CREATE TABLE t1;
240
t1 CREATE TABLE `t1` (
241
`c1` smallint(6) AUTO_INCREMENT,
242
UNIQUE KEY `c1` (`c1`)
243
) ENGINE=ENGINE DEFAULT CHARSET=latin1
244
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
245
ERROR 22003: Out of range value for column 'c1' at row 1
246
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
247
ERROR 22003: Out of range value for column 'c1' at row 1
254
SET SQL_MODE='TRADITIONAL';
255
CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL UNIQUE KEY );
256
SHOW CREATE TABLE t1;
258
t1 CREATE TABLE `t1` (
259
`c1` mediumint(9) AUTO_INCREMENT,
260
UNIQUE KEY `c1` (`c1`)
261
) ENGINE=ENGINE DEFAULT CHARSET=latin1
262
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
263
ERROR 22003: Out of range value for column 'c1' at row 1
264
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
265
ERROR 22003: Out of range value for column 'c1' at row 1
272
SET SQL_MODE='TRADITIONAL';
273
CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL UNIQUE KEY );
274
SHOW CREATE TABLE t1;
276
t1 CREATE TABLE `t1` (
277
`c1` int(11) AUTO_INCREMENT,
278
UNIQUE KEY `c1` (`c1`)
279
) ENGINE=ENGINE DEFAULT CHARSET=latin1
280
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
281
ERROR 22003: Out of range value for column 'c1' at row 1
282
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
283
ERROR 22003: Out of range value for column 'c1' at row 1
290
SET SQL_MODE='TRADITIONAL';
291
CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL UNIQUE KEY );
292
SHOW CREATE TABLE t1;
294
t1 CREATE TABLE `t1` (
295
`c1` int(11) AUTO_INCREMENT,
296
UNIQUE KEY `c1` (`c1`)
297
) ENGINE=ENGINE DEFAULT CHARSET=latin1
298
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
299
ERROR 22003: Out of range value for column 'c1' at row 1
300
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
301
ERROR 22003: Out of range value for column 'c1' at row 1
308
SET SQL_MODE='TRADITIONAL';
309
CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL UNIQUE KEY );
310
SHOW CREATE TABLE t1;
312
t1 CREATE TABLE `t1` (
313
`c1` bigint(20) AUTO_INCREMENT,
314
UNIQUE KEY `c1` (`c1`)
315
) ENGINE=ENGINE DEFAULT CHARSET=latin1
316
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
317
ERROR 22003: Out of range value for column 'c1' at row 1
318
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
319
ERROR 22003: Out of range value for column 'c1' at row 1
326
SET SQL_MODE='TRADITIONAL';
327
CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
328
SHOW CREATE TABLE t1;
330
t1 CREATE TABLE `t1` (
331
`c1` tinyint(4) NOT NULL AUTO_INCREMENT,
332
UNIQUE KEY `c1` (`c1`)
333
) ENGINE=ENGINE DEFAULT CHARSET=latin1
334
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
335
ERROR 22003: Out of range value for column 'c1' at row 1
336
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
337
ERROR 22003: Out of range value for column 'c1' at row 1
344
SET SQL_MODE='TRADITIONAL';
345
CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
346
SHOW CREATE TABLE t1;
348
t1 CREATE TABLE `t1` (
349
`c1` smallint(6) NOT NULL AUTO_INCREMENT,
350
UNIQUE KEY `c1` (`c1`)
351
) ENGINE=ENGINE DEFAULT CHARSET=latin1
352
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
353
ERROR 22003: Out of range value for column 'c1' at row 1
354
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
355
ERROR 22003: Out of range value for column 'c1' at row 1
362
SET SQL_MODE='TRADITIONAL';
363
CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
364
SHOW CREATE TABLE t1;
366
t1 CREATE TABLE `t1` (
367
`c1` mediumint(9) NOT NULL AUTO_INCREMENT,
368
UNIQUE KEY `c1` (`c1`)
369
) ENGINE=ENGINE DEFAULT CHARSET=latin1
370
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
371
ERROR 22003: Out of range value for column 'c1' at row 1
372
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
373
ERROR 22003: Out of range value for column 'c1' at row 1
380
SET SQL_MODE='TRADITIONAL';
381
CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL UNIQUE KEY );
382
SHOW CREATE TABLE t1;
384
t1 CREATE TABLE `t1` (
385
`c1` int(11) NOT NULL AUTO_INCREMENT,
386
UNIQUE KEY `c1` (`c1`)
387
) ENGINE=ENGINE DEFAULT CHARSET=latin1
388
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
389
ERROR 22003: Out of range value for column 'c1' at row 1
390
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
391
ERROR 22003: Out of range value for column 'c1' at row 1
398
SET SQL_MODE='TRADITIONAL';
399
CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL UNIQUE KEY );
400
SHOW CREATE TABLE t1;
402
t1 CREATE TABLE `t1` (
403
`c1` int(11) NOT NULL AUTO_INCREMENT,
404
UNIQUE KEY `c1` (`c1`)
405
) ENGINE=ENGINE DEFAULT CHARSET=latin1
406
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
407
ERROR 22003: Out of range value for column 'c1' at row 1
408
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
409
ERROR 22003: Out of range value for column 'c1' at row 1
416
SET SQL_MODE='TRADITIONAL';
417
CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
418
SHOW CREATE TABLE t1;
420
t1 CREATE TABLE `t1` (
421
`c1` bigint(20) NOT NULL AUTO_INCREMENT,
422
UNIQUE KEY `c1` (`c1`)
423
) ENGINE=ENGINE DEFAULT CHARSET=latin1
424
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
425
ERROR 22003: Out of range value for column 'c1' at row 1
426
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
427
ERROR 22003: Out of range value for column 'c1' at row 1
434
SET SQL_MODE='TRADITIONAL';
435
CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
436
SHOW CREATE TABLE t1;
438
t1 CREATE TABLE `t1` (
439
`c1` tinyint(4) NOT NULL AUTO_INCREMENT,
441
) ENGINE=ENGINE DEFAULT CHARSET=latin1
442
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
443
ERROR 22003: Out of range value for column 'c1' at row 1
444
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
445
ERROR 22003: Out of range value for column 'c1' at row 1
452
SET SQL_MODE='TRADITIONAL';
453
CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
454
SHOW CREATE TABLE t1;
456
t1 CREATE TABLE `t1` (
457
`c1` smallint(6) NOT NULL AUTO_INCREMENT,
459
) ENGINE=ENGINE DEFAULT CHARSET=latin1
460
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
461
ERROR 22003: Out of range value for column 'c1' at row 1
462
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
463
ERROR 22003: Out of range value for column 'c1' at row 1
470
SET SQL_MODE='TRADITIONAL';
471
CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
472
SHOW CREATE TABLE t1;
474
t1 CREATE TABLE `t1` (
475
`c1` mediumint(9) NOT NULL AUTO_INCREMENT,
477
) ENGINE=ENGINE DEFAULT CHARSET=latin1
478
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
479
ERROR 22003: Out of range value for column 'c1' at row 1
480
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
481
ERROR 22003: Out of range value for column 'c1' at row 1
488
SET SQL_MODE='TRADITIONAL';
489
CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL PRIMARY KEY );
490
SHOW CREATE TABLE t1;
492
t1 CREATE TABLE `t1` (
493
`c1` int(11) NOT NULL AUTO_INCREMENT,
495
) ENGINE=ENGINE DEFAULT CHARSET=latin1
496
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
497
ERROR 22003: Out of range value for column 'c1' at row 1
498
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
499
ERROR 22003: Out of range value for column 'c1' at row 1
506
SET SQL_MODE='TRADITIONAL';
507
CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY );
508
SHOW CREATE TABLE t1;
510
t1 CREATE TABLE `t1` (
511
`c1` int(11) NOT NULL AUTO_INCREMENT,
513
) ENGINE=ENGINE DEFAULT CHARSET=latin1
514
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
515
ERROR 22003: Out of range value for column 'c1' at row 1
516
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
517
ERROR 22003: Out of range value for column 'c1' at row 1
524
SET SQL_MODE='TRADITIONAL';
525
CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
526
SHOW CREATE TABLE t1;
528
t1 CREATE TABLE `t1` (
529
`c1` bigint(20) NOT NULL AUTO_INCREMENT,
531
) ENGINE=ENGINE DEFAULT CHARSET=latin1
532
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
533
ERROR 22003: Out of range value for column 'c1' at row 1
534
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
535
ERROR 22003: Out of range value for column 'c1' at row 1
542
SET SQL_MODE='TRADITIONAL';
543
CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL KEY );
544
SHOW CREATE TABLE t1;
546
t1 CREATE TABLE `t1` (
547
`c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
549
) ENGINE=ENGINE DEFAULT CHARSET=latin1
550
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
551
ERROR 22003: Out of range value for column 'c1' at row 1
552
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
553
ERROR 22003: Out of range value for column 'c1' at row 1
560
SET SQL_MODE='TRADITIONAL';
561
CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL KEY );
562
SHOW CREATE TABLE t1;
564
t1 CREATE TABLE `t1` (
565
`c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
567
) ENGINE=ENGINE DEFAULT CHARSET=latin1
568
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
569
ERROR 22003: Out of range value for column 'c1' at row 1
570
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
571
ERROR 22003: Out of range value for column 'c1' at row 1
578
SET SQL_MODE='TRADITIONAL';
579
CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL KEY );
580
SHOW CREATE TABLE t1;
582
t1 CREATE TABLE `t1` (
583
`c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
585
) ENGINE=ENGINE DEFAULT CHARSET=latin1
586
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
587
ERROR 22003: Out of range value for column 'c1' at row 1
588
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
589
ERROR 22003: Out of range value for column 'c1' at row 1
596
SET SQL_MODE='TRADITIONAL';
597
CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL KEY );
598
SHOW CREATE TABLE t1;
600
t1 CREATE TABLE `t1` (
601
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
603
) ENGINE=ENGINE DEFAULT CHARSET=latin1
604
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
605
ERROR 22003: Out of range value for column 'c1' at row 1
606
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
607
ERROR 22003: Out of range value for column 'c1' at row 1
614
SET SQL_MODE='TRADITIONAL';
615
CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL KEY );
616
SHOW CREATE TABLE t1;
618
t1 CREATE TABLE `t1` (
619
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
621
) ENGINE=ENGINE DEFAULT CHARSET=latin1
622
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
623
ERROR 22003: Out of range value for column 'c1' at row 1
624
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
625
ERROR 22003: Out of range value for column 'c1' at row 1
632
SET SQL_MODE='TRADITIONAL';
633
CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL KEY );
634
SHOW CREATE TABLE t1;
636
t1 CREATE TABLE `t1` (
637
`c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
639
) ENGINE=ENGINE DEFAULT CHARSET=latin1
640
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
641
ERROR 22003: Out of range value for column 'c1' at row 1
642
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
643
ERROR 22003: Out of range value for column 'c1' at row 1
650
SET SQL_MODE='TRADITIONAL';
651
CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
652
SHOW CREATE TABLE t1;
654
t1 CREATE TABLE `t1` (
655
`c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
657
) ENGINE=ENGINE DEFAULT CHARSET=latin1
658
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
659
ERROR 22003: Out of range value for column 'c1' at row 1
660
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
661
ERROR 22003: Out of range value for column 'c1' at row 1
668
SET SQL_MODE='TRADITIONAL';
669
CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
670
SHOW CREATE TABLE t1;
672
t1 CREATE TABLE `t1` (
673
`c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
675
) ENGINE=ENGINE DEFAULT CHARSET=latin1
676
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
677
ERROR 22003: Out of range value for column 'c1' at row 1
678
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
679
ERROR 22003: Out of range value for column 'c1' at row 1
686
SET SQL_MODE='TRADITIONAL';
687
CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
688
SHOW CREATE TABLE t1;
690
t1 CREATE TABLE `t1` (
691
`c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
693
) ENGINE=ENGINE DEFAULT CHARSET=latin1
694
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
695
ERROR 22003: Out of range value for column 'c1' at row 1
696
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
697
ERROR 22003: Out of range value for column 'c1' at row 1
704
SET SQL_MODE='TRADITIONAL';
705
CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
706
SHOW CREATE TABLE t1;
708
t1 CREATE TABLE `t1` (
709
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
711
) ENGINE=ENGINE DEFAULT CHARSET=latin1
712
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
713
ERROR 22003: Out of range value for column 'c1' at row 1
714
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
715
ERROR 22003: Out of range value for column 'c1' at row 1
722
SET SQL_MODE='TRADITIONAL';
723
CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY );
724
SHOW CREATE TABLE t1;
726
t1 CREATE TABLE `t1` (
727
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
729
) ENGINE=ENGINE DEFAULT CHARSET=latin1
730
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
731
ERROR 22003: Out of range value for column 'c1' at row 1
732
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
733
ERROR 22003: Out of range value for column 'c1' at row 1
740
SET SQL_MODE='TRADITIONAL';
741
CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
742
SHOW CREATE TABLE t1;
744
t1 CREATE TABLE `t1` (
745
`c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
747
) ENGINE=ENGINE DEFAULT CHARSET=latin1
748
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
749
ERROR 22003: Out of range value for column 'c1' at row 1
750
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
751
ERROR 22003: Out of range value for column 'c1' at row 1
758
SET SQL_MODE='TRADITIONAL';
759
CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
760
SHOW CREATE TABLE t1;
762
t1 CREATE TABLE `t1` (
763
`c1` tinyint(3) unsigned AUTO_INCREMENT,
764
UNIQUE KEY `c1` (`c1`)
765
) ENGINE=ENGINE DEFAULT CHARSET=latin1
766
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
767
ERROR 22003: Out of range value for column 'c1' at row 1
768
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
769
ERROR 22003: Out of range value for column 'c1' at row 1
776
SET SQL_MODE='TRADITIONAL';
777
CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
778
SHOW CREATE TABLE t1;
780
t1 CREATE TABLE `t1` (
781
`c1` smallint(5) unsigned AUTO_INCREMENT,
782
UNIQUE KEY `c1` (`c1`)
783
) ENGINE=ENGINE DEFAULT CHARSET=latin1
784
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
785
ERROR 22003: Out of range value for column 'c1' at row 1
786
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
787
ERROR 22003: Out of range value for column 'c1' at row 1
794
SET SQL_MODE='TRADITIONAL';
795
CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
796
SHOW CREATE TABLE t1;
798
t1 CREATE TABLE `t1` (
799
`c1` mediumint(8) unsigned AUTO_INCREMENT,
800
UNIQUE KEY `c1` (`c1`)
801
) ENGINE=ENGINE DEFAULT CHARSET=latin1
802
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
803
ERROR 22003: Out of range value for column 'c1' at row 1
804
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
805
ERROR 22003: Out of range value for column 'c1' at row 1
812
SET SQL_MODE='TRADITIONAL';
813
CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
814
SHOW CREATE TABLE t1;
816
t1 CREATE TABLE `t1` (
817
`c1` int(10) unsigned AUTO_INCREMENT,
818
UNIQUE KEY `c1` (`c1`)
819
) ENGINE=ENGINE DEFAULT CHARSET=latin1
820
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
821
ERROR 22003: Out of range value for column 'c1' at row 1
822
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
823
ERROR 22003: Out of range value for column 'c1' at row 1
830
SET SQL_MODE='TRADITIONAL';
831
CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
832
SHOW CREATE TABLE t1;
834
t1 CREATE TABLE `t1` (
835
`c1` int(10) unsigned AUTO_INCREMENT,
836
UNIQUE KEY `c1` (`c1`)
837
) ENGINE=ENGINE DEFAULT CHARSET=latin1
838
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
839
ERROR 22003: Out of range value for column 'c1' at row 1
840
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
841
ERROR 22003: Out of range value for column 'c1' at row 1
848
SET SQL_MODE='TRADITIONAL';
849
CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
850
SHOW CREATE TABLE t1;
852
t1 CREATE TABLE `t1` (
853
`c1` bigint(20) unsigned AUTO_INCREMENT,
854
UNIQUE KEY `c1` (`c1`)
855
) ENGINE=ENGINE DEFAULT CHARSET=latin1
856
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
857
ERROR 22003: Out of range value for column 'c1' at row 1
858
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
859
ERROR 22003: Out of range value for column 'c1' at row 1
866
SET SQL_MODE='TRADITIONAL';
867
CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
868
SHOW CREATE TABLE t1;
870
t1 CREATE TABLE `t1` (
871
`c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
872
UNIQUE KEY `c1` (`c1`)
873
) ENGINE=ENGINE DEFAULT CHARSET=latin1
874
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
875
ERROR 22003: Out of range value for column 'c1' at row 1
876
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
877
ERROR 22003: Out of range value for column 'c1' at row 1
884
SET SQL_MODE='TRADITIONAL';
885
CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
886
SHOW CREATE TABLE t1;
888
t1 CREATE TABLE `t1` (
889
`c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
890
UNIQUE KEY `c1` (`c1`)
891
) ENGINE=ENGINE DEFAULT CHARSET=latin1
892
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
893
ERROR 22003: Out of range value for column 'c1' at row 1
894
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
895
ERROR 22003: Out of range value for column 'c1' at row 1
902
SET SQL_MODE='TRADITIONAL';
903
CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
904
SHOW CREATE TABLE t1;
906
t1 CREATE TABLE `t1` (
907
`c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
908
UNIQUE KEY `c1` (`c1`)
909
) ENGINE=ENGINE DEFAULT CHARSET=latin1
910
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
911
ERROR 22003: Out of range value for column 'c1' at row 1
912
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
913
ERROR 22003: Out of range value for column 'c1' at row 1
920
SET SQL_MODE='TRADITIONAL';
921
CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
922
SHOW CREATE TABLE t1;
924
t1 CREATE TABLE `t1` (
925
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
926
UNIQUE KEY `c1` (`c1`)
927
) ENGINE=ENGINE DEFAULT CHARSET=latin1
928
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
929
ERROR 22003: Out of range value for column 'c1' at row 1
930
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
931
ERROR 22003: Out of range value for column 'c1' at row 1
938
SET SQL_MODE='TRADITIONAL';
939
CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
940
SHOW CREATE TABLE t1;
942
t1 CREATE TABLE `t1` (
943
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
944
UNIQUE KEY `c1` (`c1`)
945
) ENGINE=ENGINE DEFAULT CHARSET=latin1
946
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
947
ERROR 22003: Out of range value for column 'c1' at row 1
948
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
949
ERROR 22003: Out of range value for column 'c1' at row 1
956
SET SQL_MODE='TRADITIONAL';
957
CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
958
SHOW CREATE TABLE t1;
960
t1 CREATE TABLE `t1` (
961
`c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
962
UNIQUE KEY `c1` (`c1`)
963
) ENGINE=ENGINE DEFAULT CHARSET=latin1
964
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
965
ERROR 22003: Out of range value for column 'c1' at row 1
966
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
967
ERROR 22003: Out of range value for column 'c1' at row 1
974
SET SQL_MODE='TRADITIONAL';
975
CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
976
SHOW CREATE TABLE t1;
978
t1 CREATE TABLE `t1` (
979
`c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
981
) ENGINE=ENGINE DEFAULT CHARSET=latin1
982
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
983
ERROR 22003: Out of range value for column 'c1' at row 1
984
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
985
ERROR 22003: Out of range value for column 'c1' at row 1
992
SET SQL_MODE='TRADITIONAL';
993
CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
994
SHOW CREATE TABLE t1;
996
t1 CREATE TABLE `t1` (
997
`c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
999
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1000
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
1001
ERROR 22003: Out of range value for column 'c1' at row 1
1002
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
1003
ERROR 22003: Out of range value for column 'c1' at row 1
1010
SET SQL_MODE='TRADITIONAL';
1011
CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
1012
SHOW CREATE TABLE t1;
1014
t1 CREATE TABLE `t1` (
1015
`c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
1017
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1018
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
1019
ERROR 22003: Out of range value for column 'c1' at row 1
1020
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
1021
ERROR 22003: Out of range value for column 'c1' at row 1
1028
SET SQL_MODE='TRADITIONAL';
1029
CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
1030
SHOW CREATE TABLE t1;
1032
t1 CREATE TABLE `t1` (
1033
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
1035
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1036
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
1037
ERROR 22003: Out of range value for column 'c1' at row 1
1038
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
1039
ERROR 22003: Out of range value for column 'c1' at row 1
1046
SET SQL_MODE='TRADITIONAL';
1047
CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
1048
SHOW CREATE TABLE t1;
1050
t1 CREATE TABLE `t1` (
1051
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
1053
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1054
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
1055
ERROR 22003: Out of range value for column 'c1' at row 1
1056
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
1057
ERROR 22003: Out of range value for column 'c1' at row 1
1064
SET SQL_MODE='TRADITIONAL';
1065
CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
1066
SHOW CREATE TABLE t1;
1068
t1 CREATE TABLE `t1` (
1069
`c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1071
) ENGINE=ENGINE DEFAULT CHARSET=latin1
1072
INSERT INTO t1 VALUES(111111111111111111111111111111111111);
1073
ERROR 22003: Out of range value for column 'c1' at row 1
1074
INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
1075
ERROR 22003: Out of range value for column 'c1' at row 1