diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/t/innodb_sched_priority_purge_basic.test')
-rw-r--r-- | mysql-test/suite/sys_vars/t/innodb_sched_priority_purge_basic.test | 44 |
1 files changed, 0 insertions, 44 deletions
diff --git a/mysql-test/suite/sys_vars/t/innodb_sched_priority_purge_basic.test b/mysql-test/suite/sys_vars/t/innodb_sched_priority_purge_basic.test deleted file mode 100644 index bc37e4ee568..00000000000 --- a/mysql-test/suite/sys_vars/t/innodb_sched_priority_purge_basic.test +++ /dev/null @@ -1,44 +0,0 @@ ---source include/have_debug.inc ---source include/have_xtradb.inc ---source include/linux.inc ---source include/not_embedded.inc - -# A dynamic, global variable - -SET @start_value = @@GLOBAL.innodb_sched_priority_purge; - -# Default value -SELECT @@GLOBAL.innodb_sched_priority_purge; - -# Global only ---error ER_INCORRECT_GLOBAL_LOCAL_VAR -SELECT @@SESSION.innodb_sched_priority_purge; - -# Correct values -# The high priority values may need permissions, thus do not test them -# SET GLOBAL innodb_sched_priority_purge=39; -# SELECT @@GLOBAL.innodb_sched_priority_purge; -#SET GLOBAL innodb_sched_priority_purge=34; -# SELECT @@GLOBAL.innodb_sched_priority_purge; -SET GLOBAL innodb_sched_priority_purge=19; -SELECT @@GLOBAL.innodb_sched_priority_purge; -SET GLOBAL innodb_sched_priority_purge=5; -SELECT @@GLOBAL.innodb_sched_priority_purge; -SET GLOBAL innodb_sched_priority_purge=0; -SELECT @@GLOBAL.innodb_sched_priority_purge; - -# Incorrect values -SET GLOBAL innodb_sched_priority_purge=-1; -SELECT @@GLOBAL.innodb_sched_priority_purge; -#SET GLOBAL innodb_sched_priority_purge=40; -#SELECT @@GLOBAL.innodb_sched_priority_purge; ---error ER_WRONG_TYPE_FOR_VAR -SET GLOBAL innodb_sched_priority_purge=1.1; ---error ER_WRONG_TYPE_FOR_VAR -SET GLOBAL innodb_sched_priority_purge=1e1; ---error ER_WRONG_TYPE_FOR_VAR -SET GLOBAL innodb_sched_priority_purge='foo'; - -# If we are lacking permissions, then we cannot restore the startup value -# at the end. ---source include/restart_mysqld.inc |