Debian Codegraph @

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

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