Re: [Maria-discuss] Partitionning question

2016-03-14 Thread Justin Swanhart
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 wrote: > > Hi, > > 1- Could a partitioned table cont

[Maria-discuss] Partitionning question

2016-03-14 Thread Ghazi Btissam
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

[Maria-discuss] MariaDB CONNECT Storage Engine access to Oracle 11GR2

2016-03-14 Thread Ghazi Btissam
Hi, I saw an article about the equivalent of the Oracle DbLink feature in MariaDb, I found that the connect engine with the ODBC table type can do an insert+select on an Oracle remote table ,but the *update *of the remote data is it possible? Thanks __