Debian Codegraph @

mysql-test/suite/parts/t/mdev_24610.test

raw
1 --source include/have_innodb.inc
2 --source include/have_partition.inc
3
4 CREATE TABLE t (c BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY) ENGINE=MEMORY PARTITION BY KEY();
5 INSERT INTO t VALUES (18446744073709551615);
6 select * from t;
7 drop table t;
8
9 CREATE TABLE t (c BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY) ENGINE=MEMORY;
10 INSERT INTO t VALUES (18446744073709551615);
11 ALTER TABLE t PARTITION BY KEY();
12 INSERT INTO t VALUES (1);
13 select * from t;
14 drop table t;
15
16 CREATE TABLE t (c BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY) ENGINE=MEMORY;
17 INSERT INTO t VALUES (18446744073709551615);
18 ALTER TABLE t PARTITION BY KEY();
19 --error ER_AUTOINC_READ_FAILED
20 INSERT INTO t VALUES (NULL);
21 select * from t;
22 drop table t;