Does Federated engine supports foreigh keys

[zaeem sherazi]

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.

Regards,

Shirazi