Debian Codegraph @

mysql-test/suite/rpl/include/rpl_multi_update.test

raw
1 source include/master-slave.inc;
2
3 call mtr.add_suppression('Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT.');
4
5 eval CREATE TABLE t1 (
6 a int unsigned not null auto_increment primary key,
7 b int unsigned
8 ) ENGINE=$engine_type;
9
10 eval CREATE TABLE t2 (
11 a int unsigned not null auto_increment primary key,
12 b int unsigned
13 ) ENGINE=$engine_type;
14
15 INSERT INTO t1 VALUES (NULL, 0);
16 --disable_warnings ONCE
17 INSERT INTO t1 SELECT NULL, 0 FROM t1;
18
19 INSERT INTO t2 VALUES (NULL, 0), (NULL,1);
20
21 SELECT * FROM t1 ORDER BY a;
22 SELECT * FROM t2 ORDER BY a;
23
24 --disable_warnings ONCE
25 UPDATE t1, t2 SET t1.b = t2.b WHERE t1.a = t2.a;
26 sync_slave_with_master;
27
28 # End of 4.1 tests
29
30 connection master;
31 drop table t1, t2;
32
33 --source include/rpl_end.inc