mysql-test/suite/parts/t/partition_auto_increment_max.test
raw| 1 | --source include/have_partition.inc |
| 2 | --source include/have_log_bin.inc |
| 3 | |
| 4 | CREATE TABLE t1 (pk INT AUTO_INCREMENT PRIMARY KEY) PARTITION BY KEY (pk) PARTITIONS 2; |
| 5 | INSERT INTO t1 VALUES (NULL),(NULL); |
| 6 | |
| 7 | --error ER_DUP_ENTRY |
| 8 | UPDATE t1 SET pk = 2147483647; |
| 9 | --error HA_ERR_AUTOINC_ERANGE |
| 10 | REPLACE INTO t1 VALUES (NULL); |
| 11 | |
| 12 | DROP TABLE t1; |