MySQL Forums
Forum List  »  Federated Storage Engine

Does Federated engine supports foreigh keys
Posted by: zaeem sherazi
Date: May 26, 2010 07:49AM

Dear All,

I am using MySQL 5.1.46 and facing some issues in federated table. Let me give you brief description of it.

Server A has table test_table1(Federated) and test_table1 (InnoDB)

Server B has table test_table1(InnoDb) and test_table1 (InnoDB)

When I insert data in test_table1 on Server A I get foreign key fail message as both test_table2 has foreign key to test_table1 on Server A. Please note that record already (Parent record) exists on test_table1 on Server A.

When I disable foreign key check then it works fine. Please let me know if Federated storage engine supports foreign keys fully or not.



Options: ReplyQuote

Written By
Does Federated engine supports foreigh keys
May 26, 2010 07:49AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.