Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.query_alloc_block_size;
2 SELECT @start_global_value;
3 @start_global_value
4 32768
5 SET @start_session_value = @@session.query_alloc_block_size;
6 SELECT @start_session_value;
7 @start_session_value
8 32768
9 '#--------------------FN_DYNVARS_130_01-------------------------#'
10 SET @@global.query_alloc_block_size = 10000;
11 Warnings:
12 Warning 1292 Truncated incorrect query_alloc_block_size value: '10000'
13 SET @@global.query_alloc_block_size = DEFAULT;
14 SELECT @@global.query_alloc_block_size;
15 @@global.query_alloc_block_size
16 32768
17 SET @@session.query_alloc_block_size = 20000;
18 Warnings:
19 Warning 1292 Truncated incorrect query_alloc_block_size value: '20000'
20 SET @@session.query_alloc_block_size = DEFAULT;
21 SELECT @@session.query_alloc_block_size;
22 @@session.query_alloc_block_size
23 32768
24 '#--------------------FN_DYNVARS_130_02-------------------------#'
25 SET @@global.query_alloc_block_size = DEFAULT;
26 SELECT @@global.query_alloc_block_size = 32768;
27 @@global.query_alloc_block_size = 32768
28 1
29 SET @@session.query_alloc_block_size = DEFAULT;
30 SELECT @@session.query_alloc_block_size = 32768;
31 @@session.query_alloc_block_size = 32768
32 1
33 '#--------------------FN_DYNVARS_130_03-------------------------#'
34 SET @@global.query_alloc_block_size = 1024;
35 SELECT @@global.query_alloc_block_size;
36 @@global.query_alloc_block_size
37 1024
38 SET @@global.query_alloc_block_size = 1025;
39 Warnings:
40 Warning 1292 Truncated incorrect query_alloc_block_size value: '1025'
41 SELECT @@global.query_alloc_block_size;
42 @@global.query_alloc_block_size
43 1024
44 SET @@global.query_alloc_block_size = 65536;
45 SELECT @@global.query_alloc_block_size;
46 @@global.query_alloc_block_size
47 65536
48 '#--------------------FN_DYNVARS_130_04-------------------------#'
49 SET @@session.query_alloc_block_size = 1024;
50 SELECT @@session.query_alloc_block_size;
51 @@session.query_alloc_block_size
52 1024
53 SET @@session.query_alloc_block_size = 1025;
54 Warnings:
55 Warning 1292 Truncated incorrect query_alloc_block_size value: '1025'
56 SELECT @@session.query_alloc_block_size;
57 @@session.query_alloc_block_size
58 1024
59 SET @@session.query_alloc_block_size = 655536;
60 Warnings:
61 Warning 1292 Truncated incorrect query_alloc_block_size value: '655536'
62 SELECT @@session.query_alloc_block_size;
63 @@session.query_alloc_block_size
64 655360
65 '#------------------FN_DYNVARS_130_05-----------------------#'
66 SET @@global.query_alloc_block_size = 64;
67 Warnings:
68 Warning 1292 Truncated incorrect query_alloc_block_size value: '64'
69 SELECT @@global.query_alloc_block_size;
70 @@global.query_alloc_block_size
71 1024
72 SET @@global.query_alloc_block_size = -1;
73 Warnings:
74 Warning 1292 Truncated incorrect query_alloc_block_size value: '-1'
75 SELECT @@global.query_alloc_block_size;
76 @@global.query_alloc_block_size
77 1024
78 SET @@global.query_alloc_block_size = 1023;
79 Warnings:
80 Warning 1292 Truncated incorrect query_alloc_block_size value: '1023'
81 SELECT @@global.query_alloc_block_size;
82 @@global.query_alloc_block_size
83 1024
84 SET @@global.query_alloc_block_size = 65530.34;
85 ERROR 42000: Incorrect argument type to variable 'query_alloc_block_size'
86 SELECT @@global.query_alloc_block_size;
87 @@global.query_alloc_block_size
88 1024
89 SET @@global.query_alloc_block_size = test;
90 ERROR 42000: Incorrect argument type to variable 'query_alloc_block_size'
91 SELECT @@global.query_alloc_block_size;
92 @@global.query_alloc_block_size
93 1024
94 SET @@session.query_alloc_block_size = 64;
95 Warnings:
96 Warning 1292 Truncated incorrect query_alloc_block_size value: '64'
97 SELECT @@session.query_alloc_block_size;
98 @@session.query_alloc_block_size
99 1024
100 SET @@session.query_alloc_block_size = -2;
101 Warnings:
102 Warning 1292 Truncated incorrect query_alloc_block_size value: '-2'
103 SELECT @@session.query_alloc_block_size;
104 @@session.query_alloc_block_size
105 1024
106 SET @@session.query_alloc_block_size = 65530.34;
107 ERROR 42000: Incorrect argument type to variable 'query_alloc_block_size'
108 SET @@session.query_alloc_block_size = 1023;
109 Warnings:
110 Warning 1292 Truncated incorrect query_alloc_block_size value: '1023'
111 SELECT @@session.query_alloc_block_size;
112 @@session.query_alloc_block_size
113 1024
114 SET @@session.query_alloc_block_size = test;
115 ERROR 42000: Incorrect argument type to variable 'query_alloc_block_size'
116 SELECT @@session.query_alloc_block_size;
117 @@session.query_alloc_block_size
118 1024
119 '#------------------FN_DYNVARS_130_06-----------------------#'
120 SET @@global.query_alloc_block_size = 1;
121 Warnings:
122 Warning 1292 Truncated incorrect query_alloc_block_size value: '1'
123 SET @@session.query_alloc_block_size = 12;
124 Warnings:
125 Warning 1292 Truncated incorrect query_alloc_block_size value: '12'
126 SELECT @@global.query_alloc_block_size =
127 VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
128 WHERE VARIABLE_NAME='query_alloc_block_size';
129 @@global.query_alloc_block_size =
130 VARIABLE_VALUE
131 1
132 '#------------------FN_DYNVARS_130_07-----------------------#'
133 SELECT @@session.query_alloc_block_size = VARIABLE_VALUE
134 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
135 WHERE VARIABLE_NAME='query_alloc_block_size';
136 @@session.query_alloc_block_size = VARIABLE_VALUE
137 1
138 '#------------------FN_DYNVARS_130_08-----------------------#'
139 SET @@global.query_alloc_block_size = TRUE;
140 Warnings:
141 Warning 1292 Truncated incorrect query_alloc_block_size value: '1'
142 SELECT @@global.query_alloc_block_size;
143 @@global.query_alloc_block_size
144 1024
145 SET @@global.query_alloc_block_size = FALSE;
146 Warnings:
147 Warning 1292 Truncated incorrect query_alloc_block_size value: '0'
148 SELECT @@global.query_alloc_block_size;
149 @@global.query_alloc_block_size
150 1024
151 '#---------------------FN_DYNVARS_130_09----------------------#'
152 SET @@global.query_alloc_block_size = 2048;
153 SELECT @@query_alloc_block_size = @@global.query_alloc_block_size;
154 @@query_alloc_block_size = @@global.query_alloc_block_size
155 0
156 '#---------------------FN_DYNVARS_130_10----------------------#'
157 SET @@query_alloc_block_size = 5000;
158 Warnings:
159 Warning 1292 Truncated incorrect query_alloc_block_size value: '5000'
160 SELECT @@query_alloc_block_size = @@local.query_alloc_block_size;
161 @@query_alloc_block_size = @@local.query_alloc_block_size
162 1
163 SELECT @@local.query_alloc_block_size = @@session.query_alloc_block_size;
164 @@local.query_alloc_block_size = @@session.query_alloc_block_size
165 1
166 '#---------------------FN_DYNVARS_130_11----------------------#'
167 SET query_alloc_block_size = 1024;
168 SELECT @@query_alloc_block_size;
169 @@query_alloc_block_size
170 1024
171 SELECT local.query_alloc_block_size;
172 ERROR 42S02: Unknown table 'local' in SELECT
173 SELECT session.query_alloc_block_size;
174 ERROR 42S02: Unknown table 'session' in SELECT
175 SELECT query_alloc_block_size = @@session.query_alloc_block_size;
176 ERROR 42S22: Unknown column 'query_alloc_block_size' in 'SELECT'
177 SET @@global.query_alloc_block_size = @start_global_value;
178 SELECT @@global.query_alloc_block_size;
179 @@global.query_alloc_block_size
180 32768
181 SET @@session.query_alloc_block_size = @start_session_value;
182 SELECT @@session.query_alloc_block_size;
183 @@session.query_alloc_block_size
184 32768