Details
-
Technical task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
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)
Attachments
Issue Links
- relates to
-
MDEV-17209 App-period: unexpected warning on delete
-
- Open
-
Activity
Transition | Time In Source Status | Execution Times |
---|
|
14h 32m | 1 |
|
22h 56m | 1 |
|
126d 17h 7m | 2 |
|
16d 56m | 1 |
|
30d 1h 11m | 2 |
|
16d 15h 18m | 1 |