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/innodb_status_output_basic.test | |
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/innodb_status_output_basic.test')
-rw-r--r-- | mysql-test/suite/sys_vars/t/innodb_status_output_basic.test | 69 |
1 files changed, 69 insertions, 0 deletions
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; |