########### ../t/admin_xkill.test                            #########
##                                                                   #
## This test aims to run list_clients and kill_client admin commands #
## Test runs covers below scenarios:                                 #
##  - listing client with single session and multiple sessions       #
##  - killing own session and x_root user session with privileged user #
##  - killing own session and x_root user session with unprivileged user #
##  - killing session with value of different data types than UINT   #
##  - killing x_root session with user has only process privilege    #
##  - listing and killing session with password expired user         #
##  - killing valid sql_session id with xprotocol connection         #
##  - listing and killing default mysqlx_max_connections ie 100      #
##  - listing,killing clients with ssl xprotocol privileged conn     #
##  - listing and killing clients with ssl xprotocol x_root connection #
##  - kill_client,list_clients stats                                 #
##  - check sum of these 2 vars with all mysqlx sessions should be as#
#        that of with mysql client                                   #
######################################################################

--source include/xplugin_preamble.inc
--source include/xplugin_create_user.inc
call mtr.add_suppression("Plugin mysqlx reported: 'Unhandled network error: Bad file descriptor'");
create user sslcon@localhost identified by 'sslcon';
grant all on *.* to sslcon@localhost;
--write_file $MYSQL_TMP_DIR/admin_xkill.xpl
-->import assert_status_variable.macro
-->import kill_and_restart.macro

create user abc@localhost identified by 'abc',
            xplugin@localhost identified by 'xplugin',
            process@localhost identified by 'process',
            expire@localhost identified by 'expire';
grant all on *.* to xplugin@localhost,
                    expire@localhost;
grant process on *.* to process@localhost;
      
alter user expire@localhost password expire;
select sleep(1);

-->echo Test data
-->stmtadmin list_clients
-->recvresult

-->echo expect Mysqlx_stmt_list_clients=1 and Mysqlx_stmt_kill_client=0
quiet;
callmacro Assert_status_variable	Mysqlx_stmt_kill_client	0;
callmacro Assert_status_variable	Mysqlx_stmt_list_clients	1;
callmacro Wait_for_status_variable	Mysqlx_sessions	1;
noquiet;

-->echo create and activate new session
-->newsession aux	x_root

-->stmtadmin list_clients
-->recvresult client_id user host

-->echo expect Mysqlx_stmt_list_clients=1 and Mysqlx_stmt_kill_client=0 even with another new x_root session
quiet;
callmacro Assert_status_variable	Mysqlx_stmt_kill_client	0;
callmacro Assert_status_variable	Mysqlx_stmt_list_clients	1;
callmacro Wait_for_status_variable	Mysqlx_sessions	2;
noquiet;

-->echo switch back to default session
-->setsession

-->stmtadmin list_clients
-->recvresult client_id user host

-->echo expect Mysqlx_stmt_list_clients=2 and Mysqlx_stmt_kill_client=0 with default x_root session where list_clients already executed
quiet;
callmacro Assert_status_variable	Mysqlx_stmt_kill_client	0;
callmacro Assert_status_variable	Mysqlx_stmt_list_clients	2;
callmacro Wait_for_status_variable	Mysqlx_sessions	2;
noquiet;

callmacro kill_client	2;

callmacro Wait_for_status_variable	Mysqlx_sessions	1;

-->stmtadmin list_clients
-->recvresult client_id user host

-->echo expect Mysqlx_stmt_list_clients=3 and Mysqlx_stmt_kill_client=1 with default x_root session where list_clients executed 3 times and kill_client once
quiet;
callmacro Assert_status_variable	Mysqlx_stmt_kill_client	1;
callmacro Assert_status_variable	Mysqlx_stmt_list_clients	3;
callmacro Wait_for_status_variable	Mysqlx_sessions	1;
noquiet;

-->echo create and activate new session abc
-->echo expect only abc user session id
-->newsession abc	abc	abc

-->stmtadmin list_clients
-->recvresult client_id user host

-->echo killing x_root user session with unprivileged user 'abc' which should be unsuccessful

callmacro kill_client_expect_error	1	ER_KILL_DENIED_ERROR;

-->echo expect Mysqlx_stmt_list_clients=1 and Mysqlx_stmt_kill_client=1 with session abc where list_clients and kill_client executed once
quiet;
callmacro Assert_status_variable	Mysqlx_stmt_kill_client	1;
callmacro Assert_status_variable	Mysqlx_stmt_list_clients	1;
callmacro Wait_for_status_variable	Mysqlx_sessions	2;
noquiet;
select user(),current_user();
show grants;

-->echo open another session of abc user and kill first session of abc user,which should be successful
-->newsession abc1	abc	abc

-->stmtadmin list_clients
-->recvresult client_id user host

callmacro kill_client	3;

callmacro Wait_for_status_variable	Mysqlx_sessions	2;

-->stmtadmin list_clients
-->recvresult client_id user host


