Debian Codegraph @

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

raw
1 # ------------------------------------------------------------
2 # Start server with old datadir with
3 # Table t1 and t2
4 # having c1, c2, c3 normal columns
5 # +------+------+------+
6 # | c1 | c2 | c3 |
7 # +------+------+------+
8 # | r1c1 | r1c2 | r1c3 |
9 # +------+------+------+
10 #
11 # Table t3
12 # having c1, c2 normal columns
13 # having c3 INSTANT ADD column with NULL default value
14 # having c4 INSTANT ADD column with default value
15 # +------+------+------+--------+
16 # | c1 | c2 | c3 | c4 |
17 # +------+------+------+--------+
18 # | r1c1 | r1c2 | NULL | c4_def |
19 # +------+------+------+--------+
20 # ------------------------------------------------------------
21 # Stop the running the server
22 # Copy and unzip the datadir.
23 # Restart the server against the unzipped datadir
24 # restart: --datadir=DATADIR --innodb-page-size=16k
25 # ------------------------------------------------------------
26 # TEST 1 : Old version tables have no INSTANT ADD Columns
27 # ------------------------------------------------------------
28 # ------------------------------------------------------------
29 # Check metadat of upgraded table t1 [c1, c2, c3]
30 # Expectation : New INSTANT METADATA is not present.
31 # ------------------------------------------------------------
32 # Metadata from INFORMATION_SCHEMA.TABLES
33 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
34 test/t1 6 0 0 3 3 3
35 # Metadata from INFORMATION_SCHEMA.COLUMNS
36 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
37 c1 0 13 16711934 0 0 0
38 c2 1 13 16711934 0 0 0
39 c3 2 13 16711934 0 0 0
40 # DD Metadata of table
41 NAME SE_PRIVATE_DATA
42 t1 NULL
43 # DD Metadata of columns in table
44 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
45 c1 1 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
46 c2 2 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
47 c3 3 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
48 DB_ROW_ID 4 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
49 DB_TRX_ID 5 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
50 DB_ROLL_PTR 6 MYSQL_TYPE_LONGLONG 0 SE table_id=TABLE_ID;
51 # ------------------------------------------------------------
52 # INSTANT DROP a column and check metadata t1 [c1, c3, -c2]
53 # Expectation : New INSTANT METADATA is populated.
54 # ------------------------------------------------------------
55 ALTER TABLE t1 DROP COLUMN c2, ALGORITHM=INSTANT;
56 # Metadata from INFORMATION_SCHEMA.TABLES
57 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
58 test/t1 5 0 1 3 2 3
59 # Metadata from INFORMATION_SCHEMA.COLUMNS
60 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
61 c1 0 13 16711934 0 0 0
62 c3 1 13 16711934 0 0 0
63 !hidden!_dropped_v1_p4_c2 5 13 16711934 0 0 1
64 # DD Metadata of table
65 NAME SE_PRIVATE_DATA
66 t1 NULL
67 # DD Metadata of columns in table
68 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
69 c1 1 MYSQL_TYPE_STRING 0 Visible physical_pos=3;table_id=TABLE_ID;
70 c3 2 MYSQL_TYPE_STRING 0 Visible physical_pos=5;table_id=TABLE_ID;
71 DB_ROW_ID 3 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID;
72 DB_TRX_ID 4 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
73 DB_ROLL_PTR 5 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
74 !hidden!_dropped_v1_p4_c2 6 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=1;
75 # ------------------------------------------------------------
76 # Check metadat of upgraded table t2 [c1, c2, c3]
77 # Expectation : New INSTANT METADATA is not present.
78 # ------------------------------------------------------------
79 # Metadata from INFORMATION_SCHEMA.TABLES
80 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
81 test/t2 6 0 0 3 3 3
82 # Metadata from INFORMATION_SCHEMA.COLUMNS
83 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
84 c1 0 13 16711934 0 0 0
85 c2 1 13 16711934 0 0 0
86 c3 2 13 16711934 0 0 0
87 # DD Metadata of table
88 NAME SE_PRIVATE_DATA
89 t2 NULL
90 # DD Metadata of columns in table
91 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
92 c1 1 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
93 c2 2 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
94 c3 3 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
95 DB_ROW_ID 4 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
96 DB_TRX_ID 5 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
97 DB_ROLL_PTR 6 MYSQL_TYPE_LONGLONG 0 SE table_id=TABLE_ID;
98 # ------------------------------------------------------------
99 # INSTANT ADD a column and check metadata t2 [c1, c2, c3, +c4]
100 # Expectation : New INSTANT METADATA is populated.
101 # ------------------------------------------------------------
102 ALTER TABLE t2 ADD COLUMN c4 CHAR(10) DEFAULT "c4_def", ALGORITHM=INSTANT;
103 # Metadata from INFORMATION_SCHEMA.TABLES
104 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
105 test/t2 7 0 1 3 4 4
106 # Metadata from INFORMATION_SCHEMA.COLUMNS
107 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
108 c1 0 13 16711934 0 0 0
109 c2 1 13 16711934 0 0 0
110 c3 2 13 16711934 0 0 0
111 c4 3 13 16711934 1 1 0
112 # DD Metadata of table
113 NAME SE_PRIVATE_DATA
114 t2 NULL
115 # DD Metadata of columns in table
116 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
117 c1 1 MYSQL_TYPE_STRING 0 Visible physical_pos=3;table_id=TABLE_ID;
118 c2 2 MYSQL_TYPE_STRING 0 Visible physical_pos=4;table_id=TABLE_ID;
119 c3 3 MYSQL_TYPE_STRING 0 Visible physical_pos=5;table_id=TABLE_ID;
120 c4 4 MYSQL_TYPE_STRING 0 Visible default=63345f64656620202020;physical_pos=6;table_id=TABLE_ID;version_added=1;
121 DB_ROW_ID 5 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID;
122 DB_TRX_ID 6 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
123 DB_ROLL_PTR 7 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
124 # ------------------------------------------------------------
125 # INSTANT DROP a column and check metadata t2 [c1, c2, -c3, c4]
126 # Expectation : New INSTANT METADATA is updated.
127 # ------------------------------------------------------------
128 ALTER TABLE t2 DROP COLUMN c3, ALGORITHM=INSTANT;
129 # Metadata from INFORMATION_SCHEMA.TABLES
130 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
131 test/t2 6 0 2 3 3 4
132 # Metadata from INFORMATION_SCHEMA.COLUMNS
133 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
134 c1 0 13 16711934 0 0 0
135 c2 1 13 16711934 0 0 0
136 c4 2 13 16711934 1 1 0
137 !hidden!_dropped_v2_p5_c3 6 13 16711934 0 0 2
138 # DD Metadata of table
139 NAME SE_PRIVATE_DATA
140 t2 NULL
141 # DD Metadata of columns in table
142 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
143 c1 1 MYSQL_TYPE_STRING 0 Visible physical_pos=3;table_id=TABLE_ID;
144 c2 2 MYSQL_TYPE_STRING 0 Visible physical_pos=4;table_id=TABLE_ID;
145 c4 3 MYSQL_TYPE_STRING 0 Visible default=63345f64656620202020;physical_pos=6;table_id=TABLE_ID;version_added=1;
146 DB_ROW_ID 4 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID;
147 DB_TRX_ID 5 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
148 DB_ROLL_PTR 6 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
149 !hidden!_dropped_v2_p5_c3 7 MYSQL_TYPE_STRING 0 SE physical_pos=5;version_dropped=2;
150 DROP TABLE t1;
151 DROP TABLE t2;
152 # ------------------------------------------------------------
153 # TEST 2 : Old version tables have INSTANT ADD Columns
154 # ------------------------------------------------------------
155 # ------------------------------------------------------------
156 # Check metadat of upgraded table t3 [c1, c2, c3, c4]
157 # Expectation : Old INSTANT METADATA is present
158 # New INSTANT METADATA is not present.
159 # ------------------------------------------------------------
160 # Metadata from INFORMATION_SCHEMA.TABLES
161 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
162 test/t3 7 2 0 4 4 4
163 # Metadata from INFORMATION_SCHEMA.COLUMNS
164 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
165 c1 0 13 16711934 0 0 0
166 c2 1 13 16711934 0 0 0
167 c3 2 13 16711934 1 0 0
168 c4 3 13 16711934 1 0 0
169 # DD Metadata of table
170 NAME SE_PRIVATE_DATA
171 t3 instant_col=2;
172 # DD Metadata of columns in table
173 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
174 c1 1 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
175 c2 2 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
176 c3 3 MYSQL_TYPE_STRING 0 Visible default_null=1;table_id=TABLE_ID;
177 c4 4 MYSQL_TYPE_STRING 0 Visible default=63345f64656620202020;table_id=TABLE_ID;
178 DB_ROW_ID 5 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
179 DB_TRX_ID 6 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
180 DB_ROLL_PTR 7 MYSQL_TYPE_LONGLONG 0 SE table_id=TABLE_ID;
181 # --------------------------------------------------------------------
182 # INSTANT DROP a normal column and check metadata t3 [c1, -c2, c3, c4]
183 # Expectation : Old INSTANT METADATA stays same.
184 # New INSTANT METADATA is populated.
185 # ---------------------------------------------------------------------
186 ALTER TABLE t3 DROP COLUMN c2, ALGORITHM=INSTANT;
187 # Metadata from INFORMATION_SCHEMA.TABLES
188 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
189 test/t3 6 2 1 4 3 4
190 # Metadata from INFORMATION_SCHEMA.COLUMNS
191 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
192 c1 0 13 16711934 0 0 0
193 c3 1 13 16711934 1 0 0
194 c4 2 13 16711934 1 0 0
195 !hidden!_dropped_v1_p4_c2 6 13 16711934 0 0 1
196 # DD Metadata of table
197 NAME SE_PRIVATE_DATA
198 t3 instant_col=2;
199 # DD Metadata of columns in table
200 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
201 c1 1 MYSQL_TYPE_STRING 0 Visible physical_pos=3;table_id=TABLE_ID;
202 c3 2 MYSQL_TYPE_STRING 0 Visible default_null=1;physical_pos=5;table_id=TABLE_ID;
203 c4 3 MYSQL_TYPE_STRING 0 Visible default=63345f64656620202020;physical_pos=6;table_id=TABLE_ID;
204 DB_ROW_ID 4 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID;
205 DB_TRX_ID 5 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
206 DB_ROLL_PTR 6 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
207 !hidden!_dropped_v1_p4_c2 7 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=1;
208 # -----------------------------------------------------------------------
209 # INSTANT DROP an INSTANT column and check metadata t3 [c1, ~c2, -c3, c4]
210 # Expectation : Old INSTANT METADATA stays same.
211 # New INSTANT METADATA is updated.
212 # -----------------------------------------------------------------------
213 ALTER TABLE t3 DROP COLUMN c3, ALGORITHM=INSTANT;
214 # Metadata from INFORMATION_SCHEMA.TABLES
215 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
216 test/t3 5 2 2 4 2 4
217 # Metadata from INFORMATION_SCHEMA.COLUMNS
218 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
219 c1 0 13 16711934 0 0 0
220 c4 1 13 16711934 1 0 0
221 !hidden!_dropped_v1_p4_c2 5 13 16711934 0 0 1
222 !hidden!_dropped_v2_p5_c3 6 13 16711934 0 0 2
223 # DD Metadata of table
224 NAME SE_PRIVATE_DATA
225 t3 instant_col=2;
226 # DD Metadata of columns in table
227 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
228 c1 1 MYSQL_TYPE_STRING 0 Visible physical_pos=3;table_id=TABLE_ID;
229 c4 2 MYSQL_TYPE_STRING 0 Visible default=63345f64656620202020;physical_pos=6;table_id=TABLE_ID;
230 DB_ROW_ID 3 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID;
231 DB_TRX_ID 4 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
232 DB_ROLL_PTR 5 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
233 !hidden!_dropped_v1_p4_c2 6 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=1;
234 !hidden!_dropped_v2_p5_c3 7 MYSQL_TYPE_STRING 0 SE physical_pos=5;version_dropped=2;
235 # -----------------------------------------------------------------------
236 # INSTANT ADD a new column and check metadata t3 [c1, ~c2, ~c3, c4, +c5]
237 # Expectation : Old INSTANT METADATA stays same.
238 # New INSTANT METADATA is updated.
239 # -----------------------------------------------------------------------
240 ALTER TABLE t3 ADD COLUMN c5 CHAR(10) DEFAULT "c5_def", ALGORITHM=INSTANT;
241 # Metadata from INFORMATION_SCHEMA.TABLES
242 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
243 test/t3 6 2 3 4 3 5
244 # Metadata from INFORMATION_SCHEMA.COLUMNS
245 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
246 c1 0 13 16711934 0 0 0
247 c4 1 13 16711934 1 0 0
248 c5 2 13 16711934 1 3 0
249 !hidden!_dropped_v1_p4_c2 6 13 16711934 0 0 1
250 !hidden!_dropped_v2_p5_c3 7 13 16711934 0 0 2
251 # DD Metadata of table
252 NAME SE_PRIVATE_DATA
253 t3 instant_col=2;
254 # DD Metadata of columns in table
255 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
256 c1 1 MYSQL_TYPE_STRING 0 Visible physical_pos=3;table_id=TABLE_ID;
257 c4 2 MYSQL_TYPE_STRING 0 Visible default=63345f64656620202020;physical_pos=6;table_id=TABLE_ID;
258 c5 3 MYSQL_TYPE_STRING 0 Visible default=63355f64656620202020;physical_pos=7;table_id=TABLE_ID;version_added=3;
259 DB_ROW_ID 4 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID;
260 DB_TRX_ID 5 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
261 DB_ROLL_PTR 6 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
262 !hidden!_dropped_v1_p4_c2 7 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=1;
263 !hidden!_dropped_v2_p5_c3 8 MYSQL_TYPE_STRING 0 SE physical_pos=5;version_dropped=2;
264 # -----------------------------------------------------------------------------
265 # INSTANT DROP newly added column and check metadata t3 [c1, ~c2, ~c3, c4, -c5]
266 # Expectation : Old INSTANT METADATA stays same.
267 # New INSTANT METADATA is updated.
268 # -----------------------------------------------------------------------------
269 ALTER TABLE t3 DROP COLUMN c5, ALGORITHM=INSTANT;
270 # Metadata from INFORMATION_SCHEMA.TABLES
271 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
272 test/t3 5 2 4 4 2 5
273 # Metadata from INFORMATION_SCHEMA.COLUMNS
274 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
275 c1 0 13 16711934 0 0 0
276 c4 1 13 16711934 1 0 0
277 !hidden!_dropped_v1_p4_c2 5 13 16711934 0 0 1
278 !hidden!_dropped_v2_p5_c3 6 13 16711934 0 0 2
279 !hidden!_dropped_v4_p7_c5 7 13 16711934 0 3 4
280 # DD Metadata of table
281 NAME SE_PRIVATE_DATA
282 t3 instant_col=2;
283 # DD Metadata of columns in table
284 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
285 c1 1 MYSQL_TYPE_STRING 0 Visible physical_pos=3;table_id=TABLE_ID;
286 c4 2 MYSQL_TYPE_STRING 0 Visible default=63345f64656620202020;physical_pos=6;table_id=TABLE_ID;
287 DB_ROW_ID 3 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID;
288 DB_TRX_ID 4 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
289 DB_ROLL_PTR 5 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
290 !hidden!_dropped_v1_p4_c2 6 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=1;
291 !hidden!_dropped_v2_p5_c3 7 MYSQL_TYPE_STRING 0 SE physical_pos=5;version_dropped=2;
292 !hidden!_dropped_v4_p7_c5 8 MYSQL_TYPE_STRING 0 SE physical_pos=7;version_added=3;version_dropped=4;
293 DROP TABLE t3;
294 # -------------------------------------------------
295 # TEST 3 : New tables with INSTANT ADD/DROP Columns
296 # -------------------------------------------------
297 CREATE TABLE t1 (c1 char(10), c2 char(10), c3 char(10));
298 # ------------------------------------------------------------
299 # Check metadat of table t1 [c1, c2, c3]
300 # Expectation : Old INSTANT METADATA is not present
301 # New INSTANT METADATA is not present.
302 # ------------------------------------------------------------
303 # Metadata from INFORMATION_SCHEMA.TABLES
304 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
305 test/t1 6 0 0 3 3 3
306 # Metadata from INFORMATION_SCHEMA.COLUMNS
307 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
308 c1 0 13 16711934 0 0 0
309 c2 1 13 16711934 0 0 0
310 c3 2 13 16711934 0 0 0
311 # DD Metadata of table
312 NAME SE_PRIVATE_DATA
313 t1 NULL
314 # DD Metadata of columns in table
315 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
316 c1 1 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
317 c2 2 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
318 c3 3 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
319 DB_ROW_ID 4 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
320 DB_TRX_ID 5 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
321 DB_ROLL_PTR 6 MYSQL_TYPE_LONGLONG 0 SE table_id=TABLE_ID;
322 # -----------------------------------------------------------------------
323 # INSTANT DROP a column and check metadata t1 [c1, -c2, c3]
324 # Expectation : Old INSTANT METADATA is not present.
325 # New INSTANT METADATA is populated.
326 # -----------------------------------------------------------------------
327 ALTER TABLE t1 DROP COLUMN c2, ALGORITHM=INSTANT;
328 # Metadata from INFORMATION_SCHEMA.TABLES
329 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
330 test/t1 5 0 1 3 2 3
331 # Metadata from INFORMATION_SCHEMA.COLUMNS
332 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
333 c1 0 13 16711934 0 0 0
334 c3 1 13 16711934 0 0 0
335 !hidden!_dropped_v1_p4_c2 5 13 16711934 0 0 1
336 # DD Metadata of table
337 NAME SE_PRIVATE_DATA
338 t1 NULL
339 # DD Metadata of columns in table
340 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
341 c1 1 MYSQL_TYPE_STRING 0 Visible physical_pos=3;table_id=TABLE_ID;
342 c3 2 MYSQL_TYPE_STRING 0 Visible physical_pos=5;table_id=TABLE_ID;
343 DB_ROW_ID 3 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID;
344 DB_TRX_ID 4 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
345 DB_ROLL_PTR 5 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
346 !hidden!_dropped_v1_p4_c2 6 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=1;
347 # -----------------------------------------------------------------------
348 # INSTANT ADD a column and check metadata t1 [+c0, c1, ~c2, c3]
349 # Expectation : Old INSTANT METADATA not present.
350 # New INSTANT METADATA is updated.
351 # -----------------------------------------------------------------------
352 ALTER TABLE t1 ADD COLUMN c0 CHAR(10) DEFAULT "c0_def" FIRST, ALGORITHM=INSTANT;
353 # Metadata from INFORMATION_SCHEMA.TABLES
354 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
355 test/t1 6 0 2 3 3 4
356 # Metadata from INFORMATION_SCHEMA.COLUMNS
357 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
358 c0 0 13 16711934 1 2 0
359 c1 1 13 16711934 0 0 0
360 c3 2 13 16711934 0 0 0
361 !hidden!_dropped_v1_p4_c2 6 13 16711934 0 0 1
362 # DD Metadata of table
363 NAME SE_PRIVATE_DATA
364 t1 NULL
365 # DD Metadata of columns in table
366 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
367 c0 1 MYSQL_TYPE_STRING 0 Visible default=63305f64656620202020;physical_pos=6;table_id=TABLE_ID;version_added=2;
368 c1 2 MYSQL_TYPE_STRING 0 Visible physical_pos=3;table_id=TABLE_ID;
369 c3 3 MYSQL_TYPE_STRING 0 Visible physical_pos=5;table_id=TABLE_ID;
370 DB_ROW_ID 4 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID;
371 DB_TRX_ID 5 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
372 DB_ROLL_PTR 6 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
373 !hidden!_dropped_v1_p4_c2 7 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=1;
374 # ----------------------------------------------------------------------------
375 # INSTANT DROP the INSTANT ADD column and check metadata t1 [-c0, c1, ~c2, c3]
376 # Expectation : Old INSTANT METADATA is not present.
377 # New INSTANT METADATA is updated.
378 # ----------------------------------------------------------------------------
379 ALTER TABLE t1 DROP COLUMN c0, ALGORITHM=INSTANT;
380 # Metadata from INFORMATION_SCHEMA.TABLES
381 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
382 test/t1 5 0 3 3 2 4
383 # Metadata from INFORMATION_SCHEMA.COLUMNS
384 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
385 c1 0 13 16711934 0 0 0
386 c3 1 13 16711934 0 0 0
387 !hidden!_dropped_v1_p4_c2 5 13 16711934 0 0 1
388 !hidden!_dropped_v3_p6_c0 6 13 16711934 0 2 3
389 # DD Metadata of table
390 NAME SE_PRIVATE_DATA
391 t1 NULL
392 # DD Metadata of columns in table
393 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
394 c1 1 MYSQL_TYPE_STRING 0 Visible physical_pos=3;table_id=TABLE_ID;
395 c3 2 MYSQL_TYPE_STRING 0 Visible physical_pos=5;table_id=TABLE_ID;
396 DB_ROW_ID 3 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID;
397 DB_TRX_ID 4 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID;
398 DB_ROLL_PTR 5 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID;
399 !hidden!_dropped_v1_p4_c2 6 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=1;
400 !hidden!_dropped_v3_p6_c0 7 MYSQL_TYPE_STRING 0 SE physical_pos=6;version_added=2;version_dropped=3;
401 DROP TABLE t1;
402 ###########
403 # CLEANUP #
404 ###########
405 # Shutdown server
406 # Remove copied files
407 # Restarting server to restore server state
408 # restart