log_basic.result 547 Bytes
Newer Older
1 2 3 4 5 6 7
'#--------------------FN_DYNVARS_062_01------------------#'
SELECT @@global.log AS INIT_VALUE;
INIT_VALUE
1
SELECT @@log AS INIT_VALUE;
INIT_VALUE
1
8 9
SET @@global.general_log = ON;
SET global general_log = 0;
10 11 12 13 14 15 16 17
'Bug# 34832: log is a system but it is not accessible using SET @@global.log;'
'SET GLOBAL log; and SELECT @@global.log. SHOW VARIABLES shows the value of log.'
'#--------------------FN_DYNVARS_062_02-------------------------#'
SELECT VARIABLE_VALUE 
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 
WHERE VARIABLE_NAME='log';
VARIABLE_VALUE
OFF