EVOLUTION-MANAGER

Edit File: rpl_tokudb_row_trig004.result

include/master-slave.inc [connection master] connection master; DROP TRIGGER test.t1_bi_t2; DROP TABLE IF EXISTS test.t1; DROP TABLE IF EXISTS test.t2; CREATE TABLE test.t1 (n MEDIUMINT NOT NULL AUTO_INCREMENT, d FLOAT, PRIMARY KEY(n))ENGINE=TOKUDB; CREATE TABLE test.t2 (n MEDIUMINT NOT NULL, f FLOAT, PRIMARY KEY(n))ENGINE=TOKUDB; CREATE TRIGGER test.t1_bi_t2 BEFORE INSERT ON test.t2 FOR EACH ROW INSERT INTO test.t1 VALUES (NULL, 1.234)// INSERT INTO test.t2 VALUES (1, 0.0); INSERT INTO test.t2 VALUES (1, 0.0); ERROR 23000: Duplicate entry '1' for key 'PRIMARY' select * from test.t1; n d 1 1.234 select * from test.t2; n f 1 0 connection slave; connection slave; select * from test.t1; n d 1 1.234 select * from test.t2; n f 1 0 connection master; DROP TRIGGER test.t1_bi_t2; DROP TABLE test.t1; DROP TABLE test.t2; connection slave; include/rpl_end.inc