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

            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.