Debian Codegraph @

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

raw
1 #
2 # MDEV-28416 Incorrect AUTO_INCREMENT may be issued
3 #
4 SET @aii=@@auto_increment_increment;
5 SET auto_increment_increment=300;
6 CREATE TABLE t1 (a SERIAL) ENGINE=innodb
7 PARTITION BY RANGE (a) (
8 PARTITION p0 VALUES LESS THAN (6),
9 PARTITION p1 VALUES LESS THAN MAXVALUE
10 );
11 INSERT INTO t1 VALUES (18446744073709551613);
12 SHOW CREATE TABLE t1;
13 Table Create Table
14 t1 CREATE TABLE `t1` (
15 `a` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
16 UNIQUE KEY `a` (`a`)
17 ) ENGINE=InnoDB AUTO_INCREMENT=18446744073709551614 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
18 PARTITION BY RANGE (`a`)
19 (PARTITION `p0` VALUES LESS THAN (6) ENGINE = InnoDB,
20 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = InnoDB)
21 INSERT INTO t1 VALUES (NULL);
22 ERROR 22003: Out of range value for column 'a' at row 1
23 SHOW CREATE TABLE t1;
24 Table Create Table
25 t1 CREATE TABLE `t1` (
26 `a` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
27 UNIQUE KEY `a` (`a`)
28 ) ENGINE=InnoDB AUTO_INCREMENT=298 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
29 PARTITION BY RANGE (`a`)
30 (PARTITION `p0` VALUES LESS THAN (6) ENGINE = InnoDB,
31 PARTITION `p1` VALUES LESS THAN MAXVALUE ENGINE = InnoDB)
32 DROP TABLE t1;
33 SET auto_increment_increment=@aii;
34 # End of 10.2 tests