[MDEV-22906] Disallow system_versioning_asof in DML - Jira

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.3(EOL), 10.4(EOL), 10.5
Fix Version/s: 10.3.24, 10.4.14, 10.5.5
Component/s: Data Manipulation - Delete, Data Manipulation - Insert, Data Manipulation - Update, Versioned Tables
Labels:
None

create or replace table t1 (x int) with system versioning;

create or replace table t2 (y int);

insert into t1 values (1);

insert into t2 values (1);

set system_versioning_asof= '1970-01-01 00:00:00';

delete t1, t2 from t1 join t2 where t1.x = t2.y;

select * from t1;

select * from t2;

drop tables t1, t2;

Multi-delete didn't delete from t1

system_versioning_asof has no influence on multi-delete, multi-update, insert-select, replace-select.

relates to

MDEV-22912 Document system_versioning_asof having no influence on DML

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

MariaDB Server