Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.innodb_adaptive_hash_index;
2 Valid values are 'ON' and 'OFF'
3 select @@global.innodb_adaptive_hash_index in (0, 1);
4 @@global.innodb_adaptive_hash_index in (0, 1)
5 1
6 select @@session.innodb_adaptive_hash_index;
7 ERROR HY000: Variable 'innodb_adaptive_hash_index' is a GLOBAL variable
8 show global variables like 'innodb_adaptive_hash_index';
9 Variable_name Value
10 innodb_adaptive_hash_index #
11 show session variables like 'innodb_adaptive_hash_index';
12 Variable_name Value
13 innodb_adaptive_hash_index #
14 select variable_name from information_schema.global_variables where variable_name='innodb_adaptive_hash_index';
15 variable_name
16 INNODB_ADAPTIVE_HASH_INDEX
17 select variable_name from information_schema.session_variables where variable_name='innodb_adaptive_hash_index';
18 variable_name
19 INNODB_ADAPTIVE_HASH_INDEX
20 set global innodb_adaptive_hash_index='OFF';
21 select @@global.innodb_adaptive_hash_index;
22 @@global.innodb_adaptive_hash_index
23 0
24 select * from information_schema.global_variables where variable_name='innodb_adaptive_hash_index';
25 VARIABLE_NAME VARIABLE_VALUE
26 INNODB_ADAPTIVE_HASH_INDEX OFF
27 select * from information_schema.session_variables where variable_name='innodb_adaptive_hash_index';
28 VARIABLE_NAME VARIABLE_VALUE
29 INNODB_ADAPTIVE_HASH_INDEX OFF
30 set @@global.innodb_adaptive_hash_index=1;
31 select @@global.innodb_adaptive_hash_index;
32 @@global.innodb_adaptive_hash_index
33 1
34 select * from information_schema.global_variables where variable_name='innodb_adaptive_hash_index';
35 VARIABLE_NAME VARIABLE_VALUE
36 INNODB_ADAPTIVE_HASH_INDEX ON
37 select * from information_schema.session_variables where variable_name='innodb_adaptive_hash_index';
38 VARIABLE_NAME VARIABLE_VALUE
39 INNODB_ADAPTIVE_HASH_INDEX ON
40 set global innodb_adaptive_hash_index=0;
41 select @@global.innodb_adaptive_hash_index;
42 @@global.innodb_adaptive_hash_index
43 0
44 select * from information_schema.global_variables where variable_name='innodb_adaptive_hash_index';
45 VARIABLE_NAME VARIABLE_VALUE
46 INNODB_ADAPTIVE_HASH_INDEX OFF
47 select * from information_schema.session_variables where variable_name='innodb_adaptive_hash_index';
48 VARIABLE_NAME VARIABLE_VALUE
49 INNODB_ADAPTIVE_HASH_INDEX OFF
50 set @@global.innodb_adaptive_hash_index='ON';
51 select @@global.innodb_adaptive_hash_index;
52 @@global.innodb_adaptive_hash_index
53 1
54 select * from information_schema.global_variables where variable_name='innodb_adaptive_hash_index';
55 VARIABLE_NAME VARIABLE_VALUE
56 INNODB_ADAPTIVE_HASH_INDEX ON
57 select * from information_schema.session_variables where variable_name='innodb_adaptive_hash_index';
58 VARIABLE_NAME VARIABLE_VALUE
59 INNODB_ADAPTIVE_HASH_INDEX ON
60 set session innodb_adaptive_hash_index='OFF';
61 ERROR HY000: Variable 'innodb_adaptive_hash_index' is a GLOBAL variable and should be set with SET GLOBAL
62 set @@session.innodb_adaptive_hash_index='ON';
63 ERROR HY000: Variable 'innodb_adaptive_hash_index' is a GLOBAL variable and should be set with SET GLOBAL
64 set global innodb_adaptive_hash_index=1.1;
65 ERROR 42000: Incorrect argument type to variable 'innodb_adaptive_hash_index'
66 set global innodb_adaptive_hash_index=1e1;
67 ERROR 42000: Incorrect argument type to variable 'innodb_adaptive_hash_index'
68 set global innodb_adaptive_hash_index=2;
69 ERROR 42000: Variable 'innodb_adaptive_hash_index' can't be set to the value of '2'
70 set global innodb_adaptive_hash_index=-3;
71 ERROR 42000: Variable 'innodb_adaptive_hash_index' can't be set to the value of '-3'
72 select @@global.innodb_adaptive_hash_index;
73 @@global.innodb_adaptive_hash_index
74 1
75 select * from information_schema.global_variables where variable_name='innodb_adaptive_hash_index';
76 VARIABLE_NAME VARIABLE_VALUE
77 INNODB_ADAPTIVE_HASH_INDEX ON
78 select * from information_schema.session_variables where variable_name='innodb_adaptive_hash_index';
79 VARIABLE_NAME VARIABLE_VALUE
80 INNODB_ADAPTIVE_HASH_INDEX ON
81 set global innodb_adaptive_hash_index='AUTO';
82 ERROR 42000: Variable 'innodb_adaptive_hash_index' can't be set to the value of 'AUTO'
83 SET @@global.innodb_adaptive_hash_index = @start_global_value;