Reproduce
# Truncate partitioned
|
create or replace table t (a int) with system versioning
|
partition by system_time limit 1 partitions 3;
|
insert into t values (1);
|
update t set a= 2;
|
update t set a= 3;
|
delete history from t;
|
Warnings:
|
Warning 4114 Versioned table `test`.`t`: last HISTORY partition (`p1`) is out of LIMIT, need more HISTORY partitions
|
# The above warning is one command late (MDEV-20345) ^^^
|
Optimize calling vers_set_hist_part()
1. Look for TODO in `ha_partition::external_lock()` and `ha_partition::start_stmt()` and add more excluding conditions.
2. Add test cases for INSERT SELECT, REPLACE SELECT, etc.
3. Test INSERT and history modification setting. Should limits be followed when inserting into history partition?
|