backport: support unsigned/zerofill

[hustjieke]

Is your feature request related to a problem? Please describe.

working issue: #1013, ##1218

• commit id: b44a51c

• limit unsigned range: 38d7eb4

• revert auto_increment mtr test: e3cfea3

• bug: 71a27c4

Describe the solution you'd like

Describe alternatives you've considered

Additional context

[hustjieke]

assigned me!

[hustjieke]

crash happend when insert data out of range:

mysql> create table tiny(a int, b tinyint);

mysql> insert into tiny values(0,128);
ERROR 2013 (HY000): Lost connection to MySQL server during query
No connection. Trying to reconnect...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/github/stonedb/build/install8/tmp/mysql.sock' (111)
ERROR: 
Can't connect to the server

[hustjieke]

crash happend when insert data out of range:

mysql> create table tiny(a int, b tinyint);

mysql> insert into tiny values(0,128);
ERROR 2013 (HY000): Lost connection to MySQL server during query
No connection. Trying to reconnect...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/github/stonedb/build/install8/tmp/mysql.sock' (111)
ERROR: 
Can't connect to the server

Root cause:
In non-strict sql_mode, insert sucess with warning.
in strict sql_mode, crashed in function Sql_cmd_insert_values::execute_inner(THD *thd) in file sql/sql_insert.cc:

      if (write_record(thd, insert_table, &info, &update)) {
        has_error = true;
        break;
      }
      thd->get_stmt_da()->inc_current_row_for_condition();
    }
  }  // Statement plan is available within these braces

  assert(has_error == thd->get_stmt_da()->is_error());

here has_error = false, thd->get_stmt_da()->is_error() = true.

When insert data out of range, tianmu engine push a warning into mysql, but in strict sql_mode, the
Sql_condition::SL_WARNING will be changed to Sql_condition::SL_ERROR in function:

/**
  Implementation of STRICT mode.
  Upgrades a set of given conditions from warning to error.
*/
bool Strict_error_handler::handle_condition(
...
...
switch (sql_errno) {
    case ER_TRUNCATED_WRONG_VALUE:
    case ER_WRONG_VALUE_FOR_TYPE:
    case ER_WARN_DATA_OUT_OF_RANGE:
    case ER_WARN_DATA_OUT_OF_RANGE_FUNCTIONAL_INDEX:
    case ER_DIVISION_BY_ZERO:
    case ER_TRUNCATED_WRONG_VALUE_FOR_FIELD:
    case WARN_DATA_TRUNCATED:
    case ER_WARN_DATA_TRUNCATED_FUNCTIONAL_INDEX:
    case ER_DATA_TOO_LONG:
    case ER_BAD_NULL_ERROR:
    case ER_NO_DEFAULT_FOR_FIELD:
    case ER_TOO_LONG_KEY:
    case ER_NO_DEFAULT_FOR_VIEW_FIELD:
    case ER_WARN_NULL_TO_NOTNULL:
    case ER_CUT_VALUE_GROUP_CONCAT:
    case ER_DATETIME_FUNCTION_OVERFLOW:
    case ER_WARN_TOO_FEW_RECORDS:
    case ER_WARN_TOO_MANY_RECORDS:
    case ER_INVALID_ARGUMENT_FOR_LOGARITHM:
    case ER_NUMERIC_JSON_VALUE_OUT_OF_RANGE:
    case ER_INVALID_JSON_VALUE_FOR_CAST:
    case ER_WARN_ALLOWED_PACKET_OVERFLOWED:
      if ((*level == Sql_condition::SL_WARNING) &&
          (!thd->get_transaction()->cannot_safely_rollback(
               Transaction_ctx::STMT) ||
           (thd->variables.sql_mode & MODE_STRICT_ALL_TABLES))) {
        (*level) = Sql_condition::SL_ERROR;
      }
      break;
    default:
      break;
  }
  return false;

So, write_record(thd, insert_table, &info, &update) should return error and then set has_error = true;, after debug, I found ret value not set 1 when execption get in function:

int Engine::InsertRow(const std::string &table_path, [[maybe_unused]] Transaction *trans_, TABLE *table,
                      std::shared_ptr<TableShare> &share) {
  int ret = 0; 
  try {
    if (tianmu_sysvar_insert_delayed && table->s->tmp_table == NO_TMP_TABLE) {
      if (tianmu_sysvar_enable_rowstore) {
        InsertMemRow(table_path, share, table);
      } else {
        InsertDelayed(table_path, share->TabID(), table);
      }    
      tianmu_stat.delayinsert++;
    } else {
      current_txn_->SetLoadSource(common::LoadSource::LS_Direct);
      auto rct = current_txn_->GetTableByPath(table_path);
      ret = rct->Insert(table);
    }    
    return ret; 
  } catch (common::Exception &e) {
    TIANMU_LOG(LogCtl_Level::ERROR, "delayed inserting failed. %s %s", e.what(), e.trace().c_str());
  } catch (std::exception &e) {
    TIANMU_LOG(LogCtl_Level::ERROR, "delayed inserting failed. %s", e.what());
    ret = 1; 
  } catch (...) {
    TIANMU_LOG(LogCtl_Level::ERROR, "delayed inserting failed.");
  }

  if (tianmu_sysvar_insert_delayed) {
    tianmu_stat.failed_delayinsert++;
    ret = 1; 
  }

  return ret; 
}

we should set ret = 1 in strict sql_mode.