|
First execution of PS can auto-create partition fine (if it's needed). But the 2nd execution cannot.
--source include/have_partition.inc
|
|
create table t (a int) with system versioning
|
partition by system_time interval 1 hour auto;
|
|
insert into t values (1),(2);
|
prepare stmt from "update t set a = a + 1";
|
set @@timestamp= @@timestamp+3601;
|
execute stmt;
|
set @@timestamp= @@timestamp+3601;
|
execute stmt;
|
|
# Cleanup
|
drop table t;
|
|
bb-10.6-midenok-MDEV-17554 edbc73ac4
|
prepare stmt from "update t set a = a + 1";
|
set @@timestamp= @@timestamp+3601;
|
execute stmt;
|
set @@timestamp= @@timestamp+3601;
|
execute stmt;
|
Warnings:
|
Warning 4114 Versioned table `test`.`t`: last HISTORY partition (`p1`) is out of INTERVAL, need more HISTORY partitions
|
Same with stored procedures.
|