mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 02:46:29 +01:00
a73c3f1077Commit 6dce6aeceb breaks out of a loop
in ha_partition::info when some partitions aren't opened, in which
case auto_increment_value assertion will fail. This commit patches
that hole.
9 lines
331 B
Text
9 lines
331 B
Text
--source include/have_partition.inc
|
|
|
|
CREATE TABLE t1 (a INT) PARTITION BY RANGE (a) (PARTITION p0 VALUES LESS THAN (1), PARTITION p1 VALUES LESS THAN (MAXVALUE));
|
|
INSERT INTO t1 VALUES (1),(2);
|
|
ALTER TABLE t1 MODIFY a INT AUTO_INCREMENT PRIMARY KEY;
|
|
UPDATE t1 PARTITION (p1) SET a=9 ORDER BY a LIMIT 1;
|
|
|
|
# Cleanup
|
|
DROP TABLE t1;
|