Edit File: general_log_file_func.test
############## 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 ## let $MYSQLD_DATADIR= `select @@datadir`; --replace_result $MYSQLD_DATADIR MYSQLD_DATADIR --file_exists $MYSQLD_DATADIR/mysql-test.log --echo ## Dropping table ## DROP TABLE t1;
Back to File Manager