[MDEV-20345] Warning of full history partition is one command late - Jira

XML

Word

Printable

# 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) ^^^

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?

duplicates

MDEV-20077 Warning on full history partition is delayed until next DML statement

relates to

MDEV-20336 Assertion bitmap_is_set(read_partitions) upon SELECT FOR UPDATE from versioned table

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.