pingcap / pingcap/tidb

planner: plan-cache support queries with "int_col = str_val"

Open
#65,878 2 comments 0 reactions 1 assignee Claimed by @0xPoe View on GitHub
epic/plan-cache report/customer sig/planner type/enhancement
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Enhancement

According to [our official document](https://docs.pingcap.com/tidb/stable/sql-prepared-plan-cache/), if a query contains a predicate like "int_col = str_val", it can't hit the plan cache, please see the case below:

Image

```
create table t (a int);
prepare st from "select * from t where a

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.