Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
qw4990 opened this issue Mar 3, 2023 · 1 comment
Open

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

qw4990 opened this issue Mar 3, 2023 · 1 comment
Assignees
Labels
epic/plan-cache severity/moderate sig/planner SIG: Planner type/bug The issue is confirmed as a bug.

Comments

@qw4990
Copy link
Contributor

qw4990 commented Mar 3, 2023

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 |
@qw4990 qw4990 added type/bug The issue is confirmed as a bug. sig/planner SIG: Planner severity/moderate epic/plan-cache labels Mar 3, 2023
@qw4990 qw4990 self-assigned this Mar 3, 2023
@qw4990
Copy link
Contributor Author

qw4990 commented Mar 3, 2023

It's very rare to access enum columns with plan-cache, so I just give this issue a moderate severity.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
epic/plan-cache severity/moderate sig/planner SIG: Planner type/bug The issue is confirmed as a bug.
Projects
None yet
Development

No branches or pull requests

1 participant