Debian Codegraph @

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

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