diff options
Diffstat (limited to 'mysql-test/t/general_log_file_func.test')
-rw-r--r-- | mysql-test/t/general_log_file_func.test | 56 |
1 files changed, 56 insertions, 0 deletions
diff --git a/mysql-test/t/general_log_file_func.test b/mysql-test/t/general_log_file_func.test new file mode 100644 index 00000000000..7f79115f420 --- /dev/null +++ b/mysql-test/t/general_log_file_func.test @@ -0,0 +1,56 @@ +############## mysql-test\t\general_log_file_func.test ######################### +# # +# Variable Name: general_log_file # +# Scope: GLOBAL # +# Access Type: Dynamic # +# Data Type: Boolean # +# Default Value: filename # +# Valid Values: # +# # +# # +# Creation Date: 2008-03-17 # +# Author: Salman Rawala # +# # +# Description: Test Cases of Dynamic System Variable "general_log_file" # +# that checks functionality of this variable # +# # +# Reference: http://dev.mysql.com/doc/refman/5.1/en/ # +# server-system-variables.html#option_mysqld_general_log_file # +# # +################################################################################ + + +--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-------------------------#' +#################################################################### +# Verifying general log as we have initialized in opt file # +#################################################################### + + +SELECT @@general_log_file; + +INSERT into t1(name) values('Record_1'); +INSERT into t1(name) values('Record_2'); +INSERT into t1(name) values('Record_3'); +INSERT into t1(name) values('Record_4'); + +--echo ## Verifying general log file ## +--file_exists var/master-data/mysql-test.log + +--echo ## Dropping table ## +DROP TABLE t1; |