-->echo expect Mysqlx_stmt_list_clients=2 and Mysqlx_stmt_kill_client=1 with new session abc where list_clients executed twice and kill_client executed once
quiet;
callmacro Assert_status_variable	Mysqlx_stmt_kill_client	1;
callmacro Assert_status_variable	Mysqlx_stmt_list_clients	2;
callmacro Wait_for_status_variable	Mysqlx_sessions	2;
noquiet;
select user(),current_user();
show grants;

-->echo killing abc user session with its own session 'abc' which should be successful
-->echo expect right error instead of End of File
-->stmtadmin kill_client	{"id": 4 }
-->recvuntildisc

callmacro Wait_for_status_variable	Mysqlx_sessions	1;

-->echo switch back to default session
-->setsession

-->stmtadmin list_clients
-->recvresult client_id user host

-->echo expect Mysqlx_stmt_list_clients=4 and Mysqlx_stmt_kill_client=1 with default x_root session where list_clients executed 4 times and kill_client once
quiet;
callmacro Assert_status_variable	Mysqlx_stmt_kill_client	1;
callmacro Assert_status_variable	Mysqlx_stmt_list_clients	4;
callmacro Wait_for_status_variable	Mysqlx_sessions	1;
noquiet;
select user(),current_user();
show grants;

-->echo open process only privileged user seession and kill x_root user session,expect error "You are not owner of thread"
-->newsession process	process	process

-->stmtadmin list_clients
-->recvresult client_id user host

callmacro kill_client_expect_error	1	ER_KILL_DENIED_ERROR;

callmacro Wait_for_status_variable	Mysqlx_sessions	2;

-->echo checking list of clients after x_root user session killed by xplugin user
-->stmtadmin list_clients
-->recvresult client_id user host

-->echo expect Mysqlx_stmt_list_clients=2 and Mysqlx_stmt_kill_client=1 with process user where list_clients executed 2 times and kill_client once
show status like 'Mysqlx_stmt%client%';
select user(),current_user();
show grants;

-->echo open privileged user seession and kill x_root user session,expect success
-->newsession xplugin	xplugin	xplugin

-->stmtadmin list_clients
-->recvresult client_id user host

callmacro kill_client	1;

callmacro Wait_for_status_variable	Mysqlx_sessions	2;

-->echo checking list of clients after x_root user session killed by xplugin user
-->stmtadmin list_clients
-->recvresult client_id user host

-->echo expect Mysqlx_stmt_list_clients=2 and Mysqlx_stmt_kill_client=1 with xplugin user where list_clients executed 2 times and kill_client once
show status like 'Mysqlx_stmt%client%';
select user(),current_user();
show grants;

-->echo Cleanup
drop schema if exists xtest;
EOF

## killing client with invalid scalar data types
--write_file $MYSQL_TMP_DIR/admin_xkill_invaliddtype.xpl
-->import assert_status_variable.macro
-->import kill_and_restart.macro

-->stmtadmin list_clients
-->recvresult client_id user host

-->echo expect error while killing client with data type other than usinged int
-->echo try killing xprotocol session with valid sql_session id once xprotocol connetion opened with kill_client,expect error

callmacro kill_client_expect_error	11	ER_NO_SUCH_THREAD;

-->stmtadmin kill_client	{"id": "1"}
-->expecterror ER_X_CMD_ARGUMENT_VALUE
-->recvresult

-->stmtadmin kill_client	{"id": true}
-->expecterror ER_X_CMD_ARGUMENT_VALUE
-->recvresult

-->stmtadmin kill_client	{"id": false}
-->expecterror ER_X_CMD_ARGUMENT_VALUE
-->recvresult

-->stmtadmin kill_client	{"id": 1.0}
-->expecterror ER_X_CMD_ARGUMENT_VALUE
-->recvresult

-->stmtadmin kill_client	{"id": null}
-->expecterror ER_X_CMD_ARGUMENT_VALUE
-->recvresult

-->stmtadmin kill_client	{"id": -1}
-->expecterror ER_X_CMD_ARGUMENT_VALUE
-->recvresult

-->echo expect Mysqlx_stmt_list_clients=1 and Mysqlx_stmt_kill_client=11 with x_root user even though kill_client returns errors
quiet;
callmacro Assert_status_variable	Mysqlx_stmt_kill_client	7;
callmacro Assert_status_variable	Mysqlx_stmt_list_clients	1;
callmacro Wait_for_status_variable	Mysqlx_sessions	1;
noquiet;

EOF

--write_file $MYSQL_TMP_DIR/admin_xkill_pwd_expire.xpl
-->import assert_status_variable.macro
-->import kill_and_restart.macro

-->echo expect error if list_clients and kill_client executed from password expired user session
-->expecterror ER_MUST_CHANGE_PASSWORD
show processlist;

-->stmtadmin list_clients
-->expecterror ER_MUST_CHANGE_PASSWORD
-->recvresult

callmacro kill_client_expect_error	8	ER_MUST_CHANGE_PASSWORD;

EOF

--write_file $MYSQL_TMP_DIR/admin_mixedcase.xpl
-->import assert_status_variable.macro
-->import kill_and_restart.macro

