Tracking: porting code from 5.7 to 8.0 for stonedb 8.0 version v1.0.2

[hustjieke]

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

Currently we're doing work on backport from stonedb-5.7 to stonedb-8.0 and we had finished backport from v1.0.1, see tracking list:
#699

The version of tianmu engine in 5.7 comes to v1.0.3, we should adapt it to MySQL 8.0.
Now we'll begin backporting code from stonedb-5.7 v1.0.2 to 8.0, then port v1.0.3 until branch stonedb-8.0 catch up stonedb-5.7.

For how to build on StoneDB-8.0-dev, you can read guide docs in this pr:

1. how to make & install in ubuntu20.04 or ubuntu22.04
2. how to add and run a mtr test case.

Next is Sub Task List:

hard:

• backport: fix problems related to master slave synchronization #1669
• backport: support udf #1676
• backport: Improve the performance of master slave synchronization #1685
• backport: fixed implicit convert from number to varchar #1701
• backport: fix Trigger which assigns value selected #1717
• backport: support tianmu load error: Data format error. Row: 1 Column: 1 #1718
• backport: predicade pushdown failed lead to the table full scan #1721
• backport: support select into outfile with enclosed char #1726
• backport: support bit type #1740
• backport: support unsigned/zerofill #1716

normal:

• backport: phenomenon not consistent with innodb when data format is NULL #1664
• backport: improve code readbility  #1667
• backport: support 'ALTER TABLE t1 CHARACTER SET = ...' clause #1670
• backport: fix invalid write/read issue #1672
• backport: support alter table t1 rename t2 #1673
• backport: crashed when the subquery includes a SORT clause #1678
• backport: fix LEFT JOIN query result err with WHERE IS NULL clause #1680
• backport: fix query syntax (WHERE NOT IN ) is not supported #1682
• backport: fix query result err when executing UNION Clause #1689
• backport: timestamp union timestamp #1690
• backport: the EXTRACT() function error #1691
• feature: To fix up GROUP_CONCAT which refs to subselect #1695
• backport: support Binlog in mandatory tianmu engine mode #1702
• backport: ctas is not supported by tianmu engine #1715
• backport: fix Update multiple values does not work #1722
• backport: fix group by lead to wrong result #1725
• backport: mysqld server crash when large amount hash join #1727
• backport: fix alter table add/drop primary key #1728
• backport: fix auto_increment with max values #1729
• backport: Master slave synchronization - Row format supports primary key scanning #1732
• backport: Mathematical Functions of UNSIGNED data returns error #1733
• backport: fix DimensionGroupVirtual clone bug when shallow is truth #1736
• backport: fix replace into error on multi field pk #1737
• backport: support union query for fields whose data types are datetime and timestamp #1743

easy:

• backport: EXPLAIN query Q4, MySQL server has gone away #1666
• backport: rm duplicate 'lc-messages-dir' config item in my.cnf.sample #1668
• backport: support alter table xxx modify xxx type NULL/NOT NULL #1671
• backport: support select ... where like null #1677
• backport: fix warnings #1679
• backport: query with UNION ALL return result set error #1681
• backport: select...in...An error was reported when the date was included #1683
• backport: Load DPN when the table is empty  #1684
• backport: fix the WHERE NOT IN query where has NULL value #1686
• backport: fix query with ESCAPE #1687
• backport: add mtr for union #1692
• backport: fix STR_TO_DATE() Function does not work well #1693
• backport: support "alter table t_test comment 'abc'" ddl #1694
• backport: cmake .. -DENABLE_GCOV=1 failed #1709
• backport: make Unsupported data type more friendly #1710
• backport: delete timeout after 900 seconds #1711
• backport: fix query exists with primary key #1712
• backport: fix ALTER table DROP primary key is forbidden #1713
• backport: to support replace into values() SQL synax #1714
• backport: change default log level from INFO to DEBUG int commit phase #1719
• backport: Convert DATETIME to TIME type error #1720
• backport: Garbled code occurs after the character set is converted #1723
• backport: Fix the dimension index is -1 leads server to crash #1724
• backport: the sock file directory is inconsistent with the directory in my.cnf #1731
• backport: ALTER table xxx ADD numeric column return error #1734
• backport: When executing SELECT..WHERE NAME LIKE %_, it failed #1735
• backport: add mtr for ALTER TABLE prompt information is incorrect #1741
• backport: tianmu exporter support NULL type #1742

testing & workflow:

• backport: test cases in mtr #1665

Describe the solution you'd like

Describe alternatives you've considered

Additional context