Details
-
New Feature
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
Description
It would make sense to allow converting a table from implicit to explicit row start/end columns. Like this:
create table t1 (...) with system versioning;
|
alter table t1 add column rs timestamp(6) as row start, add column re timestamp(6) as row end, add period for system_time (rs,re);
|
This would allow to add indexes on these columns post factum, when the table history grows, and still preserve the history.
Attachments
Issue Links
- causes
-
MDEV-34904 Inplace alter for implicit to explicit versioning is broken
-
- Closed
-
Activity
Transition | Time In Source Status | Execution Times |
---|
|
822d 4h 44m | 1 |
|
3m 10s | 1 |
|
71d 2h 58m | 1 |
|
4m 38s | 1 |
|
9h 34m | 1 |
|
62d 22h 5m | 1 |
|
55d 18h 6m | 3 |
|
34d 21h 55m | 2 |