diff options
Diffstat (limited to 'mysql-test/r/interactive_timeout_func.result')
| -rw-r--r-- | mysql-test/r/interactive_timeout_func.result | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/mysql-test/r/interactive_timeout_func.result b/mysql-test/r/interactive_timeout_func.result new file mode 100644 index 00000000000..b97f7c90908 --- /dev/null +++ b/mysql-test/r/interactive_timeout_func.result @@ -0,0 +1,30 @@ +drop table if exists t1; +## Creating new table t1 ## +CREATE TABLE t1 +( +id INT NOT NULL auto_increment, +PRIMARY KEY (id), +name VARCHAR(30) +); +'#--------------------FN_DYNVARS_052_01-------------------------#' +## Setting initial value of variable to 1 ## +SET @@global.interactive_timeout = 1; +## Creating new interactive connection test_con1 ## +## Inserting record in table ## +INSERT into t1(name) values('Record_1'); +## Setting session value of interactive_timeout ## +SET @@session.interactive_timeout = 1; +## Verifying values of variable ## +SELECT @@session.interactive_timeout; +@@session.interactive_timeout +1 +SELECT @@global.interactive_timeout; +@@global.interactive_timeout +1 +## Using sleep to check timeout ## +SELECT * from t1; +id name +1 Record_1 +'Bug#35377: Error should appear here because interactive_timeout value'; +'is 1 and connection remains idle for 5 secs'; +INSERT into t1(name) values('Record_2'); |