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

        Activity

          People

            nikitamalyavin Nikita Malyavin
            valerii Valerii Kravchuk
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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