MySQL Bugs: #69357: Can not use Foreign Keys with Partitioning

Bug #69357	Can not use Foreign Keys with Partitioning
Submitted:	30 May 2013 23:36	Modified:	24 Jun 2013 18:41
Reporter:	Adam Adair	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Partitions	Severity:	S4 (Feature request)
Version:	5.7	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	partitioning; foreign keys

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Currently you can not use Foreign Keys with partitions. This is important to ensure data consistency in a partitioned environment.

How to repeat:
Create a partitioned table and try to add a Foreign key - this fails.

Suggested fix:
Add the feature of Partitioning using Foreign Keys.

Thank you for the bug report. Duplicate with http://bugs.mysql.com/bug.php?id=46012 .