pingcap / pingcap/tidb

Support plan cache for partial index on limit cases for the constraint `col is not null`

Open
#64,346 0 comments 0 reactions 0 assignees View on GitHub
sig/planner type/enhancement
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Enhancement
We only support the plan cache for very limited cases:
- The constraint of the partial index is `column is not null`
- The given SQL must have the compare operators `>\<\>=\<=\=`(`nulleq` is excluded because it can accept null value) on the constraint column.

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.