1SELECT @@GLOBAL.innodb_records_in_range;
2@@GLOBAL.innodb_records_in_range
30
40 Expected
5SET @@GLOBAL.innodb_records_in_range=100;
61 Expected
7SELECT @@GLOBAL.innodb_records_in_range;
8@@GLOBAL.innodb_records_in_range
9100
10100 Expected
11SET @@GLOBAL.innodb_records_in_range=DEFAULT;
121 Expected
13SELECT @@GLOBAL.innodb_records_in_range;
14@@GLOBAL.innodb_records_in_range
150
160 Expected
17SELECT @@GLOBAL.innodb_records_in_range = VARIABLE_VALUE
18FROM performance_schema.global_variables
19WHERE VARIABLE_NAME='innodb_records_in_range';
20@@GLOBAL.innodb_records_in_range = VARIABLE_VALUE
211
221 Expected
23SELECT @@GLOBAL.innodb_records_in_range;
24@@GLOBAL.innodb_records_in_range
250
260 Expected
27SELECT VARIABLE_VALUE
28FROM performance_schema.global_variables
29WHERE VARIABLE_NAME='innodb_records_in_range';
30VARIABLE_VALUE
310
320 Expected
33SELECT @@innodb_records_in_range = VARIABLE_VALUE
34FROM performance_schema.session_variables
35WHERE VARIABLE_NAME='innodb_records_in_range';
36@@innodb_records_in_range = VARIABLE_VALUE
371
381 Expected
39SELECT VARIABLE_VALUE
40FROM performance_schema.session_variables
41WHERE VARIABLE_NAME='innodb_records_in_range';
42VARIABLE_VALUE
430
440 Expected
45SELECT @@innodb_records_in_range = @@GLOBAL.innodb_records_in_range;
46@@innodb_records_in_range = @@GLOBAL.innodb_records_in_range
471
481 Expected
49SELECT @@innodb_records_in_range;
50@@innodb_records_in_range
510
520 Expected
53SELECT @@local.innodb_records_in_range;
54@@local.innodb_records_in_range
550
560 Expected
57SELECT @@SESSION.innodb_records_in_range;
58@@SESSION.innodb_records_in_range
590
600 Expected
61SELECT @@GLOBAL.innodb_records_in_range;
62@@GLOBAL.innodb_records_in_range
630
640 Expected
65SELECT innodb_records_in_range;
66ERROR 42S22: Unknown column 'innodb_records_in_range' in 'field list'
67Expected error 'Unknow column in field list'
68