1SET @start_value= @@global.log_output; 2SET @start_general_log= @@global.general_log; 3'#--------------------FN_DYNVARS_065_01-------------------------#' 4SET @@global.log_output = 'NONE'; 5connect con1,localhost,root,,,,; 6SET @@global.log_output = 'TABLE,FILE'; 7connect con2,localhost,root,,,,; 8SELECT @@global.log_output; 9@@global.log_output 10FILE,TABLE 11'#--------------------FN_DYNVARS_065_02-------------------------#' 12connection con1; 13'---Checking general_log when log_output is NONE---' 14SET @@global.log_output = 'NONE'; 15TRUNCATE TABLE mysql.general_log; 16DROP TABLE IF EXISTS t1; 17CREATE TABLE t1(a INT); 18INSERT INTO t1 VALUE(1); 19SELECT 'abc'; 20abc 21abc 22SELECT count(*) FROM mysql.general_log; 23count(*) 240 25'---Checking general_log when log_output is TABLE---' 26SET @@global.log_output = 'TABLE'; 27TRUNCATE TABLE mysql.general_log; 28DROP TABLE IF EXISTS t1; 29CREATE TABLE t1(a int); 30INSERT INTO t1 VALUE(1); 31SELECT 'abc'; 32abc 33abc 34SELECT count(*)>4 FROM mysql.general_log; 35count(*)>4 361 37SET @@global.general_log = 'OFF'; 38FLUSH LOGS; 39SET @@global.general_log_file = 'MYSQLTEST_VARDIR/run/mytest.log'; 40SET @@global.general_log = 'ON'; 41SET @@global.log_output = 'FILE'; 42TRUNCATE TABLE mysql.general_log; 43DROP TABLE IF EXISTS t1; 44CREATE TABLE t1(a INT); 45INSERT INTO t1 VALUE(1); 46SELECT 'abc'; 47abc 48abc 49SELECT count(*) FROM mysql.general_log; 50count(*) 510 52DROP TABLE t1; 53connection default; 54SET @@global.general_log= 'OFF'; 55SET @@global.general_log_file= 'start_general_log_file'; 56SET @@global.log_output= @start_value; 57SET @@global.general_log= @start_general_log; 58SET @@global.general_log= 'ON'; 59