Debian Codegraph @

mysql-test/suite/innodb/t/innodb-autoinc-part.test

raw
1 --source include/have_partition.inc
2 --source include/have_innodb.inc
3
4 --echo #
5 --echo # MDEV-28416 Incorrect AUTO_INCREMENT may be issued
6 --echo #
7
8 SET @aii=@@auto_increment_increment;
9 SET auto_increment_increment=300;
10
11 CREATE TABLE t1 (a SERIAL) ENGINE=innodb
12 PARTITION BY RANGE (a) (
13 PARTITION p0 VALUES LESS THAN (6),
14 PARTITION p1 VALUES LESS THAN MAXVALUE
15 );
16 INSERT INTO t1 VALUES (18446744073709551613);
17 SHOW CREATE TABLE t1;
18 --error HA_ERR_AUTOINC_ERANGE
19 INSERT INTO t1 VALUES (NULL);
20 SHOW CREATE TABLE t1;
21 DROP TABLE t1;
22 SET auto_increment_increment=@aii;
23
24 --echo # End of 10.2 tests