1# 2# Basic test for innodb_disable_resize_buffer_pool_debug 3# 4SET @start_global_value = @@global.innodb_disable_resize_buffer_pool_debug; 5SET @@global.innodb_disable_resize_buffer_pool_debug = 0; 6SELECT @@global.innodb_disable_resize_buffer_pool_debug; 7@@global.innodb_disable_resize_buffer_pool_debug 80 9SET @@global.innodb_disable_resize_buffer_pool_debug ='On' ; 10SELECT @@global.innodb_disable_resize_buffer_pool_debug; 11@@global.innodb_disable_resize_buffer_pool_debug 121 13SET @@global.innodb_disable_resize_buffer_pool_debug ='Off' ; 14SELECT @@global.innodb_disable_resize_buffer_pool_debug; 15@@global.innodb_disable_resize_buffer_pool_debug 160 17SET @@global.innodb_disable_resize_buffer_pool_debug = 1; 18SELECT @@global.innodb_disable_resize_buffer_pool_debug; 19@@global.innodb_disable_resize_buffer_pool_debug 201 21SELECT IF(@@GLOBAL.innodb_disable_resize_buffer_pool_debug,'ON','OFF') = VARIABLE_VALUE 22FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 23WHERE VARIABLE_NAME='innodb_disable_resize_buffer_pool_debug'; 24IF(@@GLOBAL.innodb_disable_resize_buffer_pool_debug,'ON','OFF') = VARIABLE_VALUE 251 261 Expected 27SELECT COUNT(@@GLOBAL.innodb_disable_resize_buffer_pool_debug); 28COUNT(@@GLOBAL.innodb_disable_resize_buffer_pool_debug) 291 301 Expected 31SELECT COUNT(VARIABLE_VALUE) 32FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 33WHERE VARIABLE_NAME='innodb_disable_resize_buffer_pool_debug'; 34COUNT(VARIABLE_VALUE) 351 361 Expected 37SELECT @@innodb_disable_resize_buffer_pool_debug = @@GLOBAL.innodb_disable_resize_buffer_pool_debug; 38@@innodb_disable_resize_buffer_pool_debug = @@GLOBAL.innodb_disable_resize_buffer_pool_debug 391 401 Expected 41SELECT COUNT(@@innodb_disable_resize_buffer_pool_debug); 42COUNT(@@innodb_disable_resize_buffer_pool_debug) 431 441 Expected 45SELECT COUNT(@@local.innodb_disable_resize_buffer_pool_debug); 46ERROR HY000: Variable 'innodb_disable_resize_buffer_pool_debug' is a GLOBAL variable 47Expected error 'Variable is a GLOBAL variable' 48SELECT COUNT(@@SESSION.innodb_disable_resize_buffer_pool_debug); 49ERROR HY000: Variable 'innodb_disable_resize_buffer_pool_debug' is a GLOBAL variable 50Expected error 'Variable is a GLOBAL variable' 51SELECT COUNT(@@GLOBAL.innodb_disable_resize_buffer_pool_debug); 52COUNT(@@GLOBAL.innodb_disable_resize_buffer_pool_debug) 531 541 Expected 55SELECT innodb_disable_resize_buffer_pool_debug = @@SESSION.innodb_disable_resize_buffer_pool_debug; 56ERROR 42S22: Unknown column 'innodb_disable_resize_buffer_pool_debug' in 'field list' 57SET @@global.innodb_disable_resize_buffer_pool_debug = @start_global_value; 58SELECT @@global.innodb_disable_resize_buffer_pool_debug; 59@@global.innodb_disable_resize_buffer_pool_debug 601 61