Debian Codegraph @

mysql-test/suite/innodb/r/discarded_partition_upgrade_from_80.result

raw
1 # Testing discarded partitions imported from 8.0.20
2 # restart: --datadir=BUGDATADIR
3 SELECT * FROM partitions.t1;
4 ERROR HY000: Tablespace has been discarded for table 't1'
5 SELECT * FROM partitions.t1 PARTITION (p0);
6 ERROR HY000: Tablespace has been discarded for table 't1'
7 SELECT * FROM partitions.t1 PARTITION (p1);
8 c1 c2
9 SELECT * FROM partitions.t1 PARTITION (p2);
10 c1 c2
11 SELECT * FROM partitions.t1 PARTITION (p3);
12 c1 c2
13 SELECT * FROM partitions.t2;
14 c1 c2
15 SELECT * FROM partitions.t2 PARTITION (p0);
16 c1 c2
17 SELECT * FROM partitions.t2 PARTITION (p1);
18 c1 c2
19 SELECT * FROM partitions.t2 PARTITION (p2);
20 c1 c2
21 SELECT * FROM partitions.t2 PARTITION (p3);
22 c1 c2
23 SELECT * FROM partitions.t3;
24 ERROR HY000: Tablespace has been discarded for table 't3'
25 SELECT * FROM partitions.t3 PARTITION (p0);
26 ERROR HY000: Tablespace has been discarded for table 't3'
27 SELECT * FROM partitions.t3 PARTITION (p1);
28 c1 c2
29 SELECT * FROM partitions.t3 PARTITION (p2);
30 c1 c2
31 SELECT * FROM partitions.t3 PARTITION (p3);
32 c1 c2
33 SELECT * FROM partitions.t4;
34 ERROR HY000: Tablespace has been discarded for table 't4'
35 SELECT * FROM partitions.t4 PARTITION (p0);
36 ERROR HY000: Tablespace has been discarded for table 't4'
37 SELECT * FROM partitions.t4 PARTITION (p0sp0);
38 ERROR HY000: Tablespace has been discarded for table 't4'
39 SELECT * FROM partitions.t4 PARTITION (p0sp1);
40 ERROR HY000: Tablespace has been discarded for table 't4'
41 SELECT * FROM partitions.t4 PARTITION (p1);
42 ERROR HY000: Tablespace has been discarded for table 't4'
43 SELECT * FROM partitions.t4 PARTITION (p1sp0);
44 ERROR HY000: Tablespace has been discarded for table 't4'
45 SELECT * FROM partitions.t4 PARTITION (p1sp1);
46 c1 c2
47 SELECT * FROM partitions.t4 PARTITION (p2);
48 c1 c2
49 SELECT * FROM partitions.t4 PARTITION (p2sp0);
50 c1 c2
51 SELECT * FROM partitions.t4 PARTITION (p2sp1);
52 c1 c2
53 SELECT * FROM partitions.t5;
54 ERROR HY000: Tablespace has been discarded for table 't5'
55 SELECT * FROM partitions.t5 PARTITION (p0);
56 c1 c2
57 SELECT * FROM partitions.t5 PARTITION (p0sp0);
58 c1 c2
59 SELECT * FROM partitions.t5 PARTITION (p0sp1);
60 c1 c2
61 SELECT * FROM partitions.t5 PARTITION (p1);
62 ERROR HY000: Tablespace has been discarded for table 't5'
63 SELECT * FROM partitions.t5 PARTITION (p1sp0);
64 c1 c2
65 SELECT * FROM partitions.t5 PARTITION (p1sp1);
66 ERROR HY000: Tablespace has been discarded for table 't5'
67 SELECT * FROM partitions.t5 PARTITION (p2);
68 c1 c2
69 SELECT * FROM partitions.t5 PARTITION (p2sp0);
70 c1 c2
71 SELECT * FROM partitions.t5 PARTITION (p2sp1);
72 c1 c2
73 SELECT * FROM partitions.t6;
74 ERROR HY000: Tablespace has been discarded for table 't6'
75 SELECT * FROM partitions.t6 PARTITION (p0);
76 ERROR HY000: Tablespace has been discarded for table 't6'
77 SELECT * FROM partitions.t6 PARTITION (p0sp0);
78 ERROR HY000: Tablespace has been discarded for table 't6'
79 SELECT * FROM partitions.t6 PARTITION (p0sp1);
80 ERROR HY000: Tablespace has been discarded for table 't6'
81 SELECT * FROM partitions.t6 PARTITION (p1);
82 ERROR HY000: Tablespace has been discarded for table 't6'
83 SELECT * FROM partitions.t6 PARTITION (p1sp0);
84 c1 c2
85 SELECT * FROM partitions.t6 PARTITION (p1sp1);
86 ERROR HY000: Tablespace has been discarded for table 't6'
87 SELECT * FROM partitions.t6 PARTITION (p2);
88 c1 c2
89 SELECT * FROM partitions.t6 PARTITION (p2sp0);
90 c1 c2
91 SELECT * FROM partitions.t6 PARTITION (p2sp1);
92 c1 c2
93 SELECT * FROM partitions.t7;
94 c1 c2
95 SELECT * FROM partitions.t7 PARTITION (p0);
96 c1 c2
97 SELECT * FROM partitions.t7 PARTITION (p0sp0);
98 c1 c2
99 SELECT * FROM partitions.t7 PARTITION (p0sp1);
100 c1 c2
101 SELECT * FROM partitions.t7 PARTITION (p1);
102 c1 c2
103 SELECT * FROM partitions.t7 PARTITION (p1sp0);
104 c1 c2
105 SELECT * FROM partitions.t7 PARTITION (p1sp1);
106 c1 c2
107 SELECT * FROM partitions.t7 PARTITION (p2);
108 c1 c2
109 SELECT * FROM partitions.t7 PARTITION (p2sp0);
110 c1 c2
111 SELECT * FROM partitions.t7 PARTITION (p2sp1);
112 c1 c2
113 ALTER TABLE partitions.t1 REBUILD PARTITION p0;
114 ERROR HY000: Tablespace has been discarded for table 't1'
115 ALTER TABLE partitions.t1 REBUILD PARTITION p1;
116 Warnings:
117 Warning 1814 InnoDB: Tablespace has been discarded for table 't1'
118 Warning 1814 InnoDB: Tablespace has been discarded for table 't1'
119 ALTER TABLE partitions.t1 REBUILD PARTITION p2;
120 Warnings:
121 Warning 1814 InnoDB: Tablespace has been discarded for table 't1'
122 ALTER TABLE partitions.t1 REBUILD PARTITION p3;
123 Warnings:
124 Warning 1814 InnoDB: Tablespace has been discarded for table 't1'
125 ALTER TABLE partitions.t2 REBUILD PARTITION p0;
126 ALTER TABLE partitions.t2 REBUILD PARTITION p1;
127 ALTER TABLE partitions.t2 REBUILD PARTITION p2;
128 ALTER TABLE partitions.t2 REBUILD PARTITION p3;
129 ALTER TABLE partitions.t3 REBUILD PARTITION p0;
130 ERROR HY000: Tablespace has been discarded for table 't3'
131 ALTER TABLE partitions.t3 REBUILD PARTITION p1;
132 Warnings:
133 Warning 1814 InnoDB: Tablespace has been discarded for table 't3'
134 Warning 1814 InnoDB: Tablespace has been discarded for table 't3'
135 ALTER TABLE partitions.t3 REBUILD PARTITION p2;
136 Warnings:
137 Warning 1814 InnoDB: Tablespace has been discarded for table 't3'
138 ALTER TABLE partitions.t3 REBUILD PARTITION p3;
139 Warnings:
140 Warning 1814 InnoDB: Tablespace has been discarded for table 't3'
141 ALTER TABLE partitions.t4 REBUILD PARTITION p0;
142 ERROR HY000: Tablespace has been discarded for table 't4'
143 ALTER TABLE partitions.t4 REBUILD PARTITION p1;
144 ERROR HY000: Tablespace has been discarded for table 't4'
145 ALTER TABLE partitions.t4 REBUILD PARTITION p2;
146 Warnings:
147 Warning 1814 InnoDB: Tablespace has been discarded for table 't4'
148 Warning 1814 InnoDB: Tablespace has been discarded for table 't4'
149 Warning 1814 InnoDB: Tablespace has been discarded for table 't4'
150 Warning 1814 InnoDB: Tablespace has been discarded for table 't4'
151 Warning 1814 InnoDB: Tablespace has been discarded for table 't4'
152 Warning 1814 InnoDB: Tablespace has been discarded for table 't4'
153 ALTER TABLE partitions.t5 REBUILD PARTITION p0;
154 Warnings:
155 Warning 1814 InnoDB: Tablespace has been discarded for table 't5'
156 ALTER TABLE partitions.t5 REBUILD PARTITION p1;
157 ERROR HY000: Tablespace has been discarded for table 't5'
158 ALTER TABLE partitions.t5 REBUILD PARTITION p2;
159 Warnings:
160 Warning 1814 InnoDB: Tablespace has been discarded for table 't5'
161 Warning 1814 InnoDB: Tablespace has been discarded for table 't5'
162 ALTER TABLE partitions.t6 REBUILD PARTITION p0;
163 ERROR HY000: Tablespace has been discarded for table 't6'
164 ALTER TABLE partitions.t6 REBUILD PARTITION p1;
165 ERROR HY000: Tablespace has been discarded for table 't6'
166 ALTER TABLE partitions.t6 REBUILD PARTITION p2;
167 Warnings:
168 Warning 1814 InnoDB: Tablespace has been discarded for table 't6'
169 Warning 1814 InnoDB: Tablespace has been discarded for table 't6'
170 Warning 1814 InnoDB: Tablespace has been discarded for table 't6'
171 Warning 1814 InnoDB: Tablespace has been discarded for table 't6'
172 Warning 1814 InnoDB: Tablespace has been discarded for table 't6'
173 Warning 1814 InnoDB: Tablespace has been discarded for table 't6'
174 ALTER TABLE partitions.t7 REBUILD PARTITION p0;
175 ALTER TABLE partitions.t7 REBUILD PARTITION p1;
176 ALTER TABLE partitions.t7 REBUILD PARTITION p2;
177 DROP TABLE partitions.t1;
178 DROP TABLE partitions.t2;
179 DROP TABLE partitions.t3;
180 DROP TABLE partitions.t4;
181 DROP TABLE partitions.t5;
182 DROP TABLE partitions.t6;
183 DROP TABLE partitions.t7;
184 DROP DATABASE partitions;
185 # restart