[MDEV-22906] Disallow system_versioning_asof in DML Created: 2020-06-16  Updated: 2020-06-16  Resolved: 2020-06-16

Status: Closed
Project: MariaDB Server
Component/s: Data Manipulation - Delete, Data Manipulation - Insert, Data Manipulation - Update, Versioned Tables
Affects Version/s: 10.3, 10.4, 10.5
Fix Version/s: 10.3.24, 10.4.14, 10.5.5

Type: Bug Priority: Major
Reporter: Aleksey Midenkov Assignee: Aleksey Midenkov
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-22912 Document system_versioning_asof havin... Open

 Description   

Reproduce

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;

Result

Multi-delete didn't delete from t1

Expected

system_versioning_asof has no influence on multi-delete, multi-update, insert-select, replace-select.
Generated at Thu Feb 08 09:18:22 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.