Method check_and_adjust

sql/sql_sequence.cc:175–281

Check whether sequence values are valid. Sets default values for fields that are not used, according to Oracle spec. @param in thd The connection @param in set_reserved_until Whether to set reserved_until to start @param in adjust_next Whether to call flush next_free_value. Default to true @retval false

              true                invalid
*/
bool sequence_definition::check_and_adjust(THD *thd, bool set_reserved_until,
                                           bool adjust_next)
{
  DBUG_ENTER("sequence_definition::check_and_adjust");

  /* Easy error to detect. */
  if (!is_allowed_value_type(value_type) || cache < 0)
    DBUG_RETURN(TRUE);

  if (!(real_increment= increment))
    real_increment= global_system_variables.auto_increment_increment;

  /*
    If min_value is not set, in case of signed sequence, set it to
    value_type_min()+1 or 1, depending on real_increment, and in case
    of unsigned sequence, set it to value_type_min()+1
  */
  if (!(used_fields & seq_field_specified_min_value))
    min_value= real_increment < 0 || is_unsigned ? value_type_min()+1 : 1;
  else
  {
    min_value= truncate_value(min_value_from_parser);
    if ((is_unsigned &&
         (ulonglong) min_value <= (ulonglong) value_type_min()) ||
        (!is_unsigned && min_value <= value_type_min()))
    {
      push_warning_printf(
          thd, Sql_condition::WARN_LEVEL_NOTE, ER_TRUNCATED_WRONG_VALUE,
          ER_THD(thd, ER_TRUNCATED_WRONG_VALUE), "INTEGER", "MINVALUE");
      min_value= value_type_min() + 1;
    }
  }

  /*
    If max_value is not set, in case of signed sequence set it to
    value_type_max()-1 or -1, depending on real_increment, and in case
    of unsigned sequence, set it to value_type_max()-1
  */
  if (!(used_fields & seq_field_specified_max_value))
    max_value= real_increment > 0 || is_unsigned ? value_type_max()-1 : -1;
  else
  {
    max_value= truncate_value(max_value_from_parser);
    if ((is_unsigned &&
         (ulonglong) max_value >= (ulonglong) value_type_max()) ||
        (!is_unsigned && max_value >= value_type_max()))
    {
      push_warning_printf(
          thd, Sql_condition::WARN_LEVEL_NOTE, ER_TRUNCATED_WRONG_VALUE,
          ER_THD(thd, ER_TRUNCATED_WRONG_VALUE), "INTEGER", "MAXVALUE");
      max_value= value_type_max() - 1;
    }
  }

  if (!(used_fields & seq_field_used_start))
  {
    /* Use min_value or max_value for start depending on real_increment */
    start= real_increment < 0 ? max_value : min_value;