Debian Codegraph @

mysql-test/suite/parts/r/partition_exch_qa_13.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 INSERT INTO t_10 VALUES (10, "TEN");
103 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
104 ERROR HY000: Found a row that does not match the partition
105 SELECT * FROM tp WHERE a < 11;
106 a b
107 2 Two
108 4 Four
109 6 Six
110 8 Eight
111 SELECT * FROM t_10 WHERE a < 11;
112 a b
113 1 One
114 10 TEN
115 3 Three
116 5 Five
117 9 Nine
118 INSERT INTO t_1000 VALUES (99, "Ninetynine");
119 ALTER TABLE tp1 EXCHANGE PARTITION p2 WITH TABLE t_1000;
120 ERROR HY000: Found a row that does not match the partition
121 SELECT * FROM tp1 WHERE a < 1000 AND a > 98;
122 a b
123 112 Hundred twelve
124 114 Hundred fourteen
125 116 Hundred sixteen
126 118 Hundred eightteen
127 122 Hundred twenty-two
128 124 Hundred twenty-four
129 126 Hundred twenty-six
130 128 Hundred twenty-eight
131 162 Hundred sixty-two
132 164 Hundred sixty-four
133 166 Hundred sixty-six
134 168 Hundred sixty-eight
135 182 Hundred eighty-two
136 184 Hundred eighty-four
137 186 Hundred eighty-six
138 188 Hundred eighty-eight
139 SELECT * FROM t_1000 WHERE a < 1000 AND a > 98;
140 a b
141 111 Hundred elven
142 113 Hundred thirdteen
143 115 Hundred fiveteen
144 119 Hundred nineteen
145 131 Hundred thirty-one
146 133 Hundred thirty-three
147 135 Hundred thirty-five
148 139 Hundred thirty-nine
149 151 Hundred fifty-one
150 153 Hundred fifty-three
151 155 Hundred fity-five
152 159 Hundred fifty-nine
153 191 Hundred ninety-one
154 193 Hundred ninety-three
155 195 Hundred ninety-five
156 199 Hundred ninety-nine
157 99 Ninetynine
158 INSERT INTO tsp_03 VALUES (20, "Twenty");
159 ALTER TABLE tsp EXCHANGE PARTITION sp03 WITH TABLE tsp_03;
160 ERROR HY000: Found a row that does not match the partition
161 SELECT * FROM tsp;
162 a b
163 112 Hundred twelve
164 114 Hundred fourteen
165 116 Hundred sixteen
166 118 Hundred eightteen
167 12 twelve
168 122 Hundred twenty-two
169 124 Hundred twenty-four
170 126 Hundred twenty-six
171 128 Hundred twenty-eight
172 14 Fourteen
173 16 Sixteen
174 162 Hundred sixty-two
175 164 Hundred sixty-four
176 166 Hundred sixty-six
177 168 Hundred sixty-eight
178 18 Eightteen
179 182 Hundred eight-two
180 184 Hundred eighty-four
181 186 Hundred eighty-six
182 188 Hundred eighty-eight
183 2 Two
184 4 Four
185 6 Six
186 8 Eight
187 SELECT * FROM tsp_03;
188 a b
189 20 Twenty
190 3 Three
191 DROP TABLE tp1;
192 DROP TABLE IF EXISTS t_10;
193 DROP TABLE IF EXISTS t_100;
194 DROP TABLE IF EXISTS t_1000;
195 DROP TABLE IF EXISTS tp;
196 DROP TABLE IF EXISTS tsp;
197 DROP TABLE IF EXISTS tsp_00;
198 DROP TABLE IF EXISTS tsp_01;
199 DROP TABLE IF EXISTS tsp_02;
200 DROP TABLE IF EXISTS tsp_03;
201 DROP TABLE IF EXISTS tsp_04;
202 DROP TABLE IF EXISTS t_empty;
203 DROP TABLE IF EXISTS t_null;