Application-time periods support (phase 1) (MDEV-16972)

[MDEV-16973] Application-time periods: DELETE Created: 2018-08-14  Updated: 2019-02-21  Resolved: 2019-02-21

Status: Closed
Project: MariaDB Server
Component/s: Versioned Tables
Affects Version/s: None
Fix Version/s: 10.4.3

Type: Technical task Priority: Major
Reporter: Nikita Malyavin Assignee: Nikita Malyavin
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-17209 App-period: unexpected warning on delete Open

 Description   

The syntax looks as following:
DELETE FROM t FOR PORTION OF <apptime> FROM <FROMVAL> TO <TOVAL>

For the case when row period is not totally inside <FROMVAL>...<TOVAL>, then the deletion should act like DELETE+INSERT (or two INSERTS if needed) was done.
This is important if we have DELETE/INSERT triggers.

If not, then more preferable way is to minimize the DELETE operations (in favor UPDATE ones)



 Comments   
Comment by Nikita Malyavin [ 2018-08-15 ]

The patch will also include CREATE TABLE part. It was already done when this tasks were created

Generated at Thu Feb 08 08:32:57 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.