1
'#--------------------FN_DYNVARS_065_01-------------------------#'
2
SET @@global.log_output = 'NONE';
3
'connect (con1,localhost,root,,,,)'
5
SELECT @@global.log_output;
8
SET @@global.log_output = 'TABLE,FILE';
9
'connect (con2,localhost,root,,,,)'
11
SELECT @@global.log_output;
14
'#--------------------FN_DYNVARS_065_02-------------------------#'
16
'---Checking general_log when log_output is NONE---'
17
SET @@global.log_output = 'NONE';
18
TRUNCATE TABLE mysql.general_log;
19
DROP TABLE IF EXISTS t1;
20
CREATE TABLE t1(a INT);
21
INSERT INTO t1 value(1);
25
SELECT count(*) FROM mysql.general_log;
28
'---Checking general_log when log_output is TABLE---'
29
SET @@global.log_output = 'TABLE';
30
TRUNCATE TABLE mysql.general_log;
31
DROP TABLE IF EXISTS t1;
32
create table t1(a int);
33
INSERT INTO t1 value(1);
37
SELECT count(*) from mysql.general_log;
40
'Bug#35371: Changing general_log file is crashing server'
41
'SET @@global.general_log_file = @log_file;'
42
SET @@global.log_output = 'FILE';
43
TRUNCATE TABLE mysql.general_log;
44
DROP TABLE IF EXISTS t1;
45
create table t1(a int);
46
INSERT INTO t1 value(1);
50
SELECT count(*) from mysql.general_log;