Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-30749

Feature request - Adding 'Begin or Start' & 'End or Stop' parameter on trigger when specific situation

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      • Whem using a syntax like
        'insert into table select * from view' which multiple records inserted at once(same to delete/update statement), wanna get the flag or parameter in trigger of the table 'table' in the sample syntax.
      • After implemtation of this request, for example,
        a trigger of the 'table' will be return some flag that
        'new.massive_start = true' right before actually started the insertion.
        and and after finish of the last insertion, 'new.massive_end = true'. (of cause, each of flag will be vback to false when not the right timing)
      • So the situation detail will be below.
        1. user call 'insert into table select * from view or table.'
        2. the before trigger of the table's insert, will provide
        > new.massive_start = true/new.massive_index=0/new.massive_end = false
        3. the after trigger of the table's insert, will provide
        > new.massive_start = false/new.massive_index=0/new.massive_end = false
        4. the before/after trigger of the table's insert middle of insertion task, will provide
        > new.massive_start = false/new.massive_index=n/new.massive_end = false
        5. the after trigger of the table's insert actuatlly after insertion task, will provide
        > new.massive_start = false/new.massive_index=n/new.massive_end = true

      The reason why we need it is,
      need preparing batch end ending batch for sepecific tasks. Which unpredictable in sequence. With this, we can do our job efficintly

      Attachments

        Activity

          People

            Unassigned Unassigned
            npdmailing@gmail.com Mitchell Lee
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.