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

Application-time periods: DELETE

Details

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

    Description

      The syntax looks as following:
      DELETE FROM t FOR PORTION OF <apptime> FROM <FROMVAL> TO <TOVAL>

      For the case when row period is not totally inside <FROMVAL>...<TOVAL>, then the deletion should act like DELETE+INSERT (or two INSERTS if needed) was done.
      This is important if we have DELETE/INSERT triggers.

      If not, then more preferable way is to minimize the DELETE operations (in favor UPDATE ones)

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17209 App-period: unexpected warning on delete

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • 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
            nikitamalyavin Nikita Malyavin made changes -
            Parent MDEV-16972 [ 69182 ]
            Issue Type Task [ 3 ] Technical task [ 7 ]
            nikitamalyavin Nikita Malyavin made changes -
            nikitamalyavin Nikita Malyavin made changes -
            Summary Applicationn period tables: DELETE Application period tables: DELETE
            nikitamalyavin Nikita Malyavin made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            nikitamalyavin Nikita Malyavin added a comment -

            The patch will also include CREATE TABLE part. It was already done when this tasks were created

            nikitamalyavin Nikita Malyavin added a comment - The patch will also include CREATE TABLE part. It was already done when this tasks were created
            nikitamalyavin Nikita Malyavin made changes -
            Description The syntax looks as following:
            {{DELETE FROM t FOR PORTION OF <apptime> FROM...TO,,,}}             		The syntax looks as following:
            {{DELETE FROM t FOR PORTION OF <apptime> FROM <FROMVAL> TO <TOVAL>}}

            For the case when row period is not totally inside <FROMVAL>...<TOVAL>, then the deletion should act like DELETE+INSERT (or two INSERTS if needed) was done.
            This is important if we have DELETE/INSERT triggers.

            If not, then more preferable way is to minimize the DELETE operations (in favor UPDATE ones)
            nikitamalyavin Nikita Malyavin made changes -
            nikitamalyavin Nikita Malyavin made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Component/s System versioning [ 14303 ]
            midenok Aleksey Midenkov made changes -
            Assignee Nikita Malyavin [ nikitamalyavin ] Aleksey Midenok [ midenok ]
            midenok Aleksey Midenkov made changes -
            Status In Progress [ 3 ] In Review [ 10002 ]
            nikitamalyavin Nikita Malyavin made changes -
            midenok Aleksey Midenkov made changes -
            Assignee Aleksey Midenok [ midenok ] Nikita Malyavin [ nikitamalyavin ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            nikitamalyavin Nikita Malyavin made changes -
            Assignee Nikita Malyavin [ nikitamalyavin ] Sergei Golubchik [ serg ]
            Status Stalled [ 10000 ] In Review [ 10002 ]
            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: DELETE Application-time periods: DELETE
            nikitamalyavin Nikita Malyavin made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            nikitamalyavin Nikita Malyavin made changes -
            Assignee Nikita Malyavin [ nikitamalyavin ] Sergei Golubchik [ serg ]
            Status In Progress [ 3 ] 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 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 88901 ] MariaDB v4 [ 154792 ]

            People

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