Debian Codegraph @

mysql-test/suite/parts/r/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 DEFAULT NULL,
14 `c2` int DEFAULT NULL
15 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
16 /*!50100 PARTITION BY LIST (`c1`)
17 (PARTITION r0 VALUES IN (1,5,9,13,17,21) ENGINE = InnoDB,
18 PARTITION r1 VALUES IN (2,6,10,14,18,22) ENGINE = InnoDB,
19 PARTITION r2 VALUES IN (3,7,11,15,19,23) ENGINE = InnoDB,
20 PARTITION r3 VALUES IN (4,8,12,16,20,24) ENGINE = InnoDB) */
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 DEFAULT NULL,
36 `c2` int DEFAULT NULL
37 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
38 /*!50100 PARTITION BY LIST (`c1`)
39 (PARTITION r0 VALUES IN (1,5,9,13,17,21) ENGINE = InnoDB,
40 PARTITION r1 VALUES IN (2,6,10,14,18,22) ENGINE = InnoDB,
41 PARTITION r2 VALUES IN (3,7,11,15,19,23) ENGINE = InnoDB,
42 PARTITION r3 VALUES IN (4,8,12,16,20,24) ENGINE = InnoDB) */
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 DEFAULT NULL,
58 `c2` int DEFAULT NULL
59 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
60 /*!50100 PARTITION BY LIST (`c1`)
61 (PARTITION r0 VALUES IN (1,5,9,13,17,21) ENGINE = InnoDB,
62 PARTITION r1 VALUES IN (2,6,10,14,18,22) ENGINE = InnoDB,
63 PARTITION r2 VALUES IN (3,7,11,15,19,23) ENGINE = InnoDB,
64 PARTITION r3 VALUES IN (4,8,12,16,20,24) ENGINE = InnoDB) */
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 DEFAULT NULL,
80 `c2` int DEFAULT NULL
81 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
82 /*!50100 PARTITION BY LIST (`c1`)
83 (PARTITION r0 VALUES IN (1,5,9,13,17,21) ENGINE = InnoDB,
84 PARTITION r1 VALUES IN (2,6,10,14,18,22) ENGINE = InnoDB,
85 PARTITION r2 VALUES IN (3,7,11,15,19,23) ENGINE = InnoDB,
86 PARTITION r3 VALUES IN (4,8,12,16,20,24) ENGINE = InnoDB) */
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 DEFAULT NULL,
102 `c2` int DEFAULT NULL
103 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
104 /*!50100 PARTITION BY LIST (`c1`)
105 (PARTITION r0 VALUES IN (1,5,9,13,17,21) ENGINE = InnoDB,
106 PARTITION r1 VALUES IN (2,6,10,14,18,22) ENGINE = InnoDB,
107 PARTITION r2 VALUES IN (3,7,11,15,19,23) ENGINE = InnoDB,
108 PARTITION r3 VALUES IN (4,8,12,16,20,24) ENGINE = InnoDB) */
109 DROP TABLE t1;
110 SHOW TABLES;
111 Tables_in_test