Debian Codegraph @

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

raw
1 use test;
2 CREATE TABLE t_10 (a INT, b VARCHAR(55), PRIMARY KEY (a)) ENGINE = MYISAM;
3 CREATE TABLE t_100 (a INT, b VARCHAR(55), PRIMARY KEY (a)) ENGINE = MYISAM;
4 CREATE TABLE t_1000 (a INT, b VARCHAR(55), PRIMARY KEY (a)) ENGINE = MYISAM;
5 CREATE TABLE t_empty (a INT, b VARCHAR(55), PRIMARY KEY (a)) ENGINE = MYISAM;
6 CREATE TABLE t_null (a INT, b VARCHAR(55), PRIMARY KEY (a)) ENGINE = MYISAM;
7 CREATE TABLE tp (a INT, b VARCHAR(55), PRIMARY KEY (a)) ENGINE = InnoDB
8 PARTITION BY RANGE (a)
9 (PARTITION p0 VALUES LESS THAN (10) ,
10 PARTITION p1 VALUES LESS THAN (100) ,
11 PARTITION p2 VALUES LESS THAN (1000) );
12 CREATE TABLE tsp (a INT, b VARCHAR(55), PRIMARY KEY (a)) ENGINE = InnoDB
13 PARTITION BY RANGE (a)
14 SUBPARTITION BY HASH(a)
15 (PARTITION p0 VALUES LESS THAN (10)
16 (SUBPARTITION sp00,
17 SUBPARTITION sp01,
18 SUBPARTITION sp02,
19 SUBPARTITION sp03,
20 SUBPARTITION sp04), PARTITION p1 VALUES LESS THAN (100)
21 (SUBPARTITION sp10 ,
22 SUBPARTITION sp11 ,
23 SUBPARTITION sp12 ,
24 SUBPARTITION sp13 ,
25 SUBPARTITION sp14 ),
26 PARTITION p2 VALUES LESS THAN (1000)
27 (SUBPARTITION sp20,
28 SUBPARTITION sp21,
29 SUBPARTITION sp22,
30 SUBPARTITION sp23,
31 SUBPARTITION sp24));
32 INSERT INTO t_10 VALUES (1, "One"), (3, "Three"), (5, "Five"), (9, "Nine");
33 INSERT INTO t_100 VALUES (11, "Eleven"), (13, "Thirdteen"), (15, "Fifeteen"), (19, "Nineteen");
34 INSERT INTO t_100 VALUES (91, "Ninety-one"), (93, "Ninety-three"), (95, "Ninety-five"), (99, "Ninety-nine");
35 INSERT INTO t_1000 VALUES (111, "Hundred elven"), (113, "Hundred thirdteen"), (115, "Hundred fiveteen"), (119, "Hundred nineteen");
36 INSERT INTO t_1000 VALUES (131, "Hundred thirty-one"), (133, "Hundred thirty-three"), (135, "Hundred thirty-five"), (139, "Hundred thirty-nine");
37 INSERT INTO t_1000 VALUES (151, "Hundred fifty-one"), (153, "Hundred fifty-three"), (155, "Hundred fity-five"), (159, "Hundred fifty-nine");
38 INSERT INTO t_1000 VALUES (191, "Hundred ninety-one"), (193, "Hundred ninety-three"), (195, "Hundred ninety-five"), (199, "Hundred ninety-nine");
39 INSERT INTO t_null VALUES (1, "NULL");
40 INSERT INTO tp VALUES (2, "Two"), (4, "Four"), (6, "Six"), (8, "Eight");
41 INSERT INTO tp VALUES (12, "twelve"), (14, "Fourteen"), (16, "Sixteen"), (18, "Eightteen");
42 INSERT INTO tp VALUES (112, "Hundred twelve"), (114, "Hundred fourteen"), (116, "Hundred sixteen"), (118, "Hundred eightteen");
43 INSERT INTO tp VALUES (122, "Hundred twenty-two"), (124, "Hundred twenty-four"), (126, "Hundred twenty-six"), (128, "Hundred twenty-eight");
44 INSERT INTO tp VALUES (162, "Hundred sixty-two"), (164, "Hundred sixty-four"), (166, "Hundred sixty-six"), (168, "Hundred sixty-eight");
45 INSERT INTO tp VALUES (182, "Hundred eighty-two"), (184, "Hundred eighty-four"), (186, "Hundred eighty-six"), (188, "Hundred eighty-eight");
46 INSERT INTO tsp VALUES (2, "Two"), (4, "Four"), (6, "Six"), (8, "Eight");
47 INSERT INTO tsp VALUES (12, "twelve"), (14, "Fourteen"), (16, "Sixteen"), (18, "Eightteen");
48 INSERT INTO tsp VALUES (112, "Hundred twelve"), (114, "Hundred fourteen"), (116, "Hundred sixteen"), (118, "Hundred eightteen");
49 INSERT INTO tsp VALUES (122, "Hundred twenty-two"), (124, "Hundred twenty-four"), (126, "Hundred twenty-six"), (128, "Hundred twenty-eight");
50 INSERT INTO tsp VALUES (162, "Hundred sixty-two"), (164, "Hundred sixty-four"), (166, "Hundred sixty-six"), (168, "Hundred sixty-eight");
51 INSERT INTO tsp VALUES (182, "Hundred eight-two"), (184, "Hundred eighty-four"), (186, "Hundred eighty-six"), (188, "Hundred eighty-eight");
52 CREATE TABLE tsp_01(a INT,b VARCHAR(55),PRIMARY KEY (a)) ENGINE = MYISAM AS SELECT a, b FROM t_10 WHERE MOD(a,5)= 1;
53 CREATE TABLE tsp_02(a INT,b VARCHAR(55),PRIMARY KEY (a)) ENGINE = MYISAM AS SELECT a, b FROM t_10 WHERE MOD(a,5)= 2;
54 CREATE TABLE tsp_03(a INT,b VARCHAR(55),PRIMARY KEY (a)) ENGINE = MYISAM AS SELECT a, b FROM t_10 WHERE MOD(a,5)= 3;
55 CREATE TABLE tsp_04(a INT,b VARCHAR(55),PRIMARY KEY (a)) ENGINE = MYISAM AS SELECT a, b FROM t_10 WHERE MOD(a,5)= 4;
56 CREATE TABLE tsp_00(a INT,b VARCHAR(55),PRIMARY KEY (a)) ENGINE = MYISAM AS SELECT a, b FROM t_10 WHERE MOD(a,5)= 0;
57 SELECT * FROM t_10;
58 a b
59 1 One
60 3 Three
61 5 Five
62 9 Nine
63 SELECT * FROM t_100;
64 a b
65 11 Eleven
66 13 Thirdteen
67 15 Fifeteen
68 19 Nineteen
69 91 Ninety-one
70 93 Ninety-three
71 95 Ninety-five
72 99 Ninety-nine
73 SELECT * FROM t_1000;
74 a b
75 111 Hundred elven
76 113 Hundred thirdteen
77 115 Hundred fiveteen
78 119 Hundred nineteen
79 131 Hundred thirty-one
80 133 Hundred thirty-three
81 135 Hundred thirty-five
82 139 Hundred thirty-nine
83 151 Hundred fifty-one
84 153 Hundred fifty-three
85 155 Hundred fity-five
86 159 Hundred fifty-nine
87 191 Hundred ninety-one
88 193 Hundred ninety-three
89 195 Hundred ninety-five
90 199 Hundred ninety-nine
91 SELECT * FROM tp;
92 a b
93 112 Hundred twelve
94 114 Hundred fourteen
95 116 Hundred sixteen
96 118 Hundred eightteen
97 12 twelve
98 122 Hundred twenty-two
99 124 Hundred twenty-four
100 126 Hundred twenty-six
101 128 Hundred twenty-eight
102 14 Fourteen
103 16 Sixteen
104 162 Hundred sixty-two
105 164 Hundred sixty-four
106 166 Hundred sixty-six
107 168 Hundred sixty-eight
108 18 Eightteen
109 182 Hundred eighty-two
110 184 Hundred eighty-four
111 186 Hundred eighty-six
112 188 Hundred eighty-eight
113 2 Two
114 4 Four
115 6 Six
116 8 Eight
117 SELECT * FROM tsp;
118 a b
119 112 Hundred twelve
120 114 Hundred fourteen
121 116 Hundred sixteen
122 118 Hundred eightteen
123 12 twelve
124 122 Hundred twenty-two
125 124 Hundred twenty-four
126 126 Hundred twenty-six
127 128 Hundred twenty-eight
128 14 Fourteen
129 16 Sixteen
130 162 Hundred sixty-two
131 164 Hundred sixty-four
132 166 Hundred sixty-six
133 168 Hundred sixty-eight
134 18 Eightteen
135 182 Hundred eight-two
136 184 Hundred eighty-four
137 186 Hundred eighty-six
138 188 Hundred eighty-eight
139 2 Two
140 4 Four
141 6 Six
142 8 Eight
143 SELECT * FROM tsp_00;
144 a b
145 5 Five
146 SELECT * FROM tsp_01;
147 a b
148 1 One
149 SELECT * FROM tsp_02;
150 a b
151 SELECT * FROM tsp_03;
152 a b
153 3 Three
154 SELECT * FROM tsp_04;
155 a b
156 9 Nine
157 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
158 ERROR HY000: The mix of handlers in the partitions is not allowed in this version of MariaDB
159 ALTER TABLE tsp EXCHANGE PARTITION sp00 WITH TABLE tsp_00;
160 ERROR HY000: The mix of handlers in the partitions is not allowed in this version of MariaDB
161 DROP TABLE IF EXISTS t_10;
162 DROP TABLE IF EXISTS t_100;
163 DROP TABLE IF EXISTS t_1000;
164 DROP TABLE IF EXISTS tp;
165 DROP TABLE IF EXISTS tsp;
166 DROP TABLE IF EXISTS tsp_00;
167 DROP TABLE IF EXISTS tsp_01;
168 DROP TABLE IF EXISTS tsp_02;
169 DROP TABLE IF EXISTS tsp_03;
170 DROP TABLE IF EXISTS tsp_04;
171 DROP TABLE IF EXISTS t_empty;
172 DROP TABLE IF EXISTS t_null;