Lines Matching refs:max_join_size

1 SET @start_global_value = @@global.max_join_size;
5 select @@global.max_join_size;
6 @@global.max_join_size
8 select @@session.max_join_size;
9 @@session.max_join_size
11 show global variables like 'max_join_size';
13 max_join_size	18446744073709551615
14 show session variables like 'max_join_size';
16 max_join_size	18446744073709551615
17 select * from information_schema.global_variables where variable_name='max_join_size';
20 select * from information_schema.session_variables where variable_name='max_join_size';
23 set global max_join_size=10;
24 set session max_join_size=20;
25 select @@global.max_join_size;
26 @@global.max_join_size
28 select @@session.max_join_size;
29 @@session.max_join_size
31 show global variables like 'max_join_size';
33 max_join_size	10
34 show session variables like 'max_join_size';
36 max_join_size	20
37 select * from information_schema.global_variables where variable_name='max_join_size';
40 select * from information_schema.session_variables where variable_name='max_join_size';
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'
52 set max_join_size=cast(-1 as unsigned int);
58 set max_join_size=100;
62 SET @@global.max_join_size = @start_global_value;
63 SELECT @@global.max_join_size;
64 @@global.max_join_size