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 SELECT @@session.wait_timeout = @@global.wait_timeout AS 'Expect 1';
6 Expect 1
7 1
8 SET @@session.wait_timeout = <session_value>;
9 connect (test_con2, localhost, root,,);
10 SET @@session.wait_timeout = <session_value> - 1;
11 connection default;
12 wait until connections ready
13 SELECT info FROM information_schema.processlist ORDER BY info;
14 info
15 NULL
16 SELECT info FROM information_schema.processlist ORDER BY info
17 Warnings:
18 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
19 '#--------------------FN_DYNVARS_186_03-------------------------#'
20 SET @@global.wait_timeout= <global_value>;
21 SELECT @@session.wait_timeout = @start_value AS 'Expect 1';
22 Expect 1
23 1
24 connect (test_con3, localhost, root,,);
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 ORDER BY info;
30 info
31 NULL
32 SELECT info FROM information_schema.processlist ORDER BY info
33 Warnings:
34 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
35 SELECT UNIX_TIMESTAMP() - @start_time >= <global_value> + <session_value>;;
36 UNIX_TIMESTAMP() - @start_time >= <global_value> + <session_value>;
37 1
38 SET @@global.wait_timeout= @start_value;