pingcap / pingcap/tidb

incorrect type warning for mv index query is unreasonable

Open
#50,599 0 comments 0 reactions 1 assignee Claimed by @time-and-fate View on GitHub
severity/moderate sig/planner type/bug
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.