pingcap / pingcap/tidb

planner: automatically mark invalid bindings

Open
#64,493 0 comments 0 reactions 1 assignee Claimed by @qw4990 View on GitHub
component/spm epic/sql-plan-management sig/planner type/feature-request
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Feature Request

**Is your feature request related to a problem? Please describe:**

Bindings might become invalid due to schema changes, for users with massive bindings, we should be able to help them mark invalid bindings automatically:

Image

**Describe the feature you'd like:**

Add a new column like `valid` in `mysql.bind_info` to indicate whether this binding is valid or not.

For users, they can more easily delete these invalid bindings.

**Describe alternatives you've considered:**

**Teachability, Documentation, Adoption, Migration Strategy:**

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.