WL#4681: Took the system variable tests out of the main test suite, put them into "sys_vars", updated some reult files and tests.

1 files changed, 70 insertions, 0 deletions

diff --git a/mysql-test/suite/sys_vars/t/interactive_timeout_func.test b/mysql-test/suite/sys_vars/t/interactive_timeout_func.test
new file mode 100644
index 00000000000..e3a210bf508
--- /dev/null
+++ b/mysql-test/suite/sys_vars/t/interactive_timeout_func.test
@@ -0,0 +1,70 @@
+############## 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');