diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/innodb_log_arch_expire_sec_basic.result')
-rw-r--r-- | mysql-test/suite/sys_vars/r/innodb_log_arch_expire_sec_basic.result | 38 |
1 files changed, 38 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/r/innodb_log_arch_expire_sec_basic.result b/mysql-test/suite/sys_vars/r/innodb_log_arch_expire_sec_basic.result new file mode 100644 index 00000000000..97bff097252 --- /dev/null +++ b/mysql-test/suite/sys_vars/r/innodb_log_arch_expire_sec_basic.result @@ -0,0 +1,38 @@ +SELECT @@GLOBAL.innodb_log_arch_expire_sec INTO @save; +SELECT @@GLOBAL.innodb_log_arch_expire_sec; +@@GLOBAL.innodb_log_arch_expire_sec +0 +0 Expected +SET @@GLOBAL.innodb_log_arch_expire_sec=1; +SELECT @@GLOBAL.innodb_log_arch_expire_sec; +@@GLOBAL.innodb_log_arch_expire_sec +1 +1 Expected +SELECT VARIABLE_VALUE +FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='innodb_log_arch_expire_sec'; +VARIABLE_VALUE +1 +1 Expected +SELECT @@innodb_log_arch_expire_sec; +@@innodb_log_arch_expire_sec +1 +1 Expected +SELECT @@innodb_log_arch_expire_sec; +@@innodb_log_arch_expire_sec +1 +1 Expected +SELECT @@local.innodb_log_arch_expire_sec; +ERROR HY000: Variable 'innodb_log_arch_expire_sec' is a GLOBAL variable +Expected error 'Variable is a GLOBAL variable' +SELECT @@SESSION.innodb_log_arch_expire_sec; +ERROR HY000: Variable 'innodb_log_arch_expire_sec' is a GLOBAL variable +Expected error 'Variable is a GLOBAL variable' +SELECT @@GLOBAL.innodb_log_arch_expire_sec; +@@GLOBAL.innodb_log_arch_expire_sec +1 +1 Expected +SELECT innodb_log_arch_expire_sec = @@SESSION.innodb_log_arch_expire_sec; +ERROR 42S22: Unknown column 'innodb_log_arch_expire_sec' in 'field list' +Expected error Unknown column 'innodb_log_arch_expire_sec' in 'field list' +SET @@GLOBAL.innodb_log_arch_expire_sec = @save; |