1
drop table if exists t1;
2
CREATE TABLE t1 (c1 BIGINT PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB;
3
INSERT INTO t1 VALUES (9223372036854775807, null);
4
INSERT INTO t1 (c2) VALUES ('innodb');
5
Got one of the listed errors
8
9223372036854775807 NULL
10
CREATE TABLE t1 (c1 TINYINT PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB;
11
INSERT INTO t1 VALUES (127, null);
12
INSERT INTO t1 (c2) VALUES ('innodb');
13
Got one of the listed errors
18
CREATE TABLE t1 (c1 TINYINT UNSIGNED PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB;
19
INSERT INTO t1 VALUES (255, null);
20
INSERT INTO t1 (c2) VALUES ('innodb');
21
Got one of the listed errors
26
CREATE TABLE t1 (c1 SMALLINT PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB;
27
INSERT INTO t1 VALUES (32767, null);
28
INSERT INTO t1 (c2) VALUES ('innodb');
29
Got one of the listed errors
34
CREATE TABLE t1 (c1 SMALLINT UNSIGNED PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB;
35
INSERT INTO t1 VALUES (65535, null);
36
INSERT INTO t1 (c2) VALUES ('innodb');
37
Got one of the listed errors
42
CREATE TABLE t1 (c1 MEDIUMINT PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB;
43
INSERT INTO t1 VALUES (8388607, null);
44
INSERT INTO t1 (c2) VALUES ('innodb');
45
Got one of the listed errors
50
CREATE TABLE t1 (c1 MEDIUMINT UNSIGNED PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB;
51
INSERT INTO t1 VALUES (16777215, null);
52
INSERT INTO t1 (c2) VALUES ('innodb');
53
Got one of the listed errors
58
CREATE TABLE t1 (c1 INT PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB;
59
INSERT INTO t1 VALUES (2147483647, null);
60
INSERT INTO t1 (c2) VALUES ('innodb');
61
Got one of the listed errors
66
CREATE TABLE t1 (c1 INT UNSIGNED PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB;
67
INSERT INTO t1 VALUES (4294967295, null);
68
INSERT INTO t1 (c2) VALUES ('innodb');
69
Got one of the listed errors
74
CREATE TABLE t1 (c1 BIGINT PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB;
75
INSERT INTO t1 VALUES (9223372036854775807, null);
76
INSERT INTO t1 (c2) VALUES ('innodb');
77
Got one of the listed errors
80
9223372036854775807 NULL
82
CREATE TABLE t1 (c1 BIGINT UNSIGNED PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB;
83
INSERT INTO t1 VALUES (18446744073709551615, null);
84
INSERT INTO t1 (c2) VALUES ('innodb');
85
Got one of the listed errors
88
18446744073709551615 NULL
90
CREATE TABLE t1(c1 INT PRIMARY KEY AUTO_INCREMENT) ENGINE=InnoDB;
91
INSERT INTO t1 VALUES (1), (2), (3);
92
INSERT INTO t1 VALUES (NULL), (NULL), (NULL);
101
SHOW CREATE TABLE t1;
103
t1 CREATE TABLE `t1` (
104
`c1` int(11) NOT NULL AUTO_INCREMENT,
106
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1
108
SHOW CREATE TABLE t1;
110
t1 CREATE TABLE `t1` (
111
`c1` int(11) NOT NULL AUTO_INCREMENT,
113
) ENGINE=InnoDB DEFAULT CHARSET=latin1
114
INSERT INTO t1 VALUES (1), (2), (3);
115
INSERT INTO t1 VALUES (NULL), (NULL), (NULL);
124
SHOW CREATE TABLE t1;
126
t1 CREATE TABLE `t1` (
127
`c1` int(11) NOT NULL AUTO_INCREMENT,
129
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1
131
CREATE TABLE t1(c1 INT PRIMARY KEY AUTO_INCREMENT) ENGINE=InnoDB;
132
INSERT INTO t1 VALUES (1), (2), (3);
133
INSERT INTO t1 VALUES (NULL), (NULL), (NULL);
142
SHOW CREATE TABLE t1;
144
t1 CREATE TABLE `t1` (
145
`c1` int(11) NOT NULL AUTO_INCREMENT,
147
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1
149
SHOW CREATE TABLE t1;
151
t1 CREATE TABLE `t1` (
152
`c1` int(11) NOT NULL AUTO_INCREMENT,
154
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1
155
INSERT INTO t1 VALUES (1), (2), (3);
156
INSERT INTO t1 VALUES (NULL), (NULL), (NULL);
165
SHOW CREATE TABLE t1;
167
t1 CREATE TABLE `t1` (
168
`c1` int(11) NOT NULL AUTO_INCREMENT,
170
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
172
DROP TABLE IF EXISTS t1;
174
Note 1051 Unknown table 't1'
175
CREATE TABLE t1 (c1 INT AUTO_INCREMENT, c2 INT, PRIMARY KEY(c1)) ENGINE=InnoDB;
176
INSERT INTO t1 VALUES (NULL, 1);
177
DELETE FROM t1 WHERE c1 = 1;
178
INSERT INTO t1 VALUES (2,1);
179
INSERT INTO t1 VALUES (NULL,8);
185
DROP TABLE IF EXISTS t1;
187
Note 1051 Unknown table 't1'
188
CREATE TABLE t1 (c1 INT AUTO_INCREMENT, c2 INT, PRIMARY KEY(c1)) ENGINE=InnoDB;
189
INSERT INTO t1 VALUES (NULL, 1);
190
DELETE FROM t1 WHERE c1 = 1;
191
INSERT INTO t1 VALUES (2,1), (NULL, 8);
192
INSERT INTO t1 VALUES (NULL,9);
199
SET @@SESSION.AUTO_INCREMENT_INCREMENT=100, @@SESSION.AUTO_INCREMENT_OFFSET=10;
200
SHOW VARIABLES LIKE "%auto_inc%";
202
auto_increment_increment 100
203
auto_increment_offset 10
204
DROP TABLE IF EXISTS t1;
206
Note 1051 Unknown table 't1'
207
CREATE TABLE t1 (c1 INT AUTO_INCREMENT, PRIMARY KEY(c1)) ENGINE=InnoDB;
208
INSERT INTO t1 VALUES (NULL),(5),(NULL);
209
INSERT INTO t1 VALUES (250),(NULL);
217
INSERT INTO t1 VALUES (1000);
219
INSERT INTO t1 VALUES(NULL),(NULL);
231
SET @@SESSION.AUTO_INCREMENT_INCREMENT=1, @@SESSION.AUTO_INCREMENT_OFFSET=1;
233
SHOW VARIABLES LIKE "%auto_inc%";
235
auto_increment_increment 1
236
auto_increment_offset 1
237
DROP TABLE IF EXISTS t1;
239
Note 1051 Unknown table 't1'
240
CREATE TABLE t1 (c1 INT AUTO_INCREMENT, PRIMARY KEY(c1)) ENGINE=InnoDB;
241
INSERT INTO t1 VALUES(0);
245
SET @@SESSION.AUTO_INCREMENT_INCREMENT=100, @@SESSION.AUTO_INCREMENT_OFFSET=10;
246
INSERT INTO t1 VALUES (-1), (NULL),(2),(NULL);
247
INSERT INTO t1 VALUES (250),(NULL);
258
INSERT INTO t1 VALUES(NULL),(NULL);
259
Got one of the listed errors
270
SET @@SESSION.AUTO_INCREMENT_INCREMENT=1, @@SESSION.AUTO_INCREMENT_OFFSET=1;
272
SHOW VARIABLES LIKE "%auto_inc%";
274
auto_increment_increment 1
275
auto_increment_offset 1
276
DROP TABLE IF EXISTS t1;
278
Note 1051 Unknown table 't1'
279
CREATE TABLE t1 (c1 INT AUTO_INCREMENT, PRIMARY KEY(c1)) ENGINE=InnoDB;
280
INSERT INTO t1 VALUES(-1);
284
SET @@SESSION.AUTO_INCREMENT_INCREMENT=100, @@SESSION.AUTO_INCREMENT_OFFSET=10;
285
SHOW VARIABLES LIKE "%auto_inc%";
287
auto_increment_increment 100
288
auto_increment_offset 10
289
INSERT INTO t1 VALUES (-2), (NULL),(2),(NULL);
290
INSERT INTO t1 VALUES (250),(NULL);
300
INSERT INTO t1 VALUES (1000);
302
INSERT INTO t1 VALUES(NULL),(NULL);
316
SET @@SESSION.AUTO_INCREMENT_INCREMENT=1, @@SESSION.AUTO_INCREMENT_OFFSET=1;
318
SHOW VARIABLES LIKE "%auto_inc%";
320
auto_increment_increment 1
321
auto_increment_offset 1
322
DROP TABLE IF EXISTS t1;
324
Note 1051 Unknown table 't1'
325
CREATE TABLE t1 (c1 INT UNSIGNED AUTO_INCREMENT, PRIMARY KEY(c1)) ENGINE=InnoDB;
326
INSERT INTO t1 VALUES(-1);
328
Warning 1264 Out of range value for column 'c1' at row 1
332
SET @@SESSION.AUTO_INCREMENT_INCREMENT=100, @@SESSION.AUTO_INCREMENT_OFFSET=10;
333
SHOW VARIABLES LIKE "%auto_inc%";
335
auto_increment_increment 100
336
auto_increment_offset 10
337
INSERT INTO t1 VALUES (-2);
339
Warning 1264 Out of range value for column 'c1' at row 1
340
INSERT INTO t1 VALUES (NULL);
341
INSERT INTO t1 VALUES (2);
342
INSERT INTO t1 VALUES (NULL);
343
INSERT INTO t1 VALUES (250);
344
INSERT INTO t1 VALUES (NULL);
354
INSERT INTO t1 VALUES (1000);
356
INSERT INTO t1 VALUES(NULL);
357
INSERT INTO t1 VALUES(NULL);
371
SET @@SESSION.AUTO_INCREMENT_INCREMENT=1, @@SESSION.AUTO_INCREMENT_OFFSET=1;
373
SHOW VARIABLES LIKE "%auto_inc%";
375
auto_increment_increment 1
376
auto_increment_offset 1
377
DROP TABLE IF EXISTS t1;
379
Note 1051 Unknown table 't1'
380
CREATE TABLE t1 (c1 INT UNSIGNED AUTO_INCREMENT, PRIMARY KEY(c1)) ENGINE=InnoDB;
381
INSERT INTO t1 VALUES(-1);
383
Warning 1264 Out of range value for column 'c1' at row 1
387
SET @@SESSION.AUTO_INCREMENT_INCREMENT=100, @@SESSION.AUTO_INCREMENT_OFFSET=10;
388
SHOW VARIABLES LIKE "%auto_inc%";
390
auto_increment_increment 100
391
auto_increment_offset 10
392
INSERT INTO t1 VALUES (-2),(NULL),(2),(NULL);
394
Warning 1264 Out of range value for column 'c1' at row 1
395
INSERT INTO t1 VALUES (250),(NULL);
405
INSERT INTO t1 VALUES (1000);
407
INSERT INTO t1 VALUES(NULL),(NULL);
408
Got one of the listed errors
420
SET @@SESSION.AUTO_INCREMENT_INCREMENT=1, @@SESSION.AUTO_INCREMENT_OFFSET=1;
422
SHOW VARIABLES LIKE "%auto_inc%";
424
auto_increment_increment 1
425
auto_increment_offset 1
426
DROP TABLE IF EXISTS t1;
428
Note 1051 Unknown table 't1'
429
CREATE TABLE t1 (c1 BIGINT AUTO_INCREMENT, PRIMARY KEY(c1)) ENGINE=InnoDB;
430
INSERT INTO t1 VALUES(NULL);
431
INSERT INTO t1 VALUES (9223372036854775794);
436
SET @@SESSION.AUTO_INCREMENT_INCREMENT=2, @@SESSION.AUTO_INCREMENT_OFFSET=10;
437
SHOW VARIABLES LIKE "%auto_inc%";
439
auto_increment_increment 2
440
auto_increment_offset 10
441
INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL);
453
SET @@SESSION.AUTO_INCREMENT_INCREMENT=1, @@SESSION.AUTO_INCREMENT_OFFSET=1;
455
SHOW VARIABLES LIKE "%auto_inc%";
457
auto_increment_increment 1
458
auto_increment_offset 1
459
DROP TABLE IF EXISTS t1;
461
Note 1051 Unknown table 't1'
462
CREATE TABLE t1 (c1 BIGINT UNSIGNED AUTO_INCREMENT, PRIMARY KEY(c1)) ENGINE=InnoDB;
463
INSERT INTO t1 VALUES(NULL);
464
INSERT INTO t1 VALUES (18446744073709551603);
469
SET @@SESSION.AUTO_INCREMENT_INCREMENT=2, @@SESSION.AUTO_INCREMENT_OFFSET=10;
470
SHOW VARIABLES LIKE "%auto_inc%";
472
auto_increment_increment 2
473
auto_increment_offset 10
474
INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL);
486
SET @@SESSION.AUTO_INCREMENT_INCREMENT=1, @@SESSION.AUTO_INCREMENT_OFFSET=1;
488
SHOW VARIABLES LIKE "%auto_inc%";
490
auto_increment_increment 1
491
auto_increment_offset 1
492
DROP TABLE IF EXISTS t1;
494
Note 1051 Unknown table 't1'
495
CREATE TABLE t1 (c1 BIGINT UNSIGNED AUTO_INCREMENT, PRIMARY KEY(c1)) ENGINE=InnoDB;
496
INSERT INTO t1 VALUES(NULL);
497
INSERT INTO t1 VALUES (18446744073709551603);
502
SET @@SESSION.AUTO_INCREMENT_INCREMENT=5, @@SESSION.AUTO_INCREMENT_OFFSET=7;
503
SHOW VARIABLES LIKE "%auto_inc%";
505
auto_increment_increment 5
506
auto_increment_offset 7
507
INSERT INTO t1 VALUES (NULL),(NULL);
515
SET @@SESSION.AUTO_INCREMENT_INCREMENT=1, @@SESSION.AUTO_INCREMENT_OFFSET=1;
517
SHOW VARIABLES LIKE "%auto_inc%";
519
auto_increment_increment 1
520
auto_increment_offset 1
521
DROP TABLE IF EXISTS t1;
523
Note 1051 Unknown table 't1'
524
CREATE TABLE t1 (c1 BIGINT AUTO_INCREMENT, PRIMARY KEY(c1)) ENGINE=InnoDB;
525
INSERT INTO t1 VALUES(NULL);
526
INSERT INTO t1 VALUES(-9223372036854775806);
527
INSERT INTO t1 VALUES(-9223372036854775807);
528
INSERT INTO t1 VALUES(-9223372036854775808);
535
SET @@SESSION.AUTO_INCREMENT_INCREMENT=3, @@SESSION.AUTO_INCREMENT_OFFSET=3;
536
SHOW VARIABLES LIKE "%auto_inc%";
538
auto_increment_increment 3
539
auto_increment_offset 3
540
INSERT INTO t1 VALUES (NULL),(NULL), (NULL);
551
SET @@SESSION.AUTO_INCREMENT_INCREMENT=1, @@SESSION.AUTO_INCREMENT_OFFSET=1;
553
SHOW VARIABLES LIKE "%auto_inc%";
555
auto_increment_increment 1
556
auto_increment_offset 1
557
DROP TABLE IF EXISTS t1;
559
Note 1051 Unknown table 't1'
560
CREATE TABLE t1 (c1 BIGINT UNSIGNED AUTO_INCREMENT, PRIMARY KEY(c1)) ENGINE=InnoDB;
561
INSERT INTO t1 VALUES(NULL);
562
INSERT INTO t1 VALUES (18446744073709551610);
567
SET @@SESSION.AUTO_INCREMENT_INCREMENT=1152921504606846976, @@SESSION.AUTO_INCREMENT_OFFSET=1152921504606846976;
569
Warning 1292 Truncated incorrect auto_increment_increment value: '1152921504606846976'
570
Warning 1292 Truncated incorrect auto_increment_offset value: '1152921504606846976'
571
SHOW VARIABLES LIKE "%auto_inc%";
573
auto_increment_increment 65535
574
auto_increment_offset 65535
575
INSERT INTO t1 VALUES (NULL);
582
SET @@SESSION.AUTO_INCREMENT_INCREMENT=1, @@SESSION.AUTO_INCREMENT_OFFSET=1;
584
SHOW VARIABLES LIKE "%auto_inc%";
586
auto_increment_increment 1
587
auto_increment_offset 1
588
CREATE TABLE t1 (c1 DOUBLE NOT NULL AUTO_INCREMENT, c2 INT, PRIMARY KEY (c1)) ENGINE=InnoDB;
589
INSERT INTO t1 VALUES(NULL, 1);
590
INSERT INTO t1 VALUES(NULL, 2);
595
ALTER TABLE t1 CHANGE c1 c1 SERIAL;
600
INSERT INTO t1 VALUES(NULL, 3);
601
INSERT INTO t1 VALUES(NULL, 4);
608
DROP TABLE IF EXISTS t1;
609
CREATE TABLE t1 (c1 FLOAT NOT NULL AUTO_INCREMENT, c2 INT, PRIMARY KEY (c1)) ENGINE=InnoDB;
610
INSERT INTO t1 VALUES(NULL, 1);
611
INSERT INTO t1 VALUES(NULL, 2);
616
ALTER TABLE t1 CHANGE c1 c1 SERIAL;
621
INSERT INTO t1 VALUES(NULL, 3);
622
INSERT INTO t1 VALUES(NULL, 4);
630
SET @@SESSION.AUTO_INCREMENT_INCREMENT=1, @@SESSION.AUTO_INCREMENT_OFFSET=5;
631
DROP TABLE IF EXISTS t1;
633
Note 1051 Unknown table 't1'
634
DROP TABLE IF EXISTS t2;
636
Note 1051 Unknown table 't2'
638
a INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
639
b INT(10) UNSIGNED NOT NULL,
640
c ENUM('FALSE','TRUE') DEFAULT NULL,
641
PRIMARY KEY (a)) ENGINE = InnoDB;
643
m INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
644
n INT(10) UNSIGNED NOT NULL,
645
o enum('FALSE','TRUE') DEFAULT NULL,
646
PRIMARY KEY (m)) ENGINE = InnoDB;
647
INSERT INTO t2 (n,o) VALUES
648
(1 , 'true'), (1 , 'false'), (2 , 'true'), (2 , 'false'), (3 , 'true'),
649
(3 , 'false'), (4 , 'true'), (4 , 'false'), (5 , 'true'), (5 , 'false');
650
SHOW CREATE TABLE t2;
652
t2 CREATE TABLE `t2` (
653
`m` int(11) unsigned NOT NULL AUTO_INCREMENT,
654
`n` int(10) unsigned NOT NULL,
655
`o` enum('FALSE','TRUE') DEFAULT NULL,
657
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1
658
INSERT INTO t1 (b,c) SELECT n,o FROM t2 ;
659
SHOW CREATE TABLE t1;
661
t1 CREATE TABLE `t1` (
662
`a` int(11) unsigned NOT NULL AUTO_INCREMENT,
663
`b` int(10) unsigned NOT NULL,
664
`c` enum('FALSE','TRUE') DEFAULT NULL,
666
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1
667
INSERT INTO t1 (b,c) SELECT n,o FROM t2 ;
690
SHOW CREATE TABLE t1;
692
t1 CREATE TABLE `t1` (
693
`a` int(11) unsigned NOT NULL AUTO_INCREMENT,
694
`b` int(10) unsigned NOT NULL,
695
`c` enum('FALSE','TRUE') DEFAULT NULL,
697
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1
698
INSERT INTO t1 (b,c) SELECT n,o FROM t2 WHERE o = 'false';
726
SHOW CREATE TABLE t1;
728
t1 CREATE TABLE `t1` (
729
`a` int(11) unsigned NOT NULL AUTO_INCREMENT,
730
`b` int(10) unsigned NOT NULL,
731
`c` enum('FALSE','TRUE') DEFAULT NULL,
733
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=latin1
734
INSERT INTO t1 (b,c) SELECT n,o FROM t2 WHERE o = 'false';
767
SHOW CREATE TABLE t1;
769
t1 CREATE TABLE `t1` (
770
`a` int(11) unsigned NOT NULL AUTO_INCREMENT,
771
`b` int(10) unsigned NOT NULL,
772
`c` enum('FALSE','TRUE') DEFAULT NULL,
774
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=latin1
775
INSERT INTO t1 (b,c) SELECT n,o FROM t2 WHERE o = 'false';
776
SHOW CREATE TABLE t1;
778
t1 CREATE TABLE `t1` (
779
`a` int(11) unsigned NOT NULL AUTO_INCREMENT,
780
`b` int(10) unsigned NOT NULL,
781
`c` enum('FALSE','TRUE') DEFAULT NULL,
783
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=latin1
784
INSERT INTO t1 (b,c) SELECT n,o FROM t2 WHERE o = 'false';
785
SHOW CREATE TABLE t1;
787
t1 CREATE TABLE `t1` (
788
`a` int(11) unsigned NOT NULL AUTO_INCREMENT,
789
`b` int(10) unsigned NOT NULL,
790
`c` enum('FALSE','TRUE') DEFAULT NULL,
792
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1
793
INSERT INTO t1 (b,c) SELECT n,o FROM t2 WHERE o = 'false';
841
SHOW CREATE TABLE t1;
843
t1 CREATE TABLE `t1` (
844
`a` int(11) unsigned NOT NULL AUTO_INCREMENT,
845
`b` int(10) unsigned NOT NULL,
846
`c` enum('FALSE','TRUE') DEFAULT NULL,
848
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=latin1
851
DROP TABLE IF EXISTS t1;
853
Note 1051 Unknown table 't1'
854
DROP TABLE IF EXISTS t2;
856
Note 1051 Unknown table 't2'
858
c1 INT(10) UNSIGNED NOT NULL AUTO_INCREMENT
859
PRIMARY KEY) ENGINE=InnoDB;
860
INSERT INTO t1 VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL);
862
c1 TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT
863
PRIMARY KEY) ENGINE=InnoDB;
864
INSERT INTO t2 SELECT c1 FROM t1;
865
Got one of the listed errors
866
INSERT INTO t2 SELECT NULL FROM t1;
867
Got one of the listed errors
870
SET @@SESSION.AUTO_INCREMENT_INCREMENT=1, @@SESSION.AUTO_INCREMENT_OFFSET=1;
871
CREATE TABLE t1 (c1 INT PRIMARY KEY AUTO_INCREMENT) ENGINE=InnoDB;
872
INSERT INTO t1 VALUES (null);
873
INSERT INTO t1 VALUES (null);
874
ALTER TABLE t1 CHANGE c1 d1 INT NOT NULL AUTO_INCREMENT;
883
INSERT INTO t1 VALUES(null);
884
Got one of the listed errors
885
ALTER TABLE t1 AUTO_INCREMENT = 3;
886
SHOW CREATE TABLE t1;
888
t1 CREATE TABLE `t1` (
889
`d1` int(11) NOT NULL AUTO_INCREMENT,
891
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1
892
INSERT INTO t1 VALUES(null);
899
SET @@SESSION.AUTO_INCREMENT_INCREMENT=1, @@SESSION.AUTO_INCREMENT_OFFSET=1;
900
SHOW VARIABLES LIKE "%auto_inc%";
902
auto_increment_increment 1
903
auto_increment_offset 1
904
CREATE TABLE t1 (c1 TINYINT PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB;
905
INSERT INTO t1 VALUES (1, NULL);
906
INSERT INTO t1 VALUES (-1, 'innodb');
907
INSERT INTO t1 VALUES (-127, 'innodb');
908
INSERT INTO t1 VALUES (NULL, NULL);
909
SHOW CREATE TABLE t1;
911
t1 CREATE TABLE `t1` (
912
`c1` tinyint(4) NOT NULL AUTO_INCREMENT,
913
`c2` varchar(10) DEFAULT NULL,
915
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
923
CREATE TABLE t1 (c1 TINYINT UNSIGNED PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB;
924
INSERT INTO t1 VALUES (1, NULL);
925
INSERT INTO t1 VALUES (-1, 'innodb');
927
Warning 1264 Out of range value for column 'c1' at row 1
928
INSERT INTO t1 VALUES (-127, 'innodb');
930
Warning 1264 Out of range value for column 'c1' at row 1
931
INSERT INTO t1 VALUES (NULL, NULL);
932
SHOW CREATE TABLE t1;
934
t1 CREATE TABLE `t1` (
935
`c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
936
`c2` varchar(10) DEFAULT NULL,
938
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1
946
CREATE TABLE t1 (c1 SMALLINT PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB;
947
INSERT INTO t1 VALUES (1, NULL);
948
INSERT INTO t1 VALUES (-1, 'innodb');
949
INSERT INTO t1 VALUES (-32767, 'innodb');
950
INSERT INTO t1 VALUES (NULL, NULL);
951
SHOW CREATE TABLE t1;
953
t1 CREATE TABLE `t1` (
954
`c1` smallint(6) NOT NULL AUTO_INCREMENT,
955
`c2` varchar(10) DEFAULT NULL,
957
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
965
CREATE TABLE t1 (c1 SMALLINT UNSIGNED PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB;
966
INSERT INTO t1 VALUES (1, NULL);
967
INSERT INTO t1 VALUES (-1, 'innodb');
969
Warning 1264 Out of range value for column 'c1' at row 1
970
INSERT INTO t1 VALUES (-32757, 'innodb');
972
Warning 1264 Out of range value for column 'c1' at row 1
973
INSERT INTO t1 VALUES (NULL, NULL);
974
SHOW CREATE TABLE t1;
976
t1 CREATE TABLE `t1` (
977
`c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
978
`c2` varchar(10) DEFAULT NULL,
980
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1
988
CREATE TABLE t1 (c1 MEDIUMINT PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB;
989
INSERT INTO t1 VALUES (1, NULL);
990
INSERT INTO t1 VALUES (-1, 'innodb');
991
INSERT INTO t1 VALUES (-8388607, 'innodb');
992
INSERT INTO t1 VALUES (NULL, NULL);
993
SHOW CREATE TABLE t1;
995
t1 CREATE TABLE `t1` (
996
`c1` mediumint(9) NOT NULL AUTO_INCREMENT,
997
`c2` varchar(10) DEFAULT NULL,
999
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
1007
CREATE TABLE t1 (c1 MEDIUMINT UNSIGNED PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB;
1008
INSERT INTO t1 VALUES (1, NULL);
1009
INSERT INTO t1 VALUES (-1, 'innodb');
1011
Warning 1264 Out of range value for column 'c1' at row 1
1012
INSERT INTO t1 VALUES (-8388607, 'innodb');
1014
Warning 1264 Out of range value for column 'c1' at row 1
1015
INSERT INTO t1 VALUES (NULL, NULL);
1016
SHOW CREATE TABLE t1;
1018
t1 CREATE TABLE `t1` (
1019
`c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
1020
`c2` varchar(10) DEFAULT NULL,
1022
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1
1030
CREATE TABLE t1 (c1 INT PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB;
1031
INSERT INTO t1 VALUES (1, NULL);
1032
INSERT INTO t1 VALUES (-1, 'innodb');
1033
INSERT INTO t1 VALUES (-2147483647, 'innodb');
1034
INSERT INTO t1 VALUES (NULL, NULL);
1035
SHOW CREATE TABLE t1;
1037
t1 CREATE TABLE `t1` (
1038
`c1` int(11) NOT NULL AUTO_INCREMENT,
1039
`c2` varchar(10) DEFAULT NULL,
1041
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
1049
CREATE TABLE t1 (c1 INT UNSIGNED PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB;
1050
INSERT INTO t1 VALUES (1, NULL);
1051
INSERT INTO t1 VALUES (-1, 'innodb');
1053
Warning 1264 Out of range value for column 'c1' at row 1
1054
INSERT INTO t1 VALUES (-2147483647, 'innodb');
1056
Warning 1264 Out of range value for column 'c1' at row 1
1057
INSERT INTO t1 VALUES (NULL, NULL);
1058
SHOW CREATE TABLE t1;
1060
t1 CREATE TABLE `t1` (
1061
`c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
1062
`c2` varchar(10) DEFAULT NULL,
1064
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1
1072
CREATE TABLE t1 (c1 BIGINT PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB;
1073
INSERT INTO t1 VALUES (1, NULL);
1074
INSERT INTO t1 VALUES (-1, 'innodb');
1075
INSERT INTO t1 VALUES (-9223372036854775807, 'innodb');
1076
INSERT INTO t1 VALUES (NULL, NULL);
1077
SHOW CREATE TABLE t1;
1079
t1 CREATE TABLE `t1` (
1080
`c1` bigint(20) NOT NULL AUTO_INCREMENT,
1081
`c2` varchar(10) DEFAULT NULL,
1083
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
1086
-9223372036854775807 innodb
1091
CREATE TABLE t1 (c1 BIGINT UNSIGNED PRIMARY KEY AUTO_INCREMENT, c2 VARCHAR(10)) ENGINE=InnoDB;
1092
INSERT INTO t1 VALUES (1, NULL);
1093
INSERT INTO t1 VALUES (-1, 'innodb');
1095
Warning 1264 Out of range value for column 'c1' at row 1
1096
INSERT INTO t1 VALUES (-9223372036854775807, 'innodb');
1098
Warning 1264 Out of range value for column 'c1' at row 1
1099
INSERT INTO t1 VALUES (NULL, NULL);
1100
SHOW CREATE TABLE t1;
1102
t1 CREATE TABLE `t1` (
1103
`c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1104
`c2` varchar(10) DEFAULT NULL,
1106
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1
1114
CREATE TABLE T1 (c1 INT AUTO_INCREMENT, c2 INT, PRIMARY KEY(c1)) AUTO_INCREMENT=10 ENGINE=InnoDB;
1115
CREATE INDEX i1 on T1(c2);
1116
SHOW CREATE TABLE T1;
1118
T1 CREATE TABLE `T1` (
1119
`c1` int(11) NOT NULL AUTO_INCREMENT,
1120
`c2` int(11) DEFAULT NULL,
1123
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1
1124
INSERT INTO T1 (c2) values (0);