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

Add, drop system versioning semantic and syntax

    XMLWordPrintable

Details

    Description

      Here is a descriptive list how various clauses should work:

      • New clause DROP PERIOD FOR SYSTEM_TIME
      • ALTER TABLE DROP COLUMN sys_trx_start, DROP COLUMN sys_trx_end, DROP PERIOD FOR SYSTEM_TIME, DROP SYSTEM VERSIONING should work as ALTER TABLE DROP SYSTEM VERSIONING
      • ALTER TABLE DROP COLUMN sys_trx_start, DROP COLUMN sys_trx_end, DROP PERIOD FOR SYSTEM_TIME should make fields and period invisible
      • ALTER TABLE DROP COLUMN sys_trx_start, DROP COLUMN sys_trx_end does the same (the period is "dropped" implicitly when all its columns are dropped)
      • DROP PERIOD FOR SYSTEM_TIME produces an error (DROP COLUMN sys_trx_start, DROP COLUMN sys_trx_end is missing)
      • ALTER TABLE DROP COLUMN sys_trx_start - error (cannot drop just one column from the period)
      • drop system versioning should not require invisibility of `sys_trx_*`

      Attachments

        Activity

          People

            kevg Eugene Kosov (Inactive)
            kevg Eugene Kosov (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.