1--source include/have_innodb.inc 2 3SET @start_global_value = @@global.innodb_status_output; 4SELECT @start_global_value; 5 6# 7# exists as global only 8# 9--echo Valid values are 'ON' and 'OFF' 10select @@global.innodb_status_output in (0, 1); 11select @@global.innodb_status_output; 12--error ER_INCORRECT_GLOBAL_LOCAL_VAR 13select @@session.innodb_status_output; 14show global variables like 'innodb_status_output'; 15show session variables like 'innodb_status_output'; 16--disable_warnings 17select * from information_schema.global_variables where variable_name='innodb_status_output'; 18select * from information_schema.session_variables where variable_name='innodb_status_output'; 19--enable_warnings 20 21# 22# show that it's writable 23# 24set global innodb_status_output='OFF'; 25select @@global.innodb_status_output; 26--disable_warnings 27select * from information_schema.global_variables where variable_name='innodb_status_output'; 28select * from information_schema.session_variables where variable_name='innodb_status_output'; 29--enable_warnings 30set @@global.innodb_status_output=1; 31select @@global.innodb_status_output; 32--disable_warnings 33select * from information_schema.global_variables where variable_name='innodb_status_output'; 34select * from information_schema.session_variables where variable_name='innodb_status_output'; 35--enable_warnings 36set global innodb_status_output=0; 37select @@global.innodb_status_output; 38--disable_warnings 39select * from information_schema.global_variables where variable_name='innodb_status_output'; 40select * from information_schema.session_variables where variable_name='innodb_status_output'; 41--enable_warnings 42set @@global.innodb_status_output='ON'; 43select @@global.innodb_status_output; 44--disable_warnings 45select * from information_schema.global_variables where variable_name='innodb_status_output'; 46select * from information_schema.session_variables where variable_name='innodb_status_output'; 47--enable_warnings 48--error ER_GLOBAL_VARIABLE 49set session innodb_status_output='OFF'; 50--error ER_GLOBAL_VARIABLE 51set @@session.innodb_status_output='ON'; 52 53# 54# incorrect types 55# 56--error ER_WRONG_TYPE_FOR_VAR 57set global innodb_status_output=1.1; 58--error ER_WRONG_TYPE_FOR_VAR 59set global innodb_status_output=1e1; 60--error ER_WRONG_VALUE_FOR_VAR 61set global innodb_status_output=2; 62--error ER_WRONG_VALUE_FOR_VAR 63set global innodb_status_output=-3; 64select @@global.innodb_status_output; 65--disable_warnings 66select * from information_schema.global_variables where variable_name='innodb_status_output'; 67select * from information_schema.session_variables where variable_name='innodb_status_output'; 68--enable_warnings 69set global innodb_status_output=DEFAULT; 70select @@global.innodb_status_output; 71--disable_warnings 72select * from information_schema.global_variables where variable_name='innodb_status_output'; 73select * from information_schema.session_variables where variable_name='innodb_status_output'; 74--enable_warnings 75--error ER_WRONG_VALUE_FOR_VAR 76set global innodb_status_output='AUTO'; 77 78# 79# Cleanup 80# 81 82SET @@global.innodb_status_output = @start_global_value; 83SELECT @@global.innodb_status_output; 84