-->echo checking list_clients and kill_client with mixed case, expect success as these commands are case insensitive
-->stmtadmin LIST_clients
-->recvresult client_id user host

-->stmtadmin kill_CLIENT	{"id": 998}
-->expecterror ER_NO_SUCH_THREAD
-->recvresult

-->echo expect Mysqlx_stmt_list_clients=1 and Mysqlx_stmt_kill_client=1 with x_root user when these commads executed with mixed case
quiet;
callmacro Assert_status_variable	Mysqlx_stmt_kill_client	1;
callmacro Assert_status_variable	Mysqlx_stmt_list_clients	1;
callmacro Wait_for_status_variable	Mysqlx_sessions	1;
noquiet;

EOF

###below script is blind, it can be modified more efficiently by reducing no of lines
--write_file $MYSQL_TMP_DIR/admin_list_kill_100conns.xpl
-->import assert_status_variable.macro
-->import kill_and_restart.macro
-->import assert_notices.macro

-->macro receive_kill_notice	%SESSION_ID%
setsession %SESSION_ID%;
# error 3169 = ER_SESSION_WAS_KILLED;
callmacro Assert_notice_warning	ERROR	3169;
recvuntildisc show-received;
-->endmacro


-->echo checking list_clients and kill_client with default 50 connections, expect success for both list and kill
set @@global.mysqlx_max_connections=60;
create user xconnection1@localhost identified by  'xconnection1',
            xconnection2@localhost identified by  'xconnection2',
            xconnection3@localhost identified by  'xconnection3',
            xconnection4@localhost identified by  'xconnection4',
            xconnection5@localhost identified by  'xconnection5',
            xconnection6@localhost identified by  'xconnection6',
            xconnection7@localhost identified by  'xconnection7',
            xconnection8@localhost identified by  'xconnection8',
            xconnection9@localhost identified by  'xconnection9',
            xconnection10@localhost identified by  'xconnection10',
            xconnection11@localhost identified by  'xconnection11',
            xconnection12@localhost identified by  'xconnection12',
            xconnection13@localhost identified by  'xconnection13',
            xconnection14@localhost identified by  'xconnection14',
            xconnection15@localhost identified by  'xconnection15',
            xconnection16@localhost identified by  'xconnection16',
            xconnection17@localhost identified by  'xconnection17',
            xconnection18@localhost identified by  'xconnection18',
            xconnection19@localhost identified by  'xconnection19',
            xconnection20@localhost identified by  'xconnection20',
            xconnection21@localhost identified by  'xconnection21',
            xconnection22@localhost identified by  'xconnection22',
            xconnection23@localhost identified by  'xconnection23',
            xconnection24@localhost identified by  'xconnection24',
            xconnection25@localhost identified by  'xconnection25',
            xconnection26@localhost identified by  'xconnection26',
            xconnection27@localhost identified by  'xconnection27',
            xconnection28@localhost identified by  'xconnection28',
            xconnection29@localhost identified by  'xconnection29',
            xconnection30@localhost identified by  'xconnection30',
            xconnection31@localhost identified by  'xconnection31',
            xconnection32@localhost identified by  'xconnection32',
            xconnection33@localhost identified by  'xconnection33',
            xconnection34@localhost identified by  'xconnection34',
            xconnection35@localhost identified by  'xconnection35',
            xconnection36@localhost identified by  'xconnection36',
            xconnection37@localhost identified by  'xconnection37',
            xconnection38@localhost identified by  'xconnection38',
            xconnection39@localhost identified by  'xconnection39',
            xconnection40@localhost identified by  'xconnection40',
            xconnection41@localhost identified by  'xconnection41',
            xconnection42@localhost identified by  'xconnection42',
            xconnection43@localhost identified by  'xconnection43',
            xconnection44@localhost identified by  'xconnection44',
            xconnection45@localhost identified by  'xconnection45',
            xconnection46@localhost identified by  'xconnection46',
            xconnection47@localhost identified by  'xconnection47',
            xconnection48@localhost identified by  'xconnection48',
            xconnection49@localhost identified by  'xconnection49',
            xconnection50@localhost identified by  'xconnection50';

-->echo Test data
stmtadmin list_clients;
recvresult;

-->echo expect Mysqlx_stmt_list_clients=1 and Mysqlx_stmt_kill_client=0
show status like 'Mysqlx_stmt%client%';

