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

            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

            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.