pingcap / pingcap/tidb

Support Foreign Keys with Partitioned Tables

Open
#46,960 0 comments 0 reactions 0 assignees View on GitHub
component/tablepartition type/enhancement
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Enhancement

Remove the limitation of not being able to use Foreign Keys with Partitioned Tables.

Including handling validations in DDLs like `DROP/EXCHANGE PARTITION`. I don't think REORGANIZE PARTITION needs any validation, since it should not allow removing rows.

Note that MySQL does not support this, but there are no technical reasons it could not be supported in TiDB.

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.