bug: add_column test failed.

[hustjieke]

Have you read the Contributing Guidelines on issues?

• I have read the Contributing Guidelines on issues.

Please confirm if bug report does NOT exists already ?

• I confirm there is no existing issue for this

Describe the problem

1. Some warnings happened.
2. select count(*) result not equal.

--- /github/stonedb/build/install8/mysql-test/suite/tianmu/r/add_column.result	2022-10-08 05:47:07.000000000 +0300
+++ /github/stonedb/build/install8/mysql-test/var/1/log/add_column.reject	2022-10-08 10:17:39.012150523 +0300
@@ -17,6 +17,12 @@
 `c_text` text COMMENT 'text',
 `c_longblob` longblob COMMENT 'longblob'
 ) ENGINE=TIANMU;
+Warnings:
+Warning	1681	Integer display width is deprecated and will be removed in a future release.
+Warning	1681	Integer display width is deprecated and will be removed in a future release.
+Warning	1681	Integer display width is deprecated and will be removed in a future release.
+Warning	1681	Integer display width is deprecated and will be removed in a future release.
+Warning	1681	Integer display width is deprecated and will be removed in a future release.
 load data infile '../../std_data/tianmu/bigdata4load' into table column_type_test fields terminated by '|';
 select count(*) from column_type_test;
 count(*)
@@ -25,11 +31,11 @@
 show create table column_type_test;
 Table	Create Table
 column_type_test	CREATE TABLE `column_type_test` (
-  `c_tinyint` tinyint(4) DEFAULT NULL COMMENT 'tinyint',
-  `c_smallint` smallint(6) DEFAULT NULL COMMENT 'smallint',
-  `c_mediumint` mediumint(9) DEFAULT NULL COMMENT 'mediumint',
-  `c_int` int(11) DEFAULT NULL COMMENT 'int',
-  `c_bigint` bigint(20) DEFAULT NULL COMMENT 'bigint',
+  `c_tinyint` tinyint DEFAULT NULL COMMENT 'tinyint',
+  `c_smallint` smallint DEFAULT NULL COMMENT 'smallint',
+  `c_mediumint` mediumint DEFAULT NULL COMMENT 'mediumint',
+  `c_int` int DEFAULT NULL COMMENT 'int',
+  `c_bigint` bigint DEFAULT NULL COMMENT 'bigint',
   `c_float` float DEFAULT NULL COMMENT 'float',
   `c_double` double DEFAULT NULL COMMENT 'double',
   `c_decimal` decimal(10,5) DEFAULT NULL COMMENT 'decimal',
@@ -42,11 +48,11 @@
   `c_blob` blob COMMENT 'blob',
   `c_text` text COMMENT 'text',
   `c_longblob` longblob COMMENT 'longblob',
-  `ex_column` int(11) DEFAULT NULL
-) ENGINE=TIANMU DEFAULT CHARSET=latin1
+  `ex_column` int DEFAULT NULL
+) ENGINE=TIANMU DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
 insert into column_type_test(c_tinyint,c_smallint,c_mediumint,c_int,c_bigint,c_float,c_double,c_decimal,c_date,c_datetime,c_timestamp,c_time,c_char,c_varchar,c_text,ex_column)
 values(105,105,105,105,105,5.2,10.88,105.083,'2016-02-25','2016-02-25 10:20:01','2016-02-25 05:20:01','10:20:01','stoneatom','hello','bcdefghijklmn',105);
 select count(*) from column_type_test;
 count(*)
100001

Expected behavior

run all tests passed.

How To Reproduce

1. cp std_data tianmu from stonedb 5.7 branch.
   cp -r stonedb/mysql-test/std_data/tianmu into stonedb 8.0 branch stonedb/mysql-test/std_data
2. Setting Running Parameters：mysql-test/include/default_mysqld.cnf

default-storage-engine=tianmu
tianmu_insert_delayed=0

3. run cmd:

./mysql-test-run.pl --suite=tianmu --nowarnings --force --nocheck-testcases --parallel=10

Environment

1. ubuntu
2. 8.0 branch
3. commit id: 52a721e

Are you interested in submitting a PR to solve the problem?

• Yes, I will!

[hustjieke]

For the warnings, see:
https://dev.mysql.com/worklog/task/?id=13127
https://stackoverflow.com/questions/58938358/mysql-warning-1681-integer-display-width-is-deprecated