Debian Codegraph @

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

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