bug: incorrect result set.Insert value has space, delete space when select, query result is not displayed

[shangyanwen]

Describe the problem

create table t3(s varchar(10) not null primary key)engine=stonedb;
insert into t3 values ('one '), ('two\t');
select * from t3 where s = 'one';           (note:No result is displayed)
Empty set (0.00 sec)        

Expected behavior

select * from t3 where s = 'one';
+------+
| s    |
+------+
| one  |
+------+
1 row in set (0.00 sec)

note:Above is the result of the InnoDB test run

How To Reproduce

create table t3(s varchar(10) not null primary key)engine=stonedb;
insert into t3 values ('one '), ('two\t');
select * from t3 where s = 'one'; 

Environment

1. StoneDB for mysql5.7 (release)
2. Ubuntu 20.04.4

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

• Yes, I will!

[lylth]

stonedb supports strict sql mode, when the inserted string contains spaces, the query should also contain spaces

mysql> insert into t3 values ('one '), ('two\t');
Query OK, 2 rows affected (0.00 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> select * from t3 where s = 'one ';
+------+
| s    |
+------+
| one  |
+------+
1 row in set (3 min 2.58 sec)

mysql> select * from t3 where s = 'two\t';
+------+
| s    |
+------+
| two    |
+------+
1 row in set (6.16 sec)