Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-16972 Application-time periods support (phase 1)
  3. MDEV-16975

Application-time periods: ALTER TABLE

Details

    • Technical task
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • None
    • 10.4.3
    • Versioned Tables
    • None

    Description

      ALTER TABLE (ADD|DROP) PERIOD FOR <apptime>

      <add table period definition> ::=
      		 
        ADD <table period definition> [ <add system time period column list> ]
      		 
      <add system time period column list> ::=
      		 
        ADD [ COLUMN ] <column definition 1> ADD [ COLUMN ] <column definition 2>


      <drop table period definition> ::=
      		 
      DROP <system or application time period specification> <drop behavior>

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27704 Unclear error message when dropping a period defined using WITHOUT OVERLAPS

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            nikitamalyavin Nikita Malyavin created issue -
            nikitamalyavin Nikita Malyavin made changes -
            Field Original Value New Value
            Description {{ALTER TABLE (ADD|DROP) PERIOD FOR <apptime>}} {{ALTER TABLE (ADD|DROP) PERIOD FOR <apptime>}}

            {code}
            <add table period definition> ::=
              ADD <table period definition> [ <add system time period column list> ]
            <add system time period column list> ::=
              ADD [ COLUMN ] <column definition 1> ADD [ COLUMN ] <column definition 2>
            {code}
            {code}
            <drop table period definition> ::=
            DROP <system or application time period specification> <drop behavior>
            {code}
            ralf.gebhardt Ralf Gebhardt made changes -
            Component/s System versioning [ 14303 ]
            nikitamalyavin Nikita Malyavin made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            midenok Aleksey Midenkov made changes -
            Assignee Nikita Malyavin [ nikitamalyavin ] Aleksey Midenok [ midenok ]
            midenok Aleksey Midenkov made changes -
            Assignee Aleksey Midenok [ midenok ] Nikita Malyavin [ nikitamalyavin ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.4 [ 22408 ]
            nikitamalyavin Nikita Malyavin made changes -
            Assignee Nikita Malyavin [ nikitamalyavin ] Sergei Golubchik [ serg ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Nikita Malyavin [ nikitamalyavin ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            nikitamalyavin Nikita Malyavin made changes -
            Summary Application period tables: ALTER TABLE Application-time periods: ALTER TABLE
            nikitamalyavin Nikita Malyavin made changes -
            Assignee Nikita Malyavin [ nikitamalyavin ] Sergei Golubchik [ serg ]
            Status Stalled [ 10000 ] In Review [ 10002 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.4.3 [ 23230 ]
            Fix Version/s 10.4 [ 22408 ]
            Assignee Sergei Golubchik [ serg ] Nikita Malyavin [ nikitamalyavin ]
            Resolution Fixed [ 1 ]
            Status In Review [ 10002 ] Closed [ 6 ]
            GeoffMontee Geoff Montee (Inactive) made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 88903 ] MariaDB v4 [ 154794 ]

            People

              nikitamalyavin Nikita Malyavin
              nikitamalyavin Nikita Malyavin
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.