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.gh...@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 _______________________________________________ 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
