A Little Noise

Trigger on firing table

Written by

snoyes

in

CREATE TABLE t1 (id int);
CREATE TRIGGER t1_ai AFTER INSERT ON t1 FOR EACH ROW 
  INSERT INTO t1 VALUES (NEW.id);

That’s not allowed; it won’t let you create the trigger.

CREATE TABLE t1 (id int);
CREATE TABLE f1 (id int) ENGINE=FEDERATED CONNECTION='localhost/test/t1';
CREATE TRIGGER t1_ai AFTER INSERT ON t1 FOR EACH ROW 
  INSERT INTO f1 VALUES (NEW.id);

The server lets that through. Don’t do it.

Comments

2 responses to “Trigger on firing table”

  1. Tom Hanlon Avatar
    Tom Hanlon

    I think you can do the same “feature” with merge table.

    —
    Tom

  2. Giuseppe Maxia Avatar
    Giuseppe Maxia

    C’mon! it is not a bug, it’s a feature! :)
    http://datacharmer.blogspot.com/2008/01/multiple-triggers-for-same-event-bug-or.html

    Or may be not. It depends on how much you want to break your system. If using replication, for example, Federated will break it independently of triggers. http://bugs.mysql.com/bug.php?id=31757

    Cheers

    Giuseppe

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

More posts