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
CREATE TABLE t1 (c1 INT PRIMARY KEY AUTO_INCREMENT) ENGINE=InnoDB;
871
INSERT INTO t1 VALUES (null);
872
INSERT INTO t1 VALUES (null);
873
ALTER TABLE t1 CHANGE c1 d1 INT NOT NULL AUTO_INCREMENT;
882
INSERT INTO t1 VALUES(null);
883
Got one of the listed errors
884
ALTER TABLE t1 AUTO_INCREMENT = 3;
885
INSERT INTO t1 VALUES(null);