incorrect type warning for mv index query is unreasonable
- 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)
```
MySQL [test]> SELECT
-> product_sources
-> FROM
-> items
-> WHERE
-> 85807650 member of (feed_profile_ids)
-> AND "OC8p1390XTkt.net/s/link" member of (normalized_short_link_clusters)
-> AND json_overlaps(
-> product_sources,
-> '["M1","M2","M3"]'
-> )
-> LIMIT 1;
+-------------------------------------------------------+
| product_sources |
+-------------------------------------------------------+
| ["M1","M2","M3"] |
+-------------------------------------------------------+
1 row in set, 2 warnings (2.47 sec)
MySQL [test]> show warnings;
+---------+------+-------------------------------------------------------------+
| Level | Code | Message |
+---------+------+-------------------------------------------------------------+
| Warning | 1292 | Truncated incorrect DOUBLE value: 'OC8p1390XTkt.net/s/link' |
| Warning | 1292 | Truncated incorrect DOUBLE value: 'OC8p1390XTkt.net/s/link' |
+---------+------+-------------------------------------------------------------+
2 rows in set (0.00 sec)
MySQL [test]>
```
### 2. What did you expect to see? (Required)
no such warning
### 3. What did you see instead (Required)
OC8p1390XTkt.net/s/link is the value of normalized_short_link_clusters, it's type is not double.
why does tidb report this warnings?
it looks strange.
### 4. What is your TiDB version? (Required)
7.6.0
Contributor guide
Assessment
This issue has not been assessed yet.