diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/log_basic.result')
| -rw-r--r-- | mysql-test/suite/sys_vars/r/log_basic.result | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/r/log_basic.result b/mysql-test/suite/sys_vars/r/log_basic.result new file mode 100644 index 00000000000..18a12b72437 --- /dev/null +++ b/mysql-test/suite/sys_vars/r/log_basic.result @@ -0,0 +1,21 @@ +'#--------------------FN_DYNVARS_062_01------------------#' +SET @start_log= @@global.log; +SELECT @@global.log AS INIT_VALUE; +INIT_VALUE +1 +SELECT @@log AS INIT_VALUE; +INIT_VALUE +1 +SET @@global.general_log = ON; +SET global general_log = 0; +'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 +SET @@global.log= @start_log; +Warnings: +Warning 1287 The syntax '@@log' is deprecated and will be removed in MySQL 7.0. Please use '@@general_log' instead |