[MDEV-30749] Feature request - Adding 'Begin or Start' & 'End or Stop' parameter on trigger when specific situation Created: 2023-02-28  Updated: 2023-02-28

Status: Open
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Task Priority: Major
Reporter: Mitchell Lee Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: 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


Generated at Thu Feb 08 10:18:36 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.