pingcap / pingcap/tidb

enhance the column substitute of multi-valued index

Open
#41,715 0 comments 0 reactions 0 assignees View on GitHub
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

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.