Details
-
Task
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.3.1-1, 10.3.1-2, 10.1.30
Description
Implement support for "System-versioned tables" as in SQL:2016.
Clauses PERIOD SYSTEM_TIME, WITH SYSTEM VERSIONING, FOR SYSTEM_TIME AS OF, FOR SYSTEM_TIME BETWEEN ... AND, FOR SYSTEM_TIME FROM ... TO.
Attachments
Issue Links
- causes
-
MDEV-26928 Column-inclusive WITH SYSTEM VERSIONING doesn't work with explicit system fields
- Closed
-
MDEV-26934 ADD SYSTEM VERSIONING and modify column WITHOUT SYSTEM VERSIONING in single ALTER TABLE command
- Open
-
MDEV-26993 Add system versioning via modify column WITH SYSTEM VERSIONING
- Open
-
MDEV-26994 Transaction-precise tables ignore most recent row versions when queried with "FOR SYSTEM_TIME FROM ts TO ts"
- Stalled
- duplicates
-
MDEV-12739 Preserve data in a non-rewriteable and non-erasable format
- Closed
- includes
-
MDEV-14556 inconsistent NOW behavior DEFAULT/ASOF
- Open
- is blocked by
-
MDEV-10177 Invisible columns
- Closed
- relates to
-
MDEV-14660 Assertion failure in lock_move_rec_list_start() after instant ADD COLUMN
- Closed
-
MDEV-14825 Assertion `col->ord_part' in row_build_index_entry_low upon ROLLBACK or DELETE with concurrent ALTER on partitioned table
- Closed