Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t2;
2 CREATE TABLE t2 (c1 TINYINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(YEAR(c3));
3 SHOW TABLES;
4 Tables_in_test
5 t2
6 SHOW CREATE TABLE t2;
7 Table Create Table
8 t2 CREATE TABLE `t2` (
9 `c1` tinyint DEFAULT NULL,
10 `c2` char(5) DEFAULT NULL,
11 `c3` datetime DEFAULT NULL
12 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
13 /*!50100 PARTITION BY HASH (year(`c3`)) */
14 DROP TABLE t2;
15 SHOW TABLES;
16 Tables_in_test
17 CREATE TABLE t2 (c1 SMALLINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(YEAR(c3));
18 SHOW TABLES;
19 Tables_in_test
20 t2
21 SHOW CREATE TABLE t2;
22 Table Create Table
23 t2 CREATE TABLE `t2` (
24 `c1` smallint DEFAULT NULL,
25 `c2` char(5) DEFAULT NULL,
26 `c3` datetime DEFAULT NULL
27 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
28 /*!50100 PARTITION BY HASH (year(`c3`)) */
29 DROP TABLE t2;
30 SHOW TABLES;
31 Tables_in_test
32 CREATE TABLE t2 (c1 MEDIUMINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(YEAR(c3));
33 SHOW TABLES;
34 Tables_in_test
35 t2
36 SHOW CREATE TABLE t2;
37 Table Create Table
38 t2 CREATE TABLE `t2` (
39 `c1` mediumint DEFAULT NULL,
40 `c2` char(5) DEFAULT NULL,
41 `c3` datetime DEFAULT NULL
42 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
43 /*!50100 PARTITION BY HASH (year(`c3`)) */
44 DROP TABLE t2;
45 SHOW TABLES;
46 Tables_in_test
47 CREATE TABLE t2 (c1 INT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(YEAR(c3));
48 SHOW TABLES;
49 Tables_in_test
50 t2
51 SHOW CREATE TABLE t2;
52 Table Create Table
53 t2 CREATE TABLE `t2` (
54 `c1` int DEFAULT NULL,
55 `c2` char(5) DEFAULT NULL,
56 `c3` datetime DEFAULT NULL
57 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
58 /*!50100 PARTITION BY HASH (year(`c3`)) */
59 DROP TABLE t2;
60 SHOW TABLES;
61 Tables_in_test
62 CREATE TABLE t2 (c1 INTEGER NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(YEAR(c3));
63 SHOW TABLES;
64 Tables_in_test
65 t2
66 SHOW CREATE TABLE t2;
67 Table Create Table
68 t2 CREATE TABLE `t2` (
69 `c1` int DEFAULT NULL,
70 `c2` char(5) DEFAULT NULL,
71 `c3` datetime DEFAULT NULL
72 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
73 /*!50100 PARTITION BY HASH (year(`c3`)) */
74 DROP TABLE t2;
75 SHOW TABLES;
76 Tables_in_test
77 CREATE TABLE t2 (c1 BIGINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(YEAR(c3));
78 SHOW TABLES;
79 Tables_in_test
80 t2
81 SHOW CREATE TABLE t2;
82 Table Create Table
83 t2 CREATE TABLE `t2` (
84 `c1` bigint DEFAULT NULL,
85 `c2` char(5) DEFAULT NULL,
86 `c3` datetime DEFAULT NULL
87 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
88 /*!50100 PARTITION BY HASH (year(`c3`)) */
89 DROP TABLE t2;
90 SHOW TABLES;
91 Tables_in_test
92 CREATE TABLE t2 (c1 TINYINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(YEAR(c3));
93 SHOW TABLES;
94 Tables_in_test
95 t2
96 SHOW CREATE TABLE t2;
97 Table Create Table
98 t2 CREATE TABLE `t2` (
99 `c1` tinyint NOT NULL,
100 `c2` char(5) DEFAULT NULL,
101 `c3` datetime DEFAULT NULL
102 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
103 /*!50100 PARTITION BY HASH (year(`c3`)) */
104 DROP TABLE t2;
105 SHOW TABLES;
106 Tables_in_test
107 CREATE TABLE t2 (c1 SMALLINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(YEAR(c3));
108 SHOW TABLES;
109 Tables_in_test
110 t2
111 SHOW CREATE TABLE t2;
112 Table Create Table
113 t2 CREATE TABLE `t2` (
114 `c1` smallint NOT NULL,
115 `c2` char(5) DEFAULT NULL,
116 `c3` datetime DEFAULT NULL
117 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
118 /*!50100 PARTITION BY HASH (year(`c3`)) */
119 DROP TABLE t2;
120 SHOW TABLES;
121 Tables_in_test
122 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(YEAR(c3));
123 SHOW TABLES;
124 Tables_in_test
125 t2
126 SHOW CREATE TABLE t2;
127 Table Create Table
128 t2 CREATE TABLE `t2` (
129 `c1` mediumint NOT NULL,
130 `c2` char(5) DEFAULT NULL,
131 `c3` datetime DEFAULT NULL
132 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
133 /*!50100 PARTITION BY HASH (year(`c3`)) */
134 DROP TABLE t2;
135 SHOW TABLES;
136 Tables_in_test
137 CREATE TABLE t2 (c1 INT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(YEAR(c3));
138 SHOW TABLES;
139 Tables_in_test
140 t2
141 SHOW CREATE TABLE t2;
142 Table Create Table
143 t2 CREATE TABLE `t2` (
144 `c1` int NOT NULL,
145 `c2` char(5) DEFAULT NULL,
146 `c3` datetime DEFAULT NULL
147 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
148 /*!50100 PARTITION BY HASH (year(`c3`)) */
149 DROP TABLE t2;
150 SHOW TABLES;
151 Tables_in_test
152 CREATE TABLE t2 (c1 INTEGER NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(YEAR(c3));
153 SHOW TABLES;
154 Tables_in_test
155 t2
156 SHOW CREATE TABLE t2;
157 Table Create Table
158 t2 CREATE TABLE `t2` (
159 `c1` int NOT NULL,
160 `c2` char(5) DEFAULT NULL,
161 `c3` datetime DEFAULT NULL
162 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
163 /*!50100 PARTITION BY HASH (year(`c3`)) */
164 DROP TABLE t2;
165 SHOW TABLES;
166 Tables_in_test
167 CREATE TABLE t2 (c1 BIGINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(YEAR(c3));
168 SHOW TABLES;
169 Tables_in_test
170 t2
171 SHOW CREATE TABLE t2;
172 Table Create Table
173 t2 CREATE TABLE `t2` (
174 `c1` bigint NOT NULL,
175 `c2` char(5) DEFAULT NULL,
176 `c3` datetime DEFAULT NULL
177 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
178 /*!50100 PARTITION BY HASH (year(`c3`)) */
179 DROP TABLE t2;
180 SHOW TABLES;
181 Tables_in_test
182 CREATE TABLE t2 (c1 TINYINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(MONTH(c3));
183 SHOW TABLES;
184 Tables_in_test
185 t2
186 SHOW CREATE TABLE t2;
187 Table Create Table
188 t2 CREATE TABLE `t2` (
189 `c1` tinyint DEFAULT NULL,
190 `c2` char(5) DEFAULT NULL,
191 `c3` datetime DEFAULT NULL
192 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
193 /*!50100 PARTITION BY HASH (month(`c3`)) */
194 DROP TABLE t2;
195 SHOW TABLES;
196 Tables_in_test
197 CREATE TABLE t2 (c1 SMALLINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(MONTH(c3));
198 SHOW TABLES;
199 Tables_in_test
200 t2
201 SHOW CREATE TABLE t2;
202 Table Create Table
203 t2 CREATE TABLE `t2` (
204 `c1` smallint DEFAULT NULL,
205 `c2` char(5) DEFAULT NULL,
206 `c3` datetime DEFAULT NULL
207 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
208 /*!50100 PARTITION BY HASH (month(`c3`)) */
209 DROP TABLE t2;
210 SHOW TABLES;
211 Tables_in_test
212 CREATE TABLE t2 (c1 MEDIUMINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(MONTH(c3));
213 SHOW TABLES;
214 Tables_in_test
215 t2
216 SHOW CREATE TABLE t2;
217 Table Create Table
218 t2 CREATE TABLE `t2` (
219 `c1` mediumint DEFAULT NULL,
220 `c2` char(5) DEFAULT NULL,
221 `c3` datetime DEFAULT NULL
222 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
223 /*!50100 PARTITION BY HASH (month(`c3`)) */
224 DROP TABLE t2;
225 SHOW TABLES;
226 Tables_in_test
227 CREATE TABLE t2 (c1 INT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(MONTH(c3));
228 SHOW TABLES;
229 Tables_in_test
230 t2
231 SHOW CREATE TABLE t2;
232 Table Create Table
233 t2 CREATE TABLE `t2` (
234 `c1` int DEFAULT NULL,
235 `c2` char(5) DEFAULT NULL,
236 `c3` datetime DEFAULT NULL
237 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
238 /*!50100 PARTITION BY HASH (month(`c3`)) */
239 DROP TABLE t2;
240 SHOW TABLES;
241 Tables_in_test
242 CREATE TABLE t2 (c1 INTEGER NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(MONTH(c3));
243 SHOW TABLES;
244 Tables_in_test
245 t2
246 SHOW CREATE TABLE t2;
247 Table Create Table
248 t2 CREATE TABLE `t2` (
249 `c1` int DEFAULT NULL,
250 `c2` char(5) DEFAULT NULL,
251 `c3` datetime DEFAULT NULL
252 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
253 /*!50100 PARTITION BY HASH (month(`c3`)) */
254 DROP TABLE t2;
255 SHOW TABLES;
256 Tables_in_test
257 CREATE TABLE t2 (c1 BIGINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(MONTH(c3));
258 SHOW TABLES;
259 Tables_in_test
260 t2
261 SHOW CREATE TABLE t2;
262 Table Create Table
263 t2 CREATE TABLE `t2` (
264 `c1` bigint DEFAULT NULL,
265 `c2` char(5) DEFAULT NULL,
266 `c3` datetime DEFAULT NULL
267 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
268 /*!50100 PARTITION BY HASH (month(`c3`)) */
269 DROP TABLE t2;
270 SHOW TABLES;
271 Tables_in_test
272 CREATE TABLE t2 (c1 TINYINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(MONTH(c3));
273 SHOW TABLES;
274 Tables_in_test
275 t2
276 SHOW CREATE TABLE t2;
277 Table Create Table
278 t2 CREATE TABLE `t2` (
279 `c1` tinyint NOT NULL,
280 `c2` char(5) DEFAULT NULL,
281 `c3` datetime DEFAULT NULL
282 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
283 /*!50100 PARTITION BY HASH (month(`c3`)) */
284 DROP TABLE t2;
285 SHOW TABLES;
286 Tables_in_test
287 CREATE TABLE t2 (c1 SMALLINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(MONTH(c3));
288 SHOW TABLES;
289 Tables_in_test
290 t2
291 SHOW CREATE TABLE t2;
292 Table Create Table
293 t2 CREATE TABLE `t2` (
294 `c1` smallint NOT NULL,
295 `c2` char(5) DEFAULT NULL,
296 `c3` datetime DEFAULT NULL
297 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
298 /*!50100 PARTITION BY HASH (month(`c3`)) */
299 DROP TABLE t2;
300 SHOW TABLES;
301 Tables_in_test
302 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(MONTH(c3));
303 SHOW TABLES;
304 Tables_in_test
305 t2
306 SHOW CREATE TABLE t2;
307 Table Create Table
308 t2 CREATE TABLE `t2` (
309 `c1` mediumint NOT NULL,
310 `c2` char(5) DEFAULT NULL,
311 `c3` datetime DEFAULT NULL
312 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
313 /*!50100 PARTITION BY HASH (month(`c3`)) */
314 DROP TABLE t2;
315 SHOW TABLES;
316 Tables_in_test
317 CREATE TABLE t2 (c1 INT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(MONTH(c3));
318 SHOW TABLES;
319 Tables_in_test
320 t2
321 SHOW CREATE TABLE t2;
322 Table Create Table
323 t2 CREATE TABLE `t2` (
324 `c1` int NOT NULL,
325 `c2` char(5) DEFAULT NULL,
326 `c3` datetime DEFAULT NULL
327 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
328 /*!50100 PARTITION BY HASH (month(`c3`)) */
329 DROP TABLE t2;
330 SHOW TABLES;
331 Tables_in_test
332 CREATE TABLE t2 (c1 INTEGER NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(MONTH(c3));
333 SHOW TABLES;
334 Tables_in_test
335 t2
336 SHOW CREATE TABLE t2;
337 Table Create Table
338 t2 CREATE TABLE `t2` (
339 `c1` int NOT NULL,
340 `c2` char(5) DEFAULT NULL,
341 `c3` datetime DEFAULT NULL
342 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
343 /*!50100 PARTITION BY HASH (month(`c3`)) */
344 DROP TABLE t2;
345 SHOW TABLES;
346 Tables_in_test
347 CREATE TABLE t2 (c1 BIGINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(MONTH(c3));
348 SHOW TABLES;
349 Tables_in_test
350 t2
351 SHOW CREATE TABLE t2;
352 Table Create Table
353 t2 CREATE TABLE `t2` (
354 `c1` bigint NOT NULL,
355 `c2` char(5) DEFAULT NULL,
356 `c3` datetime DEFAULT NULL
357 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
358 /*!50100 PARTITION BY HASH (month(`c3`)) */
359 DROP TABLE t2;
360 SHOW TABLES;
361 Tables_in_test
362 CREATE TABLE t2 (c1 TINYINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAY(c3));
363 SHOW TABLES;
364 Tables_in_test
365 t2
366 SHOW CREATE TABLE t2;
367 Table Create Table
368 t2 CREATE TABLE `t2` (
369 `c1` tinyint DEFAULT NULL,
370 `c2` char(5) DEFAULT NULL,
371 `c3` datetime DEFAULT NULL
372 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
373 /*!50100 PARTITION BY HASH (dayofmonth(`c3`)) */
374 DROP TABLE t2;
375 SHOW TABLES;
376 Tables_in_test
377 CREATE TABLE t2 (c1 SMALLINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAY(c3));
378 SHOW TABLES;
379 Tables_in_test
380 t2
381 SHOW CREATE TABLE t2;
382 Table Create Table
383 t2 CREATE TABLE `t2` (
384 `c1` smallint DEFAULT NULL,
385 `c2` char(5) DEFAULT NULL,
386 `c3` datetime DEFAULT NULL
387 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
388 /*!50100 PARTITION BY HASH (dayofmonth(`c3`)) */
389 DROP TABLE t2;
390 SHOW TABLES;
391 Tables_in_test
392 CREATE TABLE t2 (c1 MEDIUMINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAY(c3));
393 SHOW TABLES;
394 Tables_in_test
395 t2
396 SHOW CREATE TABLE t2;
397 Table Create Table
398 t2 CREATE TABLE `t2` (
399 `c1` mediumint DEFAULT NULL,
400 `c2` char(5) DEFAULT NULL,
401 `c3` datetime DEFAULT NULL
402 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
403 /*!50100 PARTITION BY HASH (dayofmonth(`c3`)) */
404 DROP TABLE t2;
405 SHOW TABLES;
406 Tables_in_test
407 CREATE TABLE t2 (c1 INT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAY(c3));
408 SHOW TABLES;
409 Tables_in_test
410 t2
411 SHOW CREATE TABLE t2;
412 Table Create Table
413 t2 CREATE TABLE `t2` (
414 `c1` int DEFAULT NULL,
415 `c2` char(5) DEFAULT NULL,
416 `c3` datetime DEFAULT NULL
417 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
418 /*!50100 PARTITION BY HASH (dayofmonth(`c3`)) */
419 DROP TABLE t2;
420 SHOW TABLES;
421 Tables_in_test
422 CREATE TABLE t2 (c1 INTEGER NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAY(c3));
423 SHOW TABLES;
424 Tables_in_test
425 t2
426 SHOW CREATE TABLE t2;
427 Table Create Table
428 t2 CREATE TABLE `t2` (
429 `c1` int DEFAULT NULL,
430 `c2` char(5) DEFAULT NULL,
431 `c3` datetime DEFAULT NULL
432 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
433 /*!50100 PARTITION BY HASH (dayofmonth(`c3`)) */
434 DROP TABLE t2;
435 SHOW TABLES;
436 Tables_in_test
437 CREATE TABLE t2 (c1 BIGINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAY(c3));
438 SHOW TABLES;
439 Tables_in_test
440 t2
441 SHOW CREATE TABLE t2;
442 Table Create Table
443 t2 CREATE TABLE `t2` (
444 `c1` bigint DEFAULT NULL,
445 `c2` char(5) DEFAULT NULL,
446 `c3` datetime DEFAULT NULL
447 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
448 /*!50100 PARTITION BY HASH (dayofmonth(`c3`)) */
449 DROP TABLE t2;
450 SHOW TABLES;
451 Tables_in_test
452 CREATE TABLE t2 (c1 TINYINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAY(c3));
453 SHOW TABLES;
454 Tables_in_test
455 t2
456 SHOW CREATE TABLE t2;
457 Table Create Table
458 t2 CREATE TABLE `t2` (
459 `c1` tinyint NOT NULL,
460 `c2` char(5) DEFAULT NULL,
461 `c3` datetime DEFAULT NULL
462 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
463 /*!50100 PARTITION BY HASH (dayofmonth(`c3`)) */
464 DROP TABLE t2;
465 SHOW TABLES;
466 Tables_in_test
467 CREATE TABLE t2 (c1 SMALLINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAY(c3));
468 SHOW TABLES;
469 Tables_in_test
470 t2
471 SHOW CREATE TABLE t2;
472 Table Create Table
473 t2 CREATE TABLE `t2` (
474 `c1` smallint NOT NULL,
475 `c2` char(5) DEFAULT NULL,
476 `c3` datetime DEFAULT NULL
477 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
478 /*!50100 PARTITION BY HASH (dayofmonth(`c3`)) */
479 DROP TABLE t2;
480 SHOW TABLES;
481 Tables_in_test
482 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAY(c3));
483 SHOW TABLES;
484 Tables_in_test
485 t2
486 SHOW CREATE TABLE t2;
487 Table Create Table
488 t2 CREATE TABLE `t2` (
489 `c1` mediumint NOT NULL,
490 `c2` char(5) DEFAULT NULL,
491 `c3` datetime DEFAULT NULL
492 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
493 /*!50100 PARTITION BY HASH (dayofmonth(`c3`)) */
494 DROP TABLE t2;
495 SHOW TABLES;
496 Tables_in_test
497 CREATE TABLE t2 (c1 INT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAY(c3));
498 SHOW TABLES;
499 Tables_in_test
500 t2
501 SHOW CREATE TABLE t2;
502 Table Create Table
503 t2 CREATE TABLE `t2` (
504 `c1` int NOT NULL,
505 `c2` char(5) DEFAULT NULL,
506 `c3` datetime DEFAULT NULL
507 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
508 /*!50100 PARTITION BY HASH (dayofmonth(`c3`)) */
509 DROP TABLE t2;
510 SHOW TABLES;
511 Tables_in_test
512 CREATE TABLE t2 (c1 INTEGER NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAY(c3));
513 SHOW TABLES;
514 Tables_in_test
515 t2
516 SHOW CREATE TABLE t2;
517 Table Create Table
518 t2 CREATE TABLE `t2` (
519 `c1` int NOT NULL,
520 `c2` char(5) DEFAULT NULL,
521 `c3` datetime DEFAULT NULL
522 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
523 /*!50100 PARTITION BY HASH (dayofmonth(`c3`)) */
524 DROP TABLE t2;
525 SHOW TABLES;
526 Tables_in_test
527 CREATE TABLE t2 (c1 BIGINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAY(c3));
528 SHOW TABLES;
529 Tables_in_test
530 t2
531 SHOW CREATE TABLE t2;
532 Table Create Table
533 t2 CREATE TABLE `t2` (
534 `c1` bigint NOT NULL,
535 `c2` char(5) DEFAULT NULL,
536 `c3` datetime DEFAULT NULL
537 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
538 /*!50100 PARTITION BY HASH (dayofmonth(`c3`)) */
539 DROP TABLE t2;
540 SHOW TABLES;
541 Tables_in_test
542 CREATE TABLE t2 (c1 TINYINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAYOFWEEK(c3));
543 SHOW TABLES;
544 Tables_in_test
545 t2
546 SHOW CREATE TABLE t2;
547 Table Create Table
548 t2 CREATE TABLE `t2` (
549 `c1` tinyint DEFAULT NULL,
550 `c2` char(5) DEFAULT NULL,
551 `c3` datetime DEFAULT NULL
552 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
553 /*!50100 PARTITION BY HASH (dayofweek(`c3`)) */
554 DROP TABLE t2;
555 SHOW TABLES;
556 Tables_in_test
557 CREATE TABLE t2 (c1 SMALLINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAYOFWEEK(c3));
558 SHOW TABLES;
559 Tables_in_test
560 t2
561 SHOW CREATE TABLE t2;
562 Table Create Table
563 t2 CREATE TABLE `t2` (
564 `c1` smallint DEFAULT NULL,
565 `c2` char(5) DEFAULT NULL,
566 `c3` datetime DEFAULT NULL
567 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
568 /*!50100 PARTITION BY HASH (dayofweek(`c3`)) */
569 DROP TABLE t2;
570 SHOW TABLES;
571 Tables_in_test
572 CREATE TABLE t2 (c1 MEDIUMINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAYOFWEEK(c3));
573 SHOW TABLES;
574 Tables_in_test
575 t2
576 SHOW CREATE TABLE t2;
577 Table Create Table
578 t2 CREATE TABLE `t2` (
579 `c1` mediumint DEFAULT NULL,
580 `c2` char(5) DEFAULT NULL,
581 `c3` datetime DEFAULT NULL
582 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
583 /*!50100 PARTITION BY HASH (dayofweek(`c3`)) */
584 DROP TABLE t2;
585 SHOW TABLES;
586 Tables_in_test
587 CREATE TABLE t2 (c1 INT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAYOFWEEK(c3));
588 SHOW TABLES;
589 Tables_in_test
590 t2
591 SHOW CREATE TABLE t2;
592 Table Create Table
593 t2 CREATE TABLE `t2` (
594 `c1` int DEFAULT NULL,
595 `c2` char(5) DEFAULT NULL,
596 `c3` datetime DEFAULT NULL
597 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
598 /*!50100 PARTITION BY HASH (dayofweek(`c3`)) */
599 DROP TABLE t2;
600 SHOW TABLES;
601 Tables_in_test
602 CREATE TABLE t2 (c1 INTEGER NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAYOFWEEK(c3));
603 SHOW TABLES;
604 Tables_in_test
605 t2
606 SHOW CREATE TABLE t2;
607 Table Create Table
608 t2 CREATE TABLE `t2` (
609 `c1` int DEFAULT NULL,
610 `c2` char(5) DEFAULT NULL,
611 `c3` datetime DEFAULT NULL
612 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
613 /*!50100 PARTITION BY HASH (dayofweek(`c3`)) */
614 DROP TABLE t2;
615 SHOW TABLES;
616 Tables_in_test
617 CREATE TABLE t2 (c1 BIGINT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAYOFWEEK(c3));
618 SHOW TABLES;
619 Tables_in_test
620 t2
621 SHOW CREATE TABLE t2;
622 Table Create Table
623 t2 CREATE TABLE `t2` (
624 `c1` bigint DEFAULT NULL,
625 `c2` char(5) DEFAULT NULL,
626 `c3` datetime DEFAULT NULL
627 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
628 /*!50100 PARTITION BY HASH (dayofweek(`c3`)) */
629 DROP TABLE t2;
630 SHOW TABLES;
631 Tables_in_test
632 CREATE TABLE t2 (c1 TINYINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAYOFWEEK(c3));
633 SHOW TABLES;
634 Tables_in_test
635 t2
636 SHOW CREATE TABLE t2;
637 Table Create Table
638 t2 CREATE TABLE `t2` (
639 `c1` tinyint NOT NULL,
640 `c2` char(5) DEFAULT NULL,
641 `c3` datetime DEFAULT NULL
642 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
643 /*!50100 PARTITION BY HASH (dayofweek(`c3`)) */
644 DROP TABLE t2;
645 SHOW TABLES;
646 Tables_in_test
647 CREATE TABLE t2 (c1 SMALLINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAYOFWEEK(c3));
648 SHOW TABLES;
649 Tables_in_test
650 t2
651 SHOW CREATE TABLE t2;
652 Table Create Table
653 t2 CREATE TABLE `t2` (
654 `c1` smallint NOT NULL,
655 `c2` char(5) DEFAULT NULL,
656 `c3` datetime DEFAULT NULL
657 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
658 /*!50100 PARTITION BY HASH (dayofweek(`c3`)) */
659 DROP TABLE t2;
660 SHOW TABLES;
661 Tables_in_test
662 CREATE TABLE t2 (c1 MEDIUMINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAYOFWEEK(c3));
663 SHOW TABLES;
664 Tables_in_test
665 t2
666 SHOW CREATE TABLE t2;
667 Table Create Table
668 t2 CREATE TABLE `t2` (
669 `c1` mediumint NOT NULL,
670 `c2` char(5) DEFAULT NULL,
671 `c3` datetime DEFAULT NULL
672 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
673 /*!50100 PARTITION BY HASH (dayofweek(`c3`)) */
674 DROP TABLE t2;
675 SHOW TABLES;
676 Tables_in_test
677 CREATE TABLE t2 (c1 INT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAYOFWEEK(c3));
678 SHOW TABLES;
679 Tables_in_test
680 t2
681 SHOW CREATE TABLE t2;
682 Table Create Table
683 t2 CREATE TABLE `t2` (
684 `c1` int NOT NULL,
685 `c2` char(5) DEFAULT NULL,
686 `c3` datetime DEFAULT NULL
687 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
688 /*!50100 PARTITION BY HASH (dayofweek(`c3`)) */
689 DROP TABLE t2;
690 SHOW TABLES;
691 Tables_in_test
692 CREATE TABLE t2 (c1 INTEGER NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAYOFWEEK(c3));
693 SHOW TABLES;
694 Tables_in_test
695 t2
696 SHOW CREATE TABLE t2;
697 Table Create Table
698 t2 CREATE TABLE `t2` (
699 `c1` int NOT NULL,
700 `c2` char(5) DEFAULT NULL,
701 `c3` datetime DEFAULT NULL
702 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
703 /*!50100 PARTITION BY HASH (dayofweek(`c3`)) */
704 DROP TABLE t2;
705 SHOW TABLES;
706 Tables_in_test
707 CREATE TABLE t2 (c1 BIGINT NOT NULL, c2 CHAR(5),c3 DATETIME) PARTITION BY HASH(DAYOFWEEK(c3));
708 SHOW TABLES;
709 Tables_in_test
710 t2
711 SHOW CREATE TABLE t2;
712 Table Create Table
713 t2 CREATE TABLE `t2` (
714 `c1` bigint NOT NULL,
715 `c2` char(5) DEFAULT NULL,
716 `c3` datetime DEFAULT NULL
717 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
718 /*!50100 PARTITION BY HASH (dayofweek(`c3`)) */
719 DROP TABLE t2;
720 SHOW TABLES;
721 Tables_in_test