Debian Codegraph @

mysql-test/suite/x/t/connection_reset_by_peer.test

raw
1 ## Test cases for connections reset by client
2
3 --source include/xplugin_preamble.inc
4 --source include/xplugin_create_user.inc
5
6
7 ## Test starts here
8
9 --let $xtest_file= $MYSQL_TMP_DIR/connection_reset_by_peer.xpl
10 --write_file $xtest_file
11 -->quiet
12
13 -->macro Long_run %PROC_NAME% %TABLE_NAME%
14 -->newsession next_ses x_root
15 -->stmtsql SELECT COUNT(*) FROM information_schema.processlist
16 -->recvresult
17
18 -->sql
19 DELIMITER //
20 CREATE PROCEDURE %PROC_NAME%()
21 BEGIN
22 REPEAT
23 SELECT * FROM %TABLE_NAME%;
24 UNTIL FALSE END REPEAT;
25 END
26 //
27 DELIMITER ;
28
29 -->endsql
30
31 -->stmtsql call %PROC_NAME%();
32 -->recv quiet
33
34 -->closesession abort
35
36
37 -->wait_for 1 SELECT COUNT(*) FROM performance_schema.processlist WHERE user = 'x_root'
38 -->wait_for 1 SELECT COUNT(*) FROM information_schema.processlist WHERE user = 'x_root'
39
40 -->stmtadmin list_clients
41 -->recvresult client_id user host
42 -->endmacro
43
44
45 -->callmacro Long_run xtest.long1 mysql.user
46 -->callmacro Long_run xtest.long2 xtest.empty
47
48 EOF
49
50
51 CREATE SCHEMA xtest;
52 CREATE TABLE xtest.empty(a INT, b FLOAT);
53
54
55 --exec $MYSQLXTEST -ux_root --file=$xtest_file 2>&1
56
57
58 ## Cleanup
59 --source ../include/xplugin_cleanup.inc