Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.join_buffer_size;
2 SET @start_session_value = @@session.join_buffer_size;
3 '#--------------------FN_DYNVARS_053_01-------------------------#'
4 SET @@global.join_buffer_size = DEFAULT;
5 SELECT @@global.join_buffer_size > 0;
6 @@global.join_buffer_size > 0
7 1
8 SET @@session.join_buffer_size = DEFAULT;
9 SELECT @@session.join_buffer_size > 0;
10 @@session.join_buffer_size > 0
11 1
12 '#--------------------FN_DYNVARS_053_03-------------------------#'
13 SET @@global.join_buffer_size = 8200;
14 Warnings:
15 Warning 1292 Truncated incorrect join_buffer_size value: '8200'
16 SELECT @@global.join_buffer_size;
17 @@global.join_buffer_size
18 8192
19 SET @@global.join_buffer_size = 65536;
20 SELECT @@global.join_buffer_size;
21 @@global.join_buffer_size
22 65536
23 SET @@global.join_buffer_size = 4294967295;
24 Warnings:
25 Warning 1292 Truncated incorrect join_buffer_size value: '4294967295'
26 SELECT @@global.join_buffer_size;
27 @@global.join_buffer_size
28 4294967168
29 '#--------------------FN_DYNVARS_053_04-------------------------#'
30 SET @@session.join_buffer_size = 8200;
31 Warnings:
32 Warning 1292 Truncated incorrect join_buffer_size value: '8200'
33 SELECT @@session.join_buffer_size;
34 @@session.join_buffer_size
35 8192
36 SET @@session.join_buffer_size = 65536;
37 SELECT @@session.join_buffer_size;
38 @@session.join_buffer_size
39 65536
40 SET @@session.join_buffer_size = 4294967295;
41 Warnings:
42 Warning 1292 Truncated incorrect join_buffer_size value: '4294967295'
43 SELECT @@session.join_buffer_size;
44 @@session.join_buffer_size
45 4294967168
46 '#------------------FN_DYNVARS_053_05-----------------------#'
47 SET @@global.join_buffer_size = 0;
48 Warnings:
49 Warning 1292 Truncated incorrect join_buffer_size value: '0'
50 SELECT @@global.join_buffer_size;
51 @@global.join_buffer_size
52 128
53 SET @@global.join_buffer_size = -1024;
54 Warnings:
55 Warning 1292 Truncated incorrect join_buffer_size value: '-1024'
56 SELECT @@global.join_buffer_size;
57 @@global.join_buffer_size
58 128
59 SET @@global.join_buffer_size = 127;
60 Warnings:
61 Warning 1292 Truncated incorrect join_buffer_size value: '127'
62 SELECT @@global.join_buffer_size;
63 @@global.join_buffer_size
64 128
65 SET @@global.join_buffer_size = 42949672951;
66 Warnings:
67 Warning 1292 Truncated incorrect join_buffer_size value: '42949672951'
68 SELECT @@global.join_buffer_size;
69 @@global.join_buffer_size
70 max_join_buffer_size
71 SET @@global.join_buffer_size = 1024*1024;
72 SET @@global.join_buffer_size = 65530.34;
73 ERROR 42000: Incorrect argument type to variable 'join_buffer_size'
74 SELECT @@global.join_buffer_size;
75 @@global.join_buffer_size
76 1048576
77 SET @@global.join_buffer_size = test;
78 ERROR 42000: Incorrect argument type to variable 'join_buffer_size'
79 SELECT @@global.join_buffer_size;
80 @@global.join_buffer_size
81 1048576
82 SET @@session.join_buffer_size = 0;
83 Warnings:
84 Warning 1292 Truncated incorrect join_buffer_size value: '0'
85 SELECT @@session.join_buffer_size;
86 @@session.join_buffer_size
87 128
88 SET @@session.join_buffer_size = -1024;
89 Warnings:
90 Warning 1292 Truncated incorrect join_buffer_size value: '-1024'
91 SELECT @@session.join_buffer_size;
92 @@session.join_buffer_size
93 128
94 SET @@session.join_buffer_size = 127;
95 Warnings:
96 Warning 1292 Truncated incorrect join_buffer_size value: '127'
97 SELECT @@session.join_buffer_size;
98 @@session.join_buffer_size
99 128
100 SET @@session.join_buffer_size = 42949672951;
101 Warnings:
102 Warning 1292 Truncated incorrect join_buffer_size value: '42949672951'
103 SELECT @@session.join_buffer_size;
104 @@session.join_buffer_size
105 max_join_buffer_size
106 SET @@session.join_buffer_size = 1024*1024;
107 SET @@session.join_buffer_size = 65530.34;
108 ERROR 42000: Incorrect argument type to variable 'join_buffer_size'
109 SELECT @@session.join_buffer_size;
110 @@session.join_buffer_size
111 1048576
112 SET @@session.join_buffer_size = test;
113 ERROR 42000: Incorrect argument type to variable 'join_buffer_size'
114 SELECT @@session.join_buffer_size;
115 @@session.join_buffer_size
116 1048576
117 '#------------------FN_DYNVARS_053_06-----------------------#'
118 SELECT @@global.join_buffer_size = VARIABLE_VALUE
119 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
120 WHERE VARIABLE_NAME='join_buffer_size';
121 @@global.join_buffer_size = VARIABLE_VALUE
122 1
123 '#------------------FN_DYNVARS_053_07-----------------------#'
124 SELECT @@session.join_buffer_size = VARIABLE_VALUE
125 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
126 WHERE VARIABLE_NAME='join_buffer_size';
127 @@session.join_buffer_size = VARIABLE_VALUE
128 1
129 '#------------------FN_DYNVARS_053_08-----------------------#'
130 SET @@global.join_buffer_size = TRUE;
131 Warnings:
132 Warning 1292 Truncated incorrect join_buffer_size value: '1'
133 SET @@global.join_buffer_size = FALSE;
134 Warnings:
135 Warning 1292 Truncated incorrect join_buffer_size value: '0'
136 '#---------------------FN_DYNVARS_001_09----------------------#'
137 SET @@global.join_buffer_size = 10;
138 Warnings:
139 Warning 1292 Truncated incorrect join_buffer_size value: '10'
140 SELECT @@join_buffer_size = @@global.join_buffer_size;
141 @@join_buffer_size = @@global.join_buffer_size
142 0
143 '#---------------------FN_DYNVARS_001_10----------------------#'
144 SET @@join_buffer_size = 100;
145 Warnings:
146 Warning 1292 Truncated incorrect join_buffer_size value: '100'
147 SELECT @@join_buffer_size = @@local.join_buffer_size;
148 @@join_buffer_size = @@local.join_buffer_size
149 1
150 SELECT @@local.join_buffer_size = @@session.join_buffer_size;
151 @@local.join_buffer_size = @@session.join_buffer_size
152 1
153 '#---------------------FN_DYNVARS_001_11----------------------#'
154 SET join_buffer_size = 1;
155 Warnings:
156 Warning 1292 Truncated incorrect join_buffer_size value: '1'
157 SELECT @@join_buffer_size;
158 @@join_buffer_size
159 128
160 SELECT local.join_buffer_size;
161 ERROR 42S02: Unknown table 'local' in SELECT
162 SELECT session.join_buffer_size;
163 ERROR 42S02: Unknown table 'session' in SELECT
164 SELECT join_buffer_size = @@session.join_buffer_size;
165 ERROR 42S22: Unknown column 'join_buffer_size' in 'SELECT'
166 SET @@global.join_buffer_size = @start_global_value;
167 SET @@session.join_buffer_size = @start_session_value;