Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.max_join_size;
2 SELECT @start_global_value;
3 @start_global_value
4 18446744073709551615
5 select @@global.max_join_size;
6 @@global.max_join_size
7 18446744073709551615
8 select @@session.max_join_size;
9 @@session.max_join_size
10 18446744073709551615
11 show global variables like 'max_join_size';
12 Variable_name Value
13 max_join_size 18446744073709551615
14 show session variables like 'max_join_size';
15 Variable_name Value
16 max_join_size 18446744073709551615
17 select * from information_schema.global_variables where variable_name='max_join_size';
18 VARIABLE_NAME VARIABLE_VALUE
19 MAX_JOIN_SIZE 18446744073709551615
20 select * from information_schema.session_variables where variable_name='max_join_size';
21 VARIABLE_NAME VARIABLE_VALUE
22 MAX_JOIN_SIZE 18446744073709551615
23 set global max_join_size=10;
24 set session max_join_size=100;
25 select @@global.max_join_size;
26 @@global.max_join_size
27 10
28 select @@session.max_join_size;
29 @@session.max_join_size
30 100
31 show global variables like 'max_join_size';
32 Variable_name Value
33 max_join_size 10
34 show session variables like 'max_join_size';
35 Variable_name Value
36 max_join_size 100
37 select * from information_schema.global_variables where variable_name='max_join_size';
38 VARIABLE_NAME VARIABLE_VALUE
39 MAX_JOIN_SIZE 10
40 select * from information_schema.session_variables where variable_name='max_join_size';
41 VARIABLE_NAME VARIABLE_VALUE
42 MAX_JOIN_SIZE 100
43 set global max_join_size=1.1;
44 ERROR 42000: Incorrect argument type to variable 'max_join_size'
45 set global max_join_size=1e1;
46 ERROR 42000: Incorrect argument type to variable 'max_join_size'
47 set global max_join_size="foo";
48 ERROR 42000: Incorrect argument type to variable 'max_join_size'
49 select @@sql_big_selects;
50 @@sql_big_selects
51 0
52 set max_join_size=cast(-1 as unsigned int);
53 Warnings:
54 Note 1105 Cast to unsigned converted negative integer to it's positive complement
55 select @@sql_big_selects;
56 @@sql_big_selects
57 1
58 set max_join_size=100;
59 select @@sql_big_selects;
60 @@sql_big_selects
61 0
62 SET @@global.max_join_size = @start_global_value;
63 SELECT @@global.max_join_size;
64 @@global.max_join_size
65 18446744073709551615