Debian Codegraph @

mysql-test/suite/innodb/r/instant_ddl_upgrade_part_metadata_debug.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 # DD Metadata of columns in table
35 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
36 c1 1 MYSQL_TYPE_LONG 0 Visible table_id=TABLE_ID;
37 c2 2 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
38 DB_ROW_ID 3 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
39 DB_TRX_ID 4 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
40 DB_ROLL_PTR 5 MYSQL_TYPE_LONGLONG 0 SE table_id=TABLE_ID;
41 # DD Metadata of partitions in table
42 NAME DESCRIPTION_UTF8 SE_PRIVATE_DATA
43 p0 100 NULL
44 p1 200 NULL
45 # Metadata from INFORMATION_SCHEMA.TABLES
46 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
47 test/t1_part#p#p0 5 0 0 2 2 2
48 # Metadata from INFORMATION_SCHEMA.COLUMNS
49 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
50 c1 0 6 1027 0 0 0
51 c2 1 13 16711934 0 0 0
52 # Metadata from INFORMATION_SCHEMA.TABLES
53 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
54 test/t1_part#p#p1 5 0 0 2 2 2
55 # Metadata from INFORMATION_SCHEMA.COLUMNS
56 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
57 c1 0 6 1027 0 0 0
58 c2 1 13 16711934 0 0 0
59 # ------------------------------------------------------------
60 # INSTANT DROP a column and check metadata t1_part [c1, -c2]
61 # Expectation : New INSTANT METADATA is populated.
62 # ------------------------------------------------------------
63 ALTER TABLE t1_part DROP COLUMN c2, ALGORITHM=INSTANT;
64 # DD Metadata of columns in table
65 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
66 c1 1 MYSQL_TYPE_LONG 0 Visible physical_pos=3;table_id=TABLE_ID;
67 DB_ROW_ID 2 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID;
68 DB_TRX_ID 3 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
69 DB_ROLL_PTR 4 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
70 !hidden!_dropped_v1_p4_c2 5 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=1;
71 # DD Metadata of partitions in table
72 NAME DESCRIPTION_UTF8 SE_PRIVATE_DATA
73 p0 100 NULL
74 p1 200 NULL
75 # Metadata from INFORMATION_SCHEMA.TABLES
76 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
77 test/t1_part#p#p0 4 0 1 2 1 2
78 # Metadata from INFORMATION_SCHEMA.COLUMNS
79 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
80 c1 0 6 1027 0 0 0
81 !hidden!_dropped_v1_p4_c2 4 13 16711934 0 0 1
82 # Metadata from INFORMATION_SCHEMA.TABLES
83 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
84 test/t1_part#p#p1 4 0 1 2 1 2
85 # Metadata from INFORMATION_SCHEMA.COLUMNS
86 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
87 c1 0 6 1027 0 0 0
88 !hidden!_dropped_v1_p4_c2 4 13 16711934 0 0 1
89 # ------------------------------------------------------------
90 # Check metadata of upgraded table t2_part [c1, c2]
91 # Expectation : New INSTANT METADATA is not present.
92 # ------------------------------------------------------------
93 # DD Metadata of columns in table
94 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
95 c1 1 MYSQL_TYPE_LONG 0 Visible table_id=TABLE_ID;
96 c2 2 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
97 DB_ROW_ID 3 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
98 DB_TRX_ID 4 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
99 DB_ROLL_PTR 5 MYSQL_TYPE_LONGLONG 0 SE table_id=TABLE_ID;
100 # DD Metadata of partitions in table
101 NAME DESCRIPTION_UTF8 SE_PRIVATE_DATA
102 p0 100 NULL
103 p1 200 NULL
104 # Metadata from INFORMATION_SCHEMA.TABLES
105 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
106 test/t2_part#p#p0 5 0 0 2 2 2
107 # Metadata from INFORMATION_SCHEMA.COLUMNS
108 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
109 c1 0 6 1027 0 0 0
110 c2 1 13 16711934 0 0 0
111 # Metadata from INFORMATION_SCHEMA.TABLES
112 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
113 test/t2_part#p#p1 5 0 0 2 2 2
114 # Metadata from INFORMATION_SCHEMA.COLUMNS
115 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
116 c1 0 6 1027 0 0 0
117 c2 1 13 16711934 0 0 0
118 # ------------------------------------------------------------
119 # INSTANT ADD a column and check metadata t2_part [c1, c2, +c3]
120 # Expectation : New INSTANT METADATA is populated.
121 # ------------------------------------------------------------
122 ALTER TABLE t2_part ADD COLUMN c3 CHAR(10) DEFAULT "c3_def", ALGORITHM=INSTANT;
123 # DD Metadata of columns in table
124 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
125 c1 1 MYSQL_TYPE_LONG 0 Visible physical_pos=3;table_id=TABLE_ID;
126 c2 2 MYSQL_TYPE_STRING 0 Visible physical_pos=4;table_id=TABLE_ID;
127 c3 3 MYSQL_TYPE_STRING 0 Visible default=63335f64656620202020;physical_pos=5;table_id=TABLE_ID;version_added=1;
128 DB_ROW_ID 4 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID;
129 DB_TRX_ID 5 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
130 DB_ROLL_PTR 6 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
131 # DD Metadata of partitions in table
132 NAME DESCRIPTION_UTF8 SE_PRIVATE_DATA
133 p0 100 NULL
134 p1 200 NULL
135 # Metadata from INFORMATION_SCHEMA.TABLES
136 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
137 test/t2_part#p#p0 6 0 1 2 3 3
138 # Metadata from INFORMATION_SCHEMA.COLUMNS
139 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
140 c1 0 6 1027 0 0 0
141 c2 1 13 16711934 0 0 0
142 c3 2 13 16711934 1 1 0
143 # Metadata from INFORMATION_SCHEMA.TABLES
144 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
145 test/t2_part#p#p1 6 0 1 2 3 3
146 # Metadata from INFORMATION_SCHEMA.COLUMNS
147 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
148 c1 0 6 1027 0 0 0
149 c2 1 13 16711934 0 0 0
150 c3 2 13 16711934 1 1 0
151 # ------------------------------------------------------------
152 # INSTANT DROP a column and check metadata t2_part [c1, -c2, c3]
153 # Expectation : New INSTANT METADATA is updated.
154 # ------------------------------------------------------------
155 ALTER TABLE t2_part DROP COLUMN c2, ALGORITHM=INSTANT;
156 # DD Metadata of columns in table
157 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
158 c1 1 MYSQL_TYPE_LONG 0 Visible physical_pos=3;table_id=TABLE_ID;
159 c3 2 MYSQL_TYPE_STRING 0 Visible default=63335f64656620202020;physical_pos=5;table_id=TABLE_ID;version_added=1;
160 DB_ROW_ID 3 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID;
161 DB_TRX_ID 4 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
162 DB_ROLL_PTR 5 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
163 !hidden!_dropped_v2_p4_c2 6 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=2;
164 # DD Metadata of partitions in table
165 NAME DESCRIPTION_UTF8 SE_PRIVATE_DATA
166 p0 100 NULL
167 p1 200 NULL
168 # Metadata from INFORMATION_SCHEMA.TABLES
169 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
170 test/t2_part#p#p0 5 0 2 2 2 3
171 # Metadata from INFORMATION_SCHEMA.COLUMNS
172 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
173 c1 0 6 1027 0 0 0
174 c3 1 13 16711934 1 1 0
175 !hidden!_dropped_v2_p4_c2 5 13 16711934 0 0 2
176 # Metadata from INFORMATION_SCHEMA.TABLES
177 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
178 test/t2_part#p#p1 5 0 2 2 2 3
179 # Metadata from INFORMATION_SCHEMA.COLUMNS
180 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
181 c1 0 6 1027 0 0 0
182 c3 1 13 16711934 1 1 0
183 !hidden!_dropped_v2_p4_c2 5 13 16711934 0 0 2
184 DROP TABLE t1_part;
185 DROP TABLE t2_part;
186 # ------------------------------------------------------------
187 # TEST 2 : Old version tables have INSTANT ADD Columns
188 # ------------------------------------------------------------
189 # ------------------------------------------------------------
190 # Check metadata of upgraded table t3_part [c1, c2, c3, c4]
191 # Expectation : Old INSTANT METADATA is present and has
192 # different INSTANT_COLS for p2.
193 # No default value for c3 for p2.
194 # New INSTANT METADATA is not present.
195 # ------------------------------------------------------------
196 # DD Metadata of columns in table
197 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
198 c1 1 MYSQL_TYPE_LONG 0 Visible table_id=TABLE_ID;
199 c2 2 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
200 c3 3 MYSQL_TYPE_STRING 0 Visible default=6465665f633320202020;table_id=TABLE_ID;
201 c4 4 MYSQL_TYPE_STRING 0 Visible default=6465665f633420202020;table_id=TABLE_ID;
202 DB_ROW_ID 5 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
203 DB_TRX_ID 6 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
204 DB_ROLL_PTR 7 MYSQL_TYPE_LONGLONG 0 SE table_id=TABLE_ID;
205 # DD Metadata of partitions in table
206 NAME DESCRIPTION_UTF8 SE_PRIVATE_DATA
207 p0 100 instant_col=2;
208 p1 200 instant_col=2;
209 p2 300 instant_col=3;
210 # Metadata from INFORMATION_SCHEMA.TABLES
211 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
212 test/t3_part#p#p0 7 2 0 4 4 4
213 # Metadata from INFORMATION_SCHEMA.COLUMNS
214 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
215 c1 0 6 1027 0 0 0
216 c2 1 13 16711934 0 0 0
217 c3 2 13 16711934 1 0 0
218 c4 3 13 16711934 1 0 0
219 # Metadata from INFORMATION_SCHEMA.TABLES
220 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
221 test/t3_part#p#p1 7 2 0 4 4 4
222 # Metadata from INFORMATION_SCHEMA.COLUMNS
223 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
224 c1 0 6 1027 0 0 0
225 c2 1 13 16711934 0 0 0
226 c3 2 13 16711934 1 0 0
227 c4 3 13 16711934 1 0 0
228 # Metadata from INFORMATION_SCHEMA.TABLES
229 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
230 test/t3_part#p#p2 7 3 0 4 4 4
231 # Metadata from INFORMATION_SCHEMA.COLUMNS
232 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
233 c1 0 6 1027 0 0 0
234 c2 1 13 16711934 0 0 0
235 c3 2 13 16711934 0 0 0
236 c4 3 13 16711934 1 0 0
237 # -----------------------------------------------------------------------
238 # INSTANT ADD a new column and check metadata t3_part [c1, c2, c3, c4, +c5]
239 # Expectation : Old INSTANT METADATA stays same.
240 # New INSTANT METADATA is populated.
241 # Default value for c5 in each partition.
242 # -----------------------------------------------------------------------
243 ALTER TABLE t3_part ADD COLUMN c5 CHAR(10) DEFAULT "c5_def", ALGORITHM=INSTANT;
244 # DD Metadata of columns in table
245 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
246 c1 1 MYSQL_TYPE_LONG 0 Visible physical_pos=3;table_id=TABLE_ID;
247 c2 2 MYSQL_TYPE_STRING 0 Visible physical_pos=4;table_id=TABLE_ID;
248 c3 3 MYSQL_TYPE_STRING 0 Visible default=6465665f633320202020;physical_pos=5;table_id=TABLE_ID;
249 c4 4 MYSQL_TYPE_STRING 0 Visible default=6465665f633420202020;physical_pos=6;table_id=TABLE_ID;
250 c5 5 MYSQL_TYPE_STRING 0 Visible default=63355f64656620202020;physical_pos=7;table_id=TABLE_ID;version_added=1;
251 DB_ROW_ID 6 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID;
252 DB_TRX_ID 7 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
253 DB_ROLL_PTR 8 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
254 # DD Metadata of partitions in table
255 NAME DESCRIPTION_UTF8 SE_PRIVATE_DATA
256 p0 100 instant_col=2;
257 p1 200 instant_col=2;
258 p2 300 instant_col=3;
259 # Metadata from INFORMATION_SCHEMA.TABLES
260 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
261 test/t3_part#p#p0 8 2 1 4 5 5
262 # Metadata from INFORMATION_SCHEMA.COLUMNS
263 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
264 c1 0 6 1027 0 0 0
265 c2 1 13 16711934 0 0 0
266 c3 2 13 16711934 1 0 0
267 c4 3 13 16711934 1 0 0
268 c5 4 13 16711934 1 1 0
269 # Metadata from INFORMATION_SCHEMA.TABLES
270 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
271 test/t3_part#p#p1 8 2 1 4 5 5
272 # Metadata from INFORMATION_SCHEMA.COLUMNS
273 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
274 c1 0 6 1027 0 0 0
275 c2 1 13 16711934 0 0 0
276 c3 2 13 16711934 1 0 0
277 c4 3 13 16711934 1 0 0
278 c5 4 13 16711934 1 1 0
279 # Metadata from INFORMATION_SCHEMA.TABLES
280 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
281 test/t3_part#p#p2 8 3 1 4 5 5
282 # Metadata from INFORMATION_SCHEMA.COLUMNS
283 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
284 c1 0 6 1027 0 0 0
285 c2 1 13 16711934 0 0 0
286 c3 2 13 16711934 0 0 0
287 c4 3 13 16711934 1 0 0
288 c5 4 13 16711934 1 1 0
289 # --------------------------------------------------------------------
290 # Add a new partition p3.
291 # Expectation : Old INSTANT METADATA stays same.
292 # Default value for c5 in each partition.
293 # -----------------------------------------------------------------------
294 ALTER TABLE t3_part ADD PARTITION (PARTITION p3 VALUES LESS THAN (400));
295 # DD Metadata of columns in table
296 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
297 c1 1 MYSQL_TYPE_LONG 0 Visible physical_pos=3;table_id=TABLE_ID;
298 c2 2 MYSQL_TYPE_STRING 0 Visible physical_pos=4;table_id=TABLE_ID;
299 c3 3 MYSQL_TYPE_STRING 0 Visible default=6465665f633320202020;physical_pos=5;table_id=TABLE_ID;
300 c4 4 MYSQL_TYPE_STRING 0 Visible default=6465665f633420202020;physical_pos=6;table_id=TABLE_ID;
301 c5 5 MYSQL_TYPE_STRING 0 Visible default=63355f64656620202020;physical_pos=7;table_id=TABLE_ID;version_added=1;
302 DB_ROW_ID 6 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID;
303 DB_TRX_ID 7 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
304 DB_ROLL_PTR 8 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
305 # DD Metadata of partitions in table
306 NAME DESCRIPTION_UTF8 SE_PRIVATE_DATA
307 p0 100 instant_col=2;
308 p1 200 instant_col=2;
309 p2 300 instant_col=3;
310 p3 400 NULL
311 # Metadata from INFORMATION_SCHEMA.TABLES
312 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
313 test/t3_part#p#p0 8 2 1 4 5 5
314 # Metadata from INFORMATION_SCHEMA.COLUMNS
315 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
316 c1 0 6 1027 0 0 0
317 c2 1 13 16711934 0 0 0
318 c3 2 13 16711934 1 0 0
319 c4 3 13 16711934 1 0 0
320 c5 4 13 16711934 1 1 0
321 # Metadata from INFORMATION_SCHEMA.TABLES
322 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
323 test/t3_part#p#p1 8 2 1 4 5 5
324 # Metadata from INFORMATION_SCHEMA.COLUMNS
325 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
326 c1 0 6 1027 0 0 0
327 c2 1 13 16711934 0 0 0
328 c3 2 13 16711934 1 0 0
329 c4 3 13 16711934 1 0 0
330 c5 4 13 16711934 1 1 0
331 # Metadata from INFORMATION_SCHEMA.TABLES
332 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
333 test/t3_part#p#p2 8 3 1 4 5 5
334 # Metadata from INFORMATION_SCHEMA.COLUMNS
335 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
336 c1 0 6 1027 0 0 0
337 c2 1 13 16711934 0 0 0
338 c3 2 13 16711934 0 0 0
339 c4 3 13 16711934 1 0 0
340 c5 4 13 16711934 1 1 0
341 # Metadata from INFORMATION_SCHEMA.TABLES
342 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
343 test/t3_part#p#p3 8 0 1 4 5 5
344 # Metadata from INFORMATION_SCHEMA.COLUMNS
345 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
346 c1 0 6 1027 0 0 0
347 c2 1 13 16711934 0 0 0
348 c3 2 13 16711934 0 0 0
349 c4 3 13 16711934 0 0 0
350 c5 4 13 16711934 1 1 0
351 # --------------------------------------------------------------------
352 # INSTANT DROP a normal column and check metadata t3_part [c1, -c2, c3, c4, c5]
353 # Expectation : Old INSTANT METADATA stays same.
354 # New INSTANT METADATA is updated.
355 # ---------------------------------------------------------------------
356 ALTER TABLE t3_part DROP COLUMN c2, ALGORITHM=INSTANT;
357 # DD Metadata of columns in table
358 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
359 c1 1 MYSQL_TYPE_LONG 0 Visible physical_pos=3;table_id=TABLE_ID;
360 c3 2 MYSQL_TYPE_STRING 0 Visible default=6465665f633320202020;physical_pos=5;table_id=TABLE_ID;
361 c4 3 MYSQL_TYPE_STRING 0 Visible default=6465665f633420202020;physical_pos=6;table_id=TABLE_ID;
362 c5 4 MYSQL_TYPE_STRING 0 Visible default=63355f64656620202020;physical_pos=7;table_id=TABLE_ID;version_added=1;
363 DB_ROW_ID 5 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID;
364 DB_TRX_ID 6 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
365 DB_ROLL_PTR 7 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
366 !hidden!_dropped_v2_p4_c2 8 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=2;
367 # DD Metadata of partitions in table
368 NAME DESCRIPTION_UTF8 SE_PRIVATE_DATA
369 p0 100 instant_col=2;
370 p1 200 instant_col=2;
371 p2 300 instant_col=3;
372 p3 400 NULL
373 # Metadata from INFORMATION_SCHEMA.TABLES
374 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
375 test/t3_part#p#p0 7 2 2 4 4 5
376 # Metadata from INFORMATION_SCHEMA.COLUMNS
377 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
378 c1 0 6 1027 0 0 0
379 c3 1 13 16711934 1 0 0
380 c4 2 13 16711934 1 0 0
381 c5 3 13 16711934 1 1 0
382 !hidden!_dropped_v2_p4_c2 7 13 16711934 0 0 2
383 # Metadata from INFORMATION_SCHEMA.TABLES
384 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
385 test/t3_part#p#p1 7 2 2 4 4 5
386 # Metadata from INFORMATION_SCHEMA.COLUMNS
387 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
388 c1 0 6 1027 0 0 0
389 c3 1 13 16711934 1 0 0
390 c4 2 13 16711934 1 0 0
391 c5 3 13 16711934 1 1 0
392 !hidden!_dropped_v2_p4_c2 7 13 16711934 0 0 2
393 # Metadata from INFORMATION_SCHEMA.TABLES
394 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
395 test/t3_part#p#p2 7 3 2 4 4 5
396 # Metadata from INFORMATION_SCHEMA.COLUMNS
397 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
398 c1 0 6 1027 0 0 0
399 c3 1 13 16711934 0 0 0
400 c4 2 13 16711934 1 0 0
401 c5 3 13 16711934 1 1 0
402 !hidden!_dropped_v2_p4_c2 7 13 16711934 0 0 2
403 # Metadata from INFORMATION_SCHEMA.TABLES
404 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
405 test/t3_part#p#p3 7 0 2 4 4 5
406 # Metadata from INFORMATION_SCHEMA.COLUMNS
407 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
408 c1 0 6 1027 0 0 0
409 c3 1 13 16711934 0 0 0
410 c4 2 13 16711934 0 0 0
411 c5 3 13 16711934 1 1 0
412 !hidden!_dropped_v2_p4_c2 7 13 16711934 0 0 2
413 # -----------------------------------------------------------------------
414 # INSTANT DROP an INSTANT column and check metadata t3_part [c1, ~c2, ~c3, c4, c5]
415 # Expectation : Old INSTANT METADATA stays same.
416 # New INSTANT METADATA is updated.
417 # -----------------------------------------------------------------------
418 ALTER TABLE t3_part DROP COLUMN c3, ALGORITHM=INSTANT;
419 # DD Metadata of columns in table
420 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
421 c1 1 MYSQL_TYPE_LONG 0 Visible physical_pos=3;table_id=TABLE_ID;
422 c4 2 MYSQL_TYPE_STRING 0 Visible default=6465665f633420202020;physical_pos=6;table_id=TABLE_ID;
423 c5 3 MYSQL_TYPE_STRING 0 Visible default=63355f64656620202020;physical_pos=7;table_id=TABLE_ID;version_added=1;
424 DB_ROW_ID 4 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID;
425 DB_TRX_ID 5 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
426 DB_ROLL_PTR 6 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
427 !hidden!_dropped_v2_p4_c2 7 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=2;
428 !hidden!_dropped_v3_p5_c3 8 MYSQL_TYPE_STRING 0 SE physical_pos=5;version_dropped=3;
429 # DD Metadata of partitions in table
430 NAME DESCRIPTION_UTF8 SE_PRIVATE_DATA
431 p0 100 instant_col=2;
432 p1 200 instant_col=2;
433 p2 300 instant_col=3;
434 p3 400 NULL
435 # Metadata from INFORMATION_SCHEMA.TABLES
436 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
437 test/t3_part#p#p0 6 2 3 4 3 5
438 # Metadata from INFORMATION_SCHEMA.COLUMNS
439 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
440 c1 0 6 1027 0 0 0
441 c4 1 13 16711934 1 0 0
442 c5 2 13 16711934 1 1 0
443 !hidden!_dropped_v2_p4_c2 6 13 16711934 0 0 2
444 !hidden!_dropped_v3_p5_c3 7 13 16711934 0 0 3
445 # Metadata from INFORMATION_SCHEMA.TABLES
446 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
447 test/t3_part#p#p1 6 2 3 4 3 5
448 # Metadata from INFORMATION_SCHEMA.COLUMNS
449 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
450 c1 0 6 1027 0 0 0
451 c4 1 13 16711934 1 0 0
452 c5 2 13 16711934 1 1 0
453 !hidden!_dropped_v2_p4_c2 6 13 16711934 0 0 2
454 !hidden!_dropped_v3_p5_c3 7 13 16711934 0 0 3
455 # Metadata from INFORMATION_SCHEMA.TABLES
456 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
457 test/t3_part#p#p2 6 3 3 4 3 5
458 # Metadata from INFORMATION_SCHEMA.COLUMNS
459 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
460 c1 0 6 1027 0 0 0
461 c4 1 13 16711934 0 0 0
462 c5 2 13 16711934 1 1 0
463 !hidden!_dropped_v2_p4_c2 6 13 16711934 0 0 2
464 !hidden!_dropped_v3_p5_c3 7 13 16711934 0 0 3
465 # Metadata from INFORMATION_SCHEMA.TABLES
466 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
467 test/t3_part#p#p3 6 0 3 4 3 5
468 # Metadata from INFORMATION_SCHEMA.COLUMNS
469 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
470 c1 0 6 1027 0 0 0
471 c4 1 13 16711934 0 0 0
472 c5 2 13 16711934 1 1 0
473 !hidden!_dropped_v2_p4_c2 6 13 16711934 0 0 2
474 !hidden!_dropped_v3_p5_c3 7 13 16711934 0 0 3
475 # -----------------------------------------------------------------------------
476 # INSTANT DROP newly added column and check metadata t3_part [c1, ~c2, ~c3, c4, -c5]
477 # Expectation : Old INSTANT METADATA stays same.
478 # New INSTANT METADATA is updated.
479 # -----------------------------------------------------------------------------
480 ALTER TABLE t3_part DROP COLUMN c5, ALGORITHM=INSTANT;
481 # DD Metadata of columns in table
482 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
483 c1 1 MYSQL_TYPE_LONG 0 Visible physical_pos=3;table_id=TABLE_ID;
484 c4 2 MYSQL_TYPE_STRING 0 Visible default=6465665f633420202020;physical_pos=6;table_id=TABLE_ID;
485 DB_ROW_ID 3 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID;
486 DB_TRX_ID 4 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
487 DB_ROLL_PTR 5 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
488 !hidden!_dropped_v2_p4_c2 6 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=2;
489 !hidden!_dropped_v3_p5_c3 7 MYSQL_TYPE_STRING 0 SE physical_pos=5;version_dropped=3;
490 !hidden!_dropped_v4_p7_c5 8 MYSQL_TYPE_STRING 0 SE physical_pos=7;version_added=1;version_dropped=4;
491 # DD Metadata of partitions in table
492 NAME DESCRIPTION_UTF8 SE_PRIVATE_DATA
493 p0 100 instant_col=2;
494 p1 200 instant_col=2;
495 p2 300 instant_col=3;
496 p3 400 NULL
497 # Metadata from INFORMATION_SCHEMA.TABLES
498 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
499 test/t3_part#p#p0 5 2 4 4 2 5
500 # Metadata from INFORMATION_SCHEMA.COLUMNS
501 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
502 c1 0 6 1027 0 0 0
503 c4 1 13 16711934 1 0 0
504 !hidden!_dropped_v2_p4_c2 5 13 16711934 0 0 2
505 !hidden!_dropped_v3_p5_c3 6 13 16711934 0 0 3
506 !hidden!_dropped_v4_p7_c5 7 13 16711934 0 1 4
507 # Metadata from INFORMATION_SCHEMA.TABLES
508 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
509 test/t3_part#p#p1 5 2 4 4 2 5
510 # Metadata from INFORMATION_SCHEMA.COLUMNS
511 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
512 c1 0 6 1027 0 0 0
513 c4 1 13 16711934 1 0 0
514 !hidden!_dropped_v2_p4_c2 5 13 16711934 0 0 2
515 !hidden!_dropped_v3_p5_c3 6 13 16711934 0 0 3
516 !hidden!_dropped_v4_p7_c5 7 13 16711934 0 1 4
517 # Metadata from INFORMATION_SCHEMA.TABLES
518 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
519 test/t3_part#p#p2 5 3 4 4 2 5
520 # Metadata from INFORMATION_SCHEMA.COLUMNS
521 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
522 c1 0 6 1027 0 0 0
523 c4 1 13 16711934 0 0 0
524 !hidden!_dropped_v2_p4_c2 5 13 16711934 0 0 2
525 !hidden!_dropped_v3_p5_c3 6 13 16711934 0 0 3
526 !hidden!_dropped_v4_p7_c5 7 13 16711934 0 1 4
527 # Metadata from INFORMATION_SCHEMA.TABLES
528 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
529 test/t3_part#p#p3 5 0 4 4 2 5
530 # Metadata from INFORMATION_SCHEMA.COLUMNS
531 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
532 c1 0 6 1027 0 0 0
533 c4 1 13 16711934 1 0 0
534 !hidden!_dropped_v2_p4_c2 5 13 16711934 0 0 2
535 !hidden!_dropped_v3_p5_c3 6 13 16711934 0 0 3
536 !hidden!_dropped_v4_p7_c5 7 13 16711934 0 1 4
537 DROP TABLE t3_part;
538 # -------------------------------------------------
539 # TEST 3 : New tables with INSTANT ADD/DROP Columns
540 # -------------------------------------------------
541 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));
542 INSERT INTO t1_part VALUES(10, "r1c2");
543 # ------------------------------------------------------------
544 # Check metadata of table t1_part [c1, c2]
545 # Expectation : Old INSTANT METADATA is not present
546 # New INSTANT METADATA is not present.
547 # ------------------------------------------------------------
548 # DD Metadata of columns in table
549 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
550 c1 1 MYSQL_TYPE_LONG 0 Visible table_id=TABLE_ID;
551 c2 2 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
552 DB_ROW_ID 3 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
553 DB_TRX_ID 4 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
554 DB_ROLL_PTR 5 MYSQL_TYPE_LONGLONG 0 SE table_id=TABLE_ID;
555 # DD Metadata of partitions in table
556 NAME DESCRIPTION_UTF8 SE_PRIVATE_DATA
557 p0 100 NULL
558 p1 200 NULL
559 # Metadata from INFORMATION_SCHEMA.TABLES
560 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
561 test/t1_part#p#p0 5 0 0 2 2 2
562 # Metadata from INFORMATION_SCHEMA.COLUMNS
563 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
564 c1 0 6 1027 0 0 0
565 c2 1 13 16711934 0 0 0
566 # Metadata from INFORMATION_SCHEMA.TABLES
567 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
568 test/t1_part#p#p1 5 0 0 2 2 2
569 # Metadata from INFORMATION_SCHEMA.COLUMNS
570 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
571 c1 0 6 1027 0 0 0
572 c2 1 13 16711934 0 0 0
573 # -----------------------------------------------------------------------
574 # INSTANT DROP a column and check metadata t1_part [c1, -c2]
575 # Expectation : Old INSTANT METADATA is not present.
576 # New INSTANT METADATA is populated.
577 # -----------------------------------------------------------------------
578 ALTER TABLE t1_part DROP COLUMN c2, ALGORITHM=INSTANT;
579 # DD Metadata of columns in table
580 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
581 c1 1 MYSQL_TYPE_LONG 0 Visible physical_pos=3;table_id=TABLE_ID;
582 DB_ROW_ID 2 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID;
583 DB_TRX_ID 3 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
584 DB_ROLL_PTR 4 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
585 !hidden!_dropped_v1_p4_c2 5 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=1;
586 # DD Metadata of partitions in table
587 NAME DESCRIPTION_UTF8 SE_PRIVATE_DATA
588 p0 100 NULL
589 p1 200 NULL
590 # Metadata from INFORMATION_SCHEMA.TABLES
591 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
592 test/t1_part#p#p0 4 0 1 2 1 2
593 # Metadata from INFORMATION_SCHEMA.COLUMNS
594 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
595 c1 0 6 1027 0 0 0
596 !hidden!_dropped_v1_p4_c2 4 13 16711934 0 0 1
597 # Metadata from INFORMATION_SCHEMA.TABLES
598 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
599 test/t1_part#p#p1 4 0 1 2 1 2
600 # Metadata from INFORMATION_SCHEMA.COLUMNS
601 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
602 c1 0 6 1027 0 0 0
603 !hidden!_dropped_v1_p4_c2 4 13 16711934 0 0 1
604 # -----------------------------------------------------------------------
605 # INSTANT ADD a column and check metadata t1_part [c1, ~c2, +c3]
606 # Expectation : Old INSTANT METADATA not present.
607 # New INSTANT METADATA is updated.
608 # -----------------------------------------------------------------------
609 ALTER TABLE t1_part ADD COLUMN c3 CHAR(10) DEFAULT "c3_def", ALGORITHM=INSTANT;
610 # DD Metadata of columns in table
611 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
612 c1 1 MYSQL_TYPE_LONG 0 Visible physical_pos=3;table_id=TABLE_ID;
613 c3 2 MYSQL_TYPE_STRING 0 Visible default=63335f64656620202020;physical_pos=5;table_id=TABLE_ID;version_added=2;
614 DB_ROW_ID 3 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID;
615 DB_TRX_ID 4 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
616 DB_ROLL_PTR 5 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
617 !hidden!_dropped_v1_p4_c2 6 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=1;
618 # DD Metadata of partitions in table
619 NAME DESCRIPTION_UTF8 SE_PRIVATE_DATA
620 p0 100 NULL
621 p1 200 NULL
622 # Metadata from INFORMATION_SCHEMA.TABLES
623 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
624 test/t1_part#p#p0 5 0 2 2 2 3
625 # Metadata from INFORMATION_SCHEMA.COLUMNS
626 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
627 c1 0 6 1027 0 0 0
628 c3 1 13 16711934 1 2 0
629 !hidden!_dropped_v1_p4_c2 5 13 16711934 0 0 1
630 # Metadata from INFORMATION_SCHEMA.TABLES
631 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
632 test/t1_part#p#p1 5 0 2 2 2 3
633 # Metadata from INFORMATION_SCHEMA.COLUMNS
634 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
635 c1 0 6 1027 0 0 0
636 c3 1 13 16711934 1 2 0
637 !hidden!_dropped_v1_p4_c2 5 13 16711934 0 0 1
638 # --------------------------------------------------------------------
639 # Add a new partition p2.
640 # Expectation : Old INSTANT METADATA not present.
641 # New INSTANT METADATA is updated.
642 # Default value for c3 in each partition.
643 # -----------------------------------------------------------------------
644 ALTER TABLE t1_part ADD PARTITION (PARTITION p2 VALUES LESS THAN (300));
645 # DD Metadata of columns in table
646 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
647 c1 1 MYSQL_TYPE_LONG 0 Visible physical_pos=3;table_id=TABLE_ID;
648 c3 2 MYSQL_TYPE_STRING 0 Visible default=63335f64656620202020;physical_pos=5;table_id=TABLE_ID;version_added=2;
649 DB_ROW_ID 3 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID;
650 DB_TRX_ID 4 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
651 DB_ROLL_PTR 5 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
652 !hidden!_dropped_v1_p4_c2 6 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=1;
653 # DD Metadata of partitions in table
654 NAME DESCRIPTION_UTF8 SE_PRIVATE_DATA
655 p0 100 NULL
656 p1 200 NULL
657 p2 300 NULL
658 # Metadata from INFORMATION_SCHEMA.TABLES
659 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
660 test/t1_part#p#p0 5 0 2 2 2 3
661 # Metadata from INFORMATION_SCHEMA.COLUMNS
662 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
663 c1 0 6 1027 0 0 0
664 c3 1 13 16711934 1 2 0
665 !hidden!_dropped_v1_p4_c2 5 13 16711934 0 0 1
666 # Metadata from INFORMATION_SCHEMA.TABLES
667 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
668 test/t1_part#p#p1 5 0 2 2 2 3
669 # Metadata from INFORMATION_SCHEMA.COLUMNS
670 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
671 c1 0 6 1027 0 0 0
672 c3 1 13 16711934 1 2 0
673 !hidden!_dropped_v1_p4_c2 5 13 16711934 0 0 1
674 # Metadata from INFORMATION_SCHEMA.TABLES
675 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
676 test/t1_part#p#p2 5 0 2 2 2 3
677 # Metadata from INFORMATION_SCHEMA.COLUMNS
678 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
679 c1 0 6 1027 0 0 0
680 c3 1 13 16711934 1 2 0
681 !hidden!_dropped_v1_p4_c2 5 13 16711934 0 0 1
682 # ----------------------------------------------------------------------------
683 # INSTANT DROP the INSTANT ADD column and check metadata t1_part [c1, ~c2, -c3]
684 # Expectation : Old INSTANT METADATA is not present.
685 # New INSTANT METADATA is updated.
686 # ----------------------------------------------------------------------------
687 ALTER TABLE t1_part DROP COLUMN c3, ALGORITHM=INSTANT;
688 # DD Metadata of columns in table
689 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
690 c1 1 MYSQL_TYPE_LONG 0 Visible physical_pos=3;table_id=TABLE_ID;
691 DB_ROW_ID 2 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID;
692 DB_TRX_ID 3 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
693 DB_ROLL_PTR 4 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
694 !hidden!_dropped_v1_p4_c2 5 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=1;
695 !hidden!_dropped_v3_p5_c3 6 MYSQL_TYPE_STRING 0 SE physical_pos=5;version_added=2;version_dropped=3;
696 # DD Metadata of partitions in table
697 NAME DESCRIPTION_UTF8 SE_PRIVATE_DATA
698 p0 100 NULL
699 p1 200 NULL
700 p2 300 NULL
701 # Metadata from INFORMATION_SCHEMA.TABLES
702 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
703 test/t1_part#p#p0 4 0 3 2 1 3
704 # Metadata from INFORMATION_SCHEMA.COLUMNS
705 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
706 c1 0 6 1027 0 0 0
707 !hidden!_dropped_v1_p4_c2 4 13 16711934 0 0 1
708 !hidden!_dropped_v3_p5_c3 5 13 16711934 0 2 3
709 # Metadata from INFORMATION_SCHEMA.TABLES
710 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
711 test/t1_part#p#p1 4 0 3 2 1 3
712 # Metadata from INFORMATION_SCHEMA.COLUMNS
713 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
714 c1 0 6 1027 0 0 0
715 !hidden!_dropped_v1_p4_c2 4 13 16711934 0 0 1
716 !hidden!_dropped_v3_p5_c3 5 13 16711934 0 2 3
717 # Metadata from INFORMATION_SCHEMA.TABLES
718 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
719 test/t1_part#p#p2 4 0 3 2 1 3
720 # Metadata from INFORMATION_SCHEMA.COLUMNS
721 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
722 c1 0 6 1027 0 0 0
723 !hidden!_dropped_v1_p4_c2 4 13 16711934 0 0 1
724 !hidden!_dropped_v3_p5_c3 5 13 16711934 0 2 3
725 DROP TABLE t1_part;
726 ###########
727 # CLEANUP #
728 ###########
729 # Shutdown server
730 # Remove copied files
731 # Restarting server to restore server state
732 # restart