#
# Test IS.user_statistics for rows_* counters for the SQL slave
#

--source include/have_binlog_format_row.inc

--source include/master-slave.inc
--source include/not_embedded.inc
--source include/not_windows.inc
--source include/have_innodb_plugin.inc

--disable_warnings
drop table if exists userstats;
drop table if exists userstats2;
--enable_warnings

connect (muc1,localhost,root,,test);

create table userstats (i int primary key, j int) engine=innodb;
create index usx on userstats(j);

create table userstats2 (i int primary key, j int) engine=innodb;
create index us2x on userstats2(j);

connection default;
sync_slave_with_master;

show create table userstats;

connection muc1;

insert into userstats values (1,1);
insert into userstats values (2,2), (3,3);
insert into userstats2 values (4,4);
insert into userstats select * from userstats2;

connection default;
sync_slave_with_master;
connection muc1;

replace into userstats value (6,6);

connection default;
sync_slave_with_master;
connection muc1;

replace into userstats value (1,1);
connection default;
sync_slave_with_master;
connection muc1;

delete from userstats where i = 1;

connection default;
sync_slave_with_master;
connection muc1;

delete from userstats where i = 0;

connection default;
sync_slave_with_master;
connection muc1;

connection default;
sync_slave_with_master;

--echo on slave, before
select * from userstats;
select * from userstats2;

connection muc1;

--echo on master, before
select * from userstats;
select * from userstats2;

delete userstats, userstats2 from userstats inner join userstats2 where userstats.i = userstats2.i;

--echo on master, after
select * from userstats;
select * from userstats2;

connection slave;
sleep 1;
--echo on slave, after
select * from userstats;
select * from userstats2;

connection default;
sync_slave_with_master;
connection muc1;

# Cleanup
drop table userstats;
drop table userstats2;
connection default;

disconnect muc1;

sync_slave_with_master;