-->echo create and activate new session xconnection1
-->newsession xconnection1	xconnection1	xconnection1
-->newsession xconnection2	xconnection2	xconnection2
-->newsession xconnection3	xconnection3	xconnection3
-->newsession xconnection4	xconnection4	xconnection4
-->newsession xconnection5	xconnection5	xconnection5
-->newsession xconnection6	xconnection6	xconnection6
-->newsession xconnection7	xconnection7	xconnection7
-->newsession xconnection8	xconnection8	xconnection8
-->newsession xconnection9	xconnection9	xconnection9
-->newsession xconnection10	xconnection10	xconnection10
-->newsession xconnection11	xconnection11	xconnection11
-->newsession xconnection12	xconnection12	xconnection12
-->newsession xconnection13	xconnection13	xconnection13
-->newsession xconnection14	xconnection14	xconnection14
-->newsession xconnection15	xconnection15	xconnection15
-->newsession xconnection16	xconnection16	xconnection16
-->newsession xconnection17	xconnection17	xconnection17
-->newsession xconnection18	xconnection18	xconnection18
-->newsession xconnection19	xconnection19	xconnection19
-->newsession xconnection20	xconnection20	xconnection20
-->newsession xconnection21	xconnection21	xconnection21
-->newsession xconnection22	xconnection22	xconnection22
-->newsession xconnection23	xconnection23	xconnection23
-->newsession xconnection24	xconnection24	xconnection24
-->newsession xconnection25	xconnection25	xconnection25
-->newsession xconnection26	xconnection26	xconnection26
-->newsession xconnection27	xconnection27	xconnection27
-->newsession xconnection28	xconnection28	xconnection28
-->newsession xconnection29	xconnection29	xconnection29
-->newsession xconnection30	xconnection30	xconnection30
-->newsession xconnection31	xconnection31	xconnection31
-->newsession xconnection32	xconnection32	xconnection32
-->newsession xconnection33	xconnection33	xconnection33
-->newsession xconnection34	xconnection34	xconnection34
-->newsession xconnection35	xconnection35	xconnection35
-->newsession xconnection36	xconnection36	xconnection36
-->newsession xconnection37	xconnection37	xconnection37
-->newsession xconnection38	xconnection38	xconnection38
-->newsession xconnection39	xconnection39	xconnection39
-->newsession xconnection40	xconnection40	xconnection40
-->newsession xconnection41	xconnection41	xconnection41
-->newsession xconnection42	xconnection42	xconnection42
-->newsession xconnection43	xconnection43	xconnection43
-->newsession xconnection44	xconnection44	xconnection44
-->newsession xconnection45	xconnection45	xconnection45
-->newsession xconnection46	xconnection46	xconnection46
-->newsession xconnection47	xconnection47	xconnection47
-->newsession xconnection48	xconnection48	xconnection48
-->newsession xconnection49	xconnection49	xconnection49
-->newsession xconnection50	xconnection50	xconnection50

-->stmtadmin list_clients
-->recvresult client_id user host

## switch back to default session
-->setsession

-->echo list all connected clients
-->stmtadmin list_clients
-->recvresult client_id user host

-->echo expect Mysqlx_stmt_list_clients=2 and Mysqlx_stmt_kill_client=0
quiet;
callmacro Assert_status_variable	Mysqlx_stmt_kill_client	0;
callmacro Assert_status_variable	Mysqlx_stmt_list_clients	2;
callmacro Wait_for_global_status_variable	Mysqlx_sessions	51;
noquiet;


-->echo killing all newly connected clients except x_root,one by one
callmacro kill_client	11;
callmacro receive_kill_notice	xconnection1;
callmacro kill_client	12;
callmacro receive_kill_notice	xconnection2;
callmacro kill_client	13;
callmacro receive_kill_notice	xconnection3;
callmacro kill_client	14;
callmacro receive_kill_notice	xconnection4;
callmacro kill_client	15;
callmacro receive_kill_notice	xconnection5;
callmacro kill_client	16;
callmacro receive_kill_notice	xconnection6;
callmacro kill_client	17;
callmacro receive_kill_notice	xconnection7;
callmacro kill_client	18;
callmacro receive_kill_notice	xconnection8;
callmacro kill_client	19;
callmacro receive_kill_notice	xconnection9;
callmacro kill_client	20;
callmacro receive_kill_notice	xconnection10;
callmacro kill_client	21;
callmacro receive_kill_notice	xconnection11;
callmacro kill_client	22;
callmacro receive_kill_notice	xconnection12;
callmacro kill_client	23;
callmacro receive_kill_notice	xconnection13;
callmacro kill_client	24;
callmacro receive_kill_notice	xconnection14;
callmacro kill_client	25;
callmacro receive_kill_notice	xconnection15;
callmacro kill_client	26;
callmacro receive_kill_notice	xconnection16;
callmacro kill_client	27;
callmacro receive_kill_notice	xconnection17;
callmacro kill_client	28;
callmacro receive_kill_notice	xconnection18;
callmacro kill_client	29;
callmacro receive_kill_notice	xconnection19;
callmacro kill_client	30;
callmacro receive_kill_notice	xconnection20;
callmacro kill_client	31;
callmacro receive_kill_notice	xconnection21;
callmacro kill_client	32;
callmacro receive_kill_notice	xconnection22;
callmacro kill_client	33;
callmacro receive_kill_notice	xconnection23;
callmacro kill_client	34;
callmacro receive_kill_notice	xconnection24;
callmacro kill_client	35;
callmacro receive_kill_notice	xconnection25;
callmacro kill_client	36;
callmacro receive_kill_notice	xconnection26;
callmacro kill_client	37;
callmacro receive_kill_notice	xconnection27;
callmacro kill_client	38;
callmacro receive_kill_notice	xconnection28;
callmacro kill_client	39;
callmacro receive_kill_notice	xconnection29;
callmacro kill_client	40;
callmacro receive_kill_notice	xconnection30;
callmacro kill_client	41;
callmacro receive_kill_notice	xconnection31;
callmacro kill_client	42;
callmacro receive_kill_notice	xconnection32;
callmacro kill_client	43;
callmacro receive_kill_notice	xconnection33;
callmacro kill_client	44;
callmacro receive_kill_notice	xconnection34;
callmacro kill_client	45;
callmacro receive_kill_notice	xconnection35;
callmacro kill_client	46;
callmacro receive_kill_notice	xconnection36;
callmacro kill_client	47;
callmacro receive_kill_notice	xconnection37;
callmacro kill_client	48;
callmacro receive_kill_notice	xconnection38;
callmacro kill_client	49;
callmacro receive_kill_notice	xconnection39;
callmacro kill_client	50;
callmacro receive_kill_notice	xconnection40;
callmacro kill_client	51;
callmacro receive_kill_notice	xconnection41;
callmacro kill_client	52;
callmacro receive_kill_notice	xconnection42;
callmacro kill_client	53;
callmacro receive_kill_notice	xconnection43;
callmacro kill_client	54;
callmacro receive_kill_notice	xconnection44;
callmacro kill_client	55;
callmacro receive_kill_notice	xconnection45;
callmacro kill_client	56;
callmacro receive_kill_notice	xconnection46;
callmacro kill_client	57;
callmacro receive_kill_notice	xconnection47;
callmacro kill_client	58;
callmacro receive_kill_notice	xconnection48;
callmacro kill_client	59;
callmacro receive_kill_notice	xconnection49;
callmacro kill_client	60;
callmacro receive_kill_notice	xconnection50;


