Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-27293

Allow converting a versioned table from implicit to explicit row_start/row_end columns

Details

    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

          Activity

            Transition Time In Source Status Execution Times
            Aleksey Midenkov made transition -
            Open In Progress
            822d 4h 44m 1
            Aleksey Midenkov made transition -
            In Progress In Review
            3m 10s 1
            Nikita Malyavin made transition -
            In Review Stalled
            71d 2h 58m 1
            Aleksey Midenkov made transition -
            Closed Stalled
            4m 38s 1
            Aleksey Midenkov made transition -
            In Progress In Testing
            9h 34m 1
            Lena Startseva made transition -
            In Testing Stalled
            62d 22h 5m 1
            Aleksey Midenkov made transition -
            Stalled In Progress
            55d 18h 6m 3
            Aleksey Midenkov made transition -
            In Progress Closed
            34d 21h 55m 2

            People

              midenok Aleksey Midenkov
              valerii Valerii Kravchuk
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.