ERROR 1105 (HY000): strconv.Atoi: parsing "20a": invalid syntax

[ChenPeng2013]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

use test;
drop table t;
CREATE TABLE `t` (   `a` int(11) DEFAULT NULL,   `b` varchar(50) DEFAULT NULL,   `c` int(11) DEFAULT NULL,   KEY `idxa` (`a`),   KEY `idxb` (`b`),   KEY `idxc` (`c`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
insert into t values(1,"2020-11-20a",1);
select * from t use index(idxa) where date(b) > '2009-01-02';

2. What did you expect to see? (Required)

mysql 8.0.21

mysql> select * from t use index(idxa) where date(b) > '2009-01-02';
+------+-------------+------+
| a    | b           | c    |
+------+-------------+------+
|    1 | 2020-11-20a |    1 |
+------+-------------+------+
1 row in set, 1 warning (0.00 sec)

3. What did you see instead (Required)

mysql>  select * from t use index(idxa) where date(b) > '2009-01-02';
ERROR 1105 (HY000): strconv.Atoi: parsing "20a": invalid syntax

4. What is your TiDB version? (Required)

Release Version: v5.4.0-alpha-440-g321d307f3
Edition: Community
Git Commit Hash: 321d307f3b23877fb2be0e7534a9ecd6a655be05
Git Branch: master
UTC Build Time: 2021-12-17 06:57:03
GoVersion: go1.16.5
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false

[znhh6018]

/assign

[zanmato1984]

I'm lowering the severity as this is pretty corner.