callmacro Wait_for_status_variable	Mysqlx_sessions	1;

-->stmtadmin list_clients
-->recvresult client_id user host

-->echo expect Mysqlx_stmt_list_clients=3 and Mysqlx_stmt_kill_client=50
quiet;
callmacro Assert_status_variable	Mysqlx_stmt_kill_client	50;
callmacro Assert_status_variable	Mysqlx_stmt_list_clients	3;
callmacro Assert_status_variable	Mysqlx_sessions	1;
callmacro Assert_status_variable	Mysqlx_sessions_accepted	60;
callmacro Assert_status_variable	Mysqlx_sessions_closed	59;
callmacro Assert_status_variable	Mysqlx_sessions_fatal_error	0;
callmacro Assert_status_variable	Mysqlx_sessions_killed	54;
callmacro Assert_status_variable	Mysqlx_sessions_rejected	0;
noquiet;

drop user xconnection1@localhost,
 xconnection2@localhost,
 xconnection3@localhost,
 xconnection4@localhost,
 xconnection5@localhost,
 xconnection6@localhost,
 xconnection7@localhost,
 xconnection8@localhost,
 xconnection9@localhost,
 xconnection10@localhost,
 xconnection11@localhost,
 xconnection12@localhost,
 xconnection13@localhost,
 xconnection14@localhost,
 xconnection15@localhost,
 xconnection16@localhost,
 xconnection17@localhost,
 xconnection18@localhost,
 xconnection19@localhost,
 xconnection20@localhost,
 xconnection21@localhost,
 xconnection22@localhost,
 xconnection23@localhost,
 xconnection24@localhost,
 xconnection25@localhost,
 xconnection26@localhost,
 xconnection27@localhost,
 xconnection28@localhost,
 xconnection29@localhost,
 xconnection30@localhost,
 xconnection31@localhost,
 xconnection32@localhost,
 xconnection33@localhost,
 xconnection34@localhost,
 xconnection35@localhost,
 xconnection36@localhost,
 xconnection37@localhost,
 xconnection38@localhost,
 xconnection39@localhost,
 xconnection40@localhost,
 xconnection41@localhost,
 xconnection42@localhost,
 xconnection43@localhost,
 xconnection44@localhost,
 xconnection45@localhost,
 xconnection46@localhost,
 xconnection47@localhost,
 xconnection48@localhost,
 xconnection49@localhost,
 xconnection50@localhost;

EOF

--write_file $MYSQL_TMP_DIR/admin_list_kill_sqlnamespace.xpl
-->echo execute list_clients,kill_client with sql namespace,expect error
-->echo change result file once error messages are fixed
Mysqlx.Sql.StmtExecute {
  stmt: "list_clients"
  namespace: "sql"
}

-->echo expect Mysqlx.Sql.StmtExecuteOk
-->expecterror ER_PARSE_ERROR
-->recvresult client_id user host

Mysqlx.Sql.StmtExecute {
  stmt: "kill_client"
  namespace: "sql"
  args {
    type: SCALAR
    scalar {
      type: V_UINT
      v_unsigned_int: 11
    }
  }
}

