MySQL Forums
Forum List  »  Federated Storage Engine

Re: Triggers and Federated tables
Posted by: Bob Field
Date: August 03, 2006 11:32PM

I have done some tests using a 5.0.18 for the base tables and a 5.0.16 system for the Federated tables. I performed a number of tests of before and after insert triggers. You can read about it in my blog entry:

http://bobfield.blogspot.com/2006/08/using-triggers-with-federated-tables.html

It is correct that information passes one way only. However it is possible to pass information from the before-insert trigger on the Federated table to the before-insert trigger on the base table. The after-insert trigger on the Federated table is somewhat anomalous because it does not receive any altered value that may have been set by any triggers on the base table. So the triggers work, just there are some limitations on how they can be used.

Options: ReplyQuote


Subject
Views
Written By
Posted
8170
July 31, 2006 09:13AM
5411
July 31, 2006 10:30AM
5296
August 03, 2006 05:59AM
4978
August 03, 2006 10:51AM
5324
August 03, 2006 11:13AM
7112
August 03, 2006 11:22PM
Re: Triggers and Federated tables
5474
August 03, 2006 11:32PM
5151
August 04, 2006 01:47AM
5017
February 28, 2008 03:22AM


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.