Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_adaptive_hash_index_parts_basic.result

raw
1 SELECT COUNT(@@GLOBAL.innodb_adaptive_hash_index_parts);
2 COUNT(@@GLOBAL.innodb_adaptive_hash_index_parts)
3 1
4 1 Expected
5 SET @@GLOBAL.innodb_adaptive_hash_index_parts=1;
6 ERROR HY000: Variable 'innodb_adaptive_hash_index_parts' is a read only variable
7 Expected error 'Read only variable'
8 SELECT COUNT(@@GLOBAL.innodb_adaptive_hash_index_parts);
9 COUNT(@@GLOBAL.innodb_adaptive_hash_index_parts)
10 1
11 1 Expected
12 SELECT @@GLOBAL.innodb_adaptive_hash_index_parts = VARIABLE_VALUE
13 FROM performance_schema.global_variables
14 WHERE VARIABLE_NAME='innodb_adaptive_hash_index_parts';
15 @@GLOBAL.innodb_adaptive_hash_index_parts = VARIABLE_VALUE
16 1
17 1 Expected
18 SELECT COUNT(@@GLOBAL.innodb_adaptive_hash_index_parts);
19 COUNT(@@GLOBAL.innodb_adaptive_hash_index_parts)
20 1
21 1 Expected
22 SELECT COUNT(VARIABLE_VALUE)
23 FROM performance_schema.global_variables
24 WHERE VARIABLE_NAME='innodb_adaptive_hash_index_parts';
25 COUNT(VARIABLE_VALUE)
26 1
27 1 Expected
28 SELECT @@innodb_adaptive_hash_index_parts = @@GLOBAL.innodb_adaptive_hash_index_parts;
29 @@innodb_adaptive_hash_index_parts = @@GLOBAL.innodb_adaptive_hash_index_parts
30 1
31 1 Expected
32 SELECT COUNT(@@innodb_adaptive_hash_index_parts);
33 COUNT(@@innodb_adaptive_hash_index_parts)
34 1
35 1 Expected
36 SELECT COUNT(@@local.innodb_adaptive_hash_index_parts);
37 ERROR HY000: Variable 'innodb_adaptive_hash_index_parts' is a GLOBAL variable
38 Expected error 'Variable is a GLOBAL variable'
39 SELECT COUNT(@@SESSION.innodb_adaptive_hash_index_parts);
40 ERROR HY000: Variable 'innodb_adaptive_hash_index_parts' is a GLOBAL variable
41 Expected error 'Variable is a GLOBAL variable'
42 SELECT COUNT(@@GLOBAL.innodb_adaptive_hash_index_parts);
43 COUNT(@@GLOBAL.innodb_adaptive_hash_index_parts)
44 1
45 1 Expected
46 SELECT innodb_adaptive_hash_index_parts;
47 ERROR 42S22: Unknown column 'innodb_adaptive_hash_index_parts' in 'field list'
48 Expected error 'Unknown column'