Partitioned tables don't support referential constraints. Composite partitioning only supports tables partitioned by RANGE or LIST and sub partitions may only be HASH or KEY. Sent from my iPhone

On Mar 14, 2016, at 5:52 AM, Ghazi Btissam <btissam.ghazi@gmail.com> wrote:

Hi,

1- Could a partitioned table contain, or be referenced by, foreign keys?

2- As I saw in MariaDb documentation ,the subpartitions may use either HASH or KEY partitioning. Does the LIST subpartitioning exists in MariaDb? Can we use : a composite partitionning : RANGE/LIST?

Thanks _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp