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