Debian Codegraph @

mysql-test/suite/parts/r/partition_exch_qa_2.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 TABLE t_11(a INT,b VARCHAR(55)) SELECT * FROM t_10;
103 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_11;
104 ERROR HY000: Tables have different definitions
105 DROP TABLE IF EXISTS t_11;
106 CREATE TABLE t_11(a INT,b CHAR(55),PRIMARY KEY(a)) ENGINE= InnoDB SELECT * FROM t_10;
107 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_11;
108 ERROR HY000: Tables have different definitions
109 DROP TABLE IF EXISTS t_11;
110 CREATE TABLE t_11(a INT,b VARCHAR(55),PRIMARY KEY(a)) ENGINE= MEMORY SELECT * FROM t_10;
111 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_11;
112 ERROR HY000: The mix of handlers in the partitions is not allowed in this version of MySQL
113 DROP TABLE IF EXISTS t_11;
114 CREATE TABLE t_11(a INT,b CHAR(55),PRIMARY KEY(a)) ENGINE= InnoDB
115 PARTITION BY KEY() AS SELECT * FROM t_10;
116 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_11;
117 ERROR HY000: Table to exchange with partition is partitioned: 't_11'
118 DROP TABLE IF EXISTS t_11;
119 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE tsp;
120 ERROR HY000: Table to exchange with partition is partitioned: 'tsp'
121 ALTER TABLE tsp EXCHANGE PARTITION p0 WITH TABLE t_10;
122 ERROR HY000: Subpartitioned table, use subpartition instead of partition
123 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_100;
124 ERROR HY000: Found a row that does not match the partition
125 ALTER TABLE tp EXCHANGE PARTITION p2 WITH TABLE t_10;
126 ERROR HY000: Found a row that does not match the partition
127 DROP TABLE IF EXISTS t_10;
128 DROP TABLE IF EXISTS t_100;
129 DROP TABLE IF EXISTS t_1000;
130 DROP TABLE IF EXISTS tp;
131 DROP TABLE IF EXISTS tsp;
132 DROP TABLE IF EXISTS tsp_00;
133 DROP TABLE IF EXISTS tsp_01;
134 DROP TABLE IF EXISTS tsp_02;
135 DROP TABLE IF EXISTS tsp_03;
136 DROP TABLE IF EXISTS tsp_04;
137 DROP TABLE IF EXISTS t_empty;
138 DROP TABLE IF EXISTS t_null;