1
############## mysql-test\t\general_log_file_func.test #########################
3
# Variable Name: general_log_file #
5
# Access Type: Dynamic #
7
# Default Value: filename #
11
# Creation Date: 2008-03-17 #
12
# Author: Salman Rawala #
14
# Description: Test Cases of Dynamic System Variable "general_log_file" #
15
# that checks functionality of this variable #
17
# Reference: http://dev.mysql.com/doc/refman/5.1/en/ #
18
# server-system-variables.html#option_mysqld_general_log_file #
20
################################################################################
24
drop table if exists t1;
27
#########################
28
# Creating new table #
29
#########################
31
--echo ## Creating new table ##
34
id INT NOT NULL auto_increment,
39
--echo '#--------------------FN_DYNVARS_018_01-------------------------#'
40
####################################################################
41
# Verifying general log as we have initialized in opt file #
42
####################################################################
45
SELECT @@general_log_file;
47
INSERT into t1(name) values('Record_1');
48
INSERT into t1(name) values('Record_2');
49
INSERT into t1(name) values('Record_3');
50
INSERT into t1(name) values('Record_4');
52
--echo ## Verifying general log file ##
53
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
54
--file_exists $MYSQLTEST_VARDIR/master-data/mysql-test.log
56
--echo ## Dropping table ##