Debian Codegraph @

mysql-test/suite/rpl_ndb/t/rpl_ndb_multi_update2_innodb.test

raw
1 ############################################################
2 # By JBM 2006-02-15 Wrapper for rpl_multi_update2.test #
3 # to reuse test code between engine runs #
4 ############################################################
5 -- source include/have_ndb.inc
6
7 # Run this only for row based replication, as replication of
8 # auto_increment values are not supported with NDB as storage engine
9 -- source include/have_binlog_format_mixed_or_row.inc
10 -- source suite/ndb_rpl/ndb_master-slave.inc
11 #
12 # BUG#13236 multi-update with subquery & --replicate-ignore-table
13 #
14
15 connection master;
16 CREATE TABLE t1 ( a INT );
17 INSERT INTO t1 VALUES (0);
18 UPDATE t1, (SELECT 3 as b) AS x SET t1.a = x.b;
19 select * from t1;
20
21 --source include/sync_slave_sql_with_master.inc
22 connection slave;
23 select * from t1;
24
25 connection master;
26 drop table t1;
27 --source include/sync_slave_sql_with_master.inc
28 --source include/rpl_end.inc