-->echo expect Mysqlx.Sql.StmtExecuteOk
-->expecterror ER_X_CMD_NUM_ARGUMENTS
-->recvresult

Mysqlx.Sql.StmtExecute {
  stmt: "kill_client"
  namespace: ""
  args {
    type: SCALAR
    scalar {
      type: V_UINT
      v_unsigned_int: 11
    }
  }
}

-->echo expect Mysqlx.Sql.StmtExecuteOk
-->expecterror ER_X_INVALID_NAMESPACE
-->recvresult

Mysqlx.Sql.StmtExecute {
  stmt: "kill_client"
  namespace: "invalid"
  args {
    type: SCALAR
    scalar {
      type: V_UINT
      v_unsigned_int: 11
    }
  }
}

-->echo expect Mysqlx.Sql.StmtExecuteOk
-->expecterror ER_X_INVALID_NAMESPACE
-->recvresult

-->echo expect Mysqlx_stmt_list_clients=0 and Mysqlx_stmt_kill_client=0 as these are not executed on right namespace
quiet;
callmacro Assert_status_variable	Mysqlx_stmt_kill_client	0;
callmacro Assert_status_variable	Mysqlx_stmt_list_clients	0;
callmacro Assert_status_variable	Mysqlx_sessions	1;
noquiet;

EOF

--write_file $MYSQL_TMP_DIR/admin_xkill_ssl.xpl
-->import assert_status_variable.macro
-->import kill_and_restart.macro

-->echo open xconnection with ssl and kill,expect success
create user con1@localhost identified by 'con1',
            con2@localhost identified by 'con2';
set @@global.mysqlx_max_connections=3;

-->echo Test data
-->stmtadmin list_clients
-->recvresult  client_id user host

-->echo expect Mysqlx_stmt_list_clients=1 and Mysqlx_stmt_kill_client=0
quiet;
callmacro Assert_status_variable	Mysqlx_stmt_kill_client	0;
callmacro Assert_status_variable	Mysqlx_stmt_list_clients	1;
callmacro Wait_for_status_variable	Mysqlx_sessions	1;
noquiet;


-->echo create and activate new session con1
-->newsession con1	con1	con1

-->stmtadmin list_clients
-->recvresult  client_id user host

-->echo expect Mysqlx_stmt_list_clients=1 and Mysqlx_stmt_kill_client=0
quiet;
callmacro Assert_status_variable	Mysqlx_stmt_kill_client	0;
callmacro Assert_status_variable	Mysqlx_stmt_list_clients	1;
callmacro Wait_for_status_variable	Mysqlx_sessions	2;
noquiet;

-->echo open 3rd xprotocol connection where 2 sessions already opened
-->newsession con2	con2	con2

-->echo expect Mysqlx_stmt_list_clients=0 and Mysqlx_stmt_kill_client=0
quiet;
callmacro Assert_status_variable	Mysqlx_stmt_kill_client	0;
callmacro Assert_status_variable	Mysqlx_stmt_list_clients	0;
callmacro Wait_for_status_variable	Mysqlx_sessions	3;
noquiet;

## switch back to default session
-->setsession

-->stmtadmin list_clients
-->recvresult  client_id user host

callmacro kill_client	63;
callmacro kill_client	64;

callmacro Wait_for_status_variable	Mysqlx_sessions	1;

-->stmtadmin list_clients
-->recvresult  client_id user host

-->echo expect Mysqlx_stmt_list_clients=3 and Mysqlx_stmt_kill_client=2
drop user con1@localhost,
  con2@localhost;

quiet;
callmacro Assert_status_variable	Mysqlx_stmt_kill_client	2;
callmacro Assert_status_variable	Mysqlx_stmt_list_clients	3;
callmacro Wait_for_status_variable	Mysqlx_sessions	1;
noquiet;

EOF

--write_file $MYSQL_TMP_DIR/admin_xkill_ssl_root.xpl
-->import assert_status_variable.macro
-->import kill_and_restart.macro

-->echo open xconnection with ssl x_root user kill,expect success
create user con1@localhost identified by 'con1',
            con2@localhost identified by 'con2';
set @@global.mysqlx_max_connections=3;

-->echo Test data
-->stmtadmin list_clients
-->recvresult  client_id user host

-->echo create and activate new session con1
-->newsession con1      con1    con1

-->stmtadmin list_clients
-->recvresult  client_id user host

-->echo open 3rd xprotocol connection where 2 sessions already opened
-->newsession con2      con2    con2

## switch back to default session
-->setsession

-->stmtadmin list_clients
-->recvresult  client_id user host

callmacro kill_client	66;
callmacro kill_client	67;

callmacro Wait_for_status_variable	Mysqlx_sessions	1;

-->stmtadmin list_clients
-->recvresult client_id user host

drop user con1@localhost,
  con2@localhost;

EOF

--write_file $MYSQL_TMP_DIR/admin_xkill_compatibility_56_OFF.xpl
-->import assert_status_variable.macro
-->import kill_and_restart.macro

