Debian Codegraph @

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

raw
1 use test;
2 SELECT * FROM t_10;
3 a b
4 1 One
5 3 Three
6 5 Five
7 9 Nine
8 SELECT * FROM t_100;
9 a b
10 11 Eleven
11 13 Thirdteen
12 15 Fifeteen
13 19 Nineteen
14 91 Ninety-one
15 93 Ninety-three
16 95 Ninety-five
17 99 Ninety-nine
18 SELECT * FROM t_1000;
19 a b
20 111 Hundred elven
21 113 Hundred thirdteen
22 115 Hundred fiveteen
23 119 Hundred nineteen
24 131 Hundred thirty-one
25 133 Hundred thirty-three
26 135 Hundred thirty-five
27 139 Hundred thirty-nine
28 151 Hundred fifty-one
29 153 Hundred fifty-three
30 155 Hundred fity-five
31 159 Hundred fifty-nine
32 191 Hundred ninety-one
33 193 Hundred ninety-three
34 195 Hundred ninety-five
35 199 Hundred ninety-nine
36 SELECT * FROM tp;
37 a b
38 112 Hundred twelve
39 114 Hundred fourteen
40 116 Hundred sixteen
41 118 Hundred eightteen
42 12 twelve
43 122 Hundred twenty-two
44 124 Hundred twenty-four
45 126 Hundred twenty-six
46 128 Hundred twenty-eight
47 14 Fourteen
48 16 Sixteen
49 162 Hundred sixty-two
50 164 Hundred sixty-four
51 166 Hundred sixty-six
52 168 Hundred sixty-eight
53 18 Eightteen
54 182 Hundred eighty-two
55 184 Hundred eighty-four
56 186 Hundred eighty-six
57 188 Hundred eighty-eight
58 2 Two
59 4 Four
60 6 Six
61 8 Eight
62 SELECT * FROM tsp;
63 a b
64 112 Hundred twelve
65 114 Hundred fourteen
66 116 Hundred sixteen
67 118 Hundred eightteen
68 12 twelve
69 122 Hundred twenty-two
70 124 Hundred twenty-four
71 126 Hundred twenty-six
72 128 Hundred twenty-eight
73 14 Fourteen
74 16 Sixteen
75 162 Hundred sixty-two
76 164 Hundred sixty-four
77 166 Hundred sixty-six
78 168 Hundred sixty-eight
79 18 Eightteen
80 182 Hundred eight-two
81 184 Hundred eighty-four
82 186 Hundred eighty-six
83 188 Hundred eighty-eight
84 2 Two
85 4 Four
86 6 Six
87 8 Eight
88 SELECT * FROM tsp_00;
89 a b
90 5 Five
91 SELECT * FROM tsp_01;
92 a b
93 1 One
94 SELECT * FROM tsp_02;
95 a b
96 SELECT * FROM tsp_03;
97 a b
98 3 Three
99 SELECT * FROM tsp_04;
100 a b
101 9 Nine
102 CREATE INDEX id_t_10_b USING BTREE ON t_10 (b);
103 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
104 ERROR HY000: Tables have different definitions
105 CREATE INDEX id_tp_b USING BTREE ON tp (b);
106 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
107 ERROR HY000: Tables have different definitions
108 DROP INDEX id_t_10_b ON t_10;
109 DROP INDEX id_tp_b ON tp;
110 ALTER TABLE t_10 ADD UNIQUE INDEX USING BTREE (a);
111 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
112 ERROR HY000: Tables have different definitions
113 ALTER TABLE tp ADD UNIQUE INDEX USING BTREE (a);
114 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
115 show create table t_10;
116 Table Create Table
117 t_10 CREATE TABLE `t_10` (
118 `a` int NOT NULL,
119 `b` varchar(55) DEFAULT NULL,
120 PRIMARY KEY (`a`),
121 UNIQUE KEY `a` (`a`) USING BTREE
122 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
123 show create table tp ;
124 Table Create Table
125 tp CREATE TABLE `tp` (
126 `a` int NOT NULL,
127 `b` varchar(55) DEFAULT NULL,
128 PRIMARY KEY (`a`),
129 UNIQUE KEY `a` (`a`) USING BTREE
130 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
131 /*!50100 PARTITION BY RANGE (`a`)
132 (PARTITION p0 VALUES LESS THAN (10) ENGINE = InnoDB,
133 PARTITION p1 VALUES LESS THAN (100) ENGINE = InnoDB,
134 PARTITION p2 VALUES LESS THAN (1000) ENGINE = InnoDB) */
135 ALTER TABLE tp DROP INDEX a;
136 ALTER TABLE t_10 DROP INDEX a;
137 ALTER TABLE tp ADD UNIQUE INDEX USING BTREE (a,b);
138 ALTER TABLE t_10 ADD UNIQUE INDEX USING BTREE (a,b);
139 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
140 show create table t_10;
141 Table Create Table
142 t_10 CREATE TABLE `t_10` (
143 `a` int NOT NULL,
144 `b` varchar(55) DEFAULT NULL,
145 PRIMARY KEY (`a`),
146 UNIQUE KEY `a` (`a`,`b`) USING BTREE
147 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
148 show create table tp ;
149 Table Create Table
150 tp CREATE TABLE `tp` (
151 `a` int NOT NULL,
152 `b` varchar(55) DEFAULT NULL,
153 PRIMARY KEY (`a`),
154 UNIQUE KEY `a` (`a`,`b`) USING BTREE
155 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
156 /*!50100 PARTITION BY RANGE (`a`)
157 (PARTITION p0 VALUES LESS THAN (10) ENGINE = InnoDB,
158 PARTITION p1 VALUES LESS THAN (100) ENGINE = InnoDB,
159 PARTITION p2 VALUES LESS THAN (1000) ENGINE = InnoDB) */
160 DROP TABLE IF EXISTS t_10;
161 DROP TABLE IF EXISTS t_100;
162 DROP TABLE IF EXISTS t_1000;
163 DROP TABLE IF EXISTS tp;
164 DROP TABLE IF EXISTS tsp;
165 DROP TABLE IF EXISTS tsp_00;
166 DROP TABLE IF EXISTS tsp_01;
167 DROP TABLE IF EXISTS tsp_02;
168 DROP TABLE IF EXISTS tsp_03;
169 DROP TABLE IF EXISTS tsp_04;
170 DROP TABLE IF EXISTS t_empty;
171 DROP TABLE IF EXISTS t_null;