query filter with `.` report syntax error
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Bug Report
Please answer these questions before submitting your issue. Thanks!
### 1. Minimal reproduce step (Required)
```sql
create table t(a decimal(55,7));
select * from t where a = 1. ;
select * from t where a between 1. and 2;
```
### 2. What did you expect to see? (Required)
all queries execute success.
### 3. What did you see instead (Required)
Introduced by #46314
```sql
[14:24:25]TiDB root:test> create table t(a decimal(55,7));
Query OK, 0 rows affected
Time: 0.014s
[14:24:34]TiDB root:test> select * from t where a = 1. ;
+---+
| a |
+---+
+---+
0 rows in set
Time: 0.008s
[14:24:43]TiDB root:test> select * from t where a between 1. and 2;
(1064, 'You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 38 near "and 2" ')
```
### 4. What is your TiDB version? (Required)
master(1769f3a1ac367)
Contributor guide
Assessment
This issue has not been assessed yet.