mysql-test/suite/parts/t/mdev_21007.test
raw| 1 | --source include/have_partition.inc |
| 2 | |
| 3 | CREATE TABLE t1 (a INT) PARTITION BY RANGE (a) (PARTITION p0 VALUES LESS THAN (1), PARTITION p1 VALUES LESS THAN (MAXVALUE)); |
| 4 | INSERT INTO t1 VALUES (1),(2); |
| 5 | ALTER TABLE t1 MODIFY a INT AUTO_INCREMENT PRIMARY KEY; |
| 6 | UPDATE t1 PARTITION (p1) SET a=9 ORDER BY a LIMIT 1; |
| 7 | |
| 8 | # Cleanup |
| 9 | DROP TABLE t1; |