-- source include/have_ndb.inc
-- source include/have_binlog_format_mixed_or_row.inc
-- source suite/ndb_rpl/ndb_master-slave.inc

#
# Bug#28170 replicate-ignore-db=mysql should not ignore mysql.ndb_apply_status
#
# Slave is started with --replicate-ignore-db=mysql
#
sync_slave_with_master;
echo *** on slave there should be zero rows ***;
select count(*) from mysql.ndb_apply_status;

connection master;
create table t1 (a int key, b int) engine ndb;
insert into t1 values (1,1);
echo *** on master it should be empty ***;
#filter away stuff put there with server_id = 0 (from ndb_restore)
select * from mysql.ndb_apply_status where server_id <> 0;

sync_slave_with_master;
echo *** on slave there should be one row ***;
select count(*) from mysql.ndb_apply_status;

connection master;
drop table t1;
sync_slave_with_master;

connection master;
--echo *** Test reset slave clearing ndb_apply_status ***
create table test.t1 (a int primary key) engine=ndb;

insert into test.t1 values (1);

sync_slave_with_master;

connection slave;

--echo Add a dummy entry
insert into mysql.ndb_apply_status values (999, 9677, 'CaramelLog', 1977, 2015);

select count(1) from mysql.ndb_apply_status;

--echo *** Standard reset slave should clear ndb_apply_status ***
stop slave;
reset slave;

select count(1) from mysql.ndb_apply_status;

--connection master
reset master;
--source include/rpl_start_slaves.inc

--echo *** Test reset slave all ***

insert into test.t1 values (2);

sync_slave_with_master;

connection slave;
--echo Add a dummy entry
insert into mysql.ndb_apply_status values (999, 9677, 'CaramelLog', 1977, 2015);

select count(1) from mysql.ndb_apply_status;

--echo *** Reset slave all should clear ndb_apply_status ***
stop slave;
reset slave all;

select count(1) from mysql.ndb_apply_status;

--connection master
reset master;
--echo RESET SLAVE ALL zapped Master info - re-set it.
--let $rpl_unconditional_change_master=1
--source include/rpl_change_topology.inc
--source include/rpl_start_slaves.inc

--connection slave

--echo *** Test effect of ndb_clear_apply_status = 0 ***

set global ndb_clear_apply_status=0;

--connection master
insert into test.t1 values (3);

sync_slave_with_master;

connection slave;

--echo Add a dummy entry
insert into mysql.ndb_apply_status values (999, 9677, 'CaramelLog', 1977, 2015);

select count(1) from mysql.ndb_apply_status;

--echo *** Standard reset slave should NOT clear ndb_apply_status ***
stop slave;
reset slave;

select count(1) from mysql.ndb_apply_status;

delete from mysql.ndb_apply_status;

--connection master
reset master;
--source include/rpl_start_slaves.inc

--connection master

--echo *** Test reset slave all ***

insert into test.t1 values (4);

sync_slave_with_master;

connection slave;

--echo Add a dummy entry
insert into mysql.ndb_apply_status values (999, 9677, 'CaramelLog', 1977, 2015);

select count(1) from mysql.ndb_apply_status;

--echo *** Reset slave all should NOT clear ndb_apply_status ***
stop slave;
reset slave all;

select count(1) from mysql.ndb_apply_status;

--connection master
reset master;
--echo RESET SLAVE ALL zapped Master info - re-set it.
--let $rpl_unconditional_change_master=1
--source include/rpl_change_topology.inc
--source include/rpl_start_slaves.inc

--connection slave
set global ndb_clear_apply_status=1;

--connection master
drop table test.t1;

sync_slave_with_master;


--source include/rpl_end.inc