Debian Codegraph @

mysql-test/suite/parts/inc/part_exch_ext_sel.inc

raw
1 SHOW CREATE TABLE t_10;
2 SHOW CREATE TABLE t_100;
3 SHOW CREATE TABLE t_1000;
4 SHOW CREATE TABLE tp_r;
5 SHOW CREATE TABLE tsp_r;
6
7 --sorted_result
8 SELECT * FROM t_10;
9 --sorted_result
10 SELECT * FROM t_100;
11 --sorted_result
12 SELECT * FROM t_1000;
13
14 --sorted_result
15 SELECT * FROM tp_r;
16 --sorted_result
17 SELECT * FROM tp_r WHERE a< 10;
18 --sorted_result
19 SELECT * FROM tp_r WHERE a BETWEEN 11 AND 100;
20 --sorted_result
21 SELECT * FROM tp_r WHERE a BETWEEN 101 AND 200;
22 --sorted_result
23 SELECT * FROM tsp_r;
24
25 --sorted_result
26 SELECT * FROM tp_r PARTITION (p0);
27 --sorted_result
28 SELECT * FROM tp_r PARTITION (p1);
29 --sorted_result
30 SELECT * FROM tp_r PARTITION (p2);
31
32 --sorted_result
33 SELECT * FROM tsp_r PARTITION (p0);
34 --sorted_result
35 SELECT * FROM tsp_r PARTITION (p1);
36 --sorted_result
37 SELECT * FROM tsp_r PARTITION (p2);
38
39 --sorted_result
40 SELECT * FROM tsp_r PARTITION (sp00);
41 --sorted_result
42 SELECT * FROM tsp_r PARTITION (sp01);
43 --sorted_result
44 SELECT * FROM tsp_r PARTITION (sp02);
45 --sorted_result
46 SELECT * FROM tsp_r PARTITION (sp03);
47 --sorted_result
48 SELECT * FROM tsp_r PARTITION (sp04);
49 --sorted_result
50 SELECT * FROM tsp_r PARTITION (sp10);
51 --sorted_result
52 SELECT * FROM tsp_r PARTITION (sp11);
53 --sorted_result
54 SELECT * FROM tsp_r PARTITION (sp12);
55 --sorted_result
56 SELECT * FROM tsp_r PARTITION (sp13);
57 --sorted_result
58 SELECT * FROM tsp_r PARTITION (sp14);
59 --sorted_result
60 SELECT * FROM tsp_r PARTITION (sp20);
61 --sorted_result
62 SELECT * FROM tsp_r PARTITION (sp21);
63 --sorted_result
64 SELECT * FROM tsp_r PARTITION (sp22);
65 --sorted_result
66 SELECT * FROM tsp_r PARTITION (sp23);
67 --sorted_result
68 SELECT * FROM tsp_r PARTITION (sp24);
69
70 --sorted_result
71 SELECT * FROM tp_rintvar PARTITION (p0);
72 --sorted_result
73 SELECT * FROM tp_rintvar PARTITION (p1);
74 --sorted_result
75 SELECT * FROM tp_rintvar PARTITION (p2);
76
77 --sorted_result
78 SELECT * FROM tp_rvar PARTITION (p0);
79 --sorted_result
80 SELECT * FROM tp_rvar PARTITION (p1);
81 --sorted_result
82 SELECT * FROM tp_rvar PARTITION (p2);
83
84 --sorted_result
85 SELECT * FROM tp_rintdate PARTITION (p0);
86 --sorted_result
87 SELECT * FROM tp_rintdate PARTITION (p1);
88 --sorted_result
89 SELECT * FROM tp_rintdate PARTITION (p2);
90
91 --sorted_result
92 SELECT * FROM tp_rdate PARTITION (p0);
93 --sorted_result
94 SELECT * FROM tp_rdate PARTITION (p1);
95 --sorted_result
96 SELECT * FROM tp_rdate PARTITION (p2);
97
98 --sorted_result
99 SELECT * FROM tsp_rvar PARTITION (p0);
100 --sorted_result
101 SELECT * FROM tsp_rvar PARTITION (p1);
102 --sorted_result
103 SELECT * FROM tsp_rvar PARTITION (p2);
104
105 --sorted_result
106 SELECT * FROM tsp_rvar PARTITION (sp00);
107 --sorted_result
108 SELECT * FROM tsp_rvar PARTITION (sp01);
109 --sorted_result
110 SELECT * FROM tsp_rvar PARTITION (sp02);
111 --sorted_result
112 SELECT * FROM tsp_rvar PARTITION (sp03);
113 --sorted_result
114 SELECT * FROM tsp_rvar PARTITION (sp04);
115 --sorted_result
116 SELECT * FROM tsp_rvar PARTITION (sp10);
117 --sorted_result
118 SELECT * FROM tsp_rvar PARTITION (sp11);
119 --sorted_result
120 SELECT * FROM tsp_rvar PARTITION (sp12);
121 --sorted_result
122 SELECT * FROM tsp_rvar PARTITION (sp13);
123 --sorted_result
124 SELECT * FROM tsp_rvar PARTITION (sp20);
125 --sorted_result
126 SELECT * FROM tsp_rvar PARTITION (sp21);
127 --sorted_result
128 SELECT * FROM tsp_rvar PARTITION (sp22);
129 --sorted_result
130 SELECT * FROM tsp_rvar PARTITION (sp23);
131
132 SELECT count(a) FROM tsp_rvar;
133
134 --sorted_result
135 SELECT partition_name, subpartition_name FROM information_schema.partitions
136 WHERE table_name LIKE 'tsp_rvar1';
137 --sorted_result
138 SELECT * FROM tsp_rvar1 PARTITION (p0);
139 --sorted_result
140 SELECT * FROM tsp_rvar1 PARTITION (p1);
141 --sorted_result
142 SELECT * FROM tsp_rvar1 PARTITION (p2);
143 --sorted_result
144 SELECT * FROM tsp_rvar1 PARTITION (p0sp0);
145 --sorted_result
146 SELECT * FROM tsp_rvar1 PARTITION (p0sp1);
147 --sorted_result
148 SELECT * FROM tsp_rvar1 PARTITION (p0sp2);
149 --sorted_result
150 SELECT * FROM tsp_rvar1 PARTITION (p0sp3);
151 --sorted_result
152 SELECT * FROM tsp_rvar1 PARTITION (p0sp4);
153 --sorted_result
154 SELECT * FROM tsp_rvar1 PARTITION (p1sp0);
155 --sorted_result
156 SELECT * FROM tsp_rvar1 PARTITION (p1sp1);
157 --sorted_result
158 SELECT * FROM tsp_rvar1 PARTITION (p1sp2);
159 --sorted_result
160 SELECT * FROM tsp_rvar1 PARTITION (p1sp3);
161 --sorted_result
162 SELECT * FROM tsp_rvar1 PARTITION (p1sp4);
163 --sorted_result
164 SELECT * FROM tsp_rvar1 PARTITION (p2sp0);
165 --sorted_result
166 SELECT * FROM tsp_rvar1 PARTITION (p2sp1);
167 --sorted_result
168 SELECT * FROM tsp_rvar1 PARTITION (p2sp2);
169 --sorted_result
170 SELECT * FROM tsp_rvar1 PARTITION (p2sp3);
171 --sorted_result
172 SELECT * FROM tsp_rvar1 PARTITION (p2sp4);
173
174 SELECT count(a) FROM tsp_rvar1;
175
176 --sorted_result
177 SELECT partition_name, subpartition_name FROM information_schema.partitions
178 WHERE table_name LIKE 'tp_l';
179
180 SELECT * FROM tp_l PARTITION (p0);
181 --sorted_result
182 SELECT * FROM tp_l PARTITION (p1);
183 --sorted_result
184 SELECT * FROM tp_l PARTITION (p2);
185
186 SELECT count(a) FROM tp_l;
187
188 --sorted_result
189 SELECT partition_name, subpartition_name FROM information_schema.partitions
190 WHERE table_name LIKE 'tsp_l';
191
192 --sorted_result
193 SELECT * FROM tsp_l PARTITION (p0);
194 --sorted_result
195 SELECT * FROM tsp_l PARTITION (p1);
196 --sorted_result
197 SELECT * FROM tsp_l PARTITION (p2);
198
199 --sorted_result
200 SELECT * FROM tsp_l PARTITION (sp00);
201 --sorted_result
202 SELECT * FROM tsp_l PARTITION (sp01);
203 --sorted_result
204 SELECT * FROM tsp_l PARTITION (sp02);
205 --sorted_result
206 SELECT * FROM tsp_l PARTITION (sp03);
207 --sorted_result
208 SELECT * FROM tsp_l PARTITION (sp04);
209 --sorted_result
210 SELECT * FROM tsp_l PARTITION (sp10);
211 --sorted_result
212 SELECT * FROM tsp_l PARTITION (sp11);
213 --sorted_result
214 SELECT * FROM tsp_l PARTITION (sp12);
215 --sorted_result
216 SELECT * FROM tsp_l PARTITION (sp13);
217 --sorted_result
218 SELECT * FROM tsp_l PARTITION (sp20);
219 --sorted_result
220 SELECT * FROM tsp_l PARTITION (sp21);
221 --sorted_result
222 SELECT * FROM tsp_l PARTITION (sp22);
223 --sorted_result
224 SELECT * FROM tsp_l PARTITION (sp23);
225 --sorted_result
226 SELECT * FROM tsp_l PARTITION (sp24);
227
228 SELECT count(a) FROM tsp_l;
229
230 --sorted_result
231 SELECT * FROM tp_k PARTITION (p0);
232 --sorted_result
233 SELECT * FROM tp_k PARTITION (p1);
234 --sorted_result
235 SELECT * FROM tp_k PARTITION (p2);
236
237 SELECT count(a) FROM tp_k;
238
239 --sorted_result
240 SELECT * FROM tp_kvar PARTITION (p0);
241 --sorted_result
242 SELECT * FROM tp_kvar PARTITION (p1);
243 --sorted_result
244 SELECT * FROM tp_kvar PARTITION (p2);
245
246 SELECT count(a) FROM tp_kvar;
247
248 --sorted_result
249 SELECT * FROM tp_kdate PARTITION (p0);
250 --sorted_result
251 SELECT * FROM tp_kdate PARTITION (p1);
252 --sorted_result
253 SELECT * FROM tp_kdate PARTITION (p2);
254
255 SELECT count(a) FROM tp_kdate;
256
257 --sorted_result
258 SELECT * FROM tp_h PARTITION (p0);
259 --sorted_result
260 SELECT * FROM tp_h PARTITION (p1);
261 --sorted_result
262 SELECT * FROM tp_h PARTITION (p2);
263
264 SELECT count(a) FROM tp_h;
265
266 --sorted_result
267 SELECT * FROM tp_hvar PARTITION (p0);
268 --sorted_result
269 SELECT * FROM tp_hvar PARTITION (p1);
270 --sorted_result
271 SELECT * FROM tp_hvar PARTITION (p2);
272
273 SELECT count(a) FROM tp_hvar;
274
275 --sorted_result
276 SELECT * FROM tp_hdate PARTITION (p0);
277 --sorted_result
278 SELECT * FROM tp_hdate PARTITION (p1);
279 --sorted_result
280 SELECT * FROM tp_hdate PARTITION (p2);
281
282 SELECT count(a) FROM tp_hdate;
283