Debian Codegraph @

mysql-test/suite/rpl_nogtid/t/rpl_multi_update2_innodb.test

raw
1 #######################################################
2 # Wrapper for rpl_multi_update2.test to allow multi #
3 # Engines to reuse test code. By JBM 2006-02-15 #
4 # Added comments section and to skip when ndb is #
5 # Default engine. #
6 #######################################################
7 --source include/not_ndb_default.inc
8 --source include/master-slave.inc
9 call mtr.add_suppression('Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT');
10
11 #
12 # BUG#13236 multi-update with subquery & --replicate-ignore-table
13 #
14 connection master;
15 CREATE TABLE t1 ( a INT );
16 INSERT INTO t1 VALUES (0);
17 UPDATE t1, (SELECT 3 as b) AS x SET t1.a = x.b;
18 select * from t1;
19
20 --source include/sync_slave_sql_with_master.inc
21 connection slave;
22 select * from t1;
23
24 connection master;
25 drop table t1;
26 --source include/sync_slave_sql_with_master.inc
27 --source include/rpl_end.inc