create user abc@localhost identified by 'abc',
            xplugin@localhost identified by 'xplugin',
            process@localhost identified by 'process',
            expire@localhost identified by 'expire';
grant all on *.* to xplugin@localhost,
                    expire@localhost;
grant process on *.* to process@localhost;

alter user expire@localhost password expire;

-->echo Test data
-->stmtadmin list_clients
-->recvresult client_id user host

-->echo expect Mysqlx_stmt_list_clients=1 and Mysqlx_stmt_kill_client=0
quiet;
callmacro Assert_status_variable	Mysqlx_stmt_kill_client	0;
callmacro Assert_status_variable	Mysqlx_stmt_list_clients	1;
callmacro Assert_status_variable	Mysqlx_sessions	1;
noquiet;


-->echo create and activate new session
-->newsession aux	x_root

-->stmtadmin list_clients
-->recvresult client_id user host

-->echo expect Mysqlx_stmt_list_clients=1 and Mysqlx_stmt_kill_client=0 even with another new x_root session
quiet;
callmacro Assert_status_variable	Mysqlx_stmt_kill_client	0;
callmacro Assert_status_variable	Mysqlx_stmt_list_clients	1;
callmacro Assert_status_variable	Mysqlx_sessions	2;
noquiet;


-->echo switch back to default session
-->setsession

-->stmtadmin list_clients
-->recvresult client_id user host

-->echo expect Mysqlx_stmt_list_clients=2 and Mysqlx_stmt_kill_client=0 with default x_root session where list_clients already executed
quiet;
callmacro Assert_status_variable	Mysqlx_stmt_kill_client	0;
callmacro Assert_status_variable	Mysqlx_stmt_list_clients	2;
callmacro Assert_status_variable	Mysqlx_sessions	2;
noquiet;

callmacro kill_client	2;

callmacro Wait_for_status_variable	Mysqlx_sessions	1;

-->stmtadmin list_clients
-->recvresult client_id user host

-->echo expect Mysqlx_stmt_list_clients=3 and Mysqlx_stmt_kill_client=1 with default x_root session where list_clients executed 3 times and kill_client once
quiet;
callmacro Assert_status_variable	Mysqlx_stmt_kill_client	1;
callmacro Assert_status_variable	Mysqlx_stmt_list_clients	3;
callmacro Assert_status_variable	Mysqlx_sessions	1;
noquiet;

-->echo create and activate new session abc
-->echo expect only abc user session id
-->newsession abc	abc	abc

-->stmtadmin list_clients
-->recvresult client_id user host

-->echo killing x_root user session with unprivileged user 'abc' which should be unsuccessful
callmacro kill_client_expect_error	1	ER_KILL_DENIED_ERROR;

-->echo expect ERROR: SELECT command denied to user 'abc'@'localhost' for table 'session_status' (code 1142) for show status command
quiet;
callmacro Assert_status_variable	Mysqlx_stmt_kill_client	1;
callmacro Assert_status_variable	Mysqlx_stmt_list_clients	1;
callmacro Assert_status_variable	Mysqlx_sessions	2;
noquiet;

-->echo open another session of abc user and kill first session of abc user,which should be successful
-->newsession abc1	abc	abc

-->stmtadmin list_clients
-->recvresult client_id user host

callmacro kill_client	3;

callmacro Wait_for_status_variable	Mysqlx_sessions	2;

-->stmtadmin list_clients
-->recvresult client_id user host

-->echo expect ERROR: SELECT command denied to user 'abc'@'localhost' for table 'session_status' (code 1142) for show status command
quiet;
callmacro Assert_status_variable	Mysqlx_stmt_kill_client	1;
callmacro Assert_status_variable	Mysqlx_stmt_list_clients	2;
callmacro Assert_status_variable	Mysqlx_sessions	2;
noquiet;

-->echo killing abc user session with its own session 'abc' which should be successful
-->echo expect right error instead of End of File
-->stmtadmin kill_client	{"id": 4}
-->echo switch back to default session
-->recvuntildisc

callmacro Wait_for_status_variable	Mysqlx_sessions	1;

-->stmtadmin list_clients
-->recvresult client_id user host

-->echo expect Mysqlx_stmt_list_clients=4 and Mysqlx_stmt_kill_client=1 with default x_root session where list_clients executed 4 times and kill_client once
quiet;
callmacro Assert_status_variable	Mysqlx_stmt_kill_client	1;
callmacro Assert_status_variable	Mysqlx_stmt_list_clients	4;
callmacro Assert_status_variable	Mysqlx_sessions	1;
noquiet;

-->echo open process only privileged user seession and kill x_root user session,expect error "You are not owner of thread"
-->newsession process	process	process
-->stmtadmin list_clients
-->recvresult client_id user host

callmacro kill_client_expect_error	1	ER_KILL_DENIED_ERROR;

callmacro Wait_for_status_variable	Mysqlx_sessions	2;

