# start a new learner
call dbms_consensus.add_learner(learner_cluster_info);
call dbms_consensus.configure_learner(learner_cluster_info, "127.0.0.1:PAXOS_PORT_1");
select server_id, role, learner_source from information_schema.alisql_cluster_global;
server_id	role	learner_source
1	Leader	0
2	Follower	0
3	Follower	0
100	Learner	1
create table t1(id int);
insert into t1 values (1);
insert into t1 values (2);
flush logs;
insert into t1 values(3);
insert into t1 values(4);
insert into t1 values(5);
flush logs;
# kill learner
show consensus logs;
Log_name	File_size	Start_log_index
master-bin.000001	#	#
master-bin.000002	#	#
master-bin.000003	#	#
insert into t1 values(6);
insert into t1 values(7);
flush logs;
show consensus logs;
Log_name	File_size	Start_log_index
master-bin.000001	#	#
master-bin.000002	#	#
master-bin.000003	#	#
master-bin.000004	#	#
call dbms_consensus.local_purge_log(100);
show consensus logs;
Log_name	File_size	Start_log_index
master-bin.000002	#	#
master-bin.000003	#	#
master-bin.000004	#	#
call dbms_consensus.drop_learner(learner_cluster_info);
call dbms_consensus.purge_log(100);
show consensus logs;
Log_name	File_size	Start_log_index
master-bin.000004	#	#
insert into t1 values(8);
insert into t1 values(9);
flush logs;
call dbms_consensus.force_purge_log(100);
show consensus logs;
Log_name	File_size	Start_log_index
master-bin.000005	#	#
drop table t1;