Function store_trigger

sql/sql_show.cc:7835–7910

static bool store_trigger(THD *thd, Trigger *trigger, TABLE *table,
                          const LEX_CSTRING *db_name,
                          const LEX_CSTRING *table_name, bool trigger_priv)
{
  CHARSET_INFO *cs= system_charset_info;
  LEX_CSTRING sql_mode_rep;
  MYSQL_TIME timestamp;
  char definer_holder[USER_HOST_BUFF_SIZE];
  LEX_STRING definer_buffer;
  LEX_CSTRING trigger_stmt, trigger_body;
  definer_buffer.str= definer_holder;

  trigger->get_trigger_info(&trigger_stmt, &trigger_body, &definer_buffer);

  restore_record(table, s->default_values);
  table->field[0]->store(STRING_WITH_LEN("def"), cs);
  table->field[1]->store(db_name->str, db_name->length, cs);
  table->field[2]->store(trigger->name.str, trigger->name.length, cs);
  DBUG_ASSERT(trigger->events < trg2bit(TRG_EVENT_MAX));
  table->field[3]->store(trg_event_type_names[trigger->events].str,
                         trg_event_type_names[trigger->events].length, cs);
  table->field[4]->store(STRING_WITH_LEN("def"), cs);
  table->field[5]->store(db_name->str, db_name->length, cs);
  table->field[6]->store(table_name->str, table_name->length, cs);

  StringBuffer<STRING_BUFFER_USUAL_SIZE> buff;
  for (int i=0;i < TRG_EVENT_MAX; i++)
  {
    if (trigger->action_order[i])
    {
      if (!buff.is_empty())
        buff.append(',');
      buff.append_longlong(trigger->action_order[i]);
    }

    table->field[7]->store(buff.ptr(), buff.length(), cs);
  }

  if (trigger_priv)
  {
    table->field[9]->set_notnull();
    table->field[18]->set_notnull();
    table->field[9]->store(trigger_body.str, trigger_body.length, cs);
    table->field[18]->store(definer_buffer.str, definer_buffer.length, cs);
  }
  else
  {
    table->field[9]->set_null();
    table->field[18]->set_null();
  }

  table->field[10]->store(STRING_WITH_LEN("ROW"), cs);
  table->field[11]->store(trg_action_time_type_names[trigger->action_time].str,
                          trg_action_time_type_names[trigger->action_time].length, cs);
  table->field[14]->store(STRING_WITH_LEN("OLD"), cs);
  table->field[15]->store(STRING_WITH_LEN("NEW"), cs);

  if (trigger->hr_create_time.val)