Edit File: ndb_rpl_ui.result
include/master-slave.inc [connection master] CREATE TABLE t1 (pk int primary key, uk int not null, unique(uk)) engine=ndb; insert into t1 values (1,1); insert into t1 values (2,2); insert into t1 values (3,3); insert into t1 values (4,4); insert into t1 values (5,5); select * from t1 where uk in (1,2,3,4,5); pk uk 1 1 2 2 3 3 4 4 5 5 update t1 set uk=uk-1 order by pk; select * from t1 where uk in (0,1,2,3,4); pk uk 1 0 2 1 3 2 4 3 5 4 Master table contents select * from t1 order by pk; pk uk 1 0 2 1 3 2 4 3 5 4 flush logs; Slave table contents select * from t1 order by pk; pk uk 1 0 2 1 3 2 4 3 5 4 select * from t1 where uk in (0,1,2,3,4); pk uk 1 0 2 1 3 2 4 3 5 4 drop table t1; include/rpl_end.inc