Debian Codegraph @

mysql-test/suite/parts/r/partition_exch_innodb.result

raw
1 use test;
2 SELECT * FROM t_10;
3 a b
4 1 One
5 3 Three
6 5 Five
7 9 Nine
8 SELECT * FROM t_100;
9 a b
10 11 Eleven
11 13 Thirdteen
12 15 Fifeteen
13 19 Nineteen
14 91 Ninety-one
15 93 Ninety-three
16 95 Ninety-five
17 99 Ninety-nine
18 SELECT * FROM t_1000;
19 a b
20 111 Hundred elven
21 113 Hundred thirdteen
22 115 Hundred fiveteen
23 119 Hundred nineteen
24 131 Hundred thirty-one
25 133 Hundred thirty-three
26 135 Hundred thirty-five
27 139 Hundred thirty-nine
28 151 Hundred fifty-one
29 153 Hundred fifty-three
30 155 Hundred fity-five
31 159 Hundred fifty-nine
32 191 Hundred ninety-one
33 193 Hundred ninety-three
34 195 Hundred ninety-five
35 199 Hundred ninety-nine
36 SELECT * FROM tp;
37 a b
38 112 Hundred twelve
39 114 Hundred fourteen
40 116 Hundred sixteen
41 118 Hundred eightteen
42 12 twelve
43 122 Hundred twenty-two
44 124 Hundred twenty-four
45 126 Hundred twenty-six
46 128 Hundred twenty-eight
47 14 Fourteen
48 16 Sixteen
49 162 Hundred sixty-two
50 164 Hundred sixty-four
51 166 Hundred sixty-six
52 168 Hundred sixty-eight
53 18 Eightteen
54 182 Hundred eighty-two
55 184 Hundred eighty-four
56 186 Hundred eighty-six
57 188 Hundred eighty-eight
58 2 Two
59 4 Four
60 6 Six
61 8 Eight
62 SELECT * FROM tsp;
63 a b
64 112 Hundred twelve
65 114 Hundred fourteen
66 116 Hundred sixteen
67 118 Hundred eightteen
68 12 twelve
69 122 Hundred twenty-two
70 124 Hundred twenty-four
71 126 Hundred twenty-six
72 128 Hundred twenty-eight
73 14 Fourteen
74 16 Sixteen
75 162 Hundred sixty-two
76 164 Hundred sixty-four
77 166 Hundred sixty-six
78 168 Hundred sixty-eight
79 18 Eightteen
80 182 Hundred eight-two
81 184 Hundred eighty-four
82 186 Hundred eighty-six
83 188 Hundred eighty-eight
84 2 Two
85 4 Four
86 6 Six
87 8 Eight
88 SELECT * FROM tsp_00;
89 a b
90 5 Five
91 SELECT * FROM tsp_01;
92 a b
93 1 One
94 SELECT * FROM tsp_02;
95 a b
96 SELECT * FROM tsp_03;
97 a b
98 3 Three
99 SELECT * FROM tsp_04;
100 a b
101 9 Nine
102 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
103 SELECT * FROM t_10;
104 a b
105 2 Two
106 4 Four
107 6 Six
108 8 Eight
109 SELECT * FROM tp WHERE a BETWEEN 0 AND 10;
110 a b
111 1 One
112 3 Three
113 5 Five
114 9 Nine
115 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
116 SELECT * FROM t_10;
117 a b
118 1 One
119 3 Three
120 5 Five
121 9 Nine
122 SELECT * FROM tp WHERE a BETWEEN 0 AND 10;
123 a b
124 2 Two
125 4 Four
126 6 Six
127 8 Eight
128 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_empty;
129 SELECT * FROM t_empty;
130 a b
131 2 Two
132 4 Four
133 6 Six
134 8 Eight
135 SELECT * FROM tp WHERE a BETWEEN 0 AND 10;
136 a b
137 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_empty;
138 SELECT * FROM t_empty;
139 a b
140 SELECT * FROM tp WHERE a BETWEEN 0 AND 10;
141 a b
142 2 Two
143 4 Four
144 6 Six
145 8 Eight
146 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_null;
147 SELECT * FROM t_null;
148 a b
149 2 Two
150 4 Four
151 6 Six
152 8 Eight
153 SELECT * FROM tp WHERE a BETWEEN 0 AND 10;
154 a b
155 1 NULL
156 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_null;
157 SELECT * FROM t_null;
158 a b
159 1 NULL
160 SELECT * FROM tp WHERE a BETWEEN 0 AND 10;
161 a b
162 2 Two
163 4 Four
164 6 Six
165 8 Eight
166 ALTER TABLE tp EXCHANGE PARTITION p1 WITH TABLE t_100;
167 SELECT * FROM t_100;
168 a b
169 12 twelve
170 14 Fourteen
171 16 Sixteen
172 18 Eightteen
173 SELECT * FROM tp WHERE a BETWEEN 10 AND 100;
174 a b
175 11 Eleven
176 13 Thirdteen
177 15 Fifeteen
178 19 Nineteen
179 91 Ninety-one
180 93 Ninety-three
181 95 Ninety-five
182 99 Ninety-nine
183 ALTER TABLE tp EXCHANGE PARTITION p1 WITH TABLE t_100;
184 SELECT * FROM t_100;
185 a b
186 11 Eleven
187 13 Thirdteen
188 15 Fifeteen
189 19 Nineteen
190 91 Ninety-one
191 93 Ninety-three
192 95 Ninety-five
193 99 Ninety-nine
194 SELECT * FROM tp WHERE a BETWEEN 10 AND 100;
195 a b
196 12 twelve
197 14 Fourteen
198 16 Sixteen
199 18 Eightteen
200 ALTER TABLE tp EXCHANGE PARTITION p2 WITH TABLE t_1000;
201 SELECT * FROM t_1000;
202 a b
203 112 Hundred twelve
204 114 Hundred fourteen
205 116 Hundred sixteen
206 118 Hundred eightteen
207 122 Hundred twenty-two
208 124 Hundred twenty-four
209 126 Hundred twenty-six
210 128 Hundred twenty-eight
211 162 Hundred sixty-two
212 164 Hundred sixty-four
213 166 Hundred sixty-six
214 168 Hundred sixty-eight
215 182 Hundred eighty-two
216 184 Hundred eighty-four
217 186 Hundred eighty-six
218 188 Hundred eighty-eight
219 SELECT * FROM tp WHERE a BETWEEN 100 AND 1000;
220 a b
221 111 Hundred elven
222 113 Hundred thirdteen
223 115 Hundred fiveteen
224 119 Hundred nineteen
225 131 Hundred thirty-one
226 133 Hundred thirty-three
227 135 Hundred thirty-five
228 139 Hundred thirty-nine
229 151 Hundred fifty-one
230 153 Hundred fifty-three
231 155 Hundred fity-five
232 159 Hundred fifty-nine
233 191 Hundred ninety-one
234 193 Hundred ninety-three
235 195 Hundred ninety-five
236 199 Hundred ninety-nine
237 ALTER TABLE tp EXCHANGE PARTITION p2 WITH TABLE t_1000;
238 SELECT * FROM t_1000;
239 a b
240 111 Hundred elven
241 113 Hundred thirdteen
242 115 Hundred fiveteen
243 119 Hundred nineteen
244 131 Hundred thirty-one
245 133 Hundred thirty-three
246 135 Hundred thirty-five
247 139 Hundred thirty-nine
248 151 Hundred fifty-one
249 153 Hundred fifty-three
250 155 Hundred fity-five
251 159 Hundred fifty-nine
252 191 Hundred ninety-one
253 193 Hundred ninety-three
254 195 Hundred ninety-five
255 199 Hundred ninety-nine
256 SELECT * FROM tp WHERE a BETWEEN 100 AND 1000;
257 a b
258 112 Hundred twelve
259 114 Hundred fourteen
260 116 Hundred sixteen
261 118 Hundred eightteen
262 122 Hundred twenty-two
263 124 Hundred twenty-four
264 126 Hundred twenty-six
265 128 Hundred twenty-eight
266 162 Hundred sixty-two
267 164 Hundred sixty-four
268 166 Hundred sixty-six
269 168 Hundred sixty-eight
270 182 Hundred eighty-two
271 184 Hundred eighty-four
272 186 Hundred eighty-six
273 188 Hundred eighty-eight
274 ALTER TABLE tsp EXCHANGE PARTITION sp00 WITH TABLE tsp_00;
275 ALTER TABLE tsp EXCHANGE PARTITION sp01 WITH TABLE tsp_01;
276 ALTER TABLE tsp EXCHANGE PARTITION sp02 WITH TABLE tsp_02;
277 ALTER TABLE tsp EXCHANGE PARTITION sp03 WITH TABLE tsp_03;
278 ALTER TABLE tsp EXCHANGE PARTITION sp04 WITH TABLE tsp_04;
279 SELECT * FROM tsp_00;
280 a b
281 SELECT * FROM tsp_01;
282 a b
283 6 Six
284 SELECT * FROM tsp_02;
285 a b
286 2 Two
287 SELECT * FROM tsp_03;
288 a b
289 8 Eight
290 SELECT * FROM tsp_04;
291 a b
292 4 Four
293 SELECT * FROM tsp WHERE a BETWEEN 0 AND 10;
294 a b
295 1 One
296 3 Three
297 5 Five
298 9 Nine
299 ALTER TABLE tsp EXCHANGE PARTITION sp00 WITH TABLE tsp_00;
300 ALTER TABLE tsp EXCHANGE PARTITION sp01 WITH TABLE tsp_01;
301 ALTER TABLE tsp EXCHANGE PARTITION sp02 WITH TABLE tsp_02;
302 ALTER TABLE tsp EXCHANGE PARTITION sp03 WITH TABLE tsp_03;
303 ALTER TABLE tsp EXCHANGE PARTITION sp04 WITH TABLE tsp_04;
304 SELECT * FROM tsp_00;
305 a b
306 5 Five
307 SELECT * FROM tsp_01;
308 a b
309 1 One
310 SELECT * FROM tsp_02;
311 a b
312 SELECT * FROM tsp_03;
313 a b
314 3 Three
315 SELECT * FROM tsp_04;
316 a b
317 9 Nine
318 SELECT * FROM tsp WHERE a BETWEEN 0 AND 10;
319 a b
320 2 Two
321 4 Four
322 6 Six
323 8 Eight
324 ALTER TABLE tsp EXCHANGE PARTITION sp01 WITH TABLE t_null;
325 SELECT * FROM t_null;
326 a b
327 6 Six
328 SELECT * FROM tsp WHERE a BETWEEN 0 AND 10;
329 a b
330 1 NULL
331 2 Two
332 4 Four
333 8 Eight
334 ALTER TABLE tsp EXCHANGE PARTITION sp01 WITH TABLE t_null;
335 SELECT * FROM t_null;
336 a b
337 1 NULL
338 SELECT * FROM tsp WHERE a BETWEEN 0 AND 10;
339 a b
340 2 Two
341 4 Four
342 6 Six
343 8 Eight
344 DROP TABLE IF EXISTS t_10;
345 DROP TABLE IF EXISTS t_100;
346 DROP TABLE IF EXISTS t_1000;
347 DROP TABLE IF EXISTS tp;
348 DROP TABLE IF EXISTS tsp;
349 DROP TABLE IF EXISTS tsp_00;
350 DROP TABLE IF EXISTS tsp_01;
351 DROP TABLE IF EXISTS tsp_02;
352 DROP TABLE IF EXISTS tsp_03;
353 DROP TABLE IF EXISTS tsp_04;
354 DROP TABLE IF EXISTS t_empty;
355 DROP TABLE IF EXISTS t_null;