wait_timeout_func.test 3.82 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
############## mysql-test\t\wait_timeout_func.test ############################
#                                                                             #
# Variable Name: wait_timeout                                                 #
# Scope: GLOBAL | SESSION                                                     #
# Access Type: Dynamic                                                        #
# Data Type: numeric                                                          #
# Default Value:                                                              #
# Range:                                                                      #
#                                                                             #
#                                                                             #
# Creation Date: 2008-03-07                                                   #
# Author:  Salman Rawala                                                      #
#                                                                             #
# Description: Test Cases of Dynamic System Variable wait_timeout             #
#              that checks the functionality of this variable                 #
#                                                                             #
# Reference: http://dev.mysql.com/doc/refman/5.1/en/                          #
#  server-system-variables.html#option_mysqld_wait_timeouts                   #
#                                                                             #
###############################################################################

22 23
--source include/not_embedded.inc

24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103
--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_186_01-------------------------#'
#######################################################################
#   Setting initial value of interactive_timeout greater than sleep and
#   verifying its behavior on session scope
#######################################################################

--echo ## Creating new connection test_con1 ## 
connect (test_con1, localhost, root,,);
connection test_con1;

--echo ## Setting value of variable to 5 ##
SET @@session.wait_timeout = 5;

--echo ## Inserting record in table t1 ##
INSERT into t1(name) values('Record_1');

--echo ## Using sleep to check timeout ## 
sleep 4;


--echo '#--------------------FN_DYNVARS_186_02-------------------------#'
#######################################################################
#   Setting initial value of interactive_timeout greater than sleep and
#   verifying its behavior on global scope
#######################################################################

--echo ## Setting value of variable ##
SET @@global.wait_timeout = 5;

--echo ## Creating new connection test_con2 ## 
connect (test_con2, localhost, root,,);
connection test_con2;

INSERT into t1(name) values('Record_2');

--echo ## Using sleep to check timeout ## 
sleep 4;




--echo '#--------------------FN_DYNVARS_186_03-------------------------#'
#######################################################################
#   Setting initial value of interactive_timeout less than sleep and
#   verifying its behavior on global scope
#######################################################################

--echo ## Setting value of variable to 1 ##
SET @@global.wait_timeout = 1;

--echo ## Creating new connection ## 
connect (test_con3, localhost, root,,);
connection test_con3;

INSERT into t1(name) values('Record_3');

--echo ## Using sleep to check timeout ##
sleep 5;

--echo ## We cannot test it further because the server stops due to wait_timeout ## 
--Error 2006
SELECT * from t1;