Debian Codegraph @

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

raw
1 ## This file provide test scenario for killing query in another session.
2 ##
3
4 --source include/xplugin_preamble.inc
5 --source include/xplugin_create_user.inc
6
7 --echo ## I. Kill query that executes for a long time(contains SQL sleep). It must be killed from another
8 --echo # XSession.
9 --echo # 1. Sleep is execute inside "WHERE" clause (of SELECT statement)
10 --echo # 2. Sleep is execute inside "select_expr" of SELECT statement, and must return multiple rows
11 --echo
12
13 ## Test Setup
14 --write_file $MYSQL_TMP_DIR/killquery.xpl
15
16 -->echo
17 -->echo #
18 -->echo # I.1
19 -->newsession second x_root test
20 -->stmtsql SELECT connection_id() AS Value;
21 -->recvtovar %ID% Value
22 -->stmtsql SELECT * FROM mysql.user WHERE SLEEP(30);
23
24 -->setsession
25 -->quiet
26 -->wait_for 1 SELECT COUNT(*) FROM information_schema.processlist WHERE id = %ID% AND state = 'User sleep'
27 -->noquiet
28 KILL QUERY %ID%;
29
30 -->setsession second
31 -->expecterror ER_QUERY_INTERRUPTED
32 -->recvresult
33 SELECT '"Second" session must work' AS state;
34 -->closesession
35
36 SELECT 'Default session must work' AS state;
37
38 -->echo
39 -->echo #
40 -->echo # I.2
41 -->newsession third x_root test
42 -->stmtsql SELECT connection_id() AS Value;
43 -->recvtovar %ID% Value
44
45 -->stmtsql select sleep(20),b from data;
46 sleep 3;
47 -->setsession
48 -->quiet
49 -->wait_for 1 SELECT COUNT(*) FROM information_schema.processlist WHERE id = %ID% AND state = 'User sleep'
50 -->noquiet
51 KILL QUERY %ID%;
52 -->setsession third
53 -->expecterror ER_QUERY_INTERRUPTED
54 -->recvresult
55 SELECT '"third" session must work' AS state;
56 -->closesession
57 EOF
58
59 CREATE TABLE data(b INT);
60 INSERT INTO data(b) VALUES (1),(2),(3);
61
62 --replace_regex /KILL QUERY [0-9]*/KILL QUERY $ID/ /WHERE id = [0-9]*/WHERE id = $ID/
63 --exec $MYSQLXTEST -u x_root --password='' --file=$MYSQL_TMP_DIR/killquery.xpl 2>&1
64
65 ## Cleanup
66 DROP TABLE data;
67 --source ../include/xplugin_cleanup.inc