diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/innodb_locks_unsafe_for_binlog_basic.result')
-rw-r--r-- | mysql-test/suite/sys_vars/r/innodb_locks_unsafe_for_binlog_basic.result | 53 |
1 files changed, 0 insertions, 53 deletions
diff --git a/mysql-test/suite/sys_vars/r/innodb_locks_unsafe_for_binlog_basic.result b/mysql-test/suite/sys_vars/r/innodb_locks_unsafe_for_binlog_basic.result deleted file mode 100644 index c2229d54d02..00000000000 --- a/mysql-test/suite/sys_vars/r/innodb_locks_unsafe_for_binlog_basic.result +++ /dev/null @@ -1,53 +0,0 @@ -'#---------------------BS_STVARS_031_01----------------------#' -SELECT COUNT(@@GLOBAL.innodb_locks_unsafe_for_binlog); -COUNT(@@GLOBAL.innodb_locks_unsafe_for_binlog) -1 -1 Expected -'#---------------------BS_STVARS_031_02----------------------#' -SET @@GLOBAL.innodb_locks_unsafe_for_binlog=1; -ERROR HY000: Variable 'innodb_locks_unsafe_for_binlog' is a read only variable -Expected error 'Read only variable' -SELECT COUNT(@@GLOBAL.innodb_locks_unsafe_for_binlog); -COUNT(@@GLOBAL.innodb_locks_unsafe_for_binlog) -1 -1 Expected -'#---------------------BS_STVARS_031_03----------------------#' -SELECT IF(@@GLOBAL.innodb_locks_unsafe_for_binlog, "ON", "OFF") = VARIABLE_VALUE -FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES -WHERE VARIABLE_NAME='innodb_locks_unsafe_for_binlog'; -IF(@@GLOBAL.innodb_locks_unsafe_for_binlog, "ON", "OFF") = VARIABLE_VALUE -1 -1 Expected -SELECT COUNT(@@GLOBAL.innodb_locks_unsafe_for_binlog); -COUNT(@@GLOBAL.innodb_locks_unsafe_for_binlog) -1 -1 Expected -SELECT COUNT(VARIABLE_VALUE) -FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES -WHERE VARIABLE_NAME='innodb_locks_unsafe_for_binlog'; -COUNT(VARIABLE_VALUE) -1 -1 Expected -'#---------------------BS_STVARS_031_04----------------------#' -SELECT @@innodb_locks_unsafe_for_binlog = @@GLOBAL.innodb_locks_unsafe_for_binlog; -@@innodb_locks_unsafe_for_binlog = @@GLOBAL.innodb_locks_unsafe_for_binlog -1 -1 Expected -'#---------------------BS_STVARS_031_05----------------------#' -SELECT COUNT(@@innodb_locks_unsafe_for_binlog); -COUNT(@@innodb_locks_unsafe_for_binlog) -1 -1 Expected -SELECT COUNT(@@local.innodb_locks_unsafe_for_binlog); -ERROR HY000: Variable 'innodb_locks_unsafe_for_binlog' is a GLOBAL variable -Expected error 'Variable is a GLOBAL variable' -SELECT COUNT(@@SESSION.innodb_locks_unsafe_for_binlog); -ERROR HY000: Variable 'innodb_locks_unsafe_for_binlog' is a GLOBAL variable -Expected error 'Variable is a GLOBAL variable' -SELECT COUNT(@@GLOBAL.innodb_locks_unsafe_for_binlog); -COUNT(@@GLOBAL.innodb_locks_unsafe_for_binlog) -1 -1 Expected -SELECT innodb_locks_unsafe_for_binlog = @@SESSION.innodb_locks_unsafe_for_binlog; -ERROR 42S22: Unknown column 'innodb_locks_unsafe_for_binlog' in 'field list' -Expected error 'Readonly variable' |