Debian Codegraph @

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;