Details
-
New Feature
-
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