diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/t/innodb_priority_master_basic.test')
| -rw-r--r-- | mysql-test/suite/sys_vars/t/innodb_priority_master_basic.test | 36 |
1 files changed, 0 insertions, 36 deletions
diff --git a/mysql-test/suite/sys_vars/t/innodb_priority_master_basic.test b/mysql-test/suite/sys_vars/t/innodb_priority_master_basic.test deleted file mode 100644 index f202738f4e1..00000000000 --- a/mysql-test/suite/sys_vars/t/innodb_priority_master_basic.test +++ /dev/null @@ -1,36 +0,0 @@ ---source include/have_debug.inc ---source include/have_xtradb.inc ---source include/linux.inc - -# A dynamic, global variable - -SET @start_value = @@GLOBAL.innodb_priority_master; - -# Default value -SELECT @@GLOBAL.innodb_priority_master; - -# Global only ---error ER_INCORRECT_GLOBAL_LOCAL_VAR -SELECT @@SESSION.innodb_priority_master; - -# Correct values -SET GLOBAL innodb_priority_master='OFF'; -SELECT @@GLOBAL.innodb_priority_master; -SET GLOBAL innodb_priority_master='ON'; -SELECT @@GLOBAL.innodb_priority_master; -SET GLOBAL innodb_priority_master=0; -SELECT @@GLOBAL.innodb_priority_master; -SET GLOBAL innodb_priority_master=1; -SELECT @@GLOBAL.innodb_priority_master; - -# Incorrect values ---error ER_WRONG_TYPE_FOR_VAR -SET GLOBAL innodb_priority_master=1.1; ---error ER_WRONG_TYPE_FOR_VAR -SET GLOBAL innodb_priority_master=1e1; ---error ER_WRONG_VALUE_FOR_VAR -SET GLOBAL innodb_priority_master=2; ---error ER_WRONG_VALUE_FOR_VAR -SET GLOBAL innodb_priority_master='foo'; - -SET GLOBAL innodb_priority_master = @start_value; |