diff options
Diffstat (limited to 'mysql-test/t/general_log_func.test')
| -rw-r--r-- | mysql-test/t/general_log_func.test | 87 |
1 files changed, 0 insertions, 87 deletions
diff --git a/mysql-test/t/general_log_func.test b/mysql-test/t/general_log_func.test deleted file mode 100644 index 39ce964a105..00000000000 --- a/mysql-test/t/general_log_func.test +++ /dev/null @@ -1,87 +0,0 @@ -################# mysql-test\t\general_log_func.test ########################### -# # -# Variable Name: general_log # -# Scope: GLOBAL # -# Access Type: Dynamic # -# Data Type: Boolean # -# Default Value: OFF # -# Valid Values: ON, OFF # -# # -# # -# Creation Date: 2008-03-17 # -# Author: Salman Rawala # -# # -# Description: Test Cases of Dynamic System Variable "general_log" # -# that checks functionality of this variable # -# # -# Reference: http://dev.mysql.com/doc/refman/5.1/en/ # -# server-system-variables.html#option_mysqld_general_log # -# # -################################################################################ - - ---disable_warnings -drop table if exists t1; ---enable_warnings - -######################### -# Creating new table # -######################### - ---echo ## Creating new table ## -CREATE TABLE t1 -( -id INT NOT NULL auto_increment, -PRIMARY KEY (id), -name VARCHAR(30) -); - ---echo '#--------------------FN_DYNVARS_018_01-------------------------#' -#################################################################### -# Setting initial value of general_log to OFF and verifying -# its behavior -#################################################################### - ---echo ## Setting initial value of variable to OFF ## -SET @@global.general_log = OFF; -SELECT @@general_log; - ---replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR ---copy_file $MYSQLTEST_VARDIR/log/master.log $MYSQLTEST_VARDIR/log/master-test.log - ---echo ## Inserting some Records & Verifying output in log ## -INSERT into t1(name) values('Record_1'); -INSERT into t1(name) values('Record_2'); - ---echo ## There should be no difference, case should pass ## ---replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR ---diff_files $MYSQLTEST_VARDIR/log/master.log $MYSQLTEST_VARDIR/log/master-test.log - - ---echo '#--------------------FN_DYNVARS_018_01-------------------------#' -#################################################################### -# Setting initial value of general_log to ON and verifying -# its behavior -#################################################################### - ---echo ## Setting initial value of variable to OFF ## -SET @@global.general_log = ON; -SELECT @@general_log; - ---replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR ---copy_file $MYSQLTEST_VARDIR/log/master.log $MYSQLTEST_VARDIR/log/master-test-1.log - ---echo ## Inserting some Records & Verifying output in log ## -INSERT into t1(name) values('Record_3'); -INSERT into t1(name) values('Record_4'); - - ---echo ## There should be no difference, case should pass ## -#--diff_files var/log/master.log var/log/master-test-1.log - ---echo ## This case is failing which shows that mysql is writing in general ## ---echo ## log when we set general_log to ON ## - ---echo ## Dropping tables ## -DROP TABLE t1; - |