1
drop table if exists t1;
2
## Creating new table t1 ##
5
id INT NOT NULL auto_increment,
9
'#--------------------FN_DYNVARS_052_01-------------------------#'
10
## Setting initial value of variable to 1 ##
11
SET @@global.interactive_timeout = 1;
12
## Creating new interactive connection test_con1 ##
13
## Inserting record in table ##
14
INSERT into t1(name) values('Record_1');
15
## Setting session value of interactive_timeout ##
16
SET @@session.interactive_timeout = 1;
17
## Verifying values of variable ##
18
SELECT @@session.interactive_timeout;
19
@@session.interactive_timeout
21
SELECT @@global.interactive_timeout;
22
@@global.interactive_timeout
24
## Using sleep to check timeout ##
28
'Bug#35377: Error should appear here because interactive_timeout value';
29
'is 1 and connection remains idle for 5 secs';
30
INSERT into t1(name) values('Record_2');