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