bug: oltp_read_write.lua sysbench returned error 1366 (Incorrect string value..）

[davidshiz]

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

[root@HAMI02 log]# sysbench --mysql-port=3306 --mysql-user=root --mysql-password=123456 --mysql-socket=/opt/stonedb57/install//tmp/mysql.sock --mysql-db=zz  --mysql_storage_engine=tianmu --create_secondary=off --table_size=20240 --tables=5 --events=0 --time=60 --threads=10 --percentile=95 --report-interval=5 --auto_inc=true /usr/share/sysbench/oltp_read_write.lua run
sysbench 1.0.17 (using system LuaJIT 2.0.4)

Running the test with following options:
Number of threads: 10
Report intermediate results every 5 second(s)
Initializing random number generator from current time


Initializing worker threads...

Threads started!

FATAL: mysql_stmt_execute() returned error 1366 (Incorrect string value: '\xE7'\x00\x00\x00\x00...' for column 'c' at row 1) for query 'DELETE FROM sbtest5 WHERE id=?'
FATAL: `thread_run' function failed: /usr/share/sysbench/oltp_common.lua:487: SQL error, errno = 1366, state = 'HY000': Incorrect string value: '\xE7'\x00\x00\x00\x00...' for column 'c' at row 1
FATAL: mysql_stmt_execute() returned error 1366 (Incorrect string value: '\xE7'\x00\x00\x00\x00...' for column 'c' at row 4) for query 'UPDATE sbtest5 SET c=? WHERE id=?'
FATAL: `thread_run' function failed: /usr/share/sysbench/oltp_common.lua:469: SQL error, errno = 1366, state = 'HY000': Incorrect string value: '\xE7'\x00\x00\x00\x00...' for column 'c' at row 4
FATAL: mysql_stmt_execute() returned error 1366 (Incorrect string value: '\xE7'\x00\x00\x00\x00...' for column 'c' at row 4) for query 'UPDATE sbtest5 SET k=k+1 WHERE id=?'
FATAL: `thread_run' function failed: /usr/share/sysbench/oltp_common.lua:458: SQL error, errno = 1366, state = 'HY000': Incorrect string value: '\xE7'\x00\x00\x00\x00...' for column 'c' at row 4

Expected behavior

No response

How To Reproduce

No response

Environment

[root@HAMI02 ~]# /opt/stonedb57/install//bin/mysqld --version
/opt/stonedb57/install//bin/mysqld  Ver 5.7.36-StoneDB-v1.0.2 for Linux on x86_64 (build-)
build information as follow:
        Repository address: https://github.com/stoneatom/stonedb.git:HEAD
        Branch name: HEAD
        Last commit ID: e8f079440
        Last commit time: Date:   Wed Mar 8 19:10:15 2023 +0800
        Build time: Date: Wed Mar  8 13:06:25 UTC 2023

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

• Yes, I will!