Function update_portion_of_time

sql/sql_delete.cc:238–287

}

static
int update_portion_of_time(THD *thd, TABLE *table,
                           const vers_select_conds_t &period_conds,
                           bool *inside_period)
{
  bool lcond= period_conds.field_start->val_datetime_packed(thd)
              < period_conds.start.item->val_datetime_packed(thd);
  bool rcond= period_conds.field_end->val_datetime_packed(thd)
              > period_conds.end.item->val_datetime_packed(thd);

  *inside_period= !lcond && !rcond;
  if (*inside_period)
    return 0;

  DBUG_ASSERT(!table->triggers
              || !table->triggers->has_triggers(TRG_EVENT_INSERT,
                                                TRG_ACTION_BEFORE));

  int res= 0;
  Item *src= lcond ? period_conds.start.item : period_conds.end.item;
  uint dst_fieldno= lcond ? table->s->period.end_fieldno
                          : table->s->period.start_fieldno;

  ulonglong prev_insert_id= table->file->next_insert_id;
  store_record(table, record[1]);
  if (likely(!res))
    res= src->save_in_field(table->field[dst_fieldno], true);

  if (likely(!res))
  {
    table->period_prepare_autoinc();
    res= table->update_generated_fields();
  }

  if(likely(!res))
    res= table->file->ha_update_row(table->record[1], table->record[0]);

  if (likely(!res) && table->triggers)
    res= table->triggers->process_triggers(thd, TRG_EVENT_INSERT,
                                           TRG_ACTION_AFTER, true, nullptr);
  restore_record(table, record[1]);
  if (res)
    table->file->restore_auto_increment(prev_insert_id);

  if (likely(!res) && lcond && rcond)
    res= table->period_make_insert(period_conds.end.item,
                                   table->field[table->s->period.start_fieldno]);

  return res;
}

/**
  Delete a record stored in: