Debian Codegraph @

mysql-test/suite/innodb/r/innodb-autoinc-44030.result

raw
1 SET @@SESSION.AUTO_INCREMENT_INCREMENT=1, @@SESSION.AUTO_INCREMENT_OFFSET=1;
2 CREATE TABLE t1 (c1 INT PRIMARY KEY AUTO_INCREMENT) ENGINE=InnoDB;
3 INSERT INTO t1 VALUES (null);
4 INSERT INTO t1 VALUES (null);
5 ALTER TABLE t1 CHANGE c1 d1 INT NOT NULL AUTO_INCREMENT;
6 affected rows: 0
7 info: Records: 0 Duplicates: 0 Warnings: 0
8 SELECT * FROM t1;
9 d1
10 1
11 2
12 # restart
13 SHOW CREATE TABLE t1;
14 Table Create Table
15 t1 CREATE TABLE `t1` (
16 `d1` int(11) NOT NULL AUTO_INCREMENT,
17 PRIMARY KEY (`d1`)
18 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
19 INSERT INTO t1 VALUES(null);
20 SELECT * FROM t1;
21 d1
22 1
23 2
24 3
25 ALTER TABLE t1 AUTO_INCREMENT = 3;
26 affected rows: 0
27 info: Records: 0 Duplicates: 0 Warnings: 0
28 SHOW CREATE TABLE t1;
29 Table Create Table
30 t1 CREATE TABLE `t1` (
31 `d1` int(11) NOT NULL AUTO_INCREMENT,
32 PRIMARY KEY (`d1`)
33 ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
34 INSERT INTO t1 VALUES(null);
35 INSERT INTO t1 VALUES(null);
36 SELECT * FROM t1;
37 d1
38 1
39 2
40 3
41 4
42 5
43 DROP TABLE t1;