Debian Codegraph @

mysql-test/suite/engines/funcs/r/tc_partition_value_specific.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1 ( c1 SMALLINT, c2 INT) PARTITION BY LIST (c1) (
3 PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),
4 PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 22),
5 PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),
6 PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
7 SHOW TABLES;
8 Tables_in_test
9 t1
10 SHOW CREATE TABLE t1;
11 Table Create Table
12 t1 CREATE TABLE `t1` (
13 `c1` smallint(6) DEFAULT NULL,
14 `c2` int(11) DEFAULT NULL
15 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
16 PARTITION BY LIST (`c1`)
17 (PARTITION `r0` VALUES IN (1,5,9,13,17,21) ENGINE = ENGINE,
18 PARTITION `r1` VALUES IN (2,6,10,14,18,22) ENGINE = ENGINE,
19 PARTITION `r2` VALUES IN (3,7,11,15,19,23) ENGINE = ENGINE,
20 PARTITION `r3` VALUES IN (4,8,12,16,20,24) ENGINE = ENGINE)
21 DROP TABLE t1;
22 SHOW TABLES;
23 Tables_in_test
24 CREATE TABLE t1 ( c1 MEDIUMINT, c2 INT) PARTITION BY LIST (c1) (
25 PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),
26 PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 22),
27 PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),
28 PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
29 SHOW TABLES;
30 Tables_in_test
31 t1
32 SHOW CREATE TABLE t1;
33 Table Create Table
34 t1 CREATE TABLE `t1` (
35 `c1` mediumint(9) DEFAULT NULL,
36 `c2` int(11) DEFAULT NULL
37 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
38 PARTITION BY LIST (`c1`)
39 (PARTITION `r0` VALUES IN (1,5,9,13,17,21) ENGINE = ENGINE,
40 PARTITION `r1` VALUES IN (2,6,10,14,18,22) ENGINE = ENGINE,
41 PARTITION `r2` VALUES IN (3,7,11,15,19,23) ENGINE = ENGINE,
42 PARTITION `r3` VALUES IN (4,8,12,16,20,24) ENGINE = ENGINE)
43 DROP TABLE t1;
44 SHOW TABLES;
45 Tables_in_test
46 CREATE TABLE t1 ( c1 INT, c2 INT) PARTITION BY LIST (c1) (
47 PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),
48 PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 22),
49 PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),
50 PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
51 SHOW TABLES;
52 Tables_in_test
53 t1
54 SHOW CREATE TABLE t1;
55 Table Create Table
56 t1 CREATE TABLE `t1` (
57 `c1` int(11) DEFAULT NULL,
58 `c2` int(11) DEFAULT NULL
59 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
60 PARTITION BY LIST (`c1`)
61 (PARTITION `r0` VALUES IN (1,5,9,13,17,21) ENGINE = ENGINE,
62 PARTITION `r1` VALUES IN (2,6,10,14,18,22) ENGINE = ENGINE,
63 PARTITION `r2` VALUES IN (3,7,11,15,19,23) ENGINE = ENGINE,
64 PARTITION `r3` VALUES IN (4,8,12,16,20,24) ENGINE = ENGINE)
65 DROP TABLE t1;
66 SHOW TABLES;
67 Tables_in_test
68 CREATE TABLE t1 ( c1 INTEGER, c2 INT) PARTITION BY LIST (c1) (
69 PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),
70 PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 22),
71 PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),
72 PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
73 SHOW TABLES;
74 Tables_in_test
75 t1
76 SHOW CREATE TABLE t1;
77 Table Create Table
78 t1 CREATE TABLE `t1` (
79 `c1` int(11) DEFAULT NULL,
80 `c2` int(11) DEFAULT NULL
81 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
82 PARTITION BY LIST (`c1`)
83 (PARTITION `r0` VALUES IN (1,5,9,13,17,21) ENGINE = ENGINE,
84 PARTITION `r1` VALUES IN (2,6,10,14,18,22) ENGINE = ENGINE,
85 PARTITION `r2` VALUES IN (3,7,11,15,19,23) ENGINE = ENGINE,
86 PARTITION `r3` VALUES IN (4,8,12,16,20,24) ENGINE = ENGINE)
87 DROP TABLE t1;
88 SHOW TABLES;
89 Tables_in_test
90 CREATE TABLE t1 ( c1 BIGINT, c2 INT) PARTITION BY LIST (c1) (
91 PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),
92 PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 22),
93 PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),
94 PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
95 SHOW TABLES;
96 Tables_in_test
97 t1
98 SHOW CREATE TABLE t1;
99 Table Create Table
100 t1 CREATE TABLE `t1` (
101 `c1` bigint(20) DEFAULT NULL,
102 `c2` int(11) DEFAULT NULL
103 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
104 PARTITION BY LIST (`c1`)
105 (PARTITION `r0` VALUES IN (1,5,9,13,17,21) ENGINE = ENGINE,
106 PARTITION `r1` VALUES IN (2,6,10,14,18,22) ENGINE = ENGINE,
107 PARTITION `r2` VALUES IN (3,7,11,15,19,23) ENGINE = ENGINE,
108 PARTITION `r3` VALUES IN (4,8,12,16,20,24) ENGINE = ENGINE)
109 DROP TABLE t1;
110 SHOW TABLES;
111 Tables_in_test