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 performance_schema.global_variables where variable_name='max_join_size';
18 VARIABLE_NAME VARIABLE_VALUE
19 max_join_size 18446744073709551615
20 select * from performance_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=20;
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 20
31 SET SQL_BIG_SELECTS=1;
32 show global variables like 'max_join_size';
33 Variable_name Value
34 max_join_size 10
35 show session variables like 'max_join_size';
36 Variable_name Value
37 max_join_size 20
38 SET SQL_BIG_SELECTS=1;
39 select * from performance_schema.global_variables where variable_name='max_join_size';
40 VARIABLE_NAME VARIABLE_VALUE
41 max_join_size 10
42 select * from performance_schema.session_variables where variable_name='max_join_size';
43 VARIABLE_NAME VARIABLE_VALUE
44 max_join_size 20
45 SET @@global.max_join_size = 1000;
46 SET @@global.max_join_size = DEFAULT;
47 SELECT @@global.max_join_size;
48 @@global.max_join_size
49 18446744073709551615
50 SET @@session.max_join_size = 1000;
51 SET @@session.max_join_size = DEFAULT;
52 SELECT @@session.max_join_size;
53 @@session.max_join_size
54 18446744073709551615
55 SET @@global.max_join_size = DEFAULT;
56 SELECT @@global.max_join_size = 4294967295;
57 @@global.max_join_size = 4294967295
58 0
59 SET @@session.max_join_size = DEFAULT;
60 SELECT @@session.max_join_size = 4294967295;
61 @@session.max_join_size = 4294967295
62 0
63 SET @@global.max_join_size = 1;
64 SELECT @@global.max_join_size;
65 @@global.max_join_size
66 1
67 SET @@global.max_join_size = 4294967295;
68 SELECT @@global.max_join_size;
69 @@global.max_join_size
70 4294967295
71 SET @@session.max_join_size = 1;
72 SELECT @@session.max_join_size;
73 @@session.max_join_size
74 1
75 SET @@session.max_join_size = 4294967295;
76 SELECT @@session.max_join_size;
77 @@session.max_join_size
78 4294967295
79 SET @@global.max_join_size = 0;
80 Warnings:
81 Warning 1292 Truncated incorrect max_join_size value: '0'
82 SELECT @@global.max_join_size;
83 @@global.max_join_size
84 1
85 SET @@global.max_join_size = -1024;
86 Warnings:
87 Warning 1292 Truncated incorrect max_join_size value: '-1024'
88 SELECT @@global.max_join_size;
89 @@global.max_join_size
90 1
91 SET @@global.max_join_size = 114294967295;
92 SELECT @@global.max_join_size;
93 @@global.max_join_size
94 114294967295
95 SET @@global.max_join_size = ' ';
96 ERROR 42000: Incorrect argument type to variable 'max_join_size'
97 SELECT @@global.max_join_size;
98 @@global.max_join_size
99 114294967295
100 SET @@session.max_join_size = 0;
101 Warnings:
102 Warning 1292 Truncated incorrect max_join_size value: '0'
103 SELECT @@session.max_join_size;
104 @@session.max_join_size
105 1
106 SET @@session.max_join_size = -1024;
107 Warnings:
108 Warning 1292 Truncated incorrect max_join_size value: '-1024'
109 SELECT @@session.max_join_size;
110 @@session.max_join_size
111 1
112 SET @@session.max_join_size = 114294967295;
113 SELECT @@session.max_join_size;
114 @@session.max_join_size
115 114294967295
116 SET @@session.max_join_size = ' ';
117 ERROR 42000: Incorrect argument type to variable 'max_join_size'
118 SELECT @@session.max_join_size;
119 @@session.max_join_size
120 114294967295
121 set global max_join_size=1.1;
122 ERROR 42000: Incorrect argument type to variable 'max_join_size'
123 set global max_join_size=1e1;
124 ERROR 42000: Incorrect argument type to variable 'max_join_size'
125 set global max_join_size="foo";
126 ERROR 42000: Incorrect argument type to variable 'max_join_size'
127 select @@sql_big_selects;
128 @@sql_big_selects
129 0
130 set max_join_size=cast(-1 as unsigned int);
131 select @@sql_big_selects;
132 @@sql_big_selects
133 1
134 set max_join_size=100;
135 select @@sql_big_selects;
136 @@sql_big_selects
137 0
138 SET @@global.max_join_size = @start_global_value;
139 SELECT @@global.max_join_size;
140 @@global.max_join_size
141 18446744073709551615