1
drop table if exists t1;
2
## Creating new table ##
5
id INT NOT NULL auto_increment,
9
'#--------------------FN_DYNVARS_018_01-------------------------#'
10
## Setting initial value of variable to OFF ##
11
SET @@global.general_log = OFF;
15
## Inserting some Records & Verifying output in log ##
16
INSERT into t1(name) values('Record_1');
17
INSERT into t1(name) values('Record_2');
18
## There should be no difference, case should pass ##
19
'#--------------------FN_DYNVARS_018_01-------------------------#'
20
## Setting initial value of variable to OFF ##
21
SET @@global.general_log = ON;
25
## Inserting some Records & Verifying output in log ##
26
INSERT into t1(name) values('Record_3');
27
INSERT into t1(name) values('Record_4');
28
## There should be no difference, case should pass ##
29
## This case is failing which shows that mysql is writing in general ##
30
## log when we set general_log to ON ##