1# 2# Basic test for innodb_dict_stats_disabled_debug 3# 4# Save default value. 5SET @default_var_value = @@GLOBAL.innodb_dict_stats_disabled_debug; 6SELECT @@GLOBAL.innodb_dict_stats_disabled_debug; 7@@GLOBAL.innodb_dict_stats_disabled_debug 80 9# Try setting to 1. 10SET @@GLOBAL.innodb_dict_stats_disabled_debug = 1; 11SELECT @@GLOBAL.innodb_dict_stats_disabled_debug; 12@@GLOBAL.innodb_dict_stats_disabled_debug 131 14# Try setting to 0. 15SET @@GLOBAL.innodb_dict_stats_disabled_debug = 0; 16SELECT @@GLOBAL.innodb_dict_stats_disabled_debug; 17@@GLOBAL.innodb_dict_stats_disabled_debug 180 19# Try setting to 1 (again). 20SET @@GLOBAL.innodb_dict_stats_disabled_debug = 1; 21SELECT @@GLOBAL.innodb_dict_stats_disabled_debug; 22@@GLOBAL.innodb_dict_stats_disabled_debug 231 24# Try setting to 0 (again). 25SET @@GLOBAL.innodb_dict_stats_disabled_debug = 0; 26SELECT @@GLOBAL.innodb_dict_stats_disabled_debug; 27@@GLOBAL.innodb_dict_stats_disabled_debug 280 29# Check what happens if we set the same value as current. 30SET @@GLOBAL.innodb_dict_stats_disabled_debug = 1; 31SET @@GLOBAL.innodb_dict_stats_disabled_debug = 1; 32SET @@GLOBAL.innodb_dict_stats_disabled_debug = 0; 33SET @@GLOBAL.innodb_dict_stats_disabled_debug = 0; 34# Try using variable as local. 35SET innodb_dict_stats_disabled_debug = 1; 36ERROR HY000: Variable 'innodb_dict_stats_disabled_debug' is a GLOBAL variable and should be set with SET GLOBAL 37# Finished. Restore default value. 38SET @@GLOBAL.innodb_dict_stats_disabled_debug = @default_var_value; 39