diff options
author | Sergei Golubchik <sergii@pisem.net> | 2014-05-06 13:57:56 +0200 |
---|---|---|
committer | Sergei Golubchik <sergii@pisem.net> | 2014-05-06 13:57:56 +0200 |
commit | 4a84ee1c25045ba1ee4bd23cba3772b90545d3d1 (patch) | |
tree | 42af0798be22fd47a555bdfc77f5d37085565049 /mysql-test/suite/sys_vars/t | |
parent | b968363aac2bf75d014482f8405e6a9fed73ccd6 (diff) | |
download | mariadb-git-4a84ee1c25045ba1ee4bd23cba3772b90545d3d1.tar.gz |
after InnoDB/XtraDB 5.6.16 merge
Diffstat (limited to 'mysql-test/suite/sys_vars/t')
3 files changed, 170 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/t/innodb_buf_flush_list_now_basic.test b/mysql-test/suite/sys_vars/t/innodb_buf_flush_list_now_basic.test new file mode 100644 index 00000000000..8a53b0a5770 --- /dev/null +++ b/mysql-test/suite/sys_vars/t/innodb_buf_flush_list_now_basic.test @@ -0,0 +1,32 @@ +--echo # +--echo # Basic test for innodb_buf_flush_list_now. +--echo # + +--source include/have_innodb.inc + +# The config variable is a debug variable for now +-- source include/have_debug.inc + +SELECT @@global.innodb_buf_flush_list_now; + +set global innodb_buf_flush_list_now = 1; + +SELECT @@global.innodb_buf_flush_list_now; + +set global innodb_buf_flush_list_now = 0; + +--error ER_WRONG_VALUE_FOR_VAR +set global innodb_buf_flush_list_now = dummy; + +--error ER_GLOBAL_VARIABLE +set innodb_buf_flush_list_now = ON; + +--echo # Setting to ON is ok. +set global innodb_buf_flush_list_now = ON; + +--echo # Setting to OFF is ok. +set global innodb_buf_flush_list_now = OFF; + +--echo # Must always be 0. +SELECT @@global.innodb_buf_flush_list_now; + diff --git a/mysql-test/suite/sys_vars/t/innodb_status_output_basic.test b/mysql-test/suite/sys_vars/t/innodb_status_output_basic.test new file mode 100644 index 00000000000..4459632134d --- /dev/null +++ b/mysql-test/suite/sys_vars/t/innodb_status_output_basic.test @@ -0,0 +1,69 @@ +--source include/have_innodb.inc + +SET @start_global_value = @@global.innodb_status_output; +SELECT @start_global_value; + +# +# exists as global only +# +--echo Valid values are 'ON' and 'OFF' +select @@global.innodb_status_output in (0, 1); +select @@global.innodb_status_output; +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +select @@session.innodb_status_output; +show global variables like 'innodb_status_output'; +show session variables like 'innodb_status_output'; +select * from information_schema.global_variables where variable_name='innodb_status_output'; +select * from information_schema.session_variables where variable_name='innodb_status_output'; + +# +# show that it's writable +# +set global innodb_status_output='OFF'; +select @@global.innodb_status_output; +select * from information_schema.global_variables where variable_name='innodb_status_output'; +select * from information_schema.session_variables where variable_name='innodb_status_output'; +set @@global.innodb_status_output=1; +select @@global.innodb_status_output; +select * from information_schema.global_variables where variable_name='innodb_status_output'; +select * from information_schema.session_variables where variable_name='innodb_status_output'; +set global innodb_status_output=0; +select @@global.innodb_status_output; +select * from information_schema.global_variables where variable_name='innodb_status_output'; +select * from information_schema.session_variables where variable_name='innodb_status_output'; +set @@global.innodb_status_output='ON'; +select @@global.innodb_status_output; +select * from information_schema.global_variables where variable_name='innodb_status_output'; +select * from information_schema.session_variables where variable_name='innodb_status_output'; +--error ER_GLOBAL_VARIABLE +set session innodb_status_output='OFF'; +--error ER_GLOBAL_VARIABLE +set @@session.innodb_status_output='ON'; + +# +# incorrect types +# +--error ER_WRONG_TYPE_FOR_VAR +set global innodb_status_output=1.1; +--error ER_WRONG_TYPE_FOR_VAR +set global innodb_status_output=1e1; +--error ER_WRONG_VALUE_FOR_VAR +set global innodb_status_output=2; +--error ER_WRONG_VALUE_FOR_VAR +set global innodb_status_output=-3; +select @@global.innodb_status_output; +select * from information_schema.global_variables where variable_name='innodb_status_output'; +select * from information_schema.session_variables where variable_name='innodb_status_output'; +set global innodb_status_output=DEFAULT; +select @@global.innodb_status_output; +select * from information_schema.global_variables where variable_name='innodb_status_output'; +select * from information_schema.session_variables where variable_name='innodb_status_output'; +--error ER_WRONG_VALUE_FOR_VAR +set global innodb_status_output='AUTO'; + +# +# Cleanup +# + +SET @@global.innodb_status_output = @start_global_value; +SELECT @@global.innodb_status_output; diff --git a/mysql-test/suite/sys_vars/t/innodb_status_output_locks_basic.test b/mysql-test/suite/sys_vars/t/innodb_status_output_locks_basic.test new file mode 100644 index 00000000000..92c82b2ddbf --- /dev/null +++ b/mysql-test/suite/sys_vars/t/innodb_status_output_locks_basic.test @@ -0,0 +1,69 @@ +--source include/have_innodb.inc + +SET @start_global_value = @@global.innodb_status_output_locks; +SELECT @start_global_value; + +# +# exists as global only +# +--echo Valid values are 'ON' and 'OFF' +select @@global.innodb_status_output_locks in (0, 1); +select @@global.innodb_status_output_locks; +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +select @@session.innodb_status_output_locks; +show global variables like 'innodb_status_output_locks'; +show session variables like 'innodb_status_output_locks'; +select * from information_schema.global_variables where variable_name='innodb_status_output_locks'; +select * from information_schema.session_variables where variable_name='innodb_status_output_locks'; + +# +# show that it's writable +# +set global innodb_status_output_locks='OFF'; +select @@global.innodb_status_output_locks; +select * from information_schema.global_variables where variable_name='innodb_status_output_locks'; +select * from information_schema.session_variables where variable_name='innodb_status_output_locks'; +set @@global.innodb_status_output_locks=1; +select @@global.innodb_status_output_locks; +select * from information_schema.global_variables where variable_name='innodb_status_output_locks'; +select * from information_schema.session_variables where variable_name='innodb_status_output_locks'; +set global innodb_status_output_locks=0; +select @@global.innodb_status_output_locks; +select * from information_schema.global_variables where variable_name='innodb_status_output_locks'; +select * from information_schema.session_variables where variable_name='innodb_status_output_locks'; +set @@global.innodb_status_output_locks='ON'; +select @@global.innodb_status_output_locks; +select * from information_schema.global_variables where variable_name='innodb_status_output_locks'; +select * from information_schema.session_variables where variable_name='innodb_status_output_locks'; +--error ER_GLOBAL_VARIABLE +set session innodb_status_output_locks='OFF'; +--error ER_GLOBAL_VARIABLE +set @@session.innodb_status_output_locks='ON'; + +# +# incorrect types +# +--error ER_WRONG_TYPE_FOR_VAR +set global innodb_status_output_locks=1.1; +--error ER_WRONG_TYPE_FOR_VAR +set global innodb_status_output_locks=1e1; +--error ER_WRONG_VALUE_FOR_VAR +set global innodb_status_output_locks=2; +--error ER_WRONG_VALUE_FOR_VAR +set global innodb_status_output_locks=-3; +select @@global.innodb_status_output_locks; +select * from information_schema.global_variables where variable_name='innodb_status_output_locks'; +select * from information_schema.session_variables where variable_name='innodb_status_output_locks'; +set global innodb_status_output_locks=DEFAULT; +select @@global.innodb_status_output_locks; +select * from information_schema.global_variables where variable_name='innodb_status_output_locks'; +select * from information_schema.session_variables where variable_name='innodb_status_output_locks'; +--error ER_WRONG_VALUE_FOR_VAR +set global innodb_status_output_locks='AUTO'; + +# +# Cleanup +# + +SET @@global.innodb_status_output_locks = @start_global_value; +SELECT @@global.innodb_status_output_locks; |