Bug #46012 Partitioning of tables requires dropping of FK constraints
Submitted: 7 Jul 2009 14:16 Modified: 20 Aug 2009 20:39
Reporter: Vivek Ramanatha Iyer Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Partitions Severity:S4 (Feature request)
Version:5.1.35 OS:Any
Assigned to: CPU Architecture:Any
Tags: foreign key, partitioning

[7 Jul 2009 14:16] Vivek Ramanatha Iyer
Partitioning of tables requires dropping of FK constraints,which is not really possible ,when you really need the feature of partitioning.
Partitioning is specifically for hi volume tables and an application that can create so much data should have data integrity.This is really frustrating and the feature can be least used putting this restriction in place.

How to repeat:
This is a feature request.
[7 Jul 2009 16:01] Valeriy Kravchuk
Thank you for the feature request. Indeed, this is a documented limitation (see http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitations.html). And, surely, it would be nice to see foreign keys supported for partitioned tables one day.
[13 Jul 2009 16:01] Vivek Ramanatha Iyer
When soon shall that be ? If that shall be ages long,then i would suggest my client to migrate from MySQL to some other vendors.
[20 Aug 2009 20:39] Mattias Jonsson
This is addressed in the ongoing WL#148, which will add FK support for all engines, including partitioning support.
[24 Jun 2013 18:42] MySQL Verification Team
http://bugs.mysql.com/bug.php?id=69357 marked as duplicate of this one.