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

          Activity

            Transition Time In Source Status Execution Times
            Nikita Malyavin made transition -
            Open In Progress
            14h 32m 1
            Nikita Malyavin made transition -
            Stalled In Review
            22h 56m 1
            Sergei Golubchik made transition -
            In Review Stalled
            126d 17h 7m 2
            Nikita Malyavin made transition -
            Stalled In Progress
            16d 56m 1
            Nikita Malyavin made transition -
            In Progress In Review
            30d 1h 11m 2
            Sergei Golubchik made transition -
            In Review Closed
            16d 15h 18m 1

            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.