Debian Codegraph @

mysql-test/suite/rpl/r/rpl_binlog_dup_entry.result

raw
1 include/master-slave.inc
2 [connection master]
3 CREATE TABLE t1 (id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, someLabel varchar(30) NOT NULL, flag tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (id)) Engine=MyISAM;
4 CREATE TABLE t2 (id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, data varchar(30) NOT NULL, status tinyint(1) NOT NULL, PRIMARY KEY (id)) Engine=MyISAM;
5 CREATE TABLE t3 (id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, t1id mediumint(8) unsigned NOT NULL, flag tinyint(1) NOT NULL DEFAULT 0, status tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (id)) Engine=MyISAM;
6 INSERT INTO t1 ( id, someLabel, flag ) VALUES ( 1, 'ABC', 0 );
7 CREATE OR REPLACE TRIGGER doNothing
8 BEFORE UPDATE ON t1
9 FOR EACH ROW
10 BEGIN
11 IF
12 new.someLabel != old.someLabel
13 THEN
14 UPDATE t3 SET t3.flag = 0;
15 END IF;
16 END|
17 FLUSH LOGS;
18 LOCK TABLES t1 WRITE, t2 WRITE;
19 INSERT INTO t2 (data, status) VALUES ('1', 4);
20 UPDATE t1 SET flag = 1 WHERE id = 1;
21 INSERT INTO t2 (data, status) VALUES ('2', 4);
22 UNLOCK TABLES;
23 connection slave;
24 include/diff_tables.inc [master:t1, slave:t1]
25 include/diff_tables.inc [master:t2, slave:t2]
26 include/diff_tables.inc [master:t3, slave:t3]
27 connection master;
28 DROP TABLE t1, t2, t3;
29 include/rpl_end.inc