Method find_trigger

sql/sql_trigger.cc:1364–1414

*/

Trigger *Table_triggers_list::find_trigger(const LEX_CSTRING *name,
                                           bool remove_from_list)
{
  Trigger *trigger = nullptr;

  for (uint i= 0; i < (uint)TRG_EVENT_MAX; i++)
  {
    for (uint j= 0; j < (uint)TRG_ACTION_MAX; j++)
    {
      Trigger **parent;

      for (parent= &triggers[i][j];
           (trigger= *parent);
           parent= &trigger->next[i])
      {
        if (trigger->name.streq(*name))
        {
          if (remove_from_list)
          {
            *parent= trigger->next[i];
            count--;
            /*
              in case only one event left or was assigned to this trigger
              return it, else continue iterations to remove the trigger
              from all events entries.
            */
            if (trigger->events != (1 << i))
            {
              /*
                Turn off event bits in the mask as the trigger is removed
                from the array for corresponding trigger event action.
                Eventually, we come to the last event this trigger is
                associated to. The associated trigger be returned from
                the method and finally deleted.
              */
              trigger->events &= ~(1 << i);
              continue;
            }
          }
          return trigger;
        }
      }
    }
  }
  /*
    We come to this point if either remove_from_list == true and
    the trigger is associated with multiple events, or there is no a trigger
    with requested name.
  */
  return trigger;
}


/**