1CREATE TABLE t1 (pk INT AUTO_INCREMENT PRIMARY KEY) PARTITION BY KEY (pk) PARTITIONS 2;
2INSERT INTO t1 VALUES (NULL),(NULL);
3UPDATE t1 SET pk = 2147483647;
4ERROR 23000: Duplicate entry '2147483647' for key 'PRIMARY'
5REPLACE INTO t1 VALUES (NULL);
6ERROR 22003: Out of range value for column 'pk' at row 1
7DROP TABLE t1;
8