1
--source include/not_embedded.inc
3
# Save the initial number of concurrent sessions
4
--source include/count_sessions.inc
6
connect (con1,localhost,root,,);
7
connect (con2,localhost,root,,);
13
DROP TABLE IF EXISTS t1;
16
CREATE TABLE t1 (n INT);
17
INSERT INTO t1 VALUES (1),(2),(3);
27
# Bug#10374 GET_LOCK does not let connection to close on the server side if it's aborted
31
SELECT GET_LOCK("dangling", 0);
32
connect(con1, localhost, root,,);
34
--send SELECT GET_LOCK('dangling', 3600);
37
SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE = "User lock"
38
AND INFO = "SELECT GET_LOCK('dangling', 3600)";
39
--source include/wait_condition.inc
42
SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE = "User lock"
43
AND INFO = "SELECT GET_LOCK('dangling', 3600)";
44
--source include/wait_condition.inc
45
connect(con1, localhost, root,,);
46
--send SELECT GET_LOCK('dangling', 3600);
49
SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE = "User lock"
50
AND INFO = "SELECT GET_LOCK('dangling', 3600)";
51
--source include/wait_condition.inc
52
SELECT RELEASE_LOCK('dangling');
58
# Wait till all disconnects are completed
59
--source include/wait_until_count_sessions.inc