EVOLUTION-MANAGER

Edit File: fast_update_binlog_statement.test

source include/master-slave.inc;
source include/have_binlog_format_statement.inc;
source include/have_tokudb.inc;

create table tt (id int primary key, x int) engine = tokudb;

connection master;
source ../include/setup_fast_update_upsert.inc;
set session tokudb_enable_fast_update=1;

connection slave;
source ../include/setup_fast_update_upsert.inc;
set session tokudb_enable_fast_update=1;

connection master;

let $n=100;

# insert a bunch of new rows
let $i=0;
while ($i < $n) {
        eval insert into tt values ($i,0) on duplicate key update x=x+1;
        inc $i;
}

# upsert a bunch of rows
let $i=0;
while ($i < $n) {
        eval insert into tt values ($i,0) on duplicate key update x=x+1;
        inc $i;
}

# update a bunch of rows
let $i=0;
while ($i < $n) {
        eval update tt set x=x+1 where id=$i;
        inc $i;
}
select * from tt where x != 2;

sync_slave_with_master;

let $diff_tables= master:test.tt, slave:test.tt;
source include/diff_tables.inc;

connection master;
drop table tt;

source include/rpl_end.inc;