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

    XMLWordPrintable

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

            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.