summaryrefslogtreecommitdiff
path: root/mysql-test/main/kill-2.test
blob: 6d40e14a700ba70855c7c8f8aa8da7d33914e996 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
#
# Test KILL and KILL QUERY statements.
#
# Killing a connection in an embedded server does not work like in a normal
# server, if it is waiting for a new statement. In an embedded server, the
# connection does not read() from a socket, but returns control to the
# application. 'mysqltest' does not handle the kill request.
#
-- source include/not_embedded.inc

--echo #
--echo # MDEV-6896 kill user command cause MariaDB crash!
--echo #
--disable_service_connection

create user foo@'127.0.0.1';

--connect (con1,127.0.0.1,foo,,)

--connection default
select user from information_schema.processlist;
kill user foo@'127.0.0.1';

let $wait_condition=
    select count(*) = 0 from information_schema.processlist
    where user = "foo";
--source include/wait_condition.inc
drop user foo@'127.0.0.1';
--enable_service_connection