Debian Codegraph @

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

raw
1 # ------------------------------------------------------------
2 # Start server with old datadir with
3 # Table t1_part and t2_part
4 # having 2 partitions p0 and p1
5 # having c1, c2 normal columns
6 # +------+------+
7 # | c1 | c2 |
8 # +------+------+
9 # | 10 | r1c2 |
10 # +------+------+
11 #
12 # Table t3_part (partition p0, p1)
13 # having c1, c2 normal columns
14 # having c3 INSTANT ADD column with default value
15 # partition p2 added.
16 # having c4 INSTANT ADD column with default value
17 # +------+------+--------+--------+
18 # | c1 | c2 | c3 | c4 |
19 # +------+------+--------+--------+
20 # | 10 | r1c2 | def_c3 | def_c4 |
21 # +------+------+--------+--------+
22 # ------------------------------------------------------------
23 # Stop the running the server
24 # Copy and unzip the datadir.
25 # Restart the server against the unzipped datadir
26 # restart: --datadir=DATADIR --innodb-page-size=16k
27 # ------------------------------------------------------------
28 # TEST 1 : Old version tables have no INSTANT ADD Columns
29 # ------------------------------------------------------------
30 # ------------------------------------------------------------
31 # Check metadata of upgraded table t1_part [c1, c2]
32 # Expectation : New INSTANT METADATA is not present.
33 # ------------------------------------------------------------
34 # Metadata from INFORMATION_SCHEMA.TABLES
35 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
36 test/t1_part#p#p0 5 0 0
37 # Metadata from INFORMATION_SCHEMA.COLUMNS
38 NAME POS MTYPE PRTYPE HAS_DEFAULT
39 c1 0 6 1027 0
40 c2 1 13 16711934 0
41 # Metadata from INFORMATION_SCHEMA.TABLES
42 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
43 test/t1_part#p#p1 5 0 0
44 # Metadata from INFORMATION_SCHEMA.COLUMNS
45 NAME POS MTYPE PRTYPE HAS_DEFAULT
46 c1 0 6 1027 0
47 c2 1 13 16711934 0
48 # ------------------------------------------------------------
49 # INSTANT DROP a column and check metadata t1_part [c1, -c2]
50 # Expectation : New INSTANT METADATA is populated.
51 # ------------------------------------------------------------
52 ALTER TABLE t1_part DROP COLUMN c2, ALGORITHM=INSTANT;
53 # Metadata from INFORMATION_SCHEMA.TABLES
54 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
55 test/t1_part#p#p0 4 0 1
56 # Metadata from INFORMATION_SCHEMA.COLUMNS
57 NAME POS MTYPE PRTYPE HAS_DEFAULT
58 c1 0 6 1027 0
59 # Metadata from INFORMATION_SCHEMA.TABLES
60 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
61 test/t1_part#p#p1 4 0 1
62 # Metadata from INFORMATION_SCHEMA.COLUMNS
63 NAME POS MTYPE PRTYPE HAS_DEFAULT
64 c1 0 6 1027 0
65 # ------------------------------------------------------------
66 # Check metadata of upgraded table t2_part [c1, c2]
67 # Expectation : New INSTANT METADATA is not present.
68 # ------------------------------------------------------------
69 # Metadata from INFORMATION_SCHEMA.TABLES
70 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
71 test/t2_part#p#p0 5 0 0
72 # Metadata from INFORMATION_SCHEMA.COLUMNS
73 NAME POS MTYPE PRTYPE HAS_DEFAULT
74 c1 0 6 1027 0
75 c2 1 13 16711934 0
76 # Metadata from INFORMATION_SCHEMA.TABLES
77 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
78 test/t2_part#p#p1 5 0 0
79 # Metadata from INFORMATION_SCHEMA.COLUMNS
80 NAME POS MTYPE PRTYPE HAS_DEFAULT
81 c1 0 6 1027 0
82 c2 1 13 16711934 0
83 # ------------------------------------------------------------
84 # INSTANT ADD a column and check metadata t2_part [c1, c2, +c3]
85 # Expectation : New INSTANT METADATA is populated.
86 # ------------------------------------------------------------
87 ALTER TABLE t2_part ADD COLUMN c3 CHAR(10) DEFAULT "c3_def", ALGORITHM=INSTANT;
88 # Metadata from INFORMATION_SCHEMA.TABLES
89 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
90 test/t2_part#p#p0 6 0 1
91 # Metadata from INFORMATION_SCHEMA.COLUMNS
92 NAME POS MTYPE PRTYPE HAS_DEFAULT
93 c1 0 6 1027 0
94 c2 1 13 16711934 0
95 c3 2 13 16711934 1
96 # Metadata from INFORMATION_SCHEMA.TABLES
97 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
98 test/t2_part#p#p1 6 0 1
99 # Metadata from INFORMATION_SCHEMA.COLUMNS
100 NAME POS MTYPE PRTYPE HAS_DEFAULT
101 c1 0 6 1027 0
102 c2 1 13 16711934 0
103 c3 2 13 16711934 1
104 # ------------------------------------------------------------
105 # INSTANT DROP a column and check metadata t2_part [c1, -c2, c3]
106 # Expectation : New INSTANT METADATA is updated.
107 # ------------------------------------------------------------
108 ALTER TABLE t2_part DROP COLUMN c2, ALGORITHM=INSTANT;
109 # Metadata from INFORMATION_SCHEMA.TABLES
110 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
111 test/t2_part#p#p0 5 0 2
112 # Metadata from INFORMATION_SCHEMA.COLUMNS
113 NAME POS MTYPE PRTYPE HAS_DEFAULT
114 c1 0 6 1027 0
115 c3 1 13 16711934 1
116 # Metadata from INFORMATION_SCHEMA.TABLES
117 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
118 test/t2_part#p#p1 5 0 2
119 # Metadata from INFORMATION_SCHEMA.COLUMNS
120 NAME POS MTYPE PRTYPE HAS_DEFAULT
121 c1 0 6 1027 0
122 c3 1 13 16711934 1
123 DROP TABLE t1_part;
124 DROP TABLE t2_part;
125 # ------------------------------------------------------------
126 # TEST 2 : Old version tables have INSTANT ADD Columns
127 # ------------------------------------------------------------
128 # ------------------------------------------------------------
129 # Check metadata of upgraded table t3_part [c1, c2, c3, c4]
130 # Expectation : Old INSTANT METADATA is present and has
131 # different INSTANT_COLS for p2.
132 # No default value for c3 for p2.
133 # New INSTANT METADATA is not present.
134 # ------------------------------------------------------------
135 # Metadata from INFORMATION_SCHEMA.TABLES
136 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
137 test/t3_part#p#p0 7 2 0
138 # Metadata from INFORMATION_SCHEMA.COLUMNS
139 NAME POS MTYPE PRTYPE HAS_DEFAULT
140 c1 0 6 1027 0
141 c2 1 13 16711934 0
142 c3 2 13 16711934 1
143 c4 3 13 16711934 1
144 # Metadata from INFORMATION_SCHEMA.TABLES
145 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
146 test/t3_part#p#p1 7 2 0
147 # Metadata from INFORMATION_SCHEMA.COLUMNS
148 NAME POS MTYPE PRTYPE HAS_DEFAULT
149 c1 0 6 1027 0
150 c2 1 13 16711934 0
151 c3 2 13 16711934 1
152 c4 3 13 16711934 1
153 # Metadata from INFORMATION_SCHEMA.TABLES
154 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
155 test/t3_part#p#p2 7 3 0
156 # Metadata from INFORMATION_SCHEMA.COLUMNS
157 NAME POS MTYPE PRTYPE HAS_DEFAULT
158 c1 0 6 1027 0
159 c2 1 13 16711934 0
160 c3 2 13 16711934 0
161 c4 3 13 16711934 1
162 # -----------------------------------------------------------------------
163 # INSTANT ADD a new column and check metadata t3_part [c1, c2, c3, c4, +c5]
164 # Expectation : Old INSTANT METADATA stays same.
165 # New INSTANT METADATA is populated.
166 # Default value for c5 in each partition.
167 # -----------------------------------------------------------------------
168 ALTER TABLE t3_part ADD COLUMN c5 CHAR(10) DEFAULT "c5_def", ALGORITHM=INSTANT;
169 # Metadata from INFORMATION_SCHEMA.TABLES
170 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
171 test/t3_part#p#p0 8 2 1
172 # Metadata from INFORMATION_SCHEMA.COLUMNS
173 NAME POS MTYPE PRTYPE HAS_DEFAULT
174 c1 0 6 1027 0
175 c2 1 13 16711934 0
176 c3 2 13 16711934 1
177 c4 3 13 16711934 1
178 c5 4 13 16711934 1
179 # Metadata from INFORMATION_SCHEMA.TABLES
180 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
181 test/t3_part#p#p1 8 2 1
182 # Metadata from INFORMATION_SCHEMA.COLUMNS
183 NAME POS MTYPE PRTYPE HAS_DEFAULT
184 c1 0 6 1027 0
185 c2 1 13 16711934 0
186 c3 2 13 16711934 1
187 c4 3 13 16711934 1
188 c5 4 13 16711934 1
189 # Metadata from INFORMATION_SCHEMA.TABLES
190 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
191 test/t3_part#p#p2 8 3 1
192 # Metadata from INFORMATION_SCHEMA.COLUMNS
193 NAME POS MTYPE PRTYPE HAS_DEFAULT
194 c1 0 6 1027 0
195 c2 1 13 16711934 0
196 c3 2 13 16711934 0
197 c4 3 13 16711934 1
198 c5 4 13 16711934 1
199 # --------------------------------------------------------------------
200 # Add a new partition p3.
201 # Expectation : Old INSTANT METADATA stays same.
202 # Default value for c5 in each partition.
203 # -----------------------------------------------------------------------
204 ALTER TABLE t3_part ADD PARTITION (PARTITION p3 VALUES LESS THAN (400));
205 # Metadata from INFORMATION_SCHEMA.TABLES
206 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
207 test/t3_part#p#p0 8 2 1
208 # Metadata from INFORMATION_SCHEMA.COLUMNS
209 NAME POS MTYPE PRTYPE HAS_DEFAULT
210 c1 0 6 1027 0
211 c2 1 13 16711934 0
212 c3 2 13 16711934 1
213 c4 3 13 16711934 1
214 c5 4 13 16711934 1
215 # Metadata from INFORMATION_SCHEMA.TABLES
216 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
217 test/t3_part#p#p1 8 2 1
218 # Metadata from INFORMATION_SCHEMA.COLUMNS
219 NAME POS MTYPE PRTYPE HAS_DEFAULT
220 c1 0 6 1027 0
221 c2 1 13 16711934 0
222 c3 2 13 16711934 1
223 c4 3 13 16711934 1
224 c5 4 13 16711934 1
225 # Metadata from INFORMATION_SCHEMA.TABLES
226 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
227 test/t3_part#p#p2 8 3 1
228 # Metadata from INFORMATION_SCHEMA.COLUMNS
229 NAME POS MTYPE PRTYPE HAS_DEFAULT
230 c1 0 6 1027 0
231 c2 1 13 16711934 0
232 c3 2 13 16711934 0
233 c4 3 13 16711934 1
234 c5 4 13 16711934 1
235 # Metadata from INFORMATION_SCHEMA.TABLES
236 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
237 test/t3_part#p#p3 8 0 1
238 # Metadata from INFORMATION_SCHEMA.COLUMNS
239 NAME POS MTYPE PRTYPE HAS_DEFAULT
240 c1 0 6 1027 0
241 c2 1 13 16711934 0
242 c3 2 13 16711934 0
243 c4 3 13 16711934 0
244 c5 4 13 16711934 1
245 # --------------------------------------------------------------------
246 # INSTANT DROP a normal column and check metadata t3_part [c1, -c2, c3, c4, c5]
247 # Expectation : Old INSTANT METADATA stays same.
248 # New INSTANT METADATA is updated.
249 # ---------------------------------------------------------------------
250 ALTER TABLE t3_part DROP COLUMN c2, ALGORITHM=INSTANT;
251 # Metadata from INFORMATION_SCHEMA.TABLES
252 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
253 test/t3_part#p#p0 7 2 2
254 # Metadata from INFORMATION_SCHEMA.COLUMNS
255 NAME POS MTYPE PRTYPE HAS_DEFAULT
256 c1 0 6 1027 0
257 c3 1 13 16711934 1
258 c4 2 13 16711934 1
259 c5 3 13 16711934 1
260 # Metadata from INFORMATION_SCHEMA.TABLES
261 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
262 test/t3_part#p#p1 7 2 2
263 # Metadata from INFORMATION_SCHEMA.COLUMNS
264 NAME POS MTYPE PRTYPE HAS_DEFAULT
265 c1 0 6 1027 0
266 c3 1 13 16711934 1
267 c4 2 13 16711934 1
268 c5 3 13 16711934 1
269 # Metadata from INFORMATION_SCHEMA.TABLES
270 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
271 test/t3_part#p#p2 7 3 2
272 # Metadata from INFORMATION_SCHEMA.COLUMNS
273 NAME POS MTYPE PRTYPE HAS_DEFAULT
274 c1 0 6 1027 0
275 c3 1 13 16711934 0
276 c4 2 13 16711934 1
277 c5 3 13 16711934 1
278 # Metadata from INFORMATION_SCHEMA.TABLES
279 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
280 test/t3_part#p#p3 7 0 2
281 # Metadata from INFORMATION_SCHEMA.COLUMNS
282 NAME POS MTYPE PRTYPE HAS_DEFAULT
283 c1 0 6 1027 0
284 c3 1 13 16711934 0
285 c4 2 13 16711934 0
286 c5 3 13 16711934 1
287 # -----------------------------------------------------------------------
288 # INSTANT DROP an INSTANT column and check metadata t3_part [c1, ~c2, ~c3, c4, c5]
289 # Expectation : Old INSTANT METADATA stays same.
290 # New INSTANT METADATA is updated.
291 # -----------------------------------------------------------------------
292 ALTER TABLE t3_part DROP COLUMN c3, ALGORITHM=INSTANT;
293 # Metadata from INFORMATION_SCHEMA.TABLES
294 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
295 test/t3_part#p#p0 6 2 3
296 # Metadata from INFORMATION_SCHEMA.COLUMNS
297 NAME POS MTYPE PRTYPE HAS_DEFAULT
298 c1 0 6 1027 0
299 c4 1 13 16711934 1
300 c5 2 13 16711934 1
301 # Metadata from INFORMATION_SCHEMA.TABLES
302 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
303 test/t3_part#p#p1 6 2 3
304 # Metadata from INFORMATION_SCHEMA.COLUMNS
305 NAME POS MTYPE PRTYPE HAS_DEFAULT
306 c1 0 6 1027 0
307 c4 1 13 16711934 1
308 c5 2 13 16711934 1
309 # Metadata from INFORMATION_SCHEMA.TABLES
310 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
311 test/t3_part#p#p2 6 3 3
312 # Metadata from INFORMATION_SCHEMA.COLUMNS
313 NAME POS MTYPE PRTYPE HAS_DEFAULT
314 c1 0 6 1027 0
315 c4 1 13 16711934 0
316 c5 2 13 16711934 1
317 # Metadata from INFORMATION_SCHEMA.TABLES
318 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
319 test/t3_part#p#p3 6 0 3
320 # Metadata from INFORMATION_SCHEMA.COLUMNS
321 NAME POS MTYPE PRTYPE HAS_DEFAULT
322 c1 0 6 1027 0
323 c4 1 13 16711934 0
324 c5 2 13 16711934 1
325 # -----------------------------------------------------------------------------
326 # INSTANT DROP newly added column and check metadata t3_part [c1, ~c2, ~c3, c4, -c5]
327 # Expectation : Old INSTANT METADATA stays same.
328 # New INSTANT METADATA is updated.
329 # -----------------------------------------------------------------------------
330 ALTER TABLE t3_part DROP COLUMN c5, ALGORITHM=INSTANT;
331 # Metadata from INFORMATION_SCHEMA.TABLES
332 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
333 test/t3_part#p#p0 5 2 4
334 # Metadata from INFORMATION_SCHEMA.COLUMNS
335 NAME POS MTYPE PRTYPE HAS_DEFAULT
336 c1 0 6 1027 0
337 c4 1 13 16711934 1
338 # Metadata from INFORMATION_SCHEMA.TABLES
339 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
340 test/t3_part#p#p1 5 2 4
341 # Metadata from INFORMATION_SCHEMA.COLUMNS
342 NAME POS MTYPE PRTYPE HAS_DEFAULT
343 c1 0 6 1027 0
344 c4 1 13 16711934 1
345 # Metadata from INFORMATION_SCHEMA.TABLES
346 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
347 test/t3_part#p#p2 5 3 4
348 # Metadata from INFORMATION_SCHEMA.COLUMNS
349 NAME POS MTYPE PRTYPE HAS_DEFAULT
350 c1 0 6 1027 0
351 c4 1 13 16711934 0
352 # Metadata from INFORMATION_SCHEMA.TABLES
353 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
354 test/t3_part#p#p3 5 0 4
355 # Metadata from INFORMATION_SCHEMA.COLUMNS
356 NAME POS MTYPE PRTYPE HAS_DEFAULT
357 c1 0 6 1027 0
358 c4 1 13 16711934 1
359 DROP TABLE t3_part;
360 # -------------------------------------------------
361 # TEST 3 : New tables with INSTANT ADD/DROP Columns
362 # -------------------------------------------------
363 CREATE TABLE t1_part (c1 INT, c2 CHAR(10)) PARTITION BY RANGE(c1) (PARTITION p0 VALUES LESS THAN (100), PARTITION p1 VALUES LESS THAN (200));
364 INSERT INTO t1_part VALUES(10, "r1c2");
365 # ------------------------------------------------------------
366 # Check metadata of table t1_part [c1, c2]
367 # Expectation : Old INSTANT METADATA is not present
368 # New INSTANT METADATA is not present.
369 # ------------------------------------------------------------
370 # Metadata from INFORMATION_SCHEMA.TABLES
371 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
372 test/t1_part#p#p0 5 0 0
373 # Metadata from INFORMATION_SCHEMA.COLUMNS
374 NAME POS MTYPE PRTYPE HAS_DEFAULT
375 c1 0 6 1027 0
376 c2 1 13 16711934 0
377 # Metadata from INFORMATION_SCHEMA.TABLES
378 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
379 test/t1_part#p#p1 5 0 0
380 # Metadata from INFORMATION_SCHEMA.COLUMNS
381 NAME POS MTYPE PRTYPE HAS_DEFAULT
382 c1 0 6 1027 0
383 c2 1 13 16711934 0
384 # -----------------------------------------------------------------------
385 # INSTANT DROP a column and check metadata t1_part [c1, -c2]
386 # Expectation : Old INSTANT METADATA is not present.
387 # New INSTANT METADATA is populated.
388 # -----------------------------------------------------------------------
389 ALTER TABLE t1_part DROP COLUMN c2, ALGORITHM=INSTANT;
390 # Metadata from INFORMATION_SCHEMA.TABLES
391 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
392 test/t1_part#p#p0 4 0 1
393 # Metadata from INFORMATION_SCHEMA.COLUMNS
394 NAME POS MTYPE PRTYPE HAS_DEFAULT
395 c1 0 6 1027 0
396 # Metadata from INFORMATION_SCHEMA.TABLES
397 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
398 test/t1_part#p#p1 4 0 1
399 # Metadata from INFORMATION_SCHEMA.COLUMNS
400 NAME POS MTYPE PRTYPE HAS_DEFAULT
401 c1 0 6 1027 0
402 # -----------------------------------------------------------------------
403 # INSTANT ADD a column and check metadata t1_part [c1, ~c2, +c3]
404 # Expectation : Old INSTANT METADATA not present.
405 # New INSTANT METADATA is updated.
406 # -----------------------------------------------------------------------
407 ALTER TABLE t1_part ADD COLUMN c3 CHAR(10) DEFAULT "c3_def", ALGORITHM=INSTANT;
408 # Metadata from INFORMATION_SCHEMA.TABLES
409 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
410 test/t1_part#p#p0 5 0 2
411 # Metadata from INFORMATION_SCHEMA.COLUMNS
412 NAME POS MTYPE PRTYPE HAS_DEFAULT
413 c1 0 6 1027 0
414 c3 1 13 16711934 1
415 # Metadata from INFORMATION_SCHEMA.TABLES
416 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
417 test/t1_part#p#p1 5 0 2
418 # Metadata from INFORMATION_SCHEMA.COLUMNS
419 NAME POS MTYPE PRTYPE HAS_DEFAULT
420 c1 0 6 1027 0
421 c3 1 13 16711934 1
422 # --------------------------------------------------------------------
423 # Add a new partition p2.
424 # Expectation : Old INSTANT METADATA not present.
425 # New INSTANT METADATA is updated.
426 # Default value for c3 in each partition.
427 # -----------------------------------------------------------------------
428 ALTER TABLE t1_part ADD PARTITION (PARTITION p2 VALUES LESS THAN (300));
429 # Metadata from INFORMATION_SCHEMA.TABLES
430 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
431 test/t1_part#p#p0 5 0 2
432 # Metadata from INFORMATION_SCHEMA.COLUMNS
433 NAME POS MTYPE PRTYPE HAS_DEFAULT
434 c1 0 6 1027 0
435 c3 1 13 16711934 1
436 # Metadata from INFORMATION_SCHEMA.TABLES
437 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
438 test/t1_part#p#p1 5 0 2
439 # Metadata from INFORMATION_SCHEMA.COLUMNS
440 NAME POS MTYPE PRTYPE HAS_DEFAULT
441 c1 0 6 1027 0
442 c3 1 13 16711934 1
443 # Metadata from INFORMATION_SCHEMA.TABLES
444 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
445 test/t1_part#p#p2 5 0 2
446 # Metadata from INFORMATION_SCHEMA.COLUMNS
447 NAME POS MTYPE PRTYPE HAS_DEFAULT
448 c1 0 6 1027 0
449 c3 1 13 16711934 1
450 # ----------------------------------------------------------------------------
451 # INSTANT DROP the INSTANT ADD column and check metadata t1_part [c1, ~c2, -c3]
452 # Expectation : Old INSTANT METADATA is not present.
453 # New INSTANT METADATA is updated.
454 # ----------------------------------------------------------------------------
455 ALTER TABLE t1_part DROP COLUMN c3, ALGORITHM=INSTANT;
456 # Metadata from INFORMATION_SCHEMA.TABLES
457 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
458 test/t1_part#p#p0 4 0 3
459 # Metadata from INFORMATION_SCHEMA.COLUMNS
460 NAME POS MTYPE PRTYPE HAS_DEFAULT
461 c1 0 6 1027 0
462 # Metadata from INFORMATION_SCHEMA.TABLES
463 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
464 test/t1_part#p#p1 4 0 3
465 # Metadata from INFORMATION_SCHEMA.COLUMNS
466 NAME POS MTYPE PRTYPE HAS_DEFAULT
467 c1 0 6 1027 0
468 # Metadata from INFORMATION_SCHEMA.TABLES
469 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
470 test/t1_part#p#p2 4 0 3
471 # Metadata from INFORMATION_SCHEMA.COLUMNS
472 NAME POS MTYPE PRTYPE HAS_DEFAULT
473 c1 0 6 1027 0
474 DROP TABLE t1_part;
475 ###########
476 # CLEANUP #
477 ###########
478 # Shutdown server
479 # Remove copied files
480 # Restarting server to restore server state
481 # restart