-->echo checking list of clients after x_root user session killed by xplugin user
-->stmtadmin list_clients
-->recvresult client_id user host

-->echo expect ERROR: SELECT command denied to user 'process'@'localhost' for table 'session_status' (code 1142) for show command
quiet;
callmacro Assert_status_variable	Mysqlx_stmt_kill_client	1;
callmacro Assert_status_variable	Mysqlx_stmt_list_clients	2;
callmacro Assert_status_variable	Mysqlx_sessions	2;
noquiet;

-->echo open privileged user seession and kill x_root user session,expect success
-->newsession xplugin	xplugin	xplugin

-->stmtadmin list_clients
-->recvresult client_id user host

callmacro kill_client	1;

callmacro Wait_for_status_variable	Mysqlx_sessions	2;

-->echo checking list of clients after x_root user session killed by xplugin user

-->stmtadmin list_clients
-->recvresult client_id user host

-->echo expect Mysqlx_stmt_list_clients=2 and Mysqlx_stmt_kill_client=1 with xplugin user where list_clients executed 2 times and kill_client once
quiet;
callmacro Assert_status_variable	Mysqlx_stmt_kill_client	1;
callmacro Assert_status_variable	Mysqlx_stmt_list_clients	2;
callmacro Assert_status_variable	Mysqlx_sessions	2;
noquiet;

-->echo Cleanup
drop schema if exists xtest;

EOF

--replace_regex /([a-z0-9]+	localhost	)[0-9]+/\1$SESSION/ /You are not owner of thread [0-9]+/You are not owner of thread/
--exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/admin_xkill.xpl 2>&1
--replace_regex /([a-z0-9]+	localhost	)[0-9]+/\1$SESSION/
--exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/admin_xkill_invaliddtype.xpl 2>&1

##try executing list_clients and kill_client with password expired user, expect error
--replace_regex /([a-z0-9]+	localhost	)[0-9]+/\1$SESSION/ /Query/Execute/
--exec $MYSQLXTEST --connect-expired-password -uexpire --password='expire' --file=$MYSQL_TMP_DIR/admin_xkill_pwd_expire.xpl 2>&1

##execute list_clients and kill_client with mixed case,expect command should be recognized
--replace_regex /([a-z0-9]+	localhost	)[0-9]+/\1$SESSION/
--exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/admin_mixedcase.xpl 2>&1

##open 100 xprotocol connections and list and kill them ony by one,expect success
--replace_regex /([a-z0-9]+	localhost	)[0-9]+/\1$SESSION/
--exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/admin_list_kill_100conns.xpl 2>&1

##execute list_clients,kill_client with invalid name space other than xplugin,exect unsuccess
--replace_regex /([a-z0-9]+	localhost	)[0-9]+/\1$SESSION/
--exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/admin_list_kill_sqlnamespace.xpl 2>&1

##verify list_clients and kill_client works with ssl privileged user
--replace_regex /([a-z0-9]+	localhost	)[0-9]+/\1$SESSION/
--exec $MYSQLXTEST -usslcon --password='sslcon' --ssl-key=$MYSQL_TEST_DIR/std_data/server-key.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/server-cert.pem --file=$MYSQL_TMP_DIR/admin_xkill_ssl.xpl 2>&1

##verify list_clients and kill_client works with x_root user having ssl
--replace_regex /([a-z0-9]+	localhost	)[0-9]+/\1$SESSION/
--exec $MYSQLXTEST -ux_root --password='' --ssl-key=$MYSQL_TEST_DIR/std_data/server-key.pem --ssl-cert=$MYSQL_TEST_DIR/std_data/server-cert.pem --file=$MYSQL_TMP_DIR/admin_xkill_ssl_root.xpl 2>&1
##expect sum of all stats of kill_client,list_clients with native mysql clients as these are global to mysql client and local to mysqlx session
show status like 'Mysqlx_stmt%client%';
#show status like 'Mysqlx_sessions%';

##verify Mysqlx_stmt_kill_client and Mysqlx_stmt_list_clients
let $restart_parameters = restart: ;
--source include/restart_mysqld.inc
drop user abc@localhost,
  xplugin@localhost,
  process@localhost,
  expire@localhost;
###expects zero stats for kill_client,list_clients once server started first time
set @@global.mysqlx_max_connections=100;
show status like 'Mysqlx_stmt%client%';
select sleep(0.5);
--replace_regex /([a-z0-9]+	localhost	)[0-9]+/\1$SESSION/ /You are not owner of thread [0-9]+/You are not owner of thread/
--exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/admin_xkill_compatibility_56_OFF.xpl 2>&1
##expect sum of all stats of kill_client,list_clients with native mysql clients as these are global to mysql client and local to mysqlx session
##seems to be it is not working that way
show status like 'Mysqlx_stmt%client%';

## Cleanup
drop user abc@localhost,
  xplugin@localhost,
  process@localhost,
  expire@localhost,
  sslcon@localhost;
--source ../include/xplugin_cleanup.inc