|
1963.2.1
by Brian Aker
Fixing up the kill function. |
1 |
# Test creating a bunch of connections, and then killing them. |
2 |
connect (con1,localhost,root,,); |
|
3 |
connect (con2,localhost,root,,); |
|
4 |
connect (con3,localhost,root,,); |
|
5 |
connect (con4,localhost,root,,); |
|
6 |
connect (con5,localhost,root,,); |
|
7 |
||
8 |
connection default; |
|
9 |
CREATE TABLE CONNECTIONS SELECT ID FROM DATA_DICTIONARY.PROCESSLIST WHERE ID != CONNECTION_ID(); |
|
10 |
INSERT INTO CONNECTIONS SELECT ID FROM DATA_DICTIONARY.PROCESSLIST WHERE ID != CONNECTION_ID(); |
|
11 |
SELECT IF (KILL(id), "YES", "NO") FROM CONNECTIONS ORDER BY RAND(); |
|
12 |
SELECT count(ID) FROM DATA_DICTIONARY.PROCESSLIST WHERE COMMAND != "Killed"; |
|
|
1963.2.5
by Brian Aker
Fix test case. We weren't dropped a table out of one test. |
13 |
DROP TABLE CONNECTIONS; |