diff options
| author | Michael Widenius <monty@askmonty.org> | 2009-02-15 12:58:34 +0200 |
|---|---|---|
| committer | Michael Widenius <monty@askmonty.org> | 2009-02-15 12:58:34 +0200 |
| commit | a8fdaa6f2c5b2e302bffb069be3475772ca20f48 (patch) | |
| tree | b5c9560ec7346f7af6a5904ad344fdbb8020849c /mysql-test/t/interactive_timeout_func.test | |
| parent | 115efe100dbc1393bce964fa1370e50cfef71d18 (diff) | |
| parent | f7a24d72dc7a86341da4634f6d1a71f1ea77000b (diff) | |
| download | mariadb-git-a8fdaa6f2c5b2e302bffb069be3475772ca20f48.tar.gz | |
Merge with base MySQL 5.1
Contains fixes for test cases
Changed release tag to beta
configure.in:
change release tag to beta
Diffstat (limited to 'mysql-test/t/interactive_timeout_func.test')
| -rw-r--r-- | mysql-test/t/interactive_timeout_func.test | 70 |
1 files changed, 0 insertions, 70 deletions
diff --git a/mysql-test/t/interactive_timeout_func.test b/mysql-test/t/interactive_timeout_func.test deleted file mode 100644 index e3a210bf508..00000000000 --- a/mysql-test/t/interactive_timeout_func.test +++ /dev/null @@ -1,70 +0,0 @@ -############## mysql-test\t\interactive_timeout_func.test ##################### -# # -# Variable Name: interactive_timeout # -# Scope: GLOBAL | SESSION # -# Access Type: Dynamic # -# Data Type: numeric # -# Default Value:28800 # -# Minvalue: 1 # -# # -# # -# Creation Date: 2008-03-07 # -# Author: Salman Rawala # -# # -# Description: Test Cases of Dynamic System Variable interactive_timeout # -# that checks the functionality of this variable # -# # -# Reference: http://dev.mysql.com/doc/refman/5.1/en/ # -# server-system-variables.html # -# # -############################################################################### - - ---disable_warnings -drop table if exists t1; ---enable_warnings - -############################## -# Creating two new tables # -############################## - ---echo ## Creating new table t1 ## -CREATE TABLE t1 -( -id INT NOT NULL auto_increment, -PRIMARY KEY (id), -name VARCHAR(30) -); - - ---echo '#--------------------FN_DYNVARS_052_01-------------------------#' -####################################################################### -# Setting initial value of interactive_timeout to 1 and verifying its -# behavior -####################################################################### - ---echo ## Setting initial value of variable to 1 ## -SET @@global.interactive_timeout = 1; - ---echo ## Creating new interactive connection test_con1 ## -connect (test_con1, localhost, root,); -connection test_con1; - ---echo ## Inserting record in table ## -INSERT into t1(name) values('Record_1'); - ---echo ## Setting session value of interactive_timeout ## -SET @@session.interactive_timeout = 1; - ---echo ## Verifying values of variable ## -SELECT @@session.interactive_timeout; -SELECT @@global.interactive_timeout; - ---echo ## Using sleep to check timeout ## -sleep 5; -SELECT * from t1; - ---echo 'Bug#35377: Error should appear here because interactive_timeout value'; ---echo 'is 1 and connection remains idle for 5 secs'; - -INSERT into t1(name) values('Record_2'); |