bug: incorrect result set.select…data<=xx,Incorrect test results were obtained

[shangyanwen]

Describe the problem

create table t1(f1 int, f2 date)engine=stonedb;
insert into t1 values(1,'2005-01-01'),(2,'2005-09-01'),(3,'2005-09-30'),(4,'2005-10-01'),(5,'2005-12-30');
select * from t1 where f2 <= '2005-09-31' order by f2;
##The error results are as follows
Empty set (0.00 sec)

Expected behavior

##The following is：innodb test result
mysql> select * from t1 where f2 <= '2005-09-31' order by f2;
+------+------------+
| f1   | f2         |
+------+------------+
|    1 | 2005-01-01 |
|    2 | 2005-09-01 |
|    3 | 2005-09-30 |
+------+------------+
3 rows in set (0.00 sec)

How To Reproduce

create table t1(f1 int, f2 date)engine=stonedb;
insert into t1 values(1,'2005-01-01'),(2,'2005-09-01'),(3,'2005-09-30'),(4,'2005-10-01'),(5,'2005-12-30');
select * from t1 where f2 <= '2005-09-31' order by f2;

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!