Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.key_cache_segments;
2 select @@global.key_cache_segments;
3 @@global.key_cache_segments
4 0
5 select @@session.key_cache_segments;
6 ERROR HY000: Variable 'key_cache_segments' is a GLOBAL variable
7 show global variables like 'key_cache_segments';
8 Variable_name Value
9 key_cache_segments 0
10 show session variables like 'key_cache_segments';
11 Variable_name Value
12 key_cache_segments 0
13 select * from information_schema.global_variables where variable_name='key_cache_segments';
14 VARIABLE_NAME VARIABLE_VALUE
15 KEY_CACHE_SEGMENTS 0
16 select * from information_schema.session_variables where variable_name='key_cache_segments';
17 VARIABLE_NAME VARIABLE_VALUE
18 KEY_CACHE_SEGMENTS 0
19 set global key_cache_segments=1;
20 select @@global.key_cache_segments;
21 @@global.key_cache_segments
22 1
23 set session key_cache_segments=1;
24 ERROR HY000: Variable 'key_cache_segments' is a GLOBAL variable and should be set with SET GLOBAL
25 set global key_cache_segments=1.1;
26 ERROR 42000: Incorrect argument type to variable 'key_cache_segments'
27 set global key_cache_segments=1e1;
28 ERROR 42000: Incorrect argument type to variable 'key_cache_segments'
29 set global key_cache_segments="foo";
30 ERROR 42000: Incorrect argument type to variable 'key_cache_segments'
31 set global key_cache_segments=0;
32 select @@global.key_cache_segments;
33 @@global.key_cache_segments
34 0
35 set global key_cache_segments=cast(-1 as unsigned int);
36 Warnings:
37 Note 1105 Cast to unsigned converted negative integer to it's positive complement
38 Warning 1292 Truncated incorrect key_cache_segments value: '18446744073709551615'
39 select @@global.key_cache_segments;
40 @@global.key_cache_segments
41 64
42 SET @@global.key_cache_segments = @start_global_value;