enhance the column substitute of multi-valued index
Open
type/enhancement
- 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 json, index i1((cast(a->'$.a' as signed array))));
desc select * from t force index(i) where 1 member of (a->'$."a"');
desc select * from t force index(i) where 1 member of (a->'$.a');
```
the json path `'$."a"'` is not the same as the definition `i1`, so it does not substitute the index column
### 2. What did you expect to see? (Required)
the result should be the same
### 3. What did you see instead (Required)
The first query report an error
### 4. What is your TiDB version? (Required)
Contributor guide
Assessment
This issue has not been assessed yet.