Debian Codegraph @

mysql-test/suite/sys_vars/r/wait_timeout_func.result

raw
1 SET @start_value= @@global.wait_timeout;
2 '#--------------------FN_DYNVARS_186_01-------------------------#'
3 SET @start_time= UNIX_TIMESTAMP();
4 connect test_con1, localhost, root,,;
5 connection test_con1;
6 SELECT @@session.wait_timeout = @@global.wait_timeout AS 'Expect 1';
7 Expect 1
8 1
9 SET @@session.wait_timeout = <session_value>;
10 connect test_con2, localhost, root,,;
11 connection test_con2;
12 SET @@session.wait_timeout = <session_value> - 1;
13 connection default;
14 wait until connections ready
15 SELECT info FROM information_schema.processlist;
16 info
17 SELECT info FROM information_schema.processlist
18 '#--------------------FN_DYNVARS_186_03-------------------------#'
19 SET @@global.wait_timeout= <global_value>;
20 SELECT @@session.wait_timeout = @start_value AS 'Expect 1';
21 Expect 1
22 1
23 connect test_con3, localhost, root,,;
24 connection test_con3;
25 SELECT @@session.wait_timeout = @@global.wait_timeout AS 'Expect 1';
26 Expect 1
27 1
28 connection default;
29 SELECT info FROM information_schema.processlist;
30 info
31 SELECT info FROM information_schema.processlist
32 SELECT UNIX_TIMESTAMP() - @start_time >= <global_value> + <session_value>;;
33 UNIX_TIMESTAMP() - @start_time >= <global_value> + <session_value>;
34 1
35 SET @@global.wait_timeout= @start_value;