1drop table if exists t1; 2## Creating new table ## 3CREATE TABLE t1 4( 5id INT NOT NULL auto_increment, 6PRIMARY KEY (id), 7name VARCHAR(30) 8); 9'#--------------------FN_DYNVARS_018_01-------------------------#' 10## Setting initial value of variable to OFF ## 11SET @@global.general_log = OFF; 12SELECT @@general_log; 13@@general_log 140 15flush logs; 16SET @@global.general_log = ON; 17flush logs; 18SET @@global.general_log = OFF; 19## Inserting some Records & Verifying output in log ## 20INSERT into t1(name) values('Record_1'); 21INSERT into t1(name) values('Record_2'); 22## There should be no difference, case should pass ## 23'#--------------------FN_DYNVARS_018_01-------------------------#' 24## Setting initial value of variable to OFF ## 25SET @@global.general_log = ON; 26SELECT @@general_log; 27@@general_log 281 29## Inserting some Records & Verifying output in log ## 30INSERT into t1(name) values('Record_3'); 31INSERT into t1(name) values('Record_4'); 32## old log is a proper prefix of the new log ## 33SET @orig_file= load_file('MYSQLD_LOGFILE.orig'); 34SET @copy_file= load_file('MYSQLD_LOGFILE.copy'); 35SELECT @orig_file > @copy_file, left(@orig_file, length(@copy_file)) = @copy_file; 36@orig_file > @copy_file left(@orig_file, length(@copy_file)) = @copy_file 371 1 38## Dropping tables ## 39DROP TABLE t1; 40