pingcap / pingcap/tidb

planner: error when access enum column by using a cached plan

Open
#41,898 1 comment 0 reactions 1 assignee Claimed by @qw4990 View on GitHub
epic/plan-cache 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)

```
create table tidx(e enum("a", "b", "c"), key(e));
prepare st from 'select * from t where e>?';
set @a=4;
execute st using @a;
```

### 2. What did you expect to see? (Required)
No error.

### 3. What did you see instead (Required)
```
ERROR 1265 (01000): Data truncated for column '%s' at row %d
```

### 4. What is your TiDB version? (Required)

```
| 5.7.25-TiDB-v6.7.0-alpha-168-gad01574a71 |
```

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.