Debian Codegraph @

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

raw
1 drop table if exists t1;
2 ## Creating new table t1 ##
3 CREATE TABLE t1
4 (
5 id INT NOT NULL auto_increment,
6 PRIMARY KEY (id),
7 name VARCHAR(30)
8 );
9 '#--------------------FN_DYNVARS_052_01-------------------------#'
10 ## Setting initial value of variable to 1 ##
11 SET @@global.interactive_timeout = 1;
12 connect test_con1, localhost, root,,,,,;
13 connection test_con1;
14 ## Inserting record in table ##
15 INSERT into t1(name) values('Record_1');
16 ## Setting session value of interactive_timeout ##
17 SET @@session.interactive_timeout = 1;
18 ## Verifying values of variable ##
19 SELECT @@session.interactive_timeout;
20 @@session.interactive_timeout
21 1
22 SELECT @@global.interactive_timeout;
23 @@global.interactive_timeout
24 1
25 connection default;
26 ## Using sleep to check timeout ##
27 sleep 2;
28 connection test_con1;
29 SELECT * from t1;
30 id name
31 1 Record_1
32 INSERT into t1(name) values('Record_2');
33 connection default;
34 disconnect test_con1;
35 DROP TABLE t1;
36 SET @@global.interactive_timeout= 28800;