Debian Codegraph @

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

raw
1 # Online DDL test on ALTER .. ADD PRIMRAY KEY with UPDATE SET on all possible row combinations
2 #
3 # What this test is doing:
4 #
5 # Upgrade server to latest version
6 # Keep a zipped copy of upgraded datadir
7 #
8 # For the primary key columns
9 # --let = c0 {
10 #
11 # For all row formats
12 # --let = [ta1b1, ta1b2, ta1b3, ta1b4, ta2b2, ta2b4, ta3b2, ta3b3, ta3b4] {
13 # --source suite/innodb/include/bug33788578_online_ddl.inc
14 #
15 # For all tables
16 # --let = [ta1b1, ta1b2, ta1b3, ta1b4, ta2b2, ta2b4, ta3b2, ta3b3, ta3b4]_ {
17 # Do the online DDL
18 # --let = c2/c6/c10 depending on table
19 # --source suite/innodb/include/bug33788578.inc
20 # }
21 # }
22 # }
23 # Check comments near end of file to see what a1b1, a2b4, etc., means
24 # This column will be made as the primary key in online DDL. TODO: extend test to include all possible primary key columns
25 # TODO: extend test to update other columns : maybe instant added ones too;
26 # Upgrade previous tables to current
27 # Restart the server
28 # restart: --datadir=DATADIR
29 SHOW TABLES;
30 Tables_in_test
31 ta1b1_compact
32 ta1b1_dynamic
33 ta1b1_redundant
34 ta1b2_compact
35 ta1b2_dynamic
36 ta1b2_redundant
37 ta1b3_compact
38 ta1b3_dynamic
39 ta1b3_redundant
40 ta1b4_compact
41 ta1b4_dynamic
42 ta1b4_redundant
43 ta2b2_compact
44 ta2b2_dynamic
45 ta2b2_redundant
46 ta2b4_compact
47 ta2b4_dynamic
48 ta2b4_redundant
49 ta3b2_compact
50 ta3b2_dynamic
51 ta3b2_redundant
52 ta3b3_compact
53 ta3b3_dynamic
54 ta3b3_redundant
55 ta3b4_compact
56 ta3b4_dynamic
57 ta3b4_redundant
58 # For all REDUNDANT tables:
59 # Prepare the table
60 # Processing alters:
61 # b1, b2: no alter add in trunk
62 # b3: alter add
63 ALTER TABLE ta1b3_redundant ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
64 ALTER TABLE ta1b3_redundant ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
65 ALTER TABLE ta3b3_redundant ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
66 ALTER TABLE ta3b3_redundant ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
67 # b4: alter add
68 ALTER TABLE ta1b4_redundant ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
69 ALTER TABLE ta1b4_redundant ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
70 ALTER TABLE ta2b4_redundant ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
71 ALTER TABLE ta2b4_redundant ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
72 ALTER TABLE ta3b4_redundant ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
73 ALTER TABLE ta3b4_redundant ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
74 # Processing row inserts:
75 # a3: rows have version from new table
76 INSERT INTO ta3b3_redundant VALUES (1, "row1", 2, 3, 4, 5, 10, 11, 12, 13);;
77 INSERT INTO ta3b3_redundant (c0, c1, c3, c5, c11, c13) VALUES (2, "row2", 33, 55, 1111, 1313);;
78 INSERT INTO ta3b4_redundant VALUES (1, "row1", 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13);;
79 INSERT INTO ta3b4_redundant (c0, c1, c3, c5, c7, c9, c11, c13) VALUES (2, "row2", 33, 55, 77, 99, 1111, 1313);;
80 # For each table, do online ddl
81 # Run online ddl for ta1b1
82 # Metadata from INFORMATION_SCHEMA.TABLES
83 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
84 test/ta1b1_redundant 9 0 0
85 # Metadata from INFORMATION_SCHEMA.COLUMNS
86 NAME POS MTYPE PRTYPE HAS_DEFAULT
87 c0 0 6 1027 0
88 c1 1 5 16711932 0
89 c2 2 6 1027 0
90 c3 3 6 1283 0
91 c4 4 6 1027 0
92 c5 5 6 1283 0
93 SELECT * FROM ta1b1_redundant;;
94 c0 c1 c2 c3 c4 c5
95 1 row1 2 3 4 5
96 2 row2 NULL 33 40 55
97 SHOW CREATE TABLE ta1b1_redundant;;
98 Table Create Table
99 ta1b1_redundant CREATE TABLE `ta1b1_redundant` (
100 `c0` int DEFAULT NULL,
101 `c1` text,
102 `c2` int DEFAULT NULL,
103 `c3` int NOT NULL,
104 `c4` int DEFAULT '40',
105 `c5` int NOT NULL DEFAULT '50'
106 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
107 CHECK TABLE ta1b1_redundant;;
108 Table Op Msg_type Msg_text
109 test.ta1b1_redundant check status OK
110 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL update_now WAIT_FOR update_done';
111 ALTER TABLE ta1b1_redundant ADD PRIMARY KEY (c0);
112 SET DEBUG_SYNC='now WAIT_FOR update_now';
113 # Metadata from INFORMATION_SCHEMA.TABLES
114 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
115 test/ta1b1_redundant 9 0 0
116 # Metadata from INFORMATION_SCHEMA.COLUMNS
117 NAME POS MTYPE PRTYPE HAS_DEFAULT
118 c0 0 6 1027 0
119 c1 1 5 16711932 0
120 c2 2 6 1027 0
121 c3 3 6 1283 0
122 c4 4 6 1027 0
123 c5 5 6 1283 0
124 SELECT * FROM ta1b1_redundant;
125 c0 c1 c2 c3 c4 c5
126 1 row1 2 3 4 5
127 2 row2 NULL 33 40 55
128 SHOW CREATE TABLE ta1b1_redundant;
129 Table Create Table
130 ta1b1_redundant CREATE TABLE `ta1b1_redundant` (
131 `c0` int DEFAULT NULL,
132 `c1` text,
133 `c2` int DEFAULT NULL,
134 `c3` int NOT NULL,
135 `c4` int DEFAULT '40',
136 `c5` int NOT NULL DEFAULT '50'
137 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
138 CHECK TABLE ta1b1_redundant;
139 Table Op Msg_type Msg_text
140 test.ta1b1_redundant check status OK
141 UPDATE ta1b1_redundant SET c2 = 1;
142 # Metadata from INFORMATION_SCHEMA.TABLES
143 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
144 test/ta1b1_redundant 9 0 0
145 # Metadata from INFORMATION_SCHEMA.COLUMNS
146 NAME POS MTYPE PRTYPE HAS_DEFAULT
147 c0 0 6 1027 0
148 c1 1 5 16711932 0
149 c2 2 6 1027 0
150 c3 3 6 1283 0
151 c4 4 6 1027 0
152 c5 5 6 1283 0
153 SELECT * FROM ta1b1_redundant;
154 c0 c1 c2 c3 c4 c5
155 1 row1 1 3 4 5
156 2 row2 1 33 40 55
157 SHOW CREATE TABLE ta1b1_redundant;
158 Table Create Table
159 ta1b1_redundant CREATE TABLE `ta1b1_redundant` (
160 `c0` int DEFAULT NULL,
161 `c1` text,
162 `c2` int DEFAULT NULL,
163 `c3` int NOT NULL,
164 `c4` int DEFAULT '40',
165 `c5` int NOT NULL DEFAULT '50'
166 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
167 CHECK TABLE ta1b1_redundant;
168 Table Op Msg_type Msg_text
169 test.ta1b1_redundant check status OK
170 SET DEBUG_SYNC='now SIGNAL update_done';
171 # Metadata from INFORMATION_SCHEMA.TABLES
172 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
173 test/ta1b1_redundant 9 0 0
174 # Metadata from INFORMATION_SCHEMA.COLUMNS
175 NAME POS MTYPE PRTYPE HAS_DEFAULT
176 c0 0 6 1283 0
177 c1 1 5 16711932 0
178 c2 2 6 1027 0
179 c3 3 6 1283 0
180 c4 4 6 1027 0
181 c5 5 6 1283 0
182 SELECT * FROM ta1b1_redundant;
183 c0 c1 c2 c3 c4 c5
184 1 row1 1 3 4 5
185 2 row2 1 33 40 55
186 SHOW CREATE TABLE ta1b1_redundant;
187 Table Create Table
188 ta1b1_redundant CREATE TABLE `ta1b1_redundant` (
189 `c0` int NOT NULL,
190 `c1` text,
191 `c2` int DEFAULT NULL,
192 `c3` int NOT NULL,
193 `c4` int DEFAULT '40',
194 `c5` int NOT NULL DEFAULT '50',
195 PRIMARY KEY (`c0`)
196 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
197 CHECK TABLE ta1b1_redundant;
198 Table Op Msg_type Msg_text
199 test.ta1b1_redundant check status OK
200 DROP TABLE ta1b1_redundant;
201 # Run online ddl for ta1b2
202 # Metadata from INFORMATION_SCHEMA.TABLES
203 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
204 test/ta1b2_redundant 13 6 0
205 # Metadata from INFORMATION_SCHEMA.COLUMNS
206 NAME POS MTYPE PRTYPE HAS_DEFAULT
207 c0 0 6 1027 0
208 c1 1 5 16711932 0
209 c2 2 6 1027 0
210 c3 3 6 1283 0
211 c4 4 6 1027 0
212 c5 5 6 1283 0
213 c6 6 6 1027 1
214 c7 7 6 1283 1
215 c8 8 6 1027 1
216 c9 9 6 1283 1
217 SELECT * FROM ta1b2_redundant;;
218 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
219 1 row1 2 3 4 5 NULL 0 80 90
220 2 row2 NULL 33 40 55 NULL 0 80 90
221 SHOW CREATE TABLE ta1b2_redundant;;
222 Table Create Table
223 ta1b2_redundant CREATE TABLE `ta1b2_redundant` (
224 `c0` int DEFAULT NULL,
225 `c1` text,
226 `c2` int DEFAULT NULL,
227 `c3` int NOT NULL,
228 `c4` int DEFAULT '40',
229 `c5` int NOT NULL DEFAULT '50',
230 `c6` int DEFAULT NULL,
231 `c7` int NOT NULL,
232 `c8` int DEFAULT '80',
233 `c9` int NOT NULL DEFAULT '90'
234 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
235 CHECK TABLE ta1b2_redundant;;
236 Table Op Msg_type Msg_text
237 test.ta1b2_redundant check status OK
238 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL update_now WAIT_FOR update_done';
239 ALTER TABLE ta1b2_redundant ADD PRIMARY KEY (c0);
240 SET DEBUG_SYNC='now WAIT_FOR update_now';
241 # Metadata from INFORMATION_SCHEMA.TABLES
242 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
243 test/ta1b2_redundant 13 6 0
244 # Metadata from INFORMATION_SCHEMA.COLUMNS
245 NAME POS MTYPE PRTYPE HAS_DEFAULT
246 c0 0 6 1027 0
247 c1 1 5 16711932 0
248 c2 2 6 1027 0
249 c3 3 6 1283 0
250 c4 4 6 1027 0
251 c5 5 6 1283 0
252 c6 6 6 1027 1
253 c7 7 6 1283 1
254 c8 8 6 1027 1
255 c9 9 6 1283 1
256 SELECT * FROM ta1b2_redundant;
257 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
258 1 row1 2 3 4 5 NULL 0 80 90
259 2 row2 NULL 33 40 55 NULL 0 80 90
260 SHOW CREATE TABLE ta1b2_redundant;
261 Table Create Table
262 ta1b2_redundant CREATE TABLE `ta1b2_redundant` (
263 `c0` int DEFAULT NULL,
264 `c1` text,
265 `c2` int DEFAULT NULL,
266 `c3` int NOT NULL,
267 `c4` int DEFAULT '40',
268 `c5` int NOT NULL DEFAULT '50',
269 `c6` int DEFAULT NULL,
270 `c7` int NOT NULL,
271 `c8` int DEFAULT '80',
272 `c9` int NOT NULL DEFAULT '90'
273 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
274 CHECK TABLE ta1b2_redundant;
275 Table Op Msg_type Msg_text
276 test.ta1b2_redundant check status OK
277 UPDATE ta1b2_redundant SET c2 = 1;
278 # Metadata from INFORMATION_SCHEMA.TABLES
279 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
280 test/ta1b2_redundant 13 6 0
281 # Metadata from INFORMATION_SCHEMA.COLUMNS
282 NAME POS MTYPE PRTYPE HAS_DEFAULT
283 c0 0 6 1027 0
284 c1 1 5 16711932 0
285 c2 2 6 1027 0
286 c3 3 6 1283 0
287 c4 4 6 1027 0
288 c5 5 6 1283 0
289 c6 6 6 1027 1
290 c7 7 6 1283 1
291 c8 8 6 1027 1
292 c9 9 6 1283 1
293 SELECT * FROM ta1b2_redundant;
294 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
295 1 row1 1 3 4 5 NULL 0 80 90
296 2 row2 1 33 40 55 NULL 0 80 90
297 SHOW CREATE TABLE ta1b2_redundant;
298 Table Create Table
299 ta1b2_redundant CREATE TABLE `ta1b2_redundant` (
300 `c0` int DEFAULT NULL,
301 `c1` text,
302 `c2` int DEFAULT NULL,
303 `c3` int NOT NULL,
304 `c4` int DEFAULT '40',
305 `c5` int NOT NULL DEFAULT '50',
306 `c6` int DEFAULT NULL,
307 `c7` int NOT NULL,
308 `c8` int DEFAULT '80',
309 `c9` int NOT NULL DEFAULT '90'
310 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
311 CHECK TABLE ta1b2_redundant;
312 Table Op Msg_type Msg_text
313 test.ta1b2_redundant check status OK
314 SET DEBUG_SYNC='now SIGNAL update_done';
315 # Metadata from INFORMATION_SCHEMA.TABLES
316 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
317 test/ta1b2_redundant 13 0 0
318 # Metadata from INFORMATION_SCHEMA.COLUMNS
319 NAME POS MTYPE PRTYPE HAS_DEFAULT
320 c0 0 6 1283 0
321 c1 1 5 16711932 0
322 c2 2 6 1027 0
323 c3 3 6 1283 0
324 c4 4 6 1027 0
325 c5 5 6 1283 0
326 c6 6 6 1027 0
327 c7 7 6 1283 0
328 c8 8 6 1027 0
329 c9 9 6 1283 0
330 SELECT * FROM ta1b2_redundant;
331 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
332 1 row1 1 3 4 5 NULL 0 80 90
333 2 row2 1 33 40 55 NULL 0 80 90
334 SHOW CREATE TABLE ta1b2_redundant;
335 Table Create Table
336 ta1b2_redundant CREATE TABLE `ta1b2_redundant` (
337 `c0` int NOT NULL,
338 `c1` text,
339 `c2` int DEFAULT NULL,
340 `c3` int NOT NULL,
341 `c4` int DEFAULT '40',
342 `c5` int NOT NULL DEFAULT '50',
343 `c6` int DEFAULT NULL,
344 `c7` int NOT NULL,
345 `c8` int DEFAULT '80',
346 `c9` int NOT NULL DEFAULT '90',
347 PRIMARY KEY (`c0`)
348 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
349 CHECK TABLE ta1b2_redundant;
350 Table Op Msg_type Msg_text
351 test.ta1b2_redundant check status OK
352 DROP TABLE ta1b2_redundant;
353 # Run online ddl for ta1b3
354 # Metadata from INFORMATION_SCHEMA.TABLES
355 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
356 test/ta1b3_redundant 13 0 2
357 # Metadata from INFORMATION_SCHEMA.COLUMNS
358 NAME POS MTYPE PRTYPE HAS_DEFAULT
359 c0 0 6 1027 0
360 c1 1 5 16711932 0
361 c2 2 6 1027 0
362 c3 3 6 1283 0
363 c4 4 6 1027 0
364 c5 5 6 1283 0
365 c10 6 6 1027 1
366 c11 7 6 1283 1
367 c12 8 6 1027 1
368 c13 9 6 1283 1
369 SELECT * FROM ta1b3_redundant;;
370 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
371 1 row1 2 3 4 5 NULL 0 120 130
372 2 row2 NULL 33 40 55 NULL 0 120 130
373 SHOW CREATE TABLE ta1b3_redundant;;
374 Table Create Table
375 ta1b3_redundant CREATE TABLE `ta1b3_redundant` (
376 `c0` int DEFAULT NULL,
377 `c1` text,
378 `c2` int DEFAULT NULL,
379 `c3` int NOT NULL,
380 `c4` int DEFAULT '40',
381 `c5` int NOT NULL DEFAULT '50',
382 `c10` int DEFAULT NULL,
383 `c11` int NOT NULL,
384 `c12` int DEFAULT '120',
385 `c13` int NOT NULL DEFAULT '130'
386 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
387 CHECK TABLE ta1b3_redundant;;
388 Table Op Msg_type Msg_text
389 test.ta1b3_redundant check status OK
390 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL update_now WAIT_FOR update_done';
391 ALTER TABLE ta1b3_redundant ADD PRIMARY KEY (c0);
392 SET DEBUG_SYNC='now WAIT_FOR update_now';
393 # Metadata from INFORMATION_SCHEMA.TABLES
394 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
395 test/ta1b3_redundant 13 0 2
396 # Metadata from INFORMATION_SCHEMA.COLUMNS
397 NAME POS MTYPE PRTYPE HAS_DEFAULT
398 c0 0 6 1027 0
399 c1 1 5 16711932 0
400 c2 2 6 1027 0
401 c3 3 6 1283 0
402 c4 4 6 1027 0
403 c5 5 6 1283 0
404 c10 6 6 1027 1
405 c11 7 6 1283 1
406 c12 8 6 1027 1
407 c13 9 6 1283 1
408 SELECT * FROM ta1b3_redundant;
409 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
410 1 row1 2 3 4 5 NULL 0 120 130
411 2 row2 NULL 33 40 55 NULL 0 120 130
412 SHOW CREATE TABLE ta1b3_redundant;
413 Table Create Table
414 ta1b3_redundant CREATE TABLE `ta1b3_redundant` (
415 `c0` int DEFAULT NULL,
416 `c1` text,
417 `c2` int DEFAULT NULL,
418 `c3` int NOT NULL,
419 `c4` int DEFAULT '40',
420 `c5` int NOT NULL DEFAULT '50',
421 `c10` int DEFAULT NULL,
422 `c11` int NOT NULL,
423 `c12` int DEFAULT '120',
424 `c13` int NOT NULL DEFAULT '130'
425 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
426 CHECK TABLE ta1b3_redundant;
427 Table Op Msg_type Msg_text
428 test.ta1b3_redundant check status OK
429 UPDATE ta1b3_redundant SET c2 = 1;
430 # Metadata from INFORMATION_SCHEMA.TABLES
431 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
432 test/ta1b3_redundant 13 0 2
433 # Metadata from INFORMATION_SCHEMA.COLUMNS
434 NAME POS MTYPE PRTYPE HAS_DEFAULT
435 c0 0 6 1027 0
436 c1 1 5 16711932 0
437 c2 2 6 1027 0
438 c3 3 6 1283 0
439 c4 4 6 1027 0
440 c5 5 6 1283 0
441 c10 6 6 1027 1
442 c11 7 6 1283 1
443 c12 8 6 1027 1
444 c13 9 6 1283 1
445 SELECT * FROM ta1b3_redundant;
446 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
447 1 row1 1 3 4 5 NULL 0 120 130
448 2 row2 1 33 40 55 NULL 0 120 130
449 SHOW CREATE TABLE ta1b3_redundant;
450 Table Create Table
451 ta1b3_redundant CREATE TABLE `ta1b3_redundant` (
452 `c0` int DEFAULT NULL,
453 `c1` text,
454 `c2` int DEFAULT NULL,
455 `c3` int NOT NULL,
456 `c4` int DEFAULT '40',
457 `c5` int NOT NULL DEFAULT '50',
458 `c10` int DEFAULT NULL,
459 `c11` int NOT NULL,
460 `c12` int DEFAULT '120',
461 `c13` int NOT NULL DEFAULT '130'
462 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
463 CHECK TABLE ta1b3_redundant;
464 Table Op Msg_type Msg_text
465 test.ta1b3_redundant check status OK
466 SET DEBUG_SYNC='now SIGNAL update_done';
467 # Metadata from INFORMATION_SCHEMA.TABLES
468 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
469 test/ta1b3_redundant 13 0 0
470 # Metadata from INFORMATION_SCHEMA.COLUMNS
471 NAME POS MTYPE PRTYPE HAS_DEFAULT
472 c0 0 6 1283 0
473 c1 1 5 16711932 0
474 c2 2 6 1027 0
475 c3 3 6 1283 0
476 c4 4 6 1027 0
477 c5 5 6 1283 0
478 c10 6 6 1027 0
479 c11 7 6 1283 0
480 c12 8 6 1027 0
481 c13 9 6 1283 0
482 SELECT * FROM ta1b3_redundant;
483 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
484 1 row1 1 3 4 5 NULL 0 120 130
485 2 row2 1 33 40 55 NULL 0 120 130
486 SHOW CREATE TABLE ta1b3_redundant;
487 Table Create Table
488 ta1b3_redundant CREATE TABLE `ta1b3_redundant` (
489 `c0` int NOT NULL,
490 `c1` text,
491 `c2` int DEFAULT NULL,
492 `c3` int NOT NULL,
493 `c4` int DEFAULT '40',
494 `c5` int NOT NULL DEFAULT '50',
495 `c10` int DEFAULT NULL,
496 `c11` int NOT NULL,
497 `c12` int DEFAULT '120',
498 `c13` int NOT NULL DEFAULT '130',
499 PRIMARY KEY (`c0`)
500 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
501 CHECK TABLE ta1b3_redundant;
502 Table Op Msg_type Msg_text
503 test.ta1b3_redundant check status OK
504 DROP TABLE ta1b3_redundant;
505 # Run online ddl for ta1b4
506 # Metadata from INFORMATION_SCHEMA.TABLES
507 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
508 test/ta1b4_redundant 17 6 2
509 # Metadata from INFORMATION_SCHEMA.COLUMNS
510 NAME POS MTYPE PRTYPE HAS_DEFAULT
511 c0 0 6 1027 0
512 c1 1 5 16711932 0
513 c2 2 6 1027 0
514 c3 3 6 1283 0
515 c4 4 6 1027 0
516 c5 5 6 1283 0
517 c6 6 6 1027 1
518 c7 7 6 1283 1
519 c8 8 6 1027 1
520 c9 9 6 1283 1
521 c10 10 6 1027 1
522 c11 11 6 1283 1
523 c12 12 6 1027 1
524 c13 13 6 1283 1
525 SELECT * FROM ta1b4_redundant;;
526 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
527 1 row1 2 3 4 5 NULL 0 80 90 NULL 0 120 130
528 2 row2 NULL 33 40 55 NULL 0 80 90 NULL 0 120 130
529 SHOW CREATE TABLE ta1b4_redundant;;
530 Table Create Table
531 ta1b4_redundant CREATE TABLE `ta1b4_redundant` (
532 `c0` int DEFAULT NULL,
533 `c1` text,
534 `c2` int DEFAULT NULL,
535 `c3` int NOT NULL,
536 `c4` int DEFAULT '40',
537 `c5` int NOT NULL DEFAULT '50',
538 `c6` int DEFAULT NULL,
539 `c7` int NOT NULL,
540 `c8` int DEFAULT '80',
541 `c9` int NOT NULL DEFAULT '90',
542 `c10` int DEFAULT NULL,
543 `c11` int NOT NULL,
544 `c12` int DEFAULT '120',
545 `c13` int NOT NULL DEFAULT '130'
546 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
547 CHECK TABLE ta1b4_redundant;;
548 Table Op Msg_type Msg_text
549 test.ta1b4_redundant check status OK
550 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL update_now WAIT_FOR update_done';
551 ALTER TABLE ta1b4_redundant ADD PRIMARY KEY (c0);
552 SET DEBUG_SYNC='now WAIT_FOR update_now';
553 # Metadata from INFORMATION_SCHEMA.TABLES
554 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
555 test/ta1b4_redundant 17 6 2
556 # Metadata from INFORMATION_SCHEMA.COLUMNS
557 NAME POS MTYPE PRTYPE HAS_DEFAULT
558 c0 0 6 1027 0
559 c1 1 5 16711932 0
560 c2 2 6 1027 0
561 c3 3 6 1283 0
562 c4 4 6 1027 0
563 c5 5 6 1283 0
564 c6 6 6 1027 1
565 c7 7 6 1283 1
566 c8 8 6 1027 1
567 c9 9 6 1283 1
568 c10 10 6 1027 1
569 c11 11 6 1283 1
570 c12 12 6 1027 1
571 c13 13 6 1283 1
572 SELECT * FROM ta1b4_redundant;
573 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
574 1 row1 2 3 4 5 NULL 0 80 90 NULL 0 120 130
575 2 row2 NULL 33 40 55 NULL 0 80 90 NULL 0 120 130
576 SHOW CREATE TABLE ta1b4_redundant;
577 Table Create Table
578 ta1b4_redundant CREATE TABLE `ta1b4_redundant` (
579 `c0` int DEFAULT NULL,
580 `c1` text,
581 `c2` int DEFAULT NULL,
582 `c3` int NOT NULL,
583 `c4` int DEFAULT '40',
584 `c5` int NOT NULL DEFAULT '50',
585 `c6` int DEFAULT NULL,
586 `c7` int NOT NULL,
587 `c8` int DEFAULT '80',
588 `c9` int NOT NULL DEFAULT '90',
589 `c10` int DEFAULT NULL,
590 `c11` int NOT NULL,
591 `c12` int DEFAULT '120',
592 `c13` int NOT NULL DEFAULT '130'
593 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
594 CHECK TABLE ta1b4_redundant;
595 Table Op Msg_type Msg_text
596 test.ta1b4_redundant check status OK
597 UPDATE ta1b4_redundant SET c2 = 1;
598 # Metadata from INFORMATION_SCHEMA.TABLES
599 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
600 test/ta1b4_redundant 17 6 2
601 # Metadata from INFORMATION_SCHEMA.COLUMNS
602 NAME POS MTYPE PRTYPE HAS_DEFAULT
603 c0 0 6 1027 0
604 c1 1 5 16711932 0
605 c2 2 6 1027 0
606 c3 3 6 1283 0
607 c4 4 6 1027 0
608 c5 5 6 1283 0
609 c6 6 6 1027 1
610 c7 7 6 1283 1
611 c8 8 6 1027 1
612 c9 9 6 1283 1
613 c10 10 6 1027 1
614 c11 11 6 1283 1
615 c12 12 6 1027 1
616 c13 13 6 1283 1
617 SELECT * FROM ta1b4_redundant;
618 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
619 1 row1 1 3 4 5 NULL 0 80 90 NULL 0 120 130
620 2 row2 1 33 40 55 NULL 0 80 90 NULL 0 120 130
621 SHOW CREATE TABLE ta1b4_redundant;
622 Table Create Table
623 ta1b4_redundant CREATE TABLE `ta1b4_redundant` (
624 `c0` int DEFAULT NULL,
625 `c1` text,
626 `c2` int DEFAULT NULL,
627 `c3` int NOT NULL,
628 `c4` int DEFAULT '40',
629 `c5` int NOT NULL DEFAULT '50',
630 `c6` int DEFAULT NULL,
631 `c7` int NOT NULL,
632 `c8` int DEFAULT '80',
633 `c9` int NOT NULL DEFAULT '90',
634 `c10` int DEFAULT NULL,
635 `c11` int NOT NULL,
636 `c12` int DEFAULT '120',
637 `c13` int NOT NULL DEFAULT '130'
638 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
639 CHECK TABLE ta1b4_redundant;
640 Table Op Msg_type Msg_text
641 test.ta1b4_redundant check status OK
642 SET DEBUG_SYNC='now SIGNAL update_done';
643 # Metadata from INFORMATION_SCHEMA.TABLES
644 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
645 test/ta1b4_redundant 17 0 0
646 # Metadata from INFORMATION_SCHEMA.COLUMNS
647 NAME POS MTYPE PRTYPE HAS_DEFAULT
648 c0 0 6 1283 0
649 c1 1 5 16711932 0
650 c2 2 6 1027 0
651 c3 3 6 1283 0
652 c4 4 6 1027 0
653 c5 5 6 1283 0
654 c6 6 6 1027 0
655 c7 7 6 1283 0
656 c8 8 6 1027 0
657 c9 9 6 1283 0
658 c10 10 6 1027 0
659 c11 11 6 1283 0
660 c12 12 6 1027 0
661 c13 13 6 1283 0
662 SELECT * FROM ta1b4_redundant;
663 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
664 1 row1 1 3 4 5 NULL 0 80 90 NULL 0 120 130
665 2 row2 1 33 40 55 NULL 0 80 90 NULL 0 120 130
666 SHOW CREATE TABLE ta1b4_redundant;
667 Table Create Table
668 ta1b4_redundant CREATE TABLE `ta1b4_redundant` (
669 `c0` int NOT NULL,
670 `c1` text,
671 `c2` int DEFAULT NULL,
672 `c3` int NOT NULL,
673 `c4` int DEFAULT '40',
674 `c5` int NOT NULL DEFAULT '50',
675 `c6` int DEFAULT NULL,
676 `c7` int NOT NULL,
677 `c8` int DEFAULT '80',
678 `c9` int NOT NULL DEFAULT '90',
679 `c10` int DEFAULT NULL,
680 `c11` int NOT NULL,
681 `c12` int DEFAULT '120',
682 `c13` int NOT NULL DEFAULT '130',
683 PRIMARY KEY (`c0`)
684 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
685 CHECK TABLE ta1b4_redundant;
686 Table Op Msg_type Msg_text
687 test.ta1b4_redundant check status OK
688 DROP TABLE ta1b4_redundant;
689 # Run online ddl for ta2b2
690 # Metadata from INFORMATION_SCHEMA.TABLES
691 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
692 test/ta2b2_redundant 13 6 0
693 # Metadata from INFORMATION_SCHEMA.COLUMNS
694 NAME POS MTYPE PRTYPE HAS_DEFAULT
695 c0 0 6 1027 0
696 c1 1 5 16711932 0
697 c2 2 6 1027 0
698 c3 3 6 1283 0
699 c4 4 6 1027 0
700 c5 5 6 1283 0
701 c6 6 6 1027 1
702 c7 7 6 1283 1
703 c8 8 6 1027 1
704 c9 9 6 1283 1
705 SELECT * FROM ta2b2_redundant;;
706 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
707 1 row1 2 3 4 5 6 7 8 9
708 2 row2 NULL 33 40 55 NULL 77 80 99
709 SHOW CREATE TABLE ta2b2_redundant;;
710 Table Create Table
711 ta2b2_redundant CREATE TABLE `ta2b2_redundant` (
712 `c0` int DEFAULT NULL,
713 `c1` text,
714 `c2` int DEFAULT NULL,
715 `c3` int NOT NULL,
716 `c4` int DEFAULT '40',
717 `c5` int NOT NULL DEFAULT '50',
718 `c6` int DEFAULT NULL,
719 `c7` int NOT NULL,
720 `c8` int DEFAULT '80',
721 `c9` int NOT NULL DEFAULT '90'
722 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
723 CHECK TABLE ta2b2_redundant;;
724 Table Op Msg_type Msg_text
725 test.ta2b2_redundant check status OK
726 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL update_now WAIT_FOR update_done';
727 ALTER TABLE ta2b2_redundant ADD PRIMARY KEY (c0);
728 SET DEBUG_SYNC='now WAIT_FOR update_now';
729 # Metadata from INFORMATION_SCHEMA.TABLES
730 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
731 test/ta2b2_redundant 13 6 0
732 # Metadata from INFORMATION_SCHEMA.COLUMNS
733 NAME POS MTYPE PRTYPE HAS_DEFAULT
734 c0 0 6 1027 0
735 c1 1 5 16711932 0
736 c2 2 6 1027 0
737 c3 3 6 1283 0
738 c4 4 6 1027 0
739 c5 5 6 1283 0
740 c6 6 6 1027 1
741 c7 7 6 1283 1
742 c8 8 6 1027 1
743 c9 9 6 1283 1
744 SELECT * FROM ta2b2_redundant;
745 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
746 1 row1 2 3 4 5 6 7 8 9
747 2 row2 NULL 33 40 55 NULL 77 80 99
748 SHOW CREATE TABLE ta2b2_redundant;
749 Table Create Table
750 ta2b2_redundant CREATE TABLE `ta2b2_redundant` (
751 `c0` int DEFAULT NULL,
752 `c1` text,
753 `c2` int DEFAULT NULL,
754 `c3` int NOT NULL,
755 `c4` int DEFAULT '40',
756 `c5` int NOT NULL DEFAULT '50',
757 `c6` int DEFAULT NULL,
758 `c7` int NOT NULL,
759 `c8` int DEFAULT '80',
760 `c9` int NOT NULL DEFAULT '90'
761 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
762 CHECK TABLE ta2b2_redundant;
763 Table Op Msg_type Msg_text
764 test.ta2b2_redundant check status OK
765 UPDATE ta2b2_redundant SET c2 = 1;
766 # Metadata from INFORMATION_SCHEMA.TABLES
767 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
768 test/ta2b2_redundant 13 6 0
769 # Metadata from INFORMATION_SCHEMA.COLUMNS
770 NAME POS MTYPE PRTYPE HAS_DEFAULT
771 c0 0 6 1027 0
772 c1 1 5 16711932 0
773 c2 2 6 1027 0
774 c3 3 6 1283 0
775 c4 4 6 1027 0
776 c5 5 6 1283 0
777 c6 6 6 1027 1
778 c7 7 6 1283 1
779 c8 8 6 1027 1
780 c9 9 6 1283 1
781 SELECT * FROM ta2b2_redundant;
782 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
783 1 row1 1 3 4 5 6 7 8 9
784 2 row2 1 33 40 55 NULL 77 80 99
785 SHOW CREATE TABLE ta2b2_redundant;
786 Table Create Table
787 ta2b2_redundant CREATE TABLE `ta2b2_redundant` (
788 `c0` int DEFAULT NULL,
789 `c1` text,
790 `c2` int DEFAULT NULL,
791 `c3` int NOT NULL,
792 `c4` int DEFAULT '40',
793 `c5` int NOT NULL DEFAULT '50',
794 `c6` int DEFAULT NULL,
795 `c7` int NOT NULL,
796 `c8` int DEFAULT '80',
797 `c9` int NOT NULL DEFAULT '90'
798 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
799 CHECK TABLE ta2b2_redundant;
800 Table Op Msg_type Msg_text
801 test.ta2b2_redundant check status OK
802 SET DEBUG_SYNC='now SIGNAL update_done';
803 # Metadata from INFORMATION_SCHEMA.TABLES
804 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
805 test/ta2b2_redundant 13 0 0
806 # Metadata from INFORMATION_SCHEMA.COLUMNS
807 NAME POS MTYPE PRTYPE HAS_DEFAULT
808 c0 0 6 1283 0
809 c1 1 5 16711932 0
810 c2 2 6 1027 0
811 c3 3 6 1283 0
812 c4 4 6 1027 0
813 c5 5 6 1283 0
814 c6 6 6 1027 0
815 c7 7 6 1283 0
816 c8 8 6 1027 0
817 c9 9 6 1283 0
818 SELECT * FROM ta2b2_redundant;
819 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
820 1 row1 1 3 4 5 6 7 8 9
821 2 row2 1 33 40 55 NULL 77 80 99
822 SHOW CREATE TABLE ta2b2_redundant;
823 Table Create Table
824 ta2b2_redundant CREATE TABLE `ta2b2_redundant` (
825 `c0` int NOT NULL,
826 `c1` text,
827 `c2` int DEFAULT NULL,
828 `c3` int NOT NULL,
829 `c4` int DEFAULT '40',
830 `c5` int NOT NULL DEFAULT '50',
831 `c6` int DEFAULT NULL,
832 `c7` int NOT NULL,
833 `c8` int DEFAULT '80',
834 `c9` int NOT NULL DEFAULT '90',
835 PRIMARY KEY (`c0`)
836 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
837 CHECK TABLE ta2b2_redundant;
838 Table Op Msg_type Msg_text
839 test.ta2b2_redundant check status OK
840 DROP TABLE ta2b2_redundant;
841 # Run online ddl for ta2b4
842 # Metadata from INFORMATION_SCHEMA.TABLES
843 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
844 test/ta2b4_redundant 17 6 2
845 # Metadata from INFORMATION_SCHEMA.COLUMNS
846 NAME POS MTYPE PRTYPE HAS_DEFAULT
847 c0 0 6 1027 0
848 c1 1 5 16711932 0
849 c2 2 6 1027 0
850 c3 3 6 1283 0
851 c4 4 6 1027 0
852 c5 5 6 1283 0
853 c6 6 6 1027 1
854 c7 7 6 1283 1
855 c8 8 6 1027 1
856 c9 9 6 1283 1
857 c10 10 6 1027 1
858 c11 11 6 1283 1
859 c12 12 6 1027 1
860 c13 13 6 1283 1
861 SELECT * FROM ta2b4_redundant;;
862 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
863 1 row1 2 3 4 5 6 7 8 9 NULL 0 120 130
864 2 row2 NULL 33 40 55 NULL 77 80 99 NULL 0 120 130
865 SHOW CREATE TABLE ta2b4_redundant;;
866 Table Create Table
867 ta2b4_redundant CREATE TABLE `ta2b4_redundant` (
868 `c0` int DEFAULT NULL,
869 `c1` text,
870 `c2` int DEFAULT NULL,
871 `c3` int NOT NULL,
872 `c4` int DEFAULT '40',
873 `c5` int NOT NULL DEFAULT '50',
874 `c6` int DEFAULT NULL,
875 `c7` int NOT NULL,
876 `c8` int DEFAULT '80',
877 `c9` int NOT NULL DEFAULT '90',
878 `c10` int DEFAULT NULL,
879 `c11` int NOT NULL,
880 `c12` int DEFAULT '120',
881 `c13` int NOT NULL DEFAULT '130'
882 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
883 CHECK TABLE ta2b4_redundant;;
884 Table Op Msg_type Msg_text
885 test.ta2b4_redundant check status OK
886 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL update_now WAIT_FOR update_done';
887 ALTER TABLE ta2b4_redundant ADD PRIMARY KEY (c0);
888 SET DEBUG_SYNC='now WAIT_FOR update_now';
889 # Metadata from INFORMATION_SCHEMA.TABLES
890 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
891 test/ta2b4_redundant 17 6 2
892 # Metadata from INFORMATION_SCHEMA.COLUMNS
893 NAME POS MTYPE PRTYPE HAS_DEFAULT
894 c0 0 6 1027 0
895 c1 1 5 16711932 0
896 c2 2 6 1027 0
897 c3 3 6 1283 0
898 c4 4 6 1027 0
899 c5 5 6 1283 0
900 c6 6 6 1027 1
901 c7 7 6 1283 1
902 c8 8 6 1027 1
903 c9 9 6 1283 1
904 c10 10 6 1027 1
905 c11 11 6 1283 1
906 c12 12 6 1027 1
907 c13 13 6 1283 1
908 SELECT * FROM ta2b4_redundant;
909 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
910 1 row1 2 3 4 5 6 7 8 9 NULL 0 120 130
911 2 row2 NULL 33 40 55 NULL 77 80 99 NULL 0 120 130
912 SHOW CREATE TABLE ta2b4_redundant;
913 Table Create Table
914 ta2b4_redundant CREATE TABLE `ta2b4_redundant` (
915 `c0` int DEFAULT NULL,
916 `c1` text,
917 `c2` int DEFAULT NULL,
918 `c3` int NOT NULL,
919 `c4` int DEFAULT '40',
920 `c5` int NOT NULL DEFAULT '50',
921 `c6` int DEFAULT NULL,
922 `c7` int NOT NULL,
923 `c8` int DEFAULT '80',
924 `c9` int NOT NULL DEFAULT '90',
925 `c10` int DEFAULT NULL,
926 `c11` int NOT NULL,
927 `c12` int DEFAULT '120',
928 `c13` int NOT NULL DEFAULT '130'
929 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
930 CHECK TABLE ta2b4_redundant;
931 Table Op Msg_type Msg_text
932 test.ta2b4_redundant check status OK
933 UPDATE ta2b4_redundant SET c2 = 1;
934 # Metadata from INFORMATION_SCHEMA.TABLES
935 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
936 test/ta2b4_redundant 17 6 2
937 # Metadata from INFORMATION_SCHEMA.COLUMNS
938 NAME POS MTYPE PRTYPE HAS_DEFAULT
939 c0 0 6 1027 0
940 c1 1 5 16711932 0
941 c2 2 6 1027 0
942 c3 3 6 1283 0
943 c4 4 6 1027 0
944 c5 5 6 1283 0
945 c6 6 6 1027 1
946 c7 7 6 1283 1
947 c8 8 6 1027 1
948 c9 9 6 1283 1
949 c10 10 6 1027 1
950 c11 11 6 1283 1
951 c12 12 6 1027 1
952 c13 13 6 1283 1
953 SELECT * FROM ta2b4_redundant;
954 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
955 1 row1 1 3 4 5 6 7 8 9 NULL 0 120 130
956 2 row2 1 33 40 55 NULL 77 80 99 NULL 0 120 130
957 SHOW CREATE TABLE ta2b4_redundant;
958 Table Create Table
959 ta2b4_redundant CREATE TABLE `ta2b4_redundant` (
960 `c0` int DEFAULT NULL,
961 `c1` text,
962 `c2` int DEFAULT NULL,
963 `c3` int NOT NULL,
964 `c4` int DEFAULT '40',
965 `c5` int NOT NULL DEFAULT '50',
966 `c6` int DEFAULT NULL,
967 `c7` int NOT NULL,
968 `c8` int DEFAULT '80',
969 `c9` int NOT NULL DEFAULT '90',
970 `c10` int DEFAULT NULL,
971 `c11` int NOT NULL,
972 `c12` int DEFAULT '120',
973 `c13` int NOT NULL DEFAULT '130'
974 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
975 CHECK TABLE ta2b4_redundant;
976 Table Op Msg_type Msg_text
977 test.ta2b4_redundant check status OK
978 SET DEBUG_SYNC='now SIGNAL update_done';
979 # Metadata from INFORMATION_SCHEMA.TABLES
980 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
981 test/ta2b4_redundant 17 0 0
982 # Metadata from INFORMATION_SCHEMA.COLUMNS
983 NAME POS MTYPE PRTYPE HAS_DEFAULT
984 c0 0 6 1283 0
985 c1 1 5 16711932 0
986 c2 2 6 1027 0
987 c3 3 6 1283 0
988 c4 4 6 1027 0
989 c5 5 6 1283 0
990 c6 6 6 1027 0
991 c7 7 6 1283 0
992 c8 8 6 1027 0
993 c9 9 6 1283 0
994 c10 10 6 1027 0
995 c11 11 6 1283 0
996 c12 12 6 1027 0
997 c13 13 6 1283 0
998 SELECT * FROM ta2b4_redundant;
999 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
1000 1 row1 1 3 4 5 6 7 8 9 NULL 0 120 130
1001 2 row2 1 33 40 55 NULL 77 80 99 NULL 0 120 130
1002 SHOW CREATE TABLE ta2b4_redundant;
1003 Table Create Table
1004 ta2b4_redundant CREATE TABLE `ta2b4_redundant` (
1005 `c0` int NOT NULL,
1006 `c1` text,
1007 `c2` int DEFAULT NULL,
1008 `c3` int NOT NULL,
1009 `c4` int DEFAULT '40',
1010 `c5` int NOT NULL DEFAULT '50',
1011 `c6` int DEFAULT NULL,
1012 `c7` int NOT NULL,
1013 `c8` int DEFAULT '80',
1014 `c9` int NOT NULL DEFAULT '90',
1015 `c10` int DEFAULT NULL,
1016 `c11` int NOT NULL,
1017 `c12` int DEFAULT '120',
1018 `c13` int NOT NULL DEFAULT '130',
1019 PRIMARY KEY (`c0`)
1020 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
1021 CHECK TABLE ta2b4_redundant;
1022 Table Op Msg_type Msg_text
1023 test.ta2b4_redundant check status OK
1024 DROP TABLE ta2b4_redundant;
1025 # Run online ddl for ta3b2
1026 # Metadata from INFORMATION_SCHEMA.TABLES
1027 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1028 test/ta3b2_redundant 13 6 0
1029 # Metadata from INFORMATION_SCHEMA.COLUMNS
1030 NAME POS MTYPE PRTYPE HAS_DEFAULT
1031 c0 0 6 1027 0
1032 c1 1 5 16711932 0
1033 c2 2 6 1027 0
1034 c3 3 6 1283 0
1035 c4 4 6 1027 0
1036 c5 5 6 1283 0
1037 c6 6 6 1027 1
1038 c7 7 6 1283 1
1039 c8 8 6 1027 1
1040 c9 9 6 1283 1
1041 SELECT * FROM ta3b2_redundant;;
1042 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
1043 SHOW CREATE TABLE ta3b2_redundant;;
1044 Table Create Table
1045 ta3b2_redundant CREATE TABLE `ta3b2_redundant` (
1046 `c0` int DEFAULT NULL,
1047 `c1` text,
1048 `c2` int DEFAULT NULL,
1049 `c3` int NOT NULL,
1050 `c4` int DEFAULT '40',
1051 `c5` int NOT NULL DEFAULT '50',
1052 `c6` int DEFAULT NULL,
1053 `c7` int NOT NULL,
1054 `c8` int DEFAULT '80',
1055 `c9` int NOT NULL DEFAULT '90'
1056 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
1057 CHECK TABLE ta3b2_redundant;;
1058 Table Op Msg_type Msg_text
1059 test.ta3b2_redundant check status OK
1060 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL update_now WAIT_FOR update_done';
1061 ALTER TABLE ta3b2_redundant ADD PRIMARY KEY (c0);
1062 SET DEBUG_SYNC='now WAIT_FOR update_now';
1063 # Metadata from INFORMATION_SCHEMA.TABLES
1064 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1065 test/ta3b2_redundant 13 6 0
1066 # Metadata from INFORMATION_SCHEMA.COLUMNS
1067 NAME POS MTYPE PRTYPE HAS_DEFAULT
1068 c0 0 6 1027 0
1069 c1 1 5 16711932 0
1070 c2 2 6 1027 0
1071 c3 3 6 1283 0
1072 c4 4 6 1027 0
1073 c5 5 6 1283 0
1074 c6 6 6 1027 1
1075 c7 7 6 1283 1
1076 c8 8 6 1027 1
1077 c9 9 6 1283 1
1078 SELECT * FROM ta3b2_redundant;
1079 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
1080 SHOW CREATE TABLE ta3b2_redundant;
1081 Table Create Table
1082 ta3b2_redundant CREATE TABLE `ta3b2_redundant` (
1083 `c0` int DEFAULT NULL,
1084 `c1` text,
1085 `c2` int DEFAULT NULL,
1086 `c3` int NOT NULL,
1087 `c4` int DEFAULT '40',
1088 `c5` int NOT NULL DEFAULT '50',
1089 `c6` int DEFAULT NULL,
1090 `c7` int NOT NULL,
1091 `c8` int DEFAULT '80',
1092 `c9` int NOT NULL DEFAULT '90'
1093 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
1094 CHECK TABLE ta3b2_redundant;
1095 Table Op Msg_type Msg_text
1096 test.ta3b2_redundant check status OK
1097 UPDATE ta3b2_redundant SET c2 = 1;
1098 # Metadata from INFORMATION_SCHEMA.TABLES
1099 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1100 test/ta3b2_redundant 13 6 0
1101 # Metadata from INFORMATION_SCHEMA.COLUMNS
1102 NAME POS MTYPE PRTYPE HAS_DEFAULT
1103 c0 0 6 1027 0
1104 c1 1 5 16711932 0
1105 c2 2 6 1027 0
1106 c3 3 6 1283 0
1107 c4 4 6 1027 0
1108 c5 5 6 1283 0
1109 c6 6 6 1027 1
1110 c7 7 6 1283 1
1111 c8 8 6 1027 1
1112 c9 9 6 1283 1
1113 SELECT * FROM ta3b2_redundant;
1114 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
1115 SHOW CREATE TABLE ta3b2_redundant;
1116 Table Create Table
1117 ta3b2_redundant CREATE TABLE `ta3b2_redundant` (
1118 `c0` int DEFAULT NULL,
1119 `c1` text,
1120 `c2` int DEFAULT NULL,
1121 `c3` int NOT NULL,
1122 `c4` int DEFAULT '40',
1123 `c5` int NOT NULL DEFAULT '50',
1124 `c6` int DEFAULT NULL,
1125 `c7` int NOT NULL,
1126 `c8` int DEFAULT '80',
1127 `c9` int NOT NULL DEFAULT '90'
1128 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
1129 CHECK TABLE ta3b2_redundant;
1130 Table Op Msg_type Msg_text
1131 test.ta3b2_redundant check status OK
1132 SET DEBUG_SYNC='now SIGNAL update_done';
1133 # Metadata from INFORMATION_SCHEMA.TABLES
1134 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1135 test/ta3b2_redundant 13 0 0
1136 # Metadata from INFORMATION_SCHEMA.COLUMNS
1137 NAME POS MTYPE PRTYPE HAS_DEFAULT
1138 c0 0 6 1283 0
1139 c1 1 5 16711932 0
1140 c2 2 6 1027 0
1141 c3 3 6 1283 0
1142 c4 4 6 1027 0
1143 c5 5 6 1283 0
1144 c6 6 6 1027 0
1145 c7 7 6 1283 0
1146 c8 8 6 1027 0
1147 c9 9 6 1283 0
1148 SELECT * FROM ta3b2_redundant;
1149 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
1150 SHOW CREATE TABLE ta3b2_redundant;
1151 Table Create Table
1152 ta3b2_redundant CREATE TABLE `ta3b2_redundant` (
1153 `c0` int NOT NULL,
1154 `c1` text,
1155 `c2` int DEFAULT NULL,
1156 `c3` int NOT NULL,
1157 `c4` int DEFAULT '40',
1158 `c5` int NOT NULL DEFAULT '50',
1159 `c6` int DEFAULT NULL,
1160 `c7` int NOT NULL,
1161 `c8` int DEFAULT '80',
1162 `c9` int NOT NULL DEFAULT '90',
1163 PRIMARY KEY (`c0`)
1164 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
1165 CHECK TABLE ta3b2_redundant;
1166 Table Op Msg_type Msg_text
1167 test.ta3b2_redundant check status OK
1168 DROP TABLE ta3b2_redundant;
1169 # Run online ddl for ta3b3
1170 # Metadata from INFORMATION_SCHEMA.TABLES
1171 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1172 test/ta3b3_redundant 13 0 2
1173 # Metadata from INFORMATION_SCHEMA.COLUMNS
1174 NAME POS MTYPE PRTYPE HAS_DEFAULT
1175 c0 0 6 1027 0
1176 c1 1 5 16711932 0
1177 c2 2 6 1027 0
1178 c3 3 6 1283 0
1179 c4 4 6 1027 0
1180 c5 5 6 1283 0
1181 c10 6 6 1027 1
1182 c11 7 6 1283 1
1183 c12 8 6 1027 1
1184 c13 9 6 1283 1
1185 SELECT * FROM ta3b3_redundant;;
1186 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
1187 1 row1 2 3 4 5 10 11 12 13
1188 2 row2 NULL 33 40 55 NULL 1111 120 1313
1189 SHOW CREATE TABLE ta3b3_redundant;;
1190 Table Create Table
1191 ta3b3_redundant CREATE TABLE `ta3b3_redundant` (
1192 `c0` int DEFAULT NULL,
1193 `c1` text,
1194 `c2` int DEFAULT NULL,
1195 `c3` int NOT NULL,
1196 `c4` int DEFAULT '40',
1197 `c5` int NOT NULL DEFAULT '50',
1198 `c10` int DEFAULT NULL,
1199 `c11` int NOT NULL,
1200 `c12` int DEFAULT '120',
1201 `c13` int NOT NULL DEFAULT '130'
1202 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
1203 CHECK TABLE ta3b3_redundant;;
1204 Table Op Msg_type Msg_text
1205 test.ta3b3_redundant check status OK
1206 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL update_now WAIT_FOR update_done';
1207 ALTER TABLE ta3b3_redundant ADD PRIMARY KEY (c0);
1208 SET DEBUG_SYNC='now WAIT_FOR update_now';
1209 # Metadata from INFORMATION_SCHEMA.TABLES
1210 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1211 test/ta3b3_redundant 13 0 2
1212 # Metadata from INFORMATION_SCHEMA.COLUMNS
1213 NAME POS MTYPE PRTYPE HAS_DEFAULT
1214 c0 0 6 1027 0
1215 c1 1 5 16711932 0
1216 c2 2 6 1027 0
1217 c3 3 6 1283 0
1218 c4 4 6 1027 0
1219 c5 5 6 1283 0
1220 c10 6 6 1027 1
1221 c11 7 6 1283 1
1222 c12 8 6 1027 1
1223 c13 9 6 1283 1
1224 SELECT * FROM ta3b3_redundant;
1225 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
1226 1 row1 2 3 4 5 10 11 12 13
1227 2 row2 NULL 33 40 55 NULL 1111 120 1313
1228 SHOW CREATE TABLE ta3b3_redundant;
1229 Table Create Table
1230 ta3b3_redundant CREATE TABLE `ta3b3_redundant` (
1231 `c0` int DEFAULT NULL,
1232 `c1` text,
1233 `c2` int DEFAULT NULL,
1234 `c3` int NOT NULL,
1235 `c4` int DEFAULT '40',
1236 `c5` int NOT NULL DEFAULT '50',
1237 `c10` int DEFAULT NULL,
1238 `c11` int NOT NULL,
1239 `c12` int DEFAULT '120',
1240 `c13` int NOT NULL DEFAULT '130'
1241 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
1242 CHECK TABLE ta3b3_redundant;
1243 Table Op Msg_type Msg_text
1244 test.ta3b3_redundant check status OK
1245 UPDATE ta3b3_redundant SET c2 = 1;
1246 # Metadata from INFORMATION_SCHEMA.TABLES
1247 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1248 test/ta3b3_redundant 13 0 2
1249 # Metadata from INFORMATION_SCHEMA.COLUMNS
1250 NAME POS MTYPE PRTYPE HAS_DEFAULT
1251 c0 0 6 1027 0
1252 c1 1 5 16711932 0
1253 c2 2 6 1027 0
1254 c3 3 6 1283 0
1255 c4 4 6 1027 0
1256 c5 5 6 1283 0
1257 c10 6 6 1027 1
1258 c11 7 6 1283 1
1259 c12 8 6 1027 1
1260 c13 9 6 1283 1
1261 SELECT * FROM ta3b3_redundant;
1262 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
1263 1 row1 1 3 4 5 10 11 12 13
1264 2 row2 1 33 40 55 NULL 1111 120 1313
1265 SHOW CREATE TABLE ta3b3_redundant;
1266 Table Create Table
1267 ta3b3_redundant CREATE TABLE `ta3b3_redundant` (
1268 `c0` int DEFAULT NULL,
1269 `c1` text,
1270 `c2` int DEFAULT NULL,
1271 `c3` int NOT NULL,
1272 `c4` int DEFAULT '40',
1273 `c5` int NOT NULL DEFAULT '50',
1274 `c10` int DEFAULT NULL,
1275 `c11` int NOT NULL,
1276 `c12` int DEFAULT '120',
1277 `c13` int NOT NULL DEFAULT '130'
1278 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
1279 CHECK TABLE ta3b3_redundant;
1280 Table Op Msg_type Msg_text
1281 test.ta3b3_redundant check status OK
1282 SET DEBUG_SYNC='now SIGNAL update_done';
1283 # Metadata from INFORMATION_SCHEMA.TABLES
1284 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1285 test/ta3b3_redundant 13 0 0
1286 # Metadata from INFORMATION_SCHEMA.COLUMNS
1287 NAME POS MTYPE PRTYPE HAS_DEFAULT
1288 c0 0 6 1283 0
1289 c1 1 5 16711932 0
1290 c2 2 6 1027 0
1291 c3 3 6 1283 0
1292 c4 4 6 1027 0
1293 c5 5 6 1283 0
1294 c10 6 6 1027 0
1295 c11 7 6 1283 0
1296 c12 8 6 1027 0
1297 c13 9 6 1283 0
1298 SELECT * FROM ta3b3_redundant;
1299 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
1300 1 row1 1 3 4 5 10 11 12 13
1301 2 row2 1 33 40 55 NULL 1111 120 1313
1302 SHOW CREATE TABLE ta3b3_redundant;
1303 Table Create Table
1304 ta3b3_redundant CREATE TABLE `ta3b3_redundant` (
1305 `c0` int NOT NULL,
1306 `c1` text,
1307 `c2` int DEFAULT NULL,
1308 `c3` int NOT NULL,
1309 `c4` int DEFAULT '40',
1310 `c5` int NOT NULL DEFAULT '50',
1311 `c10` int DEFAULT NULL,
1312 `c11` int NOT NULL,
1313 `c12` int DEFAULT '120',
1314 `c13` int NOT NULL DEFAULT '130',
1315 PRIMARY KEY (`c0`)
1316 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
1317 CHECK TABLE ta3b3_redundant;
1318 Table Op Msg_type Msg_text
1319 test.ta3b3_redundant check status OK
1320 DROP TABLE ta3b3_redundant;
1321 # Run online ddl for ta3b4
1322 # Metadata from INFORMATION_SCHEMA.TABLES
1323 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1324 test/ta3b4_redundant 17 6 2
1325 # Metadata from INFORMATION_SCHEMA.COLUMNS
1326 NAME POS MTYPE PRTYPE HAS_DEFAULT
1327 c0 0 6 1027 0
1328 c1 1 5 16711932 0
1329 c2 2 6 1027 0
1330 c3 3 6 1283 0
1331 c4 4 6 1027 0
1332 c5 5 6 1283 0
1333 c6 6 6 1027 1
1334 c7 7 6 1283 1
1335 c8 8 6 1027 1
1336 c9 9 6 1283 1
1337 c10 10 6 1027 1
1338 c11 11 6 1283 1
1339 c12 12 6 1027 1
1340 c13 13 6 1283 1
1341 SELECT * FROM ta3b4_redundant;;
1342 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
1343 1 row1 2 3 4 5 6 7 8 9 10 11 12 13
1344 2 row2 NULL 33 40 55 NULL 77 80 99 NULL 1111 120 1313
1345 SHOW CREATE TABLE ta3b4_redundant;;
1346 Table Create Table
1347 ta3b4_redundant CREATE TABLE `ta3b4_redundant` (
1348 `c0` int DEFAULT NULL,
1349 `c1` text,
1350 `c2` int DEFAULT NULL,
1351 `c3` int NOT NULL,
1352 `c4` int DEFAULT '40',
1353 `c5` int NOT NULL DEFAULT '50',
1354 `c6` int DEFAULT NULL,
1355 `c7` int NOT NULL,
1356 `c8` int DEFAULT '80',
1357 `c9` int NOT NULL DEFAULT '90',
1358 `c10` int DEFAULT NULL,
1359 `c11` int NOT NULL,
1360 `c12` int DEFAULT '120',
1361 `c13` int NOT NULL DEFAULT '130'
1362 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
1363 CHECK TABLE ta3b4_redundant;;
1364 Table Op Msg_type Msg_text
1365 test.ta3b4_redundant check status OK
1366 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL update_now WAIT_FOR update_done';
1367 ALTER TABLE ta3b4_redundant ADD PRIMARY KEY (c0);
1368 SET DEBUG_SYNC='now WAIT_FOR update_now';
1369 # Metadata from INFORMATION_SCHEMA.TABLES
1370 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1371 test/ta3b4_redundant 17 6 2
1372 # Metadata from INFORMATION_SCHEMA.COLUMNS
1373 NAME POS MTYPE PRTYPE HAS_DEFAULT
1374 c0 0 6 1027 0
1375 c1 1 5 16711932 0
1376 c2 2 6 1027 0
1377 c3 3 6 1283 0
1378 c4 4 6 1027 0
1379 c5 5 6 1283 0
1380 c6 6 6 1027 1
1381 c7 7 6 1283 1
1382 c8 8 6 1027 1
1383 c9 9 6 1283 1
1384 c10 10 6 1027 1
1385 c11 11 6 1283 1
1386 c12 12 6 1027 1
1387 c13 13 6 1283 1
1388 SELECT * FROM ta3b4_redundant;
1389 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
1390 1 row1 2 3 4 5 6 7 8 9 10 11 12 13
1391 2 row2 NULL 33 40 55 NULL 77 80 99 NULL 1111 120 1313
1392 SHOW CREATE TABLE ta3b4_redundant;
1393 Table Create Table
1394 ta3b4_redundant CREATE TABLE `ta3b4_redundant` (
1395 `c0` int DEFAULT NULL,
1396 `c1` text,
1397 `c2` int DEFAULT NULL,
1398 `c3` int NOT NULL,
1399 `c4` int DEFAULT '40',
1400 `c5` int NOT NULL DEFAULT '50',
1401 `c6` int DEFAULT NULL,
1402 `c7` int NOT NULL,
1403 `c8` int DEFAULT '80',
1404 `c9` int NOT NULL DEFAULT '90',
1405 `c10` int DEFAULT NULL,
1406 `c11` int NOT NULL,
1407 `c12` int DEFAULT '120',
1408 `c13` int NOT NULL DEFAULT '130'
1409 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
1410 CHECK TABLE ta3b4_redundant;
1411 Table Op Msg_type Msg_text
1412 test.ta3b4_redundant check status OK
1413 UPDATE ta3b4_redundant SET c2 = 1;
1414 # Metadata from INFORMATION_SCHEMA.TABLES
1415 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1416 test/ta3b4_redundant 17 6 2
1417 # Metadata from INFORMATION_SCHEMA.COLUMNS
1418 NAME POS MTYPE PRTYPE HAS_DEFAULT
1419 c0 0 6 1027 0
1420 c1 1 5 16711932 0
1421 c2 2 6 1027 0
1422 c3 3 6 1283 0
1423 c4 4 6 1027 0
1424 c5 5 6 1283 0
1425 c6 6 6 1027 1
1426 c7 7 6 1283 1
1427 c8 8 6 1027 1
1428 c9 9 6 1283 1
1429 c10 10 6 1027 1
1430 c11 11 6 1283 1
1431 c12 12 6 1027 1
1432 c13 13 6 1283 1
1433 SELECT * FROM ta3b4_redundant;
1434 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
1435 1 row1 1 3 4 5 6 7 8 9 10 11 12 13
1436 2 row2 1 33 40 55 NULL 77 80 99 NULL 1111 120 1313
1437 SHOW CREATE TABLE ta3b4_redundant;
1438 Table Create Table
1439 ta3b4_redundant CREATE TABLE `ta3b4_redundant` (
1440 `c0` int DEFAULT NULL,
1441 `c1` text,
1442 `c2` int DEFAULT NULL,
1443 `c3` int NOT NULL,
1444 `c4` int DEFAULT '40',
1445 `c5` int NOT NULL DEFAULT '50',
1446 `c6` int DEFAULT NULL,
1447 `c7` int NOT NULL,
1448 `c8` int DEFAULT '80',
1449 `c9` int NOT NULL DEFAULT '90',
1450 `c10` int DEFAULT NULL,
1451 `c11` int NOT NULL,
1452 `c12` int DEFAULT '120',
1453 `c13` int NOT NULL DEFAULT '130'
1454 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
1455 CHECK TABLE ta3b4_redundant;
1456 Table Op Msg_type Msg_text
1457 test.ta3b4_redundant check status OK
1458 SET DEBUG_SYNC='now SIGNAL update_done';
1459 # Metadata from INFORMATION_SCHEMA.TABLES
1460 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1461 test/ta3b4_redundant 17 0 0
1462 # Metadata from INFORMATION_SCHEMA.COLUMNS
1463 NAME POS MTYPE PRTYPE HAS_DEFAULT
1464 c0 0 6 1283 0
1465 c1 1 5 16711932 0
1466 c2 2 6 1027 0
1467 c3 3 6 1283 0
1468 c4 4 6 1027 0
1469 c5 5 6 1283 0
1470 c6 6 6 1027 0
1471 c7 7 6 1283 0
1472 c8 8 6 1027 0
1473 c9 9 6 1283 0
1474 c10 10 6 1027 0
1475 c11 11 6 1283 0
1476 c12 12 6 1027 0
1477 c13 13 6 1283 0
1478 SELECT * FROM ta3b4_redundant;
1479 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
1480 1 row1 1 3 4 5 6 7 8 9 10 11 12 13
1481 2 row2 1 33 40 55 NULL 77 80 99 NULL 1111 120 1313
1482 SHOW CREATE TABLE ta3b4_redundant;
1483 Table Create Table
1484 ta3b4_redundant CREATE TABLE `ta3b4_redundant` (
1485 `c0` int NOT NULL,
1486 `c1` text,
1487 `c2` int DEFAULT NULL,
1488 `c3` int NOT NULL,
1489 `c4` int DEFAULT '40',
1490 `c5` int NOT NULL DEFAULT '50',
1491 `c6` int DEFAULT NULL,
1492 `c7` int NOT NULL,
1493 `c8` int DEFAULT '80',
1494 `c9` int NOT NULL DEFAULT '90',
1495 `c10` int DEFAULT NULL,
1496 `c11` int NOT NULL,
1497 `c12` int DEFAULT '120',
1498 `c13` int NOT NULL DEFAULT '130',
1499 PRIMARY KEY (`c0`)
1500 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
1501 CHECK TABLE ta3b4_redundant;
1502 Table Op Msg_type Msg_text
1503 test.ta3b4_redundant check status OK
1504 DROP TABLE ta3b4_redundant;
1505 # For all COMPACT tables:
1506 # Prepare the table
1507 # Processing alters:
1508 # b1, b2: no alter add in trunk
1509 # b3: alter add
1510 ALTER TABLE ta1b3_compact ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
1511 ALTER TABLE ta1b3_compact ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
1512 ALTER TABLE ta3b3_compact ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
1513 ALTER TABLE ta3b3_compact ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
1514 # b4: alter add
1515 ALTER TABLE ta1b4_compact ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
1516 ALTER TABLE ta1b4_compact ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
1517 ALTER TABLE ta2b4_compact ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
1518 ALTER TABLE ta2b4_compact ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
1519 ALTER TABLE ta3b4_compact ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
1520 ALTER TABLE ta3b4_compact ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
1521 # Processing row inserts:
1522 # a3: rows have version from new table
1523 INSERT INTO ta3b3_compact VALUES (1, "row1", 2, 3, 4, 5, 10, 11, 12, 13);;
1524 INSERT INTO ta3b3_compact (c0, c1, c3, c5, c11, c13) VALUES (2, "row2", 33, 55, 1111, 1313);;
1525 INSERT INTO ta3b4_compact VALUES (1, "row1", 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13);;
1526 INSERT INTO ta3b4_compact (c0, c1, c3, c5, c7, c9, c11, c13) VALUES (2, "row2", 33, 55, 77, 99, 1111, 1313);;
1527 # For each table, do online ddl
1528 # Run online ddl for ta1b1
1529 # Metadata from INFORMATION_SCHEMA.TABLES
1530 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1531 test/ta1b1_compact 9 0 0
1532 # Metadata from INFORMATION_SCHEMA.COLUMNS
1533 NAME POS MTYPE PRTYPE HAS_DEFAULT
1534 c0 0 6 1027 0
1535 c1 1 5 16711932 0
1536 c2 2 6 1027 0
1537 c3 3 6 1283 0
1538 c4 4 6 1027 0
1539 c5 5 6 1283 0
1540 SELECT * FROM ta1b1_compact;;
1541 c0 c1 c2 c3 c4 c5
1542 1 row1 2 3 4 5
1543 2 row2 NULL 33 40 55
1544 SHOW CREATE TABLE ta1b1_compact;;
1545 Table Create Table
1546 ta1b1_compact CREATE TABLE `ta1b1_compact` (
1547 `c0` int DEFAULT NULL,
1548 `c1` text,
1549 `c2` int DEFAULT NULL,
1550 `c3` int NOT NULL,
1551 `c4` int DEFAULT '40',
1552 `c5` int NOT NULL DEFAULT '50'
1553 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
1554 CHECK TABLE ta1b1_compact;;
1555 Table Op Msg_type Msg_text
1556 test.ta1b1_compact check status OK
1557 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL update_now WAIT_FOR update_done';
1558 ALTER TABLE ta1b1_compact ADD PRIMARY KEY (c0);
1559 SET DEBUG_SYNC='now WAIT_FOR update_now';
1560 # Metadata from INFORMATION_SCHEMA.TABLES
1561 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1562 test/ta1b1_compact 9 0 0
1563 # Metadata from INFORMATION_SCHEMA.COLUMNS
1564 NAME POS MTYPE PRTYPE HAS_DEFAULT
1565 c0 0 6 1027 0
1566 c1 1 5 16711932 0
1567 c2 2 6 1027 0
1568 c3 3 6 1283 0
1569 c4 4 6 1027 0
1570 c5 5 6 1283 0
1571 SELECT * FROM ta1b1_compact;
1572 c0 c1 c2 c3 c4 c5
1573 1 row1 2 3 4 5
1574 2 row2 NULL 33 40 55
1575 SHOW CREATE TABLE ta1b1_compact;
1576 Table Create Table
1577 ta1b1_compact CREATE TABLE `ta1b1_compact` (
1578 `c0` int DEFAULT NULL,
1579 `c1` text,
1580 `c2` int DEFAULT NULL,
1581 `c3` int NOT NULL,
1582 `c4` int DEFAULT '40',
1583 `c5` int NOT NULL DEFAULT '50'
1584 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
1585 CHECK TABLE ta1b1_compact;
1586 Table Op Msg_type Msg_text
1587 test.ta1b1_compact check status OK
1588 UPDATE ta1b1_compact SET c2 = 1;
1589 # Metadata from INFORMATION_SCHEMA.TABLES
1590 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1591 test/ta1b1_compact 9 0 0
1592 # Metadata from INFORMATION_SCHEMA.COLUMNS
1593 NAME POS MTYPE PRTYPE HAS_DEFAULT
1594 c0 0 6 1027 0
1595 c1 1 5 16711932 0
1596 c2 2 6 1027 0
1597 c3 3 6 1283 0
1598 c4 4 6 1027 0
1599 c5 5 6 1283 0
1600 SELECT * FROM ta1b1_compact;
1601 c0 c1 c2 c3 c4 c5
1602 1 row1 1 3 4 5
1603 2 row2 1 33 40 55
1604 SHOW CREATE TABLE ta1b1_compact;
1605 Table Create Table
1606 ta1b1_compact CREATE TABLE `ta1b1_compact` (
1607 `c0` int DEFAULT NULL,
1608 `c1` text,
1609 `c2` int DEFAULT NULL,
1610 `c3` int NOT NULL,
1611 `c4` int DEFAULT '40',
1612 `c5` int NOT NULL DEFAULT '50'
1613 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
1614 CHECK TABLE ta1b1_compact;
1615 Table Op Msg_type Msg_text
1616 test.ta1b1_compact check status OK
1617 SET DEBUG_SYNC='now SIGNAL update_done';
1618 # Metadata from INFORMATION_SCHEMA.TABLES
1619 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1620 test/ta1b1_compact 9 0 0
1621 # Metadata from INFORMATION_SCHEMA.COLUMNS
1622 NAME POS MTYPE PRTYPE HAS_DEFAULT
1623 c0 0 6 1283 0
1624 c1 1 5 16711932 0
1625 c2 2 6 1027 0
1626 c3 3 6 1283 0
1627 c4 4 6 1027 0
1628 c5 5 6 1283 0
1629 SELECT * FROM ta1b1_compact;
1630 c0 c1 c2 c3 c4 c5
1631 1 row1 1 3 4 5
1632 2 row2 1 33 40 55
1633 SHOW CREATE TABLE ta1b1_compact;
1634 Table Create Table
1635 ta1b1_compact CREATE TABLE `ta1b1_compact` (
1636 `c0` int NOT NULL,
1637 `c1` text,
1638 `c2` int DEFAULT NULL,
1639 `c3` int NOT NULL,
1640 `c4` int DEFAULT '40',
1641 `c5` int NOT NULL DEFAULT '50',
1642 PRIMARY KEY (`c0`)
1643 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
1644 CHECK TABLE ta1b1_compact;
1645 Table Op Msg_type Msg_text
1646 test.ta1b1_compact check status OK
1647 DROP TABLE ta1b1_compact;
1648 # Run online ddl for ta1b2
1649 # Metadata from INFORMATION_SCHEMA.TABLES
1650 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1651 test/ta1b2_compact 13 6 0
1652 # Metadata from INFORMATION_SCHEMA.COLUMNS
1653 NAME POS MTYPE PRTYPE HAS_DEFAULT
1654 c0 0 6 1027 0
1655 c1 1 5 16711932 0
1656 c2 2 6 1027 0
1657 c3 3 6 1283 0
1658 c4 4 6 1027 0
1659 c5 5 6 1283 0
1660 c6 6 6 1027 1
1661 c7 7 6 1283 1
1662 c8 8 6 1027 1
1663 c9 9 6 1283 1
1664 SELECT * FROM ta1b2_compact;;
1665 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
1666 1 row1 2 3 4 5 NULL 0 80 90
1667 2 row2 NULL 33 40 55 NULL 0 80 90
1668 SHOW CREATE TABLE ta1b2_compact;;
1669 Table Create Table
1670 ta1b2_compact CREATE TABLE `ta1b2_compact` (
1671 `c0` int DEFAULT NULL,
1672 `c1` text,
1673 `c2` int DEFAULT NULL,
1674 `c3` int NOT NULL,
1675 `c4` int DEFAULT '40',
1676 `c5` int NOT NULL DEFAULT '50',
1677 `c6` int DEFAULT NULL,
1678 `c7` int NOT NULL,
1679 `c8` int DEFAULT '80',
1680 `c9` int NOT NULL DEFAULT '90'
1681 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
1682 CHECK TABLE ta1b2_compact;;
1683 Table Op Msg_type Msg_text
1684 test.ta1b2_compact check status OK
1685 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL update_now WAIT_FOR update_done';
1686 ALTER TABLE ta1b2_compact ADD PRIMARY KEY (c0);
1687 SET DEBUG_SYNC='now WAIT_FOR update_now';
1688 # Metadata from INFORMATION_SCHEMA.TABLES
1689 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1690 test/ta1b2_compact 13 6 0
1691 # Metadata from INFORMATION_SCHEMA.COLUMNS
1692 NAME POS MTYPE PRTYPE HAS_DEFAULT
1693 c0 0 6 1027 0
1694 c1 1 5 16711932 0
1695 c2 2 6 1027 0
1696 c3 3 6 1283 0
1697 c4 4 6 1027 0
1698 c5 5 6 1283 0
1699 c6 6 6 1027 1
1700 c7 7 6 1283 1
1701 c8 8 6 1027 1
1702 c9 9 6 1283 1
1703 SELECT * FROM ta1b2_compact;
1704 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
1705 1 row1 2 3 4 5 NULL 0 80 90
1706 2 row2 NULL 33 40 55 NULL 0 80 90
1707 SHOW CREATE TABLE ta1b2_compact;
1708 Table Create Table
1709 ta1b2_compact CREATE TABLE `ta1b2_compact` (
1710 `c0` int DEFAULT NULL,
1711 `c1` text,
1712 `c2` int DEFAULT NULL,
1713 `c3` int NOT NULL,
1714 `c4` int DEFAULT '40',
1715 `c5` int NOT NULL DEFAULT '50',
1716 `c6` int DEFAULT NULL,
1717 `c7` int NOT NULL,
1718 `c8` int DEFAULT '80',
1719 `c9` int NOT NULL DEFAULT '90'
1720 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
1721 CHECK TABLE ta1b2_compact;
1722 Table Op Msg_type Msg_text
1723 test.ta1b2_compact check status OK
1724 UPDATE ta1b2_compact SET c2 = 1;
1725 # Metadata from INFORMATION_SCHEMA.TABLES
1726 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1727 test/ta1b2_compact 13 6 0
1728 # Metadata from INFORMATION_SCHEMA.COLUMNS
1729 NAME POS MTYPE PRTYPE HAS_DEFAULT
1730 c0 0 6 1027 0
1731 c1 1 5 16711932 0
1732 c2 2 6 1027 0
1733 c3 3 6 1283 0
1734 c4 4 6 1027 0
1735 c5 5 6 1283 0
1736 c6 6 6 1027 1
1737 c7 7 6 1283 1
1738 c8 8 6 1027 1
1739 c9 9 6 1283 1
1740 SELECT * FROM ta1b2_compact;
1741 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
1742 1 row1 1 3 4 5 NULL 0 80 90
1743 2 row2 1 33 40 55 NULL 0 80 90
1744 SHOW CREATE TABLE ta1b2_compact;
1745 Table Create Table
1746 ta1b2_compact CREATE TABLE `ta1b2_compact` (
1747 `c0` int DEFAULT NULL,
1748 `c1` text,
1749 `c2` int DEFAULT NULL,
1750 `c3` int NOT NULL,
1751 `c4` int DEFAULT '40',
1752 `c5` int NOT NULL DEFAULT '50',
1753 `c6` int DEFAULT NULL,
1754 `c7` int NOT NULL,
1755 `c8` int DEFAULT '80',
1756 `c9` int NOT NULL DEFAULT '90'
1757 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
1758 CHECK TABLE ta1b2_compact;
1759 Table Op Msg_type Msg_text
1760 test.ta1b2_compact check status OK
1761 SET DEBUG_SYNC='now SIGNAL update_done';
1762 # Metadata from INFORMATION_SCHEMA.TABLES
1763 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1764 test/ta1b2_compact 13 0 0
1765 # Metadata from INFORMATION_SCHEMA.COLUMNS
1766 NAME POS MTYPE PRTYPE HAS_DEFAULT
1767 c0 0 6 1283 0
1768 c1 1 5 16711932 0
1769 c2 2 6 1027 0
1770 c3 3 6 1283 0
1771 c4 4 6 1027 0
1772 c5 5 6 1283 0
1773 c6 6 6 1027 0
1774 c7 7 6 1283 0
1775 c8 8 6 1027 0
1776 c9 9 6 1283 0
1777 SELECT * FROM ta1b2_compact;
1778 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
1779 1 row1 1 3 4 5 NULL 0 80 90
1780 2 row2 1 33 40 55 NULL 0 80 90
1781 SHOW CREATE TABLE ta1b2_compact;
1782 Table Create Table
1783 ta1b2_compact CREATE TABLE `ta1b2_compact` (
1784 `c0` int NOT NULL,
1785 `c1` text,
1786 `c2` int DEFAULT NULL,
1787 `c3` int NOT NULL,
1788 `c4` int DEFAULT '40',
1789 `c5` int NOT NULL DEFAULT '50',
1790 `c6` int DEFAULT NULL,
1791 `c7` int NOT NULL,
1792 `c8` int DEFAULT '80',
1793 `c9` int NOT NULL DEFAULT '90',
1794 PRIMARY KEY (`c0`)
1795 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
1796 CHECK TABLE ta1b2_compact;
1797 Table Op Msg_type Msg_text
1798 test.ta1b2_compact check status OK
1799 DROP TABLE ta1b2_compact;
1800 # Run online ddl for ta1b3
1801 # Metadata from INFORMATION_SCHEMA.TABLES
1802 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1803 test/ta1b3_compact 13 0 2
1804 # Metadata from INFORMATION_SCHEMA.COLUMNS
1805 NAME POS MTYPE PRTYPE HAS_DEFAULT
1806 c0 0 6 1027 0
1807 c1 1 5 16711932 0
1808 c2 2 6 1027 0
1809 c3 3 6 1283 0
1810 c4 4 6 1027 0
1811 c5 5 6 1283 0
1812 c10 6 6 1027 1
1813 c11 7 6 1283 1
1814 c12 8 6 1027 1
1815 c13 9 6 1283 1
1816 SELECT * FROM ta1b3_compact;;
1817 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
1818 1 row1 2 3 4 5 NULL 0 120 130
1819 2 row2 NULL 33 40 55 NULL 0 120 130
1820 SHOW CREATE TABLE ta1b3_compact;;
1821 Table Create Table
1822 ta1b3_compact CREATE TABLE `ta1b3_compact` (
1823 `c0` int DEFAULT NULL,
1824 `c1` text,
1825 `c2` int DEFAULT NULL,
1826 `c3` int NOT NULL,
1827 `c4` int DEFAULT '40',
1828 `c5` int NOT NULL DEFAULT '50',
1829 `c10` int DEFAULT NULL,
1830 `c11` int NOT NULL,
1831 `c12` int DEFAULT '120',
1832 `c13` int NOT NULL DEFAULT '130'
1833 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
1834 CHECK TABLE ta1b3_compact;;
1835 Table Op Msg_type Msg_text
1836 test.ta1b3_compact check status OK
1837 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL update_now WAIT_FOR update_done';
1838 ALTER TABLE ta1b3_compact ADD PRIMARY KEY (c0);
1839 SET DEBUG_SYNC='now WAIT_FOR update_now';
1840 # Metadata from INFORMATION_SCHEMA.TABLES
1841 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1842 test/ta1b3_compact 13 0 2
1843 # Metadata from INFORMATION_SCHEMA.COLUMNS
1844 NAME POS MTYPE PRTYPE HAS_DEFAULT
1845 c0 0 6 1027 0
1846 c1 1 5 16711932 0
1847 c2 2 6 1027 0
1848 c3 3 6 1283 0
1849 c4 4 6 1027 0
1850 c5 5 6 1283 0
1851 c10 6 6 1027 1
1852 c11 7 6 1283 1
1853 c12 8 6 1027 1
1854 c13 9 6 1283 1
1855 SELECT * FROM ta1b3_compact;
1856 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
1857 1 row1 2 3 4 5 NULL 0 120 130
1858 2 row2 NULL 33 40 55 NULL 0 120 130
1859 SHOW CREATE TABLE ta1b3_compact;
1860 Table Create Table
1861 ta1b3_compact CREATE TABLE `ta1b3_compact` (
1862 `c0` int DEFAULT NULL,
1863 `c1` text,
1864 `c2` int DEFAULT NULL,
1865 `c3` int NOT NULL,
1866 `c4` int DEFAULT '40',
1867 `c5` int NOT NULL DEFAULT '50',
1868 `c10` int DEFAULT NULL,
1869 `c11` int NOT NULL,
1870 `c12` int DEFAULT '120',
1871 `c13` int NOT NULL DEFAULT '130'
1872 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
1873 CHECK TABLE ta1b3_compact;
1874 Table Op Msg_type Msg_text
1875 test.ta1b3_compact check status OK
1876 UPDATE ta1b3_compact SET c2 = 1;
1877 # Metadata from INFORMATION_SCHEMA.TABLES
1878 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1879 test/ta1b3_compact 13 0 2
1880 # Metadata from INFORMATION_SCHEMA.COLUMNS
1881 NAME POS MTYPE PRTYPE HAS_DEFAULT
1882 c0 0 6 1027 0
1883 c1 1 5 16711932 0
1884 c2 2 6 1027 0
1885 c3 3 6 1283 0
1886 c4 4 6 1027 0
1887 c5 5 6 1283 0
1888 c10 6 6 1027 1
1889 c11 7 6 1283 1
1890 c12 8 6 1027 1
1891 c13 9 6 1283 1
1892 SELECT * FROM ta1b3_compact;
1893 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
1894 1 row1 1 3 4 5 NULL 0 120 130
1895 2 row2 1 33 40 55 NULL 0 120 130
1896 SHOW CREATE TABLE ta1b3_compact;
1897 Table Create Table
1898 ta1b3_compact CREATE TABLE `ta1b3_compact` (
1899 `c0` int DEFAULT NULL,
1900 `c1` text,
1901 `c2` int DEFAULT NULL,
1902 `c3` int NOT NULL,
1903 `c4` int DEFAULT '40',
1904 `c5` int NOT NULL DEFAULT '50',
1905 `c10` int DEFAULT NULL,
1906 `c11` int NOT NULL,
1907 `c12` int DEFAULT '120',
1908 `c13` int NOT NULL DEFAULT '130'
1909 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
1910 CHECK TABLE ta1b3_compact;
1911 Table Op Msg_type Msg_text
1912 test.ta1b3_compact check status OK
1913 SET DEBUG_SYNC='now SIGNAL update_done';
1914 # Metadata from INFORMATION_SCHEMA.TABLES
1915 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1916 test/ta1b3_compact 13 0 0
1917 # Metadata from INFORMATION_SCHEMA.COLUMNS
1918 NAME POS MTYPE PRTYPE HAS_DEFAULT
1919 c0 0 6 1283 0
1920 c1 1 5 16711932 0
1921 c2 2 6 1027 0
1922 c3 3 6 1283 0
1923 c4 4 6 1027 0
1924 c5 5 6 1283 0
1925 c10 6 6 1027 0
1926 c11 7 6 1283 0
1927 c12 8 6 1027 0
1928 c13 9 6 1283 0
1929 SELECT * FROM ta1b3_compact;
1930 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
1931 1 row1 1 3 4 5 NULL 0 120 130
1932 2 row2 1 33 40 55 NULL 0 120 130
1933 SHOW CREATE TABLE ta1b3_compact;
1934 Table Create Table
1935 ta1b3_compact CREATE TABLE `ta1b3_compact` (
1936 `c0` int NOT NULL,
1937 `c1` text,
1938 `c2` int DEFAULT NULL,
1939 `c3` int NOT NULL,
1940 `c4` int DEFAULT '40',
1941 `c5` int NOT NULL DEFAULT '50',
1942 `c10` int DEFAULT NULL,
1943 `c11` int NOT NULL,
1944 `c12` int DEFAULT '120',
1945 `c13` int NOT NULL DEFAULT '130',
1946 PRIMARY KEY (`c0`)
1947 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
1948 CHECK TABLE ta1b3_compact;
1949 Table Op Msg_type Msg_text
1950 test.ta1b3_compact check status OK
1951 DROP TABLE ta1b3_compact;
1952 # Run online ddl for ta1b4
1953 # Metadata from INFORMATION_SCHEMA.TABLES
1954 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1955 test/ta1b4_compact 17 6 2
1956 # Metadata from INFORMATION_SCHEMA.COLUMNS
1957 NAME POS MTYPE PRTYPE HAS_DEFAULT
1958 c0 0 6 1027 0
1959 c1 1 5 16711932 0
1960 c2 2 6 1027 0
1961 c3 3 6 1283 0
1962 c4 4 6 1027 0
1963 c5 5 6 1283 0
1964 c6 6 6 1027 1
1965 c7 7 6 1283 1
1966 c8 8 6 1027 1
1967 c9 9 6 1283 1
1968 c10 10 6 1027 1
1969 c11 11 6 1283 1
1970 c12 12 6 1027 1
1971 c13 13 6 1283 1
1972 SELECT * FROM ta1b4_compact;;
1973 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
1974 1 row1 2 3 4 5 NULL 0 80 90 NULL 0 120 130
1975 2 row2 NULL 33 40 55 NULL 0 80 90 NULL 0 120 130
1976 SHOW CREATE TABLE ta1b4_compact;;
1977 Table Create Table
1978 ta1b4_compact CREATE TABLE `ta1b4_compact` (
1979 `c0` int DEFAULT NULL,
1980 `c1` text,
1981 `c2` int DEFAULT NULL,
1982 `c3` int NOT NULL,
1983 `c4` int DEFAULT '40',
1984 `c5` int NOT NULL DEFAULT '50',
1985 `c6` int DEFAULT NULL,
1986 `c7` int NOT NULL,
1987 `c8` int DEFAULT '80',
1988 `c9` int NOT NULL DEFAULT '90',
1989 `c10` int DEFAULT NULL,
1990 `c11` int NOT NULL,
1991 `c12` int DEFAULT '120',
1992 `c13` int NOT NULL DEFAULT '130'
1993 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
1994 CHECK TABLE ta1b4_compact;;
1995 Table Op Msg_type Msg_text
1996 test.ta1b4_compact check status OK
1997 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL update_now WAIT_FOR update_done';
1998 ALTER TABLE ta1b4_compact ADD PRIMARY KEY (c0);
1999 SET DEBUG_SYNC='now WAIT_FOR update_now';
2000 # Metadata from INFORMATION_SCHEMA.TABLES
2001 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2002 test/ta1b4_compact 17 6 2
2003 # Metadata from INFORMATION_SCHEMA.COLUMNS
2004 NAME POS MTYPE PRTYPE HAS_DEFAULT
2005 c0 0 6 1027 0
2006 c1 1 5 16711932 0
2007 c2 2 6 1027 0
2008 c3 3 6 1283 0
2009 c4 4 6 1027 0
2010 c5 5 6 1283 0
2011 c6 6 6 1027 1
2012 c7 7 6 1283 1
2013 c8 8 6 1027 1
2014 c9 9 6 1283 1
2015 c10 10 6 1027 1
2016 c11 11 6 1283 1
2017 c12 12 6 1027 1
2018 c13 13 6 1283 1
2019 SELECT * FROM ta1b4_compact;
2020 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
2021 1 row1 2 3 4 5 NULL 0 80 90 NULL 0 120 130
2022 2 row2 NULL 33 40 55 NULL 0 80 90 NULL 0 120 130
2023 SHOW CREATE TABLE ta1b4_compact;
2024 Table Create Table
2025 ta1b4_compact CREATE TABLE `ta1b4_compact` (
2026 `c0` int DEFAULT NULL,
2027 `c1` text,
2028 `c2` int DEFAULT NULL,
2029 `c3` int NOT NULL,
2030 `c4` int DEFAULT '40',
2031 `c5` int NOT NULL DEFAULT '50',
2032 `c6` int DEFAULT NULL,
2033 `c7` int NOT NULL,
2034 `c8` int DEFAULT '80',
2035 `c9` int NOT NULL DEFAULT '90',
2036 `c10` int DEFAULT NULL,
2037 `c11` int NOT NULL,
2038 `c12` int DEFAULT '120',
2039 `c13` int NOT NULL DEFAULT '130'
2040 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
2041 CHECK TABLE ta1b4_compact;
2042 Table Op Msg_type Msg_text
2043 test.ta1b4_compact check status OK
2044 UPDATE ta1b4_compact SET c2 = 1;
2045 # Metadata from INFORMATION_SCHEMA.TABLES
2046 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2047 test/ta1b4_compact 17 6 2
2048 # Metadata from INFORMATION_SCHEMA.COLUMNS
2049 NAME POS MTYPE PRTYPE HAS_DEFAULT
2050 c0 0 6 1027 0
2051 c1 1 5 16711932 0
2052 c2 2 6 1027 0
2053 c3 3 6 1283 0
2054 c4 4 6 1027 0
2055 c5 5 6 1283 0
2056 c6 6 6 1027 1
2057 c7 7 6 1283 1
2058 c8 8 6 1027 1
2059 c9 9 6 1283 1
2060 c10 10 6 1027 1
2061 c11 11 6 1283 1
2062 c12 12 6 1027 1
2063 c13 13 6 1283 1
2064 SELECT * FROM ta1b4_compact;
2065 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
2066 1 row1 1 3 4 5 NULL 0 80 90 NULL 0 120 130
2067 2 row2 1 33 40 55 NULL 0 80 90 NULL 0 120 130
2068 SHOW CREATE TABLE ta1b4_compact;
2069 Table Create Table
2070 ta1b4_compact CREATE TABLE `ta1b4_compact` (
2071 `c0` int DEFAULT NULL,
2072 `c1` text,
2073 `c2` int DEFAULT NULL,
2074 `c3` int NOT NULL,
2075 `c4` int DEFAULT '40',
2076 `c5` int NOT NULL DEFAULT '50',
2077 `c6` int DEFAULT NULL,
2078 `c7` int NOT NULL,
2079 `c8` int DEFAULT '80',
2080 `c9` int NOT NULL DEFAULT '90',
2081 `c10` int DEFAULT NULL,
2082 `c11` int NOT NULL,
2083 `c12` int DEFAULT '120',
2084 `c13` int NOT NULL DEFAULT '130'
2085 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
2086 CHECK TABLE ta1b4_compact;
2087 Table Op Msg_type Msg_text
2088 test.ta1b4_compact check status OK
2089 SET DEBUG_SYNC='now SIGNAL update_done';
2090 # Metadata from INFORMATION_SCHEMA.TABLES
2091 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2092 test/ta1b4_compact 17 0 0
2093 # Metadata from INFORMATION_SCHEMA.COLUMNS
2094 NAME POS MTYPE PRTYPE HAS_DEFAULT
2095 c0 0 6 1283 0
2096 c1 1 5 16711932 0
2097 c2 2 6 1027 0
2098 c3 3 6 1283 0
2099 c4 4 6 1027 0
2100 c5 5 6 1283 0
2101 c6 6 6 1027 0
2102 c7 7 6 1283 0
2103 c8 8 6 1027 0
2104 c9 9 6 1283 0
2105 c10 10 6 1027 0
2106 c11 11 6 1283 0
2107 c12 12 6 1027 0
2108 c13 13 6 1283 0
2109 SELECT * FROM ta1b4_compact;
2110 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
2111 1 row1 1 3 4 5 NULL 0 80 90 NULL 0 120 130
2112 2 row2 1 33 40 55 NULL 0 80 90 NULL 0 120 130
2113 SHOW CREATE TABLE ta1b4_compact;
2114 Table Create Table
2115 ta1b4_compact CREATE TABLE `ta1b4_compact` (
2116 `c0` int NOT NULL,
2117 `c1` text,
2118 `c2` int DEFAULT NULL,
2119 `c3` int NOT NULL,
2120 `c4` int DEFAULT '40',
2121 `c5` int NOT NULL DEFAULT '50',
2122 `c6` int DEFAULT NULL,
2123 `c7` int NOT NULL,
2124 `c8` int DEFAULT '80',
2125 `c9` int NOT NULL DEFAULT '90',
2126 `c10` int DEFAULT NULL,
2127 `c11` int NOT NULL,
2128 `c12` int DEFAULT '120',
2129 `c13` int NOT NULL DEFAULT '130',
2130 PRIMARY KEY (`c0`)
2131 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
2132 CHECK TABLE ta1b4_compact;
2133 Table Op Msg_type Msg_text
2134 test.ta1b4_compact check status OK
2135 DROP TABLE ta1b4_compact;
2136 # Run online ddl for ta2b2
2137 # Metadata from INFORMATION_SCHEMA.TABLES
2138 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2139 test/ta2b2_compact 13 6 0
2140 # Metadata from INFORMATION_SCHEMA.COLUMNS
2141 NAME POS MTYPE PRTYPE HAS_DEFAULT
2142 c0 0 6 1027 0
2143 c1 1 5 16711932 0
2144 c2 2 6 1027 0
2145 c3 3 6 1283 0
2146 c4 4 6 1027 0
2147 c5 5 6 1283 0
2148 c6 6 6 1027 1
2149 c7 7 6 1283 1
2150 c8 8 6 1027 1
2151 c9 9 6 1283 1
2152 SELECT * FROM ta2b2_compact;;
2153 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
2154 1 row1 2 3 4 5 6 7 8 9
2155 2 row2 NULL 33 40 55 NULL 77 80 99
2156 SHOW CREATE TABLE ta2b2_compact;;
2157 Table Create Table
2158 ta2b2_compact CREATE TABLE `ta2b2_compact` (
2159 `c0` int DEFAULT NULL,
2160 `c1` text,
2161 `c2` int DEFAULT NULL,
2162 `c3` int NOT NULL,
2163 `c4` int DEFAULT '40',
2164 `c5` int NOT NULL DEFAULT '50',
2165 `c6` int DEFAULT NULL,
2166 `c7` int NOT NULL,
2167 `c8` int DEFAULT '80',
2168 `c9` int NOT NULL DEFAULT '90'
2169 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
2170 CHECK TABLE ta2b2_compact;;
2171 Table Op Msg_type Msg_text
2172 test.ta2b2_compact check status OK
2173 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL update_now WAIT_FOR update_done';
2174 ALTER TABLE ta2b2_compact ADD PRIMARY KEY (c0);
2175 SET DEBUG_SYNC='now WAIT_FOR update_now';
2176 # Metadata from INFORMATION_SCHEMA.TABLES
2177 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2178 test/ta2b2_compact 13 6 0
2179 # Metadata from INFORMATION_SCHEMA.COLUMNS
2180 NAME POS MTYPE PRTYPE HAS_DEFAULT
2181 c0 0 6 1027 0
2182 c1 1 5 16711932 0
2183 c2 2 6 1027 0
2184 c3 3 6 1283 0
2185 c4 4 6 1027 0
2186 c5 5 6 1283 0
2187 c6 6 6 1027 1
2188 c7 7 6 1283 1
2189 c8 8 6 1027 1
2190 c9 9 6 1283 1
2191 SELECT * FROM ta2b2_compact;
2192 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
2193 1 row1 2 3 4 5 6 7 8 9
2194 2 row2 NULL 33 40 55 NULL 77 80 99
2195 SHOW CREATE TABLE ta2b2_compact;
2196 Table Create Table
2197 ta2b2_compact CREATE TABLE `ta2b2_compact` (
2198 `c0` int DEFAULT NULL,
2199 `c1` text,
2200 `c2` int DEFAULT NULL,
2201 `c3` int NOT NULL,
2202 `c4` int DEFAULT '40',
2203 `c5` int NOT NULL DEFAULT '50',
2204 `c6` int DEFAULT NULL,
2205 `c7` int NOT NULL,
2206 `c8` int DEFAULT '80',
2207 `c9` int NOT NULL DEFAULT '90'
2208 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
2209 CHECK TABLE ta2b2_compact;
2210 Table Op Msg_type Msg_text
2211 test.ta2b2_compact check status OK
2212 UPDATE ta2b2_compact SET c2 = 1;
2213 # Metadata from INFORMATION_SCHEMA.TABLES
2214 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2215 test/ta2b2_compact 13 6 0
2216 # Metadata from INFORMATION_SCHEMA.COLUMNS
2217 NAME POS MTYPE PRTYPE HAS_DEFAULT
2218 c0 0 6 1027 0
2219 c1 1 5 16711932 0
2220 c2 2 6 1027 0
2221 c3 3 6 1283 0
2222 c4 4 6 1027 0
2223 c5 5 6 1283 0
2224 c6 6 6 1027 1
2225 c7 7 6 1283 1
2226 c8 8 6 1027 1
2227 c9 9 6 1283 1
2228 SELECT * FROM ta2b2_compact;
2229 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
2230 1 row1 1 3 4 5 6 7 8 9
2231 2 row2 1 33 40 55 NULL 77 80 99
2232 SHOW CREATE TABLE ta2b2_compact;
2233 Table Create Table
2234 ta2b2_compact CREATE TABLE `ta2b2_compact` (
2235 `c0` int DEFAULT NULL,
2236 `c1` text,
2237 `c2` int DEFAULT NULL,
2238 `c3` int NOT NULL,
2239 `c4` int DEFAULT '40',
2240 `c5` int NOT NULL DEFAULT '50',
2241 `c6` int DEFAULT NULL,
2242 `c7` int NOT NULL,
2243 `c8` int DEFAULT '80',
2244 `c9` int NOT NULL DEFAULT '90'
2245 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
2246 CHECK TABLE ta2b2_compact;
2247 Table Op Msg_type Msg_text
2248 test.ta2b2_compact check status OK
2249 SET DEBUG_SYNC='now SIGNAL update_done';
2250 # Metadata from INFORMATION_SCHEMA.TABLES
2251 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2252 test/ta2b2_compact 13 0 0
2253 # Metadata from INFORMATION_SCHEMA.COLUMNS
2254 NAME POS MTYPE PRTYPE HAS_DEFAULT
2255 c0 0 6 1283 0
2256 c1 1 5 16711932 0
2257 c2 2 6 1027 0
2258 c3 3 6 1283 0
2259 c4 4 6 1027 0
2260 c5 5 6 1283 0
2261 c6 6 6 1027 0
2262 c7 7 6 1283 0
2263 c8 8 6 1027 0
2264 c9 9 6 1283 0
2265 SELECT * FROM ta2b2_compact;
2266 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
2267 1 row1 1 3 4 5 6 7 8 9
2268 2 row2 1 33 40 55 NULL 77 80 99
2269 SHOW CREATE TABLE ta2b2_compact;
2270 Table Create Table
2271 ta2b2_compact CREATE TABLE `ta2b2_compact` (
2272 `c0` int NOT NULL,
2273 `c1` text,
2274 `c2` int DEFAULT NULL,
2275 `c3` int NOT NULL,
2276 `c4` int DEFAULT '40',
2277 `c5` int NOT NULL DEFAULT '50',
2278 `c6` int DEFAULT NULL,
2279 `c7` int NOT NULL,
2280 `c8` int DEFAULT '80',
2281 `c9` int NOT NULL DEFAULT '90',
2282 PRIMARY KEY (`c0`)
2283 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
2284 CHECK TABLE ta2b2_compact;
2285 Table Op Msg_type Msg_text
2286 test.ta2b2_compact check status OK
2287 DROP TABLE ta2b2_compact;
2288 # Run online ddl for ta2b4
2289 # Metadata from INFORMATION_SCHEMA.TABLES
2290 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2291 test/ta2b4_compact 17 6 2
2292 # Metadata from INFORMATION_SCHEMA.COLUMNS
2293 NAME POS MTYPE PRTYPE HAS_DEFAULT
2294 c0 0 6 1027 0
2295 c1 1 5 16711932 0
2296 c2 2 6 1027 0
2297 c3 3 6 1283 0
2298 c4 4 6 1027 0
2299 c5 5 6 1283 0
2300 c6 6 6 1027 1
2301 c7 7 6 1283 1
2302 c8 8 6 1027 1
2303 c9 9 6 1283 1
2304 c10 10 6 1027 1
2305 c11 11 6 1283 1
2306 c12 12 6 1027 1
2307 c13 13 6 1283 1
2308 SELECT * FROM ta2b4_compact;;
2309 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
2310 1 row1 2 3 4 5 6 7 8 9 NULL 0 120 130
2311 2 row2 NULL 33 40 55 NULL 77 80 99 NULL 0 120 130
2312 SHOW CREATE TABLE ta2b4_compact;;
2313 Table Create Table
2314 ta2b4_compact CREATE TABLE `ta2b4_compact` (
2315 `c0` int DEFAULT NULL,
2316 `c1` text,
2317 `c2` int DEFAULT NULL,
2318 `c3` int NOT NULL,
2319 `c4` int DEFAULT '40',
2320 `c5` int NOT NULL DEFAULT '50',
2321 `c6` int DEFAULT NULL,
2322 `c7` int NOT NULL,
2323 `c8` int DEFAULT '80',
2324 `c9` int NOT NULL DEFAULT '90',
2325 `c10` int DEFAULT NULL,
2326 `c11` int NOT NULL,
2327 `c12` int DEFAULT '120',
2328 `c13` int NOT NULL DEFAULT '130'
2329 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
2330 CHECK TABLE ta2b4_compact;;
2331 Table Op Msg_type Msg_text
2332 test.ta2b4_compact check status OK
2333 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL update_now WAIT_FOR update_done';
2334 ALTER TABLE ta2b4_compact ADD PRIMARY KEY (c0);
2335 SET DEBUG_SYNC='now WAIT_FOR update_now';
2336 # Metadata from INFORMATION_SCHEMA.TABLES
2337 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2338 test/ta2b4_compact 17 6 2
2339 # Metadata from INFORMATION_SCHEMA.COLUMNS
2340 NAME POS MTYPE PRTYPE HAS_DEFAULT
2341 c0 0 6 1027 0
2342 c1 1 5 16711932 0
2343 c2 2 6 1027 0
2344 c3 3 6 1283 0
2345 c4 4 6 1027 0
2346 c5 5 6 1283 0
2347 c6 6 6 1027 1
2348 c7 7 6 1283 1
2349 c8 8 6 1027 1
2350 c9 9 6 1283 1
2351 c10 10 6 1027 1
2352 c11 11 6 1283 1
2353 c12 12 6 1027 1
2354 c13 13 6 1283 1
2355 SELECT * FROM ta2b4_compact;
2356 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
2357 1 row1 2 3 4 5 6 7 8 9 NULL 0 120 130
2358 2 row2 NULL 33 40 55 NULL 77 80 99 NULL 0 120 130
2359 SHOW CREATE TABLE ta2b4_compact;
2360 Table Create Table
2361 ta2b4_compact CREATE TABLE `ta2b4_compact` (
2362 `c0` int DEFAULT NULL,
2363 `c1` text,
2364 `c2` int DEFAULT NULL,
2365 `c3` int NOT NULL,
2366 `c4` int DEFAULT '40',
2367 `c5` int NOT NULL DEFAULT '50',
2368 `c6` int DEFAULT NULL,
2369 `c7` int NOT NULL,
2370 `c8` int DEFAULT '80',
2371 `c9` int NOT NULL DEFAULT '90',
2372 `c10` int DEFAULT NULL,
2373 `c11` int NOT NULL,
2374 `c12` int DEFAULT '120',
2375 `c13` int NOT NULL DEFAULT '130'
2376 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
2377 CHECK TABLE ta2b4_compact;
2378 Table Op Msg_type Msg_text
2379 test.ta2b4_compact check status OK
2380 UPDATE ta2b4_compact SET c2 = 1;
2381 # Metadata from INFORMATION_SCHEMA.TABLES
2382 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2383 test/ta2b4_compact 17 6 2
2384 # Metadata from INFORMATION_SCHEMA.COLUMNS
2385 NAME POS MTYPE PRTYPE HAS_DEFAULT
2386 c0 0 6 1027 0
2387 c1 1 5 16711932 0
2388 c2 2 6 1027 0
2389 c3 3 6 1283 0
2390 c4 4 6 1027 0
2391 c5 5 6 1283 0
2392 c6 6 6 1027 1
2393 c7 7 6 1283 1
2394 c8 8 6 1027 1
2395 c9 9 6 1283 1
2396 c10 10 6 1027 1
2397 c11 11 6 1283 1
2398 c12 12 6 1027 1
2399 c13 13 6 1283 1
2400 SELECT * FROM ta2b4_compact;
2401 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
2402 1 row1 1 3 4 5 6 7 8 9 NULL 0 120 130
2403 2 row2 1 33 40 55 NULL 77 80 99 NULL 0 120 130
2404 SHOW CREATE TABLE ta2b4_compact;
2405 Table Create Table
2406 ta2b4_compact CREATE TABLE `ta2b4_compact` (
2407 `c0` int DEFAULT NULL,
2408 `c1` text,
2409 `c2` int DEFAULT NULL,
2410 `c3` int NOT NULL,
2411 `c4` int DEFAULT '40',
2412 `c5` int NOT NULL DEFAULT '50',
2413 `c6` int DEFAULT NULL,
2414 `c7` int NOT NULL,
2415 `c8` int DEFAULT '80',
2416 `c9` int NOT NULL DEFAULT '90',
2417 `c10` int DEFAULT NULL,
2418 `c11` int NOT NULL,
2419 `c12` int DEFAULT '120',
2420 `c13` int NOT NULL DEFAULT '130'
2421 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
2422 CHECK TABLE ta2b4_compact;
2423 Table Op Msg_type Msg_text
2424 test.ta2b4_compact check status OK
2425 SET DEBUG_SYNC='now SIGNAL update_done';
2426 # Metadata from INFORMATION_SCHEMA.TABLES
2427 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2428 test/ta2b4_compact 17 0 0
2429 # Metadata from INFORMATION_SCHEMA.COLUMNS
2430 NAME POS MTYPE PRTYPE HAS_DEFAULT
2431 c0 0 6 1283 0
2432 c1 1 5 16711932 0
2433 c2 2 6 1027 0
2434 c3 3 6 1283 0
2435 c4 4 6 1027 0
2436 c5 5 6 1283 0
2437 c6 6 6 1027 0
2438 c7 7 6 1283 0
2439 c8 8 6 1027 0
2440 c9 9 6 1283 0
2441 c10 10 6 1027 0
2442 c11 11 6 1283 0
2443 c12 12 6 1027 0
2444 c13 13 6 1283 0
2445 SELECT * FROM ta2b4_compact;
2446 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
2447 1 row1 1 3 4 5 6 7 8 9 NULL 0 120 130
2448 2 row2 1 33 40 55 NULL 77 80 99 NULL 0 120 130
2449 SHOW CREATE TABLE ta2b4_compact;
2450 Table Create Table
2451 ta2b4_compact CREATE TABLE `ta2b4_compact` (
2452 `c0` int NOT NULL,
2453 `c1` text,
2454 `c2` int DEFAULT NULL,
2455 `c3` int NOT NULL,
2456 `c4` int DEFAULT '40',
2457 `c5` int NOT NULL DEFAULT '50',
2458 `c6` int DEFAULT NULL,
2459 `c7` int NOT NULL,
2460 `c8` int DEFAULT '80',
2461 `c9` int NOT NULL DEFAULT '90',
2462 `c10` int DEFAULT NULL,
2463 `c11` int NOT NULL,
2464 `c12` int DEFAULT '120',
2465 `c13` int NOT NULL DEFAULT '130',
2466 PRIMARY KEY (`c0`)
2467 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
2468 CHECK TABLE ta2b4_compact;
2469 Table Op Msg_type Msg_text
2470 test.ta2b4_compact check status OK
2471 DROP TABLE ta2b4_compact;
2472 # Run online ddl for ta3b2
2473 # Metadata from INFORMATION_SCHEMA.TABLES
2474 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2475 test/ta3b2_compact 13 6 0
2476 # Metadata from INFORMATION_SCHEMA.COLUMNS
2477 NAME POS MTYPE PRTYPE HAS_DEFAULT
2478 c0 0 6 1027 0
2479 c1 1 5 16711932 0
2480 c2 2 6 1027 0
2481 c3 3 6 1283 0
2482 c4 4 6 1027 0
2483 c5 5 6 1283 0
2484 c6 6 6 1027 1
2485 c7 7 6 1283 1
2486 c8 8 6 1027 1
2487 c9 9 6 1283 1
2488 SELECT * FROM ta3b2_compact;;
2489 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
2490 SHOW CREATE TABLE ta3b2_compact;;
2491 Table Create Table
2492 ta3b2_compact CREATE TABLE `ta3b2_compact` (
2493 `c0` int DEFAULT NULL,
2494 `c1` text,
2495 `c2` int DEFAULT NULL,
2496 `c3` int NOT NULL,
2497 `c4` int DEFAULT '40',
2498 `c5` int NOT NULL DEFAULT '50',
2499 `c6` int DEFAULT NULL,
2500 `c7` int NOT NULL,
2501 `c8` int DEFAULT '80',
2502 `c9` int NOT NULL DEFAULT '90'
2503 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
2504 CHECK TABLE ta3b2_compact;;
2505 Table Op Msg_type Msg_text
2506 test.ta3b2_compact check status OK
2507 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL update_now WAIT_FOR update_done';
2508 ALTER TABLE ta3b2_compact ADD PRIMARY KEY (c0);
2509 SET DEBUG_SYNC='now WAIT_FOR update_now';
2510 # Metadata from INFORMATION_SCHEMA.TABLES
2511 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2512 test/ta3b2_compact 13 6 0
2513 # Metadata from INFORMATION_SCHEMA.COLUMNS
2514 NAME POS MTYPE PRTYPE HAS_DEFAULT
2515 c0 0 6 1027 0
2516 c1 1 5 16711932 0
2517 c2 2 6 1027 0
2518 c3 3 6 1283 0
2519 c4 4 6 1027 0
2520 c5 5 6 1283 0
2521 c6 6 6 1027 1
2522 c7 7 6 1283 1
2523 c8 8 6 1027 1
2524 c9 9 6 1283 1
2525 SELECT * FROM ta3b2_compact;
2526 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
2527 SHOW CREATE TABLE ta3b2_compact;
2528 Table Create Table
2529 ta3b2_compact CREATE TABLE `ta3b2_compact` (
2530 `c0` int DEFAULT NULL,
2531 `c1` text,
2532 `c2` int DEFAULT NULL,
2533 `c3` int NOT NULL,
2534 `c4` int DEFAULT '40',
2535 `c5` int NOT NULL DEFAULT '50',
2536 `c6` int DEFAULT NULL,
2537 `c7` int NOT NULL,
2538 `c8` int DEFAULT '80',
2539 `c9` int NOT NULL DEFAULT '90'
2540 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
2541 CHECK TABLE ta3b2_compact;
2542 Table Op Msg_type Msg_text
2543 test.ta3b2_compact check status OK
2544 UPDATE ta3b2_compact SET c2 = 1;
2545 # Metadata from INFORMATION_SCHEMA.TABLES
2546 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2547 test/ta3b2_compact 13 6 0
2548 # Metadata from INFORMATION_SCHEMA.COLUMNS
2549 NAME POS MTYPE PRTYPE HAS_DEFAULT
2550 c0 0 6 1027 0
2551 c1 1 5 16711932 0
2552 c2 2 6 1027 0
2553 c3 3 6 1283 0
2554 c4 4 6 1027 0
2555 c5 5 6 1283 0
2556 c6 6 6 1027 1
2557 c7 7 6 1283 1
2558 c8 8 6 1027 1
2559 c9 9 6 1283 1
2560 SELECT * FROM ta3b2_compact;
2561 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
2562 SHOW CREATE TABLE ta3b2_compact;
2563 Table Create Table
2564 ta3b2_compact CREATE TABLE `ta3b2_compact` (
2565 `c0` int DEFAULT NULL,
2566 `c1` text,
2567 `c2` int DEFAULT NULL,
2568 `c3` int NOT NULL,
2569 `c4` int DEFAULT '40',
2570 `c5` int NOT NULL DEFAULT '50',
2571 `c6` int DEFAULT NULL,
2572 `c7` int NOT NULL,
2573 `c8` int DEFAULT '80',
2574 `c9` int NOT NULL DEFAULT '90'
2575 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
2576 CHECK TABLE ta3b2_compact;
2577 Table Op Msg_type Msg_text
2578 test.ta3b2_compact check status OK
2579 SET DEBUG_SYNC='now SIGNAL update_done';
2580 # Metadata from INFORMATION_SCHEMA.TABLES
2581 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2582 test/ta3b2_compact 13 0 0
2583 # Metadata from INFORMATION_SCHEMA.COLUMNS
2584 NAME POS MTYPE PRTYPE HAS_DEFAULT
2585 c0 0 6 1283 0
2586 c1 1 5 16711932 0
2587 c2 2 6 1027 0
2588 c3 3 6 1283 0
2589 c4 4 6 1027 0
2590 c5 5 6 1283 0
2591 c6 6 6 1027 0
2592 c7 7 6 1283 0
2593 c8 8 6 1027 0
2594 c9 9 6 1283 0
2595 SELECT * FROM ta3b2_compact;
2596 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
2597 SHOW CREATE TABLE ta3b2_compact;
2598 Table Create Table
2599 ta3b2_compact CREATE TABLE `ta3b2_compact` (
2600 `c0` int NOT NULL,
2601 `c1` text,
2602 `c2` int DEFAULT NULL,
2603 `c3` int NOT NULL,
2604 `c4` int DEFAULT '40',
2605 `c5` int NOT NULL DEFAULT '50',
2606 `c6` int DEFAULT NULL,
2607 `c7` int NOT NULL,
2608 `c8` int DEFAULT '80',
2609 `c9` int NOT NULL DEFAULT '90',
2610 PRIMARY KEY (`c0`)
2611 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
2612 CHECK TABLE ta3b2_compact;
2613 Table Op Msg_type Msg_text
2614 test.ta3b2_compact check status OK
2615 DROP TABLE ta3b2_compact;
2616 # Run online ddl for ta3b3
2617 # Metadata from INFORMATION_SCHEMA.TABLES
2618 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2619 test/ta3b3_compact 13 0 2
2620 # Metadata from INFORMATION_SCHEMA.COLUMNS
2621 NAME POS MTYPE PRTYPE HAS_DEFAULT
2622 c0 0 6 1027 0
2623 c1 1 5 16711932 0
2624 c2 2 6 1027 0
2625 c3 3 6 1283 0
2626 c4 4 6 1027 0
2627 c5 5 6 1283 0
2628 c10 6 6 1027 1
2629 c11 7 6 1283 1
2630 c12 8 6 1027 1
2631 c13 9 6 1283 1
2632 SELECT * FROM ta3b3_compact;;
2633 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
2634 1 row1 2 3 4 5 10 11 12 13
2635 2 row2 NULL 33 40 55 NULL 1111 120 1313
2636 SHOW CREATE TABLE ta3b3_compact;;
2637 Table Create Table
2638 ta3b3_compact CREATE TABLE `ta3b3_compact` (
2639 `c0` int DEFAULT NULL,
2640 `c1` text,
2641 `c2` int DEFAULT NULL,
2642 `c3` int NOT NULL,
2643 `c4` int DEFAULT '40',
2644 `c5` int NOT NULL DEFAULT '50',
2645 `c10` int DEFAULT NULL,
2646 `c11` int NOT NULL,
2647 `c12` int DEFAULT '120',
2648 `c13` int NOT NULL DEFAULT '130'
2649 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
2650 CHECK TABLE ta3b3_compact;;
2651 Table Op Msg_type Msg_text
2652 test.ta3b3_compact check status OK
2653 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL update_now WAIT_FOR update_done';
2654 ALTER TABLE ta3b3_compact ADD PRIMARY KEY (c0);
2655 SET DEBUG_SYNC='now WAIT_FOR update_now';
2656 # Metadata from INFORMATION_SCHEMA.TABLES
2657 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2658 test/ta3b3_compact 13 0 2
2659 # Metadata from INFORMATION_SCHEMA.COLUMNS
2660 NAME POS MTYPE PRTYPE HAS_DEFAULT
2661 c0 0 6 1027 0
2662 c1 1 5 16711932 0
2663 c2 2 6 1027 0
2664 c3 3 6 1283 0
2665 c4 4 6 1027 0
2666 c5 5 6 1283 0
2667 c10 6 6 1027 1
2668 c11 7 6 1283 1
2669 c12 8 6 1027 1
2670 c13 9 6 1283 1
2671 SELECT * FROM ta3b3_compact;
2672 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
2673 1 row1 2 3 4 5 10 11 12 13
2674 2 row2 NULL 33 40 55 NULL 1111 120 1313
2675 SHOW CREATE TABLE ta3b3_compact;
2676 Table Create Table
2677 ta3b3_compact CREATE TABLE `ta3b3_compact` (
2678 `c0` int DEFAULT NULL,
2679 `c1` text,
2680 `c2` int DEFAULT NULL,
2681 `c3` int NOT NULL,
2682 `c4` int DEFAULT '40',
2683 `c5` int NOT NULL DEFAULT '50',
2684 `c10` int DEFAULT NULL,
2685 `c11` int NOT NULL,
2686 `c12` int DEFAULT '120',
2687 `c13` int NOT NULL DEFAULT '130'
2688 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
2689 CHECK TABLE ta3b3_compact;
2690 Table Op Msg_type Msg_text
2691 test.ta3b3_compact check status OK
2692 UPDATE ta3b3_compact SET c2 = 1;
2693 # Metadata from INFORMATION_SCHEMA.TABLES
2694 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2695 test/ta3b3_compact 13 0 2
2696 # Metadata from INFORMATION_SCHEMA.COLUMNS
2697 NAME POS MTYPE PRTYPE HAS_DEFAULT
2698 c0 0 6 1027 0
2699 c1 1 5 16711932 0
2700 c2 2 6 1027 0
2701 c3 3 6 1283 0
2702 c4 4 6 1027 0
2703 c5 5 6 1283 0
2704 c10 6 6 1027 1
2705 c11 7 6 1283 1
2706 c12 8 6 1027 1
2707 c13 9 6 1283 1
2708 SELECT * FROM ta3b3_compact;
2709 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
2710 1 row1 1 3 4 5 10 11 12 13
2711 2 row2 1 33 40 55 NULL 1111 120 1313
2712 SHOW CREATE TABLE ta3b3_compact;
2713 Table Create Table
2714 ta3b3_compact CREATE TABLE `ta3b3_compact` (
2715 `c0` int DEFAULT NULL,
2716 `c1` text,
2717 `c2` int DEFAULT NULL,
2718 `c3` int NOT NULL,
2719 `c4` int DEFAULT '40',
2720 `c5` int NOT NULL DEFAULT '50',
2721 `c10` int DEFAULT NULL,
2722 `c11` int NOT NULL,
2723 `c12` int DEFAULT '120',
2724 `c13` int NOT NULL DEFAULT '130'
2725 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
2726 CHECK TABLE ta3b3_compact;
2727 Table Op Msg_type Msg_text
2728 test.ta3b3_compact check status OK
2729 SET DEBUG_SYNC='now SIGNAL update_done';
2730 # Metadata from INFORMATION_SCHEMA.TABLES
2731 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2732 test/ta3b3_compact 13 0 0
2733 # Metadata from INFORMATION_SCHEMA.COLUMNS
2734 NAME POS MTYPE PRTYPE HAS_DEFAULT
2735 c0 0 6 1283 0
2736 c1 1 5 16711932 0
2737 c2 2 6 1027 0
2738 c3 3 6 1283 0
2739 c4 4 6 1027 0
2740 c5 5 6 1283 0
2741 c10 6 6 1027 0
2742 c11 7 6 1283 0
2743 c12 8 6 1027 0
2744 c13 9 6 1283 0
2745 SELECT * FROM ta3b3_compact;
2746 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
2747 1 row1 1 3 4 5 10 11 12 13
2748 2 row2 1 33 40 55 NULL 1111 120 1313
2749 SHOW CREATE TABLE ta3b3_compact;
2750 Table Create Table
2751 ta3b3_compact CREATE TABLE `ta3b3_compact` (
2752 `c0` int NOT NULL,
2753 `c1` text,
2754 `c2` int DEFAULT NULL,
2755 `c3` int NOT NULL,
2756 `c4` int DEFAULT '40',
2757 `c5` int NOT NULL DEFAULT '50',
2758 `c10` int DEFAULT NULL,
2759 `c11` int NOT NULL,
2760 `c12` int DEFAULT '120',
2761 `c13` int NOT NULL DEFAULT '130',
2762 PRIMARY KEY (`c0`)
2763 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
2764 CHECK TABLE ta3b3_compact;
2765 Table Op Msg_type Msg_text
2766 test.ta3b3_compact check status OK
2767 DROP TABLE ta3b3_compact;
2768 # Run online ddl for ta3b4
2769 # Metadata from INFORMATION_SCHEMA.TABLES
2770 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2771 test/ta3b4_compact 17 6 2
2772 # Metadata from INFORMATION_SCHEMA.COLUMNS
2773 NAME POS MTYPE PRTYPE HAS_DEFAULT
2774 c0 0 6 1027 0
2775 c1 1 5 16711932 0
2776 c2 2 6 1027 0
2777 c3 3 6 1283 0
2778 c4 4 6 1027 0
2779 c5 5 6 1283 0
2780 c6 6 6 1027 1
2781 c7 7 6 1283 1
2782 c8 8 6 1027 1
2783 c9 9 6 1283 1
2784 c10 10 6 1027 1
2785 c11 11 6 1283 1
2786 c12 12 6 1027 1
2787 c13 13 6 1283 1
2788 SELECT * FROM ta3b4_compact;;
2789 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
2790 1 row1 2 3 4 5 6 7 8 9 10 11 12 13
2791 2 row2 NULL 33 40 55 NULL 77 80 99 NULL 1111 120 1313
2792 SHOW CREATE TABLE ta3b4_compact;;
2793 Table Create Table
2794 ta3b4_compact CREATE TABLE `ta3b4_compact` (
2795 `c0` int DEFAULT NULL,
2796 `c1` text,
2797 `c2` int DEFAULT NULL,
2798 `c3` int NOT NULL,
2799 `c4` int DEFAULT '40',
2800 `c5` int NOT NULL DEFAULT '50',
2801 `c6` int DEFAULT NULL,
2802 `c7` int NOT NULL,
2803 `c8` int DEFAULT '80',
2804 `c9` int NOT NULL DEFAULT '90',
2805 `c10` int DEFAULT NULL,
2806 `c11` int NOT NULL,
2807 `c12` int DEFAULT '120',
2808 `c13` int NOT NULL DEFAULT '130'
2809 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
2810 CHECK TABLE ta3b4_compact;;
2811 Table Op Msg_type Msg_text
2812 test.ta3b4_compact check status OK
2813 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL update_now WAIT_FOR update_done';
2814 ALTER TABLE ta3b4_compact ADD PRIMARY KEY (c0);
2815 SET DEBUG_SYNC='now WAIT_FOR update_now';
2816 # Metadata from INFORMATION_SCHEMA.TABLES
2817 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2818 test/ta3b4_compact 17 6 2
2819 # Metadata from INFORMATION_SCHEMA.COLUMNS
2820 NAME POS MTYPE PRTYPE HAS_DEFAULT
2821 c0 0 6 1027 0
2822 c1 1 5 16711932 0
2823 c2 2 6 1027 0
2824 c3 3 6 1283 0
2825 c4 4 6 1027 0
2826 c5 5 6 1283 0
2827 c6 6 6 1027 1
2828 c7 7 6 1283 1
2829 c8 8 6 1027 1
2830 c9 9 6 1283 1
2831 c10 10 6 1027 1
2832 c11 11 6 1283 1
2833 c12 12 6 1027 1
2834 c13 13 6 1283 1
2835 SELECT * FROM ta3b4_compact;
2836 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
2837 1 row1 2 3 4 5 6 7 8 9 10 11 12 13
2838 2 row2 NULL 33 40 55 NULL 77 80 99 NULL 1111 120 1313
2839 SHOW CREATE TABLE ta3b4_compact;
2840 Table Create Table
2841 ta3b4_compact CREATE TABLE `ta3b4_compact` (
2842 `c0` int DEFAULT NULL,
2843 `c1` text,
2844 `c2` int DEFAULT NULL,
2845 `c3` int NOT NULL,
2846 `c4` int DEFAULT '40',
2847 `c5` int NOT NULL DEFAULT '50',
2848 `c6` int DEFAULT NULL,
2849 `c7` int NOT NULL,
2850 `c8` int DEFAULT '80',
2851 `c9` int NOT NULL DEFAULT '90',
2852 `c10` int DEFAULT NULL,
2853 `c11` int NOT NULL,
2854 `c12` int DEFAULT '120',
2855 `c13` int NOT NULL DEFAULT '130'
2856 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
2857 CHECK TABLE ta3b4_compact;
2858 Table Op Msg_type Msg_text
2859 test.ta3b4_compact check status OK
2860 UPDATE ta3b4_compact SET c2 = 1;
2861 # Metadata from INFORMATION_SCHEMA.TABLES
2862 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2863 test/ta3b4_compact 17 6 2
2864 # Metadata from INFORMATION_SCHEMA.COLUMNS
2865 NAME POS MTYPE PRTYPE HAS_DEFAULT
2866 c0 0 6 1027 0
2867 c1 1 5 16711932 0
2868 c2 2 6 1027 0
2869 c3 3 6 1283 0
2870 c4 4 6 1027 0
2871 c5 5 6 1283 0
2872 c6 6 6 1027 1
2873 c7 7 6 1283 1
2874 c8 8 6 1027 1
2875 c9 9 6 1283 1
2876 c10 10 6 1027 1
2877 c11 11 6 1283 1
2878 c12 12 6 1027 1
2879 c13 13 6 1283 1
2880 SELECT * FROM ta3b4_compact;
2881 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
2882 1 row1 1 3 4 5 6 7 8 9 10 11 12 13
2883 2 row2 1 33 40 55 NULL 77 80 99 NULL 1111 120 1313
2884 SHOW CREATE TABLE ta3b4_compact;
2885 Table Create Table
2886 ta3b4_compact CREATE TABLE `ta3b4_compact` (
2887 `c0` int DEFAULT NULL,
2888 `c1` text,
2889 `c2` int DEFAULT NULL,
2890 `c3` int NOT NULL,
2891 `c4` int DEFAULT '40',
2892 `c5` int NOT NULL DEFAULT '50',
2893 `c6` int DEFAULT NULL,
2894 `c7` int NOT NULL,
2895 `c8` int DEFAULT '80',
2896 `c9` int NOT NULL DEFAULT '90',
2897 `c10` int DEFAULT NULL,
2898 `c11` int NOT NULL,
2899 `c12` int DEFAULT '120',
2900 `c13` int NOT NULL DEFAULT '130'
2901 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
2902 CHECK TABLE ta3b4_compact;
2903 Table Op Msg_type Msg_text
2904 test.ta3b4_compact check status OK
2905 SET DEBUG_SYNC='now SIGNAL update_done';
2906 # Metadata from INFORMATION_SCHEMA.TABLES
2907 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2908 test/ta3b4_compact 17 0 0
2909 # Metadata from INFORMATION_SCHEMA.COLUMNS
2910 NAME POS MTYPE PRTYPE HAS_DEFAULT
2911 c0 0 6 1283 0
2912 c1 1 5 16711932 0
2913 c2 2 6 1027 0
2914 c3 3 6 1283 0
2915 c4 4 6 1027 0
2916 c5 5 6 1283 0
2917 c6 6 6 1027 0
2918 c7 7 6 1283 0
2919 c8 8 6 1027 0
2920 c9 9 6 1283 0
2921 c10 10 6 1027 0
2922 c11 11 6 1283 0
2923 c12 12 6 1027 0
2924 c13 13 6 1283 0
2925 SELECT * FROM ta3b4_compact;
2926 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
2927 1 row1 1 3 4 5 6 7 8 9 10 11 12 13
2928 2 row2 1 33 40 55 NULL 77 80 99 NULL 1111 120 1313
2929 SHOW CREATE TABLE ta3b4_compact;
2930 Table Create Table
2931 ta3b4_compact CREATE TABLE `ta3b4_compact` (
2932 `c0` int NOT NULL,
2933 `c1` text,
2934 `c2` int DEFAULT NULL,
2935 `c3` int NOT NULL,
2936 `c4` int DEFAULT '40',
2937 `c5` int NOT NULL DEFAULT '50',
2938 `c6` int DEFAULT NULL,
2939 `c7` int NOT NULL,
2940 `c8` int DEFAULT '80',
2941 `c9` int NOT NULL DEFAULT '90',
2942 `c10` int DEFAULT NULL,
2943 `c11` int NOT NULL,
2944 `c12` int DEFAULT '120',
2945 `c13` int NOT NULL DEFAULT '130',
2946 PRIMARY KEY (`c0`)
2947 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
2948 CHECK TABLE ta3b4_compact;
2949 Table Op Msg_type Msg_text
2950 test.ta3b4_compact check status OK
2951 DROP TABLE ta3b4_compact;
2952 # For all DYNAMIC tables:
2953 # Prepare the table
2954 # Processing alters:
2955 # b1, b2: no alter add in trunk
2956 # b3: alter add
2957 ALTER TABLE ta1b3_dynamic ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
2958 ALTER TABLE ta1b3_dynamic ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
2959 ALTER TABLE ta3b3_dynamic ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
2960 ALTER TABLE ta3b3_dynamic ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
2961 # b4: alter add
2962 ALTER TABLE ta1b4_dynamic ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
2963 ALTER TABLE ta1b4_dynamic ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
2964 ALTER TABLE ta2b4_dynamic ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
2965 ALTER TABLE ta2b4_dynamic ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
2966 ALTER TABLE ta3b4_dynamic ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
2967 ALTER TABLE ta3b4_dynamic ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
2968 # Processing row inserts:
2969 # a3: rows have version from new table
2970 INSERT INTO ta3b3_dynamic VALUES (1, "row1", 2, 3, 4, 5, 10, 11, 12, 13);;
2971 INSERT INTO ta3b3_dynamic (c0, c1, c3, c5, c11, c13) VALUES (2, "row2", 33, 55, 1111, 1313);;
2972 INSERT INTO ta3b4_dynamic VALUES (1, "row1", 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13);;
2973 INSERT INTO ta3b4_dynamic (c0, c1, c3, c5, c7, c9, c11, c13) VALUES (2, "row2", 33, 55, 77, 99, 1111, 1313);;
2974 # For each table, do online ddl
2975 # Run online ddl for ta1b1
2976 # Metadata from INFORMATION_SCHEMA.TABLES
2977 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2978 test/ta1b1_dynamic 9 0 0
2979 # Metadata from INFORMATION_SCHEMA.COLUMNS
2980 NAME POS MTYPE PRTYPE HAS_DEFAULT
2981 c0 0 6 1027 0
2982 c1 1 5 16711932 0
2983 c2 2 6 1027 0
2984 c3 3 6 1283 0
2985 c4 4 6 1027 0
2986 c5 5 6 1283 0
2987 SELECT * FROM ta1b1_dynamic;;
2988 c0 c1 c2 c3 c4 c5
2989 1 row1 2 3 4 5
2990 2 row2 NULL 33 40 55
2991 SHOW CREATE TABLE ta1b1_dynamic;;
2992 Table Create Table
2993 ta1b1_dynamic CREATE TABLE `ta1b1_dynamic` (
2994 `c0` int DEFAULT NULL,
2995 `c1` text,
2996 `c2` int DEFAULT NULL,
2997 `c3` int NOT NULL,
2998 `c4` int DEFAULT '40',
2999 `c5` int NOT NULL DEFAULT '50'
3000 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
3001 CHECK TABLE ta1b1_dynamic;;
3002 Table Op Msg_type Msg_text
3003 test.ta1b1_dynamic check status OK
3004 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL update_now WAIT_FOR update_done';
3005 ALTER TABLE ta1b1_dynamic ADD PRIMARY KEY (c0);
3006 SET DEBUG_SYNC='now WAIT_FOR update_now';
3007 # Metadata from INFORMATION_SCHEMA.TABLES
3008 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
3009 test/ta1b1_dynamic 9 0 0
3010 # Metadata from INFORMATION_SCHEMA.COLUMNS
3011 NAME POS MTYPE PRTYPE HAS_DEFAULT
3012 c0 0 6 1027 0
3013 c1 1 5 16711932 0
3014 c2 2 6 1027 0
3015 c3 3 6 1283 0
3016 c4 4 6 1027 0
3017 c5 5 6 1283 0
3018 SELECT * FROM ta1b1_dynamic;
3019 c0 c1 c2 c3 c4 c5
3020 1 row1 2 3 4 5
3021 2 row2 NULL 33 40 55
3022 SHOW CREATE TABLE ta1b1_dynamic;
3023 Table Create Table
3024 ta1b1_dynamic CREATE TABLE `ta1b1_dynamic` (
3025 `c0` int DEFAULT NULL,
3026 `c1` text,
3027 `c2` int DEFAULT NULL,
3028 `c3` int NOT NULL,
3029 `c4` int DEFAULT '40',
3030 `c5` int NOT NULL DEFAULT '50'
3031 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
3032 CHECK TABLE ta1b1_dynamic;
3033 Table Op Msg_type Msg_text
3034 test.ta1b1_dynamic check status OK
3035 UPDATE ta1b1_dynamic SET c2 = 1;
3036 # Metadata from INFORMATION_SCHEMA.TABLES
3037 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
3038 test/ta1b1_dynamic 9 0 0
3039 # Metadata from INFORMATION_SCHEMA.COLUMNS
3040 NAME POS MTYPE PRTYPE HAS_DEFAULT
3041 c0 0 6 1027 0
3042 c1 1 5 16711932 0
3043 c2 2 6 1027 0
3044 c3 3 6 1283 0
3045 c4 4 6 1027 0
3046 c5 5 6 1283 0
3047 SELECT * FROM ta1b1_dynamic;
3048 c0 c1 c2 c3 c4 c5
3049 1 row1 1 3 4 5
3050 2 row2 1 33 40 55
3051 SHOW CREATE TABLE ta1b1_dynamic;
3052 Table Create Table
3053 ta1b1_dynamic CREATE TABLE `ta1b1_dynamic` (
3054 `c0` int DEFAULT NULL,
3055 `c1` text,
3056 `c2` int DEFAULT NULL,
3057 `c3` int NOT NULL,
3058 `c4` int DEFAULT '40',
3059 `c5` int NOT NULL DEFAULT '50'
3060 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
3061 CHECK TABLE ta1b1_dynamic;
3062 Table Op Msg_type Msg_text
3063 test.ta1b1_dynamic check status OK
3064 SET DEBUG_SYNC='now SIGNAL update_done';
3065 # Metadata from INFORMATION_SCHEMA.TABLES
3066 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
3067 test/ta1b1_dynamic 9 0 0
3068 # Metadata from INFORMATION_SCHEMA.COLUMNS
3069 NAME POS MTYPE PRTYPE HAS_DEFAULT
3070 c0 0 6 1283 0
3071 c1 1 5 16711932 0
3072 c2 2 6 1027 0
3073 c3 3 6 1283 0
3074 c4 4 6 1027 0
3075 c5 5 6 1283 0
3076 SELECT * FROM ta1b1_dynamic;
3077 c0 c1 c2 c3 c4 c5
3078 1 row1 1 3 4 5
3079 2 row2 1 33 40 55
3080 SHOW CREATE TABLE ta1b1_dynamic;
3081 Table Create Table
3082 ta1b1_dynamic CREATE TABLE `ta1b1_dynamic` (
3083 `c0` int NOT NULL,
3084 `c1` text,
3085 `c2` int DEFAULT NULL,
3086 `c3` int NOT NULL,
3087 `c4` int DEFAULT '40',
3088 `c5` int NOT NULL DEFAULT '50',
3089 PRIMARY KEY (`c0`)
3090 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
3091 CHECK TABLE ta1b1_dynamic;
3092 Table Op Msg_type Msg_text
3093 test.ta1b1_dynamic check status OK
3094 DROP TABLE ta1b1_dynamic;
3095 # Run online ddl for ta1b2
3096 # Metadata from INFORMATION_SCHEMA.TABLES
3097 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
3098 test/ta1b2_dynamic 13 6 0
3099 # Metadata from INFORMATION_SCHEMA.COLUMNS
3100 NAME POS MTYPE PRTYPE HAS_DEFAULT
3101 c0 0 6 1027 0
3102 c1 1 5 16711932 0
3103 c2 2 6 1027 0
3104 c3 3 6 1283 0
3105 c4 4 6 1027 0
3106 c5 5 6 1283 0
3107 c6 6 6 1027 1
3108 c7 7 6 1283 1
3109 c8 8 6 1027 1
3110 c9 9 6 1283 1
3111 SELECT * FROM ta1b2_dynamic;;
3112 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
3113 1 row1 2 3 4 5 NULL 0 80 90
3114 2 row2 NULL 33 40 55 NULL 0 80 90
3115 SHOW CREATE TABLE ta1b2_dynamic;;
3116 Table Create Table
3117 ta1b2_dynamic CREATE TABLE `ta1b2_dynamic` (
3118 `c0` int DEFAULT NULL,
3119 `c1` text,
3120 `c2` int DEFAULT NULL,
3121 `c3` int NOT NULL,
3122 `c4` int DEFAULT '40',
3123 `c5` int NOT NULL DEFAULT '50',
3124 `c6` int DEFAULT NULL,
3125 `c7` int NOT NULL,
3126 `c8` int DEFAULT '80',
3127 `c9` int NOT NULL DEFAULT '90'
3128 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
3129 CHECK TABLE ta1b2_dynamic;;
3130 Table Op Msg_type Msg_text
3131 test.ta1b2_dynamic check status OK
3132 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL update_now WAIT_FOR update_done';
3133 ALTER TABLE ta1b2_dynamic ADD PRIMARY KEY (c0);
3134 SET DEBUG_SYNC='now WAIT_FOR update_now';
3135 # Metadata from INFORMATION_SCHEMA.TABLES
3136 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
3137 test/ta1b2_dynamic 13 6 0
3138 # Metadata from INFORMATION_SCHEMA.COLUMNS
3139 NAME POS MTYPE PRTYPE HAS_DEFAULT
3140 c0 0 6 1027 0
3141 c1 1 5 16711932 0
3142 c2 2 6 1027 0
3143 c3 3 6 1283 0
3144 c4 4 6 1027 0
3145 c5 5 6 1283 0
3146 c6 6 6 1027 1
3147 c7 7 6 1283 1
3148 c8 8 6 1027 1
3149 c9 9 6 1283 1
3150 SELECT * FROM ta1b2_dynamic;
3151 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
3152 1 row1 2 3 4 5 NULL 0 80 90
3153 2 row2 NULL 33 40 55 NULL 0 80 90
3154 SHOW CREATE TABLE ta1b2_dynamic;
3155 Table Create Table
3156 ta1b2_dynamic CREATE TABLE `ta1b2_dynamic` (
3157 `c0` int DEFAULT NULL,
3158 `c1` text,
3159 `c2` int DEFAULT NULL,
3160 `c3` int NOT NULL,
3161 `c4` int DEFAULT '40',
3162 `c5` int NOT NULL DEFAULT '50',
3163 `c6` int DEFAULT NULL,
3164 `c7` int NOT NULL,
3165 `c8` int DEFAULT '80',
3166 `c9` int NOT NULL DEFAULT '90'
3167 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
3168 CHECK TABLE ta1b2_dynamic;
3169 Table Op Msg_type Msg_text
3170 test.ta1b2_dynamic check status OK
3171 UPDATE ta1b2_dynamic SET c2 = 1;
3172 # Metadata from INFORMATION_SCHEMA.TABLES
3173 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
3174 test/ta1b2_dynamic 13 6 0
3175 # Metadata from INFORMATION_SCHEMA.COLUMNS
3176 NAME POS MTYPE PRTYPE HAS_DEFAULT
3177 c0 0 6 1027 0
3178 c1 1 5 16711932 0
3179 c2 2 6 1027 0
3180 c3 3 6 1283 0
3181 c4 4 6 1027 0
3182 c5 5 6 1283 0
3183 c6 6 6 1027 1
3184 c7 7 6 1283 1
3185 c8 8 6 1027 1
3186 c9 9 6 1283 1
3187 SELECT * FROM ta1b2_dynamic;
3188 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
3189 1 row1 1 3 4 5 NULL 0 80 90
3190 2 row2 1 33 40 55 NULL 0 80 90
3191 SHOW CREATE TABLE ta1b2_dynamic;
3192 Table Create Table
3193 ta1b2_dynamic CREATE TABLE `ta1b2_dynamic` (
3194 `c0` int DEFAULT NULL,
3195 `c1` text,
3196 `c2` int DEFAULT NULL,
3197 `c3` int NOT NULL,
3198 `c4` int DEFAULT '40',
3199 `c5` int NOT NULL DEFAULT '50',
3200 `c6` int DEFAULT NULL,
3201 `c7` int NOT NULL,
3202 `c8` int DEFAULT '80',
3203 `c9` int NOT NULL DEFAULT '90'
3204 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
3205 CHECK TABLE ta1b2_dynamic;
3206 Table Op Msg_type Msg_text
3207 test.ta1b2_dynamic check status OK
3208 SET DEBUG_SYNC='now SIGNAL update_done';
3209 # Metadata from INFORMATION_SCHEMA.TABLES
3210 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
3211 test/ta1b2_dynamic 13 0 0
3212 # Metadata from INFORMATION_SCHEMA.COLUMNS
3213 NAME POS MTYPE PRTYPE HAS_DEFAULT
3214 c0 0 6 1283 0
3215 c1 1 5 16711932 0
3216 c2 2 6 1027 0
3217 c3 3 6 1283 0
3218 c4 4 6 1027 0
3219 c5 5 6 1283 0
3220 c6 6 6 1027 0
3221 c7 7 6 1283 0
3222 c8 8 6 1027 0
3223 c9 9 6 1283 0
3224 SELECT * FROM ta1b2_dynamic;
3225 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
3226 1 row1 1 3 4 5 NULL 0 80 90
3227 2 row2 1 33 40 55 NULL 0 80 90
3228 SHOW CREATE TABLE ta1b2_dynamic;
3229 Table Create Table
3230 ta1b2_dynamic CREATE TABLE `ta1b2_dynamic` (
3231 `c0` int NOT NULL,
3232 `c1` text,
3233 `c2` int DEFAULT NULL,
3234 `c3` int NOT NULL,
3235 `c4` int DEFAULT '40',
3236 `c5` int NOT NULL DEFAULT '50',
3237 `c6` int DEFAULT NULL,
3238 `c7` int NOT NULL,
3239 `c8` int DEFAULT '80',
3240 `c9` int NOT NULL DEFAULT '90',
3241 PRIMARY KEY (`c0`)
3242 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
3243 CHECK TABLE ta1b2_dynamic;
3244 Table Op Msg_type Msg_text
3245 test.ta1b2_dynamic check status OK
3246 DROP TABLE ta1b2_dynamic;
3247 # Run online ddl for ta1b3
3248 # Metadata from INFORMATION_SCHEMA.TABLES
3249 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
3250 test/ta1b3_dynamic 13 0 2
3251 # Metadata from INFORMATION_SCHEMA.COLUMNS
3252 NAME POS MTYPE PRTYPE HAS_DEFAULT
3253 c0 0 6 1027 0
3254 c1 1 5 16711932 0
3255 c2 2 6 1027 0
3256 c3 3 6 1283 0
3257 c4 4 6 1027 0
3258 c5 5 6 1283 0
3259 c10 6 6 1027 1
3260 c11 7 6 1283 1
3261 c12 8 6 1027 1
3262 c13 9 6 1283 1
3263 SELECT * FROM ta1b3_dynamic;;
3264 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
3265 1 row1 2 3 4 5 NULL 0 120 130
3266 2 row2 NULL 33 40 55 NULL 0 120 130
3267 SHOW CREATE TABLE ta1b3_dynamic;;
3268 Table Create Table
3269 ta1b3_dynamic CREATE TABLE `ta1b3_dynamic` (
3270 `c0` int DEFAULT NULL,
3271 `c1` text,
3272 `c2` int DEFAULT NULL,
3273 `c3` int NOT NULL,
3274 `c4` int DEFAULT '40',
3275 `c5` int NOT NULL DEFAULT '50',
3276 `c10` int DEFAULT NULL,
3277 `c11` int NOT NULL,
3278 `c12` int DEFAULT '120',
3279 `c13` int NOT NULL DEFAULT '130'
3280 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
3281 CHECK TABLE ta1b3_dynamic;;
3282 Table Op Msg_type Msg_text
3283 test.ta1b3_dynamic check status OK
3284 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL update_now WAIT_FOR update_done';
3285 ALTER TABLE ta1b3_dynamic ADD PRIMARY KEY (c0);
3286 SET DEBUG_SYNC='now WAIT_FOR update_now';
3287 # Metadata from INFORMATION_SCHEMA.TABLES
3288 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
3289 test/ta1b3_dynamic 13 0 2
3290 # Metadata from INFORMATION_SCHEMA.COLUMNS
3291 NAME POS MTYPE PRTYPE HAS_DEFAULT
3292 c0 0 6 1027 0
3293 c1 1 5 16711932 0
3294 c2 2 6 1027 0
3295 c3 3 6 1283 0
3296 c4 4 6 1027 0
3297 c5 5 6 1283 0
3298 c10 6 6 1027 1
3299 c11 7 6 1283 1
3300 c12 8 6 1027 1
3301 c13 9 6 1283 1
3302 SELECT * FROM ta1b3_dynamic;
3303 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
3304 1 row1 2 3 4 5 NULL 0 120 130
3305 2 row2 NULL 33 40 55 NULL 0 120 130
3306 SHOW CREATE TABLE ta1b3_dynamic;
3307 Table Create Table
3308 ta1b3_dynamic CREATE TABLE `ta1b3_dynamic` (
3309 `c0` int DEFAULT NULL,
3310 `c1` text,
3311 `c2` int DEFAULT NULL,
3312 `c3` int NOT NULL,
3313 `c4` int DEFAULT '40',
3314 `c5` int NOT NULL DEFAULT '50',
3315 `c10` int DEFAULT NULL,
3316 `c11` int NOT NULL,
3317 `c12` int DEFAULT '120',
3318 `c13` int NOT NULL DEFAULT '130'
3319 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
3320 CHECK TABLE ta1b3_dynamic;
3321 Table Op Msg_type Msg_text
3322 test.ta1b3_dynamic check status OK
3323 UPDATE ta1b3_dynamic SET c2 = 1;
3324 # Metadata from INFORMATION_SCHEMA.TABLES
3325 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
3326 test/ta1b3_dynamic 13 0 2
3327 # Metadata from INFORMATION_SCHEMA.COLUMNS
3328 NAME POS MTYPE PRTYPE HAS_DEFAULT
3329 c0 0 6 1027 0
3330 c1 1 5 16711932 0
3331 c2 2 6 1027 0
3332 c3 3 6 1283 0
3333 c4 4 6 1027 0
3334 c5 5 6 1283 0
3335 c10 6 6 1027 1
3336 c11 7 6 1283 1
3337 c12 8 6 1027 1
3338 c13 9 6 1283 1
3339 SELECT * FROM ta1b3_dynamic;
3340 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
3341 1 row1 1 3 4 5 NULL 0 120 130
3342 2 row2 1 33 40 55 NULL 0 120 130
3343 SHOW CREATE TABLE ta1b3_dynamic;
3344 Table Create Table
3345 ta1b3_dynamic CREATE TABLE `ta1b3_dynamic` (
3346 `c0` int DEFAULT NULL,
3347 `c1` text,
3348 `c2` int DEFAULT NULL,
3349 `c3` int NOT NULL,
3350 `c4` int DEFAULT '40',
3351 `c5` int NOT NULL DEFAULT '50',
3352 `c10` int DEFAULT NULL,
3353 `c11` int NOT NULL,
3354 `c12` int DEFAULT '120',
3355 `c13` int NOT NULL DEFAULT '130'
3356 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
3357 CHECK TABLE ta1b3_dynamic;
3358 Table Op Msg_type Msg_text
3359 test.ta1b3_dynamic check status OK
3360 SET DEBUG_SYNC='now SIGNAL update_done';
3361 # Metadata from INFORMATION_SCHEMA.TABLES
3362 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
3363 test/ta1b3_dynamic 13 0 0
3364 # Metadata from INFORMATION_SCHEMA.COLUMNS
3365 NAME POS MTYPE PRTYPE HAS_DEFAULT
3366 c0 0 6 1283 0
3367 c1 1 5 16711932 0
3368 c2 2 6 1027 0
3369 c3 3 6 1283 0
3370 c4 4 6 1027 0
3371 c5 5 6 1283 0
3372 c10 6 6 1027 0
3373 c11 7 6 1283 0
3374 c12 8 6 1027 0
3375 c13 9 6 1283 0
3376 SELECT * FROM ta1b3_dynamic;
3377 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
3378 1 row1 1 3 4 5 NULL 0 120 130
3379 2 row2 1 33 40 55 NULL 0 120 130
3380 SHOW CREATE TABLE ta1b3_dynamic;
3381 Table Create Table
3382 ta1b3_dynamic CREATE TABLE `ta1b3_dynamic` (
3383 `c0` int NOT NULL,
3384 `c1` text,
3385 `c2` int DEFAULT NULL,
3386 `c3` int NOT NULL,
3387 `c4` int DEFAULT '40',
3388 `c5` int NOT NULL DEFAULT '50',
3389 `c10` int DEFAULT NULL,
3390 `c11` int NOT NULL,
3391 `c12` int DEFAULT '120',
3392 `c13` int NOT NULL DEFAULT '130',
3393 PRIMARY KEY (`c0`)
3394 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
3395 CHECK TABLE ta1b3_dynamic;
3396 Table Op Msg_type Msg_text
3397 test.ta1b3_dynamic check status OK
3398 DROP TABLE ta1b3_dynamic;
3399 # Run online ddl for ta1b4
3400 # Metadata from INFORMATION_SCHEMA.TABLES
3401 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
3402 test/ta1b4_dynamic 17 6 2
3403 # Metadata from INFORMATION_SCHEMA.COLUMNS
3404 NAME POS MTYPE PRTYPE HAS_DEFAULT
3405 c0 0 6 1027 0
3406 c1 1 5 16711932 0
3407 c2 2 6 1027 0
3408 c3 3 6 1283 0
3409 c4 4 6 1027 0
3410 c5 5 6 1283 0
3411 c6 6 6 1027 1
3412 c7 7 6 1283 1
3413 c8 8 6 1027 1
3414 c9 9 6 1283 1
3415 c10 10 6 1027 1
3416 c11 11 6 1283 1
3417 c12 12 6 1027 1
3418 c13 13 6 1283 1
3419 SELECT * FROM ta1b4_dynamic;;
3420 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
3421 1 row1 2 3 4 5 NULL 0 80 90 NULL 0 120 130
3422 2 row2 NULL 33 40 55 NULL 0 80 90 NULL 0 120 130
3423 SHOW CREATE TABLE ta1b4_dynamic;;
3424 Table Create Table
3425 ta1b4_dynamic CREATE TABLE `ta1b4_dynamic` (
3426 `c0` int DEFAULT NULL,
3427 `c1` text,
3428 `c2` int DEFAULT NULL,
3429 `c3` int NOT NULL,
3430 `c4` int DEFAULT '40',
3431 `c5` int NOT NULL DEFAULT '50',
3432 `c6` int DEFAULT NULL,
3433 `c7` int NOT NULL,
3434 `c8` int DEFAULT '80',
3435 `c9` int NOT NULL DEFAULT '90',
3436 `c10` int DEFAULT NULL,
3437 `c11` int NOT NULL,
3438 `c12` int DEFAULT '120',
3439 `c13` int NOT NULL DEFAULT '130'
3440 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
3441 CHECK TABLE ta1b4_dynamic;;
3442 Table Op Msg_type Msg_text
3443 test.ta1b4_dynamic check status OK
3444 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL update_now WAIT_FOR update_done';
3445 ALTER TABLE ta1b4_dynamic ADD PRIMARY KEY (c0);
3446 SET DEBUG_SYNC='now WAIT_FOR update_now';
3447 # Metadata from INFORMATION_SCHEMA.TABLES
3448 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
3449 test/ta1b4_dynamic 17 6 2
3450 # Metadata from INFORMATION_SCHEMA.COLUMNS
3451 NAME POS MTYPE PRTYPE HAS_DEFAULT
3452 c0 0 6 1027 0
3453 c1 1 5 16711932 0
3454 c2 2 6 1027 0
3455 c3 3 6 1283 0
3456 c4 4 6 1027 0
3457 c5 5 6 1283 0
3458 c6 6 6 1027 1
3459 c7 7 6 1283 1
3460 c8 8 6 1027 1
3461 c9 9 6 1283 1
3462 c10 10 6 1027 1
3463 c11 11 6 1283 1
3464 c12 12 6 1027 1
3465 c13 13 6 1283 1
3466 SELECT * FROM ta1b4_dynamic;
3467 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
3468 1 row1 2 3 4 5 NULL 0 80 90 NULL 0 120 130
3469 2 row2 NULL 33 40 55 NULL 0 80 90 NULL 0 120 130
3470 SHOW CREATE TABLE ta1b4_dynamic;
3471 Table Create Table
3472 ta1b4_dynamic CREATE TABLE `ta1b4_dynamic` (
3473 `c0` int DEFAULT NULL,
3474 `c1` text,
3475 `c2` int DEFAULT NULL,
3476 `c3` int NOT NULL,
3477 `c4` int DEFAULT '40',
3478 `c5` int NOT NULL DEFAULT '50',
3479 `c6` int DEFAULT NULL,
3480 `c7` int NOT NULL,
3481 `c8` int DEFAULT '80',
3482 `c9` int NOT NULL DEFAULT '90',
3483 `c10` int DEFAULT NULL,
3484 `c11` int NOT NULL,
3485 `c12` int DEFAULT '120',
3486 `c13` int NOT NULL DEFAULT '130'
3487 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
3488 CHECK TABLE ta1b4_dynamic;
3489 Table Op Msg_type Msg_text
3490 test.ta1b4_dynamic check status OK
3491 UPDATE ta1b4_dynamic SET c2 = 1;
3492 # Metadata from INFORMATION_SCHEMA.TABLES
3493 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
3494 test/ta1b4_dynamic 17 6 2
3495 # Metadata from INFORMATION_SCHEMA.COLUMNS
3496 NAME POS MTYPE PRTYPE HAS_DEFAULT
3497 c0 0 6 1027 0
3498 c1 1 5 16711932 0
3499 c2 2 6 1027 0
3500 c3 3 6 1283 0
3501 c4 4 6 1027 0
3502 c5 5 6 1283 0
3503 c6 6 6 1027 1
3504 c7 7 6 1283 1
3505 c8 8 6 1027 1
3506 c9 9 6 1283 1
3507 c10 10 6 1027 1
3508 c11 11 6 1283 1
3509 c12 12 6 1027 1
3510 c13 13 6 1283 1
3511 SELECT * FROM ta1b4_dynamic;
3512 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
3513 1 row1 1 3 4 5 NULL 0 80 90 NULL 0 120 130
3514 2 row2 1 33 40 55 NULL 0 80 90 NULL 0 120 130
3515 SHOW CREATE TABLE ta1b4_dynamic;
3516 Table Create Table
3517 ta1b4_dynamic CREATE TABLE `ta1b4_dynamic` (
3518 `c0` int DEFAULT NULL,
3519 `c1` text,
3520 `c2` int DEFAULT NULL,
3521 `c3` int NOT NULL,
3522 `c4` int DEFAULT '40',
3523 `c5` int NOT NULL DEFAULT '50',
3524 `c6` int DEFAULT NULL,
3525 `c7` int NOT NULL,
3526 `c8` int DEFAULT '80',
3527 `c9` int NOT NULL DEFAULT '90',
3528 `c10` int DEFAULT NULL,
3529 `c11` int NOT NULL,
3530 `c12` int DEFAULT '120',
3531 `c13` int NOT NULL DEFAULT '130'
3532 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
3533 CHECK TABLE ta1b4_dynamic;
3534 Table Op Msg_type Msg_text
3535 test.ta1b4_dynamic check status OK
3536 SET DEBUG_SYNC='now SIGNAL update_done';
3537 # Metadata from INFORMATION_SCHEMA.TABLES
3538 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
3539 test/ta1b4_dynamic 17 0 0
3540 # Metadata from INFORMATION_SCHEMA.COLUMNS
3541 NAME POS MTYPE PRTYPE HAS_DEFAULT
3542 c0 0 6 1283 0
3543 c1 1 5 16711932 0
3544 c2 2 6 1027 0
3545 c3 3 6 1283 0
3546 c4 4 6 1027 0
3547 c5 5 6 1283 0
3548 c6 6 6 1027 0
3549 c7 7 6 1283 0
3550 c8 8 6 1027 0
3551 c9 9 6 1283 0
3552 c10 10 6 1027 0
3553 c11 11 6 1283 0
3554 c12 12 6 1027 0
3555 c13 13 6 1283 0
3556 SELECT * FROM ta1b4_dynamic;
3557 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
3558 1 row1 1 3 4 5 NULL 0 80 90 NULL 0 120 130
3559 2 row2 1 33 40 55 NULL 0 80 90 NULL 0 120 130
3560 SHOW CREATE TABLE ta1b4_dynamic;
3561 Table Create Table
3562 ta1b4_dynamic CREATE TABLE `ta1b4_dynamic` (
3563 `c0` int NOT NULL,
3564 `c1` text,
3565 `c2` int DEFAULT NULL,
3566 `c3` int NOT NULL,
3567 `c4` int DEFAULT '40',
3568 `c5` int NOT NULL DEFAULT '50',
3569 `c6` int DEFAULT NULL,
3570 `c7` int NOT NULL,
3571 `c8` int DEFAULT '80',
3572 `c9` int NOT NULL DEFAULT '90',
3573 `c10` int DEFAULT NULL,
3574 `c11` int NOT NULL,
3575 `c12` int DEFAULT '120',
3576 `c13` int NOT NULL DEFAULT '130',
3577 PRIMARY KEY (`c0`)
3578 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
3579 CHECK TABLE ta1b4_dynamic;
3580 Table Op Msg_type Msg_text
3581 test.ta1b4_dynamic check status OK
3582 DROP TABLE ta1b4_dynamic;
3583 # Run online ddl for ta2b2
3584 # Metadata from INFORMATION_SCHEMA.TABLES
3585 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
3586 test/ta2b2_dynamic 13 6 0
3587 # Metadata from INFORMATION_SCHEMA.COLUMNS
3588 NAME POS MTYPE PRTYPE HAS_DEFAULT
3589 c0 0 6 1027 0
3590 c1 1 5 16711932 0
3591 c2 2 6 1027 0
3592 c3 3 6 1283 0
3593 c4 4 6 1027 0
3594 c5 5 6 1283 0
3595 c6 6 6 1027 1
3596 c7 7 6 1283 1
3597 c8 8 6 1027 1
3598 c9 9 6 1283 1
3599 SELECT * FROM ta2b2_dynamic;;
3600 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
3601 1 row1 2 3 4 5 6 7 8 9
3602 2 row2 NULL 33 40 55 NULL 77 80 99
3603 SHOW CREATE TABLE ta2b2_dynamic;;
3604 Table Create Table
3605 ta2b2_dynamic CREATE TABLE `ta2b2_dynamic` (
3606 `c0` int DEFAULT NULL,
3607 `c1` text,
3608 `c2` int DEFAULT NULL,
3609 `c3` int NOT NULL,
3610 `c4` int DEFAULT '40',
3611 `c5` int NOT NULL DEFAULT '50',
3612 `c6` int DEFAULT NULL,
3613 `c7` int NOT NULL,
3614 `c8` int DEFAULT '80',
3615 `c9` int NOT NULL DEFAULT '90'
3616 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
3617 CHECK TABLE ta2b2_dynamic;;
3618 Table Op Msg_type Msg_text
3619 test.ta2b2_dynamic check status OK
3620 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL update_now WAIT_FOR update_done';
3621 ALTER TABLE ta2b2_dynamic ADD PRIMARY KEY (c0);
3622 SET DEBUG_SYNC='now WAIT_FOR update_now';
3623 # Metadata from INFORMATION_SCHEMA.TABLES
3624 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
3625 test/ta2b2_dynamic 13 6 0
3626 # Metadata from INFORMATION_SCHEMA.COLUMNS
3627 NAME POS MTYPE PRTYPE HAS_DEFAULT
3628 c0 0 6 1027 0
3629 c1 1 5 16711932 0
3630 c2 2 6 1027 0
3631 c3 3 6 1283 0
3632 c4 4 6 1027 0
3633 c5 5 6 1283 0
3634 c6 6 6 1027 1
3635 c7 7 6 1283 1
3636 c8 8 6 1027 1
3637 c9 9 6 1283 1
3638 SELECT * FROM ta2b2_dynamic;
3639 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
3640 1 row1 2 3 4 5 6 7 8 9
3641 2 row2 NULL 33 40 55 NULL 77 80 99
3642 SHOW CREATE TABLE ta2b2_dynamic;
3643 Table Create Table
3644 ta2b2_dynamic CREATE TABLE `ta2b2_dynamic` (
3645 `c0` int DEFAULT NULL,
3646 `c1` text,
3647 `c2` int DEFAULT NULL,
3648 `c3` int NOT NULL,
3649 `c4` int DEFAULT '40',
3650 `c5` int NOT NULL DEFAULT '50',
3651 `c6` int DEFAULT NULL,
3652 `c7` int NOT NULL,
3653 `c8` int DEFAULT '80',
3654 `c9` int NOT NULL DEFAULT '90'
3655 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
3656 CHECK TABLE ta2b2_dynamic;
3657 Table Op Msg_type Msg_text
3658 test.ta2b2_dynamic check status OK
3659 UPDATE ta2b2_dynamic SET c2 = 1;
3660 # Metadata from INFORMATION_SCHEMA.TABLES
3661 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
3662 test/ta2b2_dynamic 13 6 0
3663 # Metadata from INFORMATION_SCHEMA.COLUMNS
3664 NAME POS MTYPE PRTYPE HAS_DEFAULT
3665 c0 0 6 1027 0
3666 c1 1 5 16711932 0
3667 c2 2 6 1027 0
3668 c3 3 6 1283 0
3669 c4 4 6 1027 0
3670 c5 5 6 1283 0
3671 c6 6 6 1027 1
3672 c7 7 6 1283 1
3673 c8 8 6 1027 1
3674 c9 9 6 1283 1
3675 SELECT * FROM ta2b2_dynamic;
3676 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
3677 1 row1 1 3 4 5 6 7 8 9
3678 2 row2 1 33 40 55 NULL 77 80 99
3679 SHOW CREATE TABLE ta2b2_dynamic;
3680 Table Create Table
3681 ta2b2_dynamic CREATE TABLE `ta2b2_dynamic` (
3682 `c0` int DEFAULT NULL,
3683 `c1` text,
3684 `c2` int DEFAULT NULL,
3685 `c3` int NOT NULL,
3686 `c4` int DEFAULT '40',
3687 `c5` int NOT NULL DEFAULT '50',
3688 `c6` int DEFAULT NULL,
3689 `c7` int NOT NULL,
3690 `c8` int DEFAULT '80',
3691 `c9` int NOT NULL DEFAULT '90'
3692 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
3693 CHECK TABLE ta2b2_dynamic;
3694 Table Op Msg_type Msg_text
3695 test.ta2b2_dynamic check status OK
3696 SET DEBUG_SYNC='now SIGNAL update_done';
3697 # Metadata from INFORMATION_SCHEMA.TABLES
3698 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
3699 test/ta2b2_dynamic 13 0 0
3700 # Metadata from INFORMATION_SCHEMA.COLUMNS
3701 NAME POS MTYPE PRTYPE HAS_DEFAULT
3702 c0 0 6 1283 0
3703 c1 1 5 16711932 0
3704 c2 2 6 1027 0
3705 c3 3 6 1283 0
3706 c4 4 6 1027 0
3707 c5 5 6 1283 0
3708 c6 6 6 1027 0
3709 c7 7 6 1283 0
3710 c8 8 6 1027 0
3711 c9 9 6 1283 0
3712 SELECT * FROM ta2b2_dynamic;
3713 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
3714 1 row1 1 3 4 5 6 7 8 9
3715 2 row2 1 33 40 55 NULL 77 80 99
3716 SHOW CREATE TABLE ta2b2_dynamic;
3717 Table Create Table
3718 ta2b2_dynamic CREATE TABLE `ta2b2_dynamic` (
3719 `c0` int NOT NULL,
3720 `c1` text,
3721 `c2` int DEFAULT NULL,
3722 `c3` int NOT NULL,
3723 `c4` int DEFAULT '40',
3724 `c5` int NOT NULL DEFAULT '50',
3725 `c6` int DEFAULT NULL,
3726 `c7` int NOT NULL,
3727 `c8` int DEFAULT '80',
3728 `c9` int NOT NULL DEFAULT '90',
3729 PRIMARY KEY (`c0`)
3730 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
3731 CHECK TABLE ta2b2_dynamic;
3732 Table Op Msg_type Msg_text
3733 test.ta2b2_dynamic check status OK
3734 DROP TABLE ta2b2_dynamic;
3735 # Run online ddl for ta2b4
3736 # Metadata from INFORMATION_SCHEMA.TABLES
3737 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
3738 test/ta2b4_dynamic 17 6 2
3739 # Metadata from INFORMATION_SCHEMA.COLUMNS
3740 NAME POS MTYPE PRTYPE HAS_DEFAULT
3741 c0 0 6 1027 0
3742 c1 1 5 16711932 0
3743 c2 2 6 1027 0
3744 c3 3 6 1283 0
3745 c4 4 6 1027 0
3746 c5 5 6 1283 0
3747 c6 6 6 1027 1
3748 c7 7 6 1283 1
3749 c8 8 6 1027 1
3750 c9 9 6 1283 1
3751 c10 10 6 1027 1
3752 c11 11 6 1283 1
3753 c12 12 6 1027 1
3754 c13 13 6 1283 1
3755 SELECT * FROM ta2b4_dynamic;;
3756 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
3757 1 row1 2 3 4 5 6 7 8 9 NULL 0 120 130
3758 2 row2 NULL 33 40 55 NULL 77 80 99 NULL 0 120 130
3759 SHOW CREATE TABLE ta2b4_dynamic;;
3760 Table Create Table
3761 ta2b4_dynamic CREATE TABLE `ta2b4_dynamic` (
3762 `c0` int DEFAULT NULL,
3763 `c1` text,
3764 `c2` int DEFAULT NULL,
3765 `c3` int NOT NULL,
3766 `c4` int DEFAULT '40',
3767 `c5` int NOT NULL DEFAULT '50',
3768 `c6` int DEFAULT NULL,
3769 `c7` int NOT NULL,
3770 `c8` int DEFAULT '80',
3771 `c9` int NOT NULL DEFAULT '90',
3772 `c10` int DEFAULT NULL,
3773 `c11` int NOT NULL,
3774 `c12` int DEFAULT '120',
3775 `c13` int NOT NULL DEFAULT '130'
3776 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
3777 CHECK TABLE ta2b4_dynamic;;
3778 Table Op Msg_type Msg_text
3779 test.ta2b4_dynamic check status OK
3780 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL update_now WAIT_FOR update_done';
3781 ALTER TABLE ta2b4_dynamic ADD PRIMARY KEY (c0);
3782 SET DEBUG_SYNC='now WAIT_FOR update_now';
3783 # Metadata from INFORMATION_SCHEMA.TABLES
3784 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
3785 test/ta2b4_dynamic 17 6 2
3786 # Metadata from INFORMATION_SCHEMA.COLUMNS
3787 NAME POS MTYPE PRTYPE HAS_DEFAULT
3788 c0 0 6 1027 0
3789 c1 1 5 16711932 0
3790 c2 2 6 1027 0
3791 c3 3 6 1283 0
3792 c4 4 6 1027 0
3793 c5 5 6 1283 0
3794 c6 6 6 1027 1
3795 c7 7 6 1283 1
3796 c8 8 6 1027 1
3797 c9 9 6 1283 1
3798 c10 10 6 1027 1
3799 c11 11 6 1283 1
3800 c12 12 6 1027 1
3801 c13 13 6 1283 1
3802 SELECT * FROM ta2b4_dynamic;
3803 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
3804 1 row1 2 3 4 5 6 7 8 9 NULL 0 120 130
3805 2 row2 NULL 33 40 55 NULL 77 80 99 NULL 0 120 130
3806 SHOW CREATE TABLE ta2b4_dynamic;
3807 Table Create Table
3808 ta2b4_dynamic CREATE TABLE `ta2b4_dynamic` (
3809 `c0` int DEFAULT NULL,
3810 `c1` text,
3811 `c2` int DEFAULT NULL,
3812 `c3` int NOT NULL,
3813 `c4` int DEFAULT '40',
3814 `c5` int NOT NULL DEFAULT '50',
3815 `c6` int DEFAULT NULL,
3816 `c7` int NOT NULL,
3817 `c8` int DEFAULT '80',
3818 `c9` int NOT NULL DEFAULT '90',
3819 `c10` int DEFAULT NULL,
3820 `c11` int NOT NULL,
3821 `c12` int DEFAULT '120',
3822 `c13` int NOT NULL DEFAULT '130'
3823 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
3824 CHECK TABLE ta2b4_dynamic;
3825 Table Op Msg_type Msg_text
3826 test.ta2b4_dynamic check status OK
3827 UPDATE ta2b4_dynamic SET c2 = 1;
3828 # Metadata from INFORMATION_SCHEMA.TABLES
3829 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
3830 test/ta2b4_dynamic 17 6 2
3831 # Metadata from INFORMATION_SCHEMA.COLUMNS
3832 NAME POS MTYPE PRTYPE HAS_DEFAULT
3833 c0 0 6 1027 0
3834 c1 1 5 16711932 0
3835 c2 2 6 1027 0
3836 c3 3 6 1283 0
3837 c4 4 6 1027 0
3838 c5 5 6 1283 0
3839 c6 6 6 1027 1
3840 c7 7 6 1283 1
3841 c8 8 6 1027 1
3842 c9 9 6 1283 1
3843 c10 10 6 1027 1
3844 c11 11 6 1283 1
3845 c12 12 6 1027 1
3846 c13 13 6 1283 1
3847 SELECT * FROM ta2b4_dynamic;
3848 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
3849 1 row1 1 3 4 5 6 7 8 9 NULL 0 120 130
3850 2 row2 1 33 40 55 NULL 77 80 99 NULL 0 120 130
3851 SHOW CREATE TABLE ta2b4_dynamic;
3852 Table Create Table
3853 ta2b4_dynamic CREATE TABLE `ta2b4_dynamic` (
3854 `c0` int DEFAULT NULL,
3855 `c1` text,
3856 `c2` int DEFAULT NULL,
3857 `c3` int NOT NULL,
3858 `c4` int DEFAULT '40',
3859 `c5` int NOT NULL DEFAULT '50',
3860 `c6` int DEFAULT NULL,
3861 `c7` int NOT NULL,
3862 `c8` int DEFAULT '80',
3863 `c9` int NOT NULL DEFAULT '90',
3864 `c10` int DEFAULT NULL,
3865 `c11` int NOT NULL,
3866 `c12` int DEFAULT '120',
3867 `c13` int NOT NULL DEFAULT '130'
3868 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
3869 CHECK TABLE ta2b4_dynamic;
3870 Table Op Msg_type Msg_text
3871 test.ta2b4_dynamic check status OK
3872 SET DEBUG_SYNC='now SIGNAL update_done';
3873 # Metadata from INFORMATION_SCHEMA.TABLES
3874 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
3875 test/ta2b4_dynamic 17 0 0
3876 # Metadata from INFORMATION_SCHEMA.COLUMNS
3877 NAME POS MTYPE PRTYPE HAS_DEFAULT
3878 c0 0 6 1283 0
3879 c1 1 5 16711932 0
3880 c2 2 6 1027 0
3881 c3 3 6 1283 0
3882 c4 4 6 1027 0
3883 c5 5 6 1283 0
3884 c6 6 6 1027 0
3885 c7 7 6 1283 0
3886 c8 8 6 1027 0
3887 c9 9 6 1283 0
3888 c10 10 6 1027 0
3889 c11 11 6 1283 0
3890 c12 12 6 1027 0
3891 c13 13 6 1283 0
3892 SELECT * FROM ta2b4_dynamic;
3893 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
3894 1 row1 1 3 4 5 6 7 8 9 NULL 0 120 130
3895 2 row2 1 33 40 55 NULL 77 80 99 NULL 0 120 130
3896 SHOW CREATE TABLE ta2b4_dynamic;
3897 Table Create Table
3898 ta2b4_dynamic CREATE TABLE `ta2b4_dynamic` (
3899 `c0` int NOT NULL,
3900 `c1` text,
3901 `c2` int DEFAULT NULL,
3902 `c3` int NOT NULL,
3903 `c4` int DEFAULT '40',
3904 `c5` int NOT NULL DEFAULT '50',
3905 `c6` int DEFAULT NULL,
3906 `c7` int NOT NULL,
3907 `c8` int DEFAULT '80',
3908 `c9` int NOT NULL DEFAULT '90',
3909 `c10` int DEFAULT NULL,
3910 `c11` int NOT NULL,
3911 `c12` int DEFAULT '120',
3912 `c13` int NOT NULL DEFAULT '130',
3913 PRIMARY KEY (`c0`)
3914 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
3915 CHECK TABLE ta2b4_dynamic;
3916 Table Op Msg_type Msg_text
3917 test.ta2b4_dynamic check status OK
3918 DROP TABLE ta2b4_dynamic;
3919 # Run online ddl for ta3b2
3920 # Metadata from INFORMATION_SCHEMA.TABLES
3921 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
3922 test/ta3b2_dynamic 13 6 0
3923 # Metadata from INFORMATION_SCHEMA.COLUMNS
3924 NAME POS MTYPE PRTYPE HAS_DEFAULT
3925 c0 0 6 1027 0
3926 c1 1 5 16711932 0
3927 c2 2 6 1027 0
3928 c3 3 6 1283 0
3929 c4 4 6 1027 0
3930 c5 5 6 1283 0
3931 c6 6 6 1027 1
3932 c7 7 6 1283 1
3933 c8 8 6 1027 1
3934 c9 9 6 1283 1
3935 SELECT * FROM ta3b2_dynamic;;
3936 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
3937 SHOW CREATE TABLE ta3b2_dynamic;;
3938 Table Create Table
3939 ta3b2_dynamic CREATE TABLE `ta3b2_dynamic` (
3940 `c0` int DEFAULT NULL,
3941 `c1` text,
3942 `c2` int DEFAULT NULL,
3943 `c3` int NOT NULL,
3944 `c4` int DEFAULT '40',
3945 `c5` int NOT NULL DEFAULT '50',
3946 `c6` int DEFAULT NULL,
3947 `c7` int NOT NULL,
3948 `c8` int DEFAULT '80',
3949 `c9` int NOT NULL DEFAULT '90'
3950 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
3951 CHECK TABLE ta3b2_dynamic;;
3952 Table Op Msg_type Msg_text
3953 test.ta3b2_dynamic check status OK
3954 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL update_now WAIT_FOR update_done';
3955 ALTER TABLE ta3b2_dynamic ADD PRIMARY KEY (c0);
3956 SET DEBUG_SYNC='now WAIT_FOR update_now';
3957 # Metadata from INFORMATION_SCHEMA.TABLES
3958 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
3959 test/ta3b2_dynamic 13 6 0
3960 # Metadata from INFORMATION_SCHEMA.COLUMNS
3961 NAME POS MTYPE PRTYPE HAS_DEFAULT
3962 c0 0 6 1027 0
3963 c1 1 5 16711932 0
3964 c2 2 6 1027 0
3965 c3 3 6 1283 0
3966 c4 4 6 1027 0
3967 c5 5 6 1283 0
3968 c6 6 6 1027 1
3969 c7 7 6 1283 1
3970 c8 8 6 1027 1
3971 c9 9 6 1283 1
3972 SELECT * FROM ta3b2_dynamic;
3973 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
3974 SHOW CREATE TABLE ta3b2_dynamic;
3975 Table Create Table
3976 ta3b2_dynamic CREATE TABLE `ta3b2_dynamic` (
3977 `c0` int DEFAULT NULL,
3978 `c1` text,
3979 `c2` int DEFAULT NULL,
3980 `c3` int NOT NULL,
3981 `c4` int DEFAULT '40',
3982 `c5` int NOT NULL DEFAULT '50',
3983 `c6` int DEFAULT NULL,
3984 `c7` int NOT NULL,
3985 `c8` int DEFAULT '80',
3986 `c9` int NOT NULL DEFAULT '90'
3987 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
3988 CHECK TABLE ta3b2_dynamic;
3989 Table Op Msg_type Msg_text
3990 test.ta3b2_dynamic check status OK
3991 UPDATE ta3b2_dynamic SET c2 = 1;
3992 # Metadata from INFORMATION_SCHEMA.TABLES
3993 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
3994 test/ta3b2_dynamic 13 6 0
3995 # Metadata from INFORMATION_SCHEMA.COLUMNS
3996 NAME POS MTYPE PRTYPE HAS_DEFAULT
3997 c0 0 6 1027 0
3998 c1 1 5 16711932 0
3999 c2 2 6 1027 0
4000 c3 3 6 1283 0
4001 c4 4 6 1027 0
4002 c5 5 6 1283 0
4003 c6 6 6 1027 1
4004 c7 7 6 1283 1
4005 c8 8 6 1027 1
4006 c9 9 6 1283 1
4007 SELECT * FROM ta3b2_dynamic;
4008 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
4009 SHOW CREATE TABLE ta3b2_dynamic;
4010 Table Create Table
4011 ta3b2_dynamic CREATE TABLE `ta3b2_dynamic` (
4012 `c0` int DEFAULT NULL,
4013 `c1` text,
4014 `c2` int DEFAULT NULL,
4015 `c3` int NOT NULL,
4016 `c4` int DEFAULT '40',
4017 `c5` int NOT NULL DEFAULT '50',
4018 `c6` int DEFAULT NULL,
4019 `c7` int NOT NULL,
4020 `c8` int DEFAULT '80',
4021 `c9` int NOT NULL DEFAULT '90'
4022 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
4023 CHECK TABLE ta3b2_dynamic;
4024 Table Op Msg_type Msg_text
4025 test.ta3b2_dynamic check status OK
4026 SET DEBUG_SYNC='now SIGNAL update_done';
4027 # Metadata from INFORMATION_SCHEMA.TABLES
4028 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
4029 test/ta3b2_dynamic 13 0 0
4030 # Metadata from INFORMATION_SCHEMA.COLUMNS
4031 NAME POS MTYPE PRTYPE HAS_DEFAULT
4032 c0 0 6 1283 0
4033 c1 1 5 16711932 0
4034 c2 2 6 1027 0
4035 c3 3 6 1283 0
4036 c4 4 6 1027 0
4037 c5 5 6 1283 0
4038 c6 6 6 1027 0
4039 c7 7 6 1283 0
4040 c8 8 6 1027 0
4041 c9 9 6 1283 0
4042 SELECT * FROM ta3b2_dynamic;
4043 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
4044 SHOW CREATE TABLE ta3b2_dynamic;
4045 Table Create Table
4046 ta3b2_dynamic CREATE TABLE `ta3b2_dynamic` (
4047 `c0` int NOT NULL,
4048 `c1` text,
4049 `c2` int DEFAULT NULL,
4050 `c3` int NOT NULL,
4051 `c4` int DEFAULT '40',
4052 `c5` int NOT NULL DEFAULT '50',
4053 `c6` int DEFAULT NULL,
4054 `c7` int NOT NULL,
4055 `c8` int DEFAULT '80',
4056 `c9` int NOT NULL DEFAULT '90',
4057 PRIMARY KEY (`c0`)
4058 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
4059 CHECK TABLE ta3b2_dynamic;
4060 Table Op Msg_type Msg_text
4061 test.ta3b2_dynamic check status OK
4062 DROP TABLE ta3b2_dynamic;
4063 # Run online ddl for ta3b3
4064 # Metadata from INFORMATION_SCHEMA.TABLES
4065 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
4066 test/ta3b3_dynamic 13 0 2
4067 # Metadata from INFORMATION_SCHEMA.COLUMNS
4068 NAME POS MTYPE PRTYPE HAS_DEFAULT
4069 c0 0 6 1027 0
4070 c1 1 5 16711932 0
4071 c2 2 6 1027 0
4072 c3 3 6 1283 0
4073 c4 4 6 1027 0
4074 c5 5 6 1283 0
4075 c10 6 6 1027 1
4076 c11 7 6 1283 1
4077 c12 8 6 1027 1
4078 c13 9 6 1283 1
4079 SELECT * FROM ta3b3_dynamic;;
4080 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
4081 1 row1 2 3 4 5 10 11 12 13
4082 2 row2 NULL 33 40 55 NULL 1111 120 1313
4083 SHOW CREATE TABLE ta3b3_dynamic;;
4084 Table Create Table
4085 ta3b3_dynamic CREATE TABLE `ta3b3_dynamic` (
4086 `c0` int DEFAULT NULL,
4087 `c1` text,
4088 `c2` int DEFAULT NULL,
4089 `c3` int NOT NULL,
4090 `c4` int DEFAULT '40',
4091 `c5` int NOT NULL DEFAULT '50',
4092 `c10` int DEFAULT NULL,
4093 `c11` int NOT NULL,
4094 `c12` int DEFAULT '120',
4095 `c13` int NOT NULL DEFAULT '130'
4096 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
4097 CHECK TABLE ta3b3_dynamic;;
4098 Table Op Msg_type Msg_text
4099 test.ta3b3_dynamic check status OK
4100 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL update_now WAIT_FOR update_done';
4101 ALTER TABLE ta3b3_dynamic ADD PRIMARY KEY (c0);
4102 SET DEBUG_SYNC='now WAIT_FOR update_now';
4103 # Metadata from INFORMATION_SCHEMA.TABLES
4104 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
4105 test/ta3b3_dynamic 13 0 2
4106 # Metadata from INFORMATION_SCHEMA.COLUMNS
4107 NAME POS MTYPE PRTYPE HAS_DEFAULT
4108 c0 0 6 1027 0
4109 c1 1 5 16711932 0
4110 c2 2 6 1027 0
4111 c3 3 6 1283 0
4112 c4 4 6 1027 0
4113 c5 5 6 1283 0
4114 c10 6 6 1027 1
4115 c11 7 6 1283 1
4116 c12 8 6 1027 1
4117 c13 9 6 1283 1
4118 SELECT * FROM ta3b3_dynamic;
4119 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
4120 1 row1 2 3 4 5 10 11 12 13
4121 2 row2 NULL 33 40 55 NULL 1111 120 1313
4122 SHOW CREATE TABLE ta3b3_dynamic;
4123 Table Create Table
4124 ta3b3_dynamic CREATE TABLE `ta3b3_dynamic` (
4125 `c0` int DEFAULT NULL,
4126 `c1` text,
4127 `c2` int DEFAULT NULL,
4128 `c3` int NOT NULL,
4129 `c4` int DEFAULT '40',
4130 `c5` int NOT NULL DEFAULT '50',
4131 `c10` int DEFAULT NULL,
4132 `c11` int NOT NULL,
4133 `c12` int DEFAULT '120',
4134 `c13` int NOT NULL DEFAULT '130'
4135 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
4136 CHECK TABLE ta3b3_dynamic;
4137 Table Op Msg_type Msg_text
4138 test.ta3b3_dynamic check status OK
4139 UPDATE ta3b3_dynamic SET c2 = 1;
4140 # Metadata from INFORMATION_SCHEMA.TABLES
4141 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
4142 test/ta3b3_dynamic 13 0 2
4143 # Metadata from INFORMATION_SCHEMA.COLUMNS
4144 NAME POS MTYPE PRTYPE HAS_DEFAULT
4145 c0 0 6 1027 0
4146 c1 1 5 16711932 0
4147 c2 2 6 1027 0
4148 c3 3 6 1283 0
4149 c4 4 6 1027 0
4150 c5 5 6 1283 0
4151 c10 6 6 1027 1
4152 c11 7 6 1283 1
4153 c12 8 6 1027 1
4154 c13 9 6 1283 1
4155 SELECT * FROM ta3b3_dynamic;
4156 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
4157 1 row1 1 3 4 5 10 11 12 13
4158 2 row2 1 33 40 55 NULL 1111 120 1313
4159 SHOW CREATE TABLE ta3b3_dynamic;
4160 Table Create Table
4161 ta3b3_dynamic CREATE TABLE `ta3b3_dynamic` (
4162 `c0` int DEFAULT NULL,
4163 `c1` text,
4164 `c2` int DEFAULT NULL,
4165 `c3` int NOT NULL,
4166 `c4` int DEFAULT '40',
4167 `c5` int NOT NULL DEFAULT '50',
4168 `c10` int DEFAULT NULL,
4169 `c11` int NOT NULL,
4170 `c12` int DEFAULT '120',
4171 `c13` int NOT NULL DEFAULT '130'
4172 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
4173 CHECK TABLE ta3b3_dynamic;
4174 Table Op Msg_type Msg_text
4175 test.ta3b3_dynamic check status OK
4176 SET DEBUG_SYNC='now SIGNAL update_done';
4177 # Metadata from INFORMATION_SCHEMA.TABLES
4178 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
4179 test/ta3b3_dynamic 13 0 0
4180 # Metadata from INFORMATION_SCHEMA.COLUMNS
4181 NAME POS MTYPE PRTYPE HAS_DEFAULT
4182 c0 0 6 1283 0
4183 c1 1 5 16711932 0
4184 c2 2 6 1027 0
4185 c3 3 6 1283 0
4186 c4 4 6 1027 0
4187 c5 5 6 1283 0
4188 c10 6 6 1027 0
4189 c11 7 6 1283 0
4190 c12 8 6 1027 0
4191 c13 9 6 1283 0
4192 SELECT * FROM ta3b3_dynamic;
4193 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
4194 1 row1 1 3 4 5 10 11 12 13
4195 2 row2 1 33 40 55 NULL 1111 120 1313
4196 SHOW CREATE TABLE ta3b3_dynamic;
4197 Table Create Table
4198 ta3b3_dynamic CREATE TABLE `ta3b3_dynamic` (
4199 `c0` int NOT NULL,
4200 `c1` text,
4201 `c2` int DEFAULT NULL,
4202 `c3` int NOT NULL,
4203 `c4` int DEFAULT '40',
4204 `c5` int NOT NULL DEFAULT '50',
4205 `c10` int DEFAULT NULL,
4206 `c11` int NOT NULL,
4207 `c12` int DEFAULT '120',
4208 `c13` int NOT NULL DEFAULT '130',
4209 PRIMARY KEY (`c0`)
4210 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
4211 CHECK TABLE ta3b3_dynamic;
4212 Table Op Msg_type Msg_text
4213 test.ta3b3_dynamic check status OK
4214 DROP TABLE ta3b3_dynamic;
4215 # Run online ddl for ta3b4
4216 # Metadata from INFORMATION_SCHEMA.TABLES
4217 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
4218 test/ta3b4_dynamic 17 6 2
4219 # Metadata from INFORMATION_SCHEMA.COLUMNS
4220 NAME POS MTYPE PRTYPE HAS_DEFAULT
4221 c0 0 6 1027 0
4222 c1 1 5 16711932 0
4223 c2 2 6 1027 0
4224 c3 3 6 1283 0
4225 c4 4 6 1027 0
4226 c5 5 6 1283 0
4227 c6 6 6 1027 1
4228 c7 7 6 1283 1
4229 c8 8 6 1027 1
4230 c9 9 6 1283 1
4231 c10 10 6 1027 1
4232 c11 11 6 1283 1
4233 c12 12 6 1027 1
4234 c13 13 6 1283 1
4235 SELECT * FROM ta3b4_dynamic;;
4236 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
4237 1 row1 2 3 4 5 6 7 8 9 10 11 12 13
4238 2 row2 NULL 33 40 55 NULL 77 80 99 NULL 1111 120 1313
4239 SHOW CREATE TABLE ta3b4_dynamic;;
4240 Table Create Table
4241 ta3b4_dynamic CREATE TABLE `ta3b4_dynamic` (
4242 `c0` int DEFAULT NULL,
4243 `c1` text,
4244 `c2` int DEFAULT NULL,
4245 `c3` int NOT NULL,
4246 `c4` int DEFAULT '40',
4247 `c5` int NOT NULL DEFAULT '50',
4248 `c6` int DEFAULT NULL,
4249 `c7` int NOT NULL,
4250 `c8` int DEFAULT '80',
4251 `c9` int NOT NULL DEFAULT '90',
4252 `c10` int DEFAULT NULL,
4253 `c11` int NOT NULL,
4254 `c12` int DEFAULT '120',
4255 `c13` int NOT NULL DEFAULT '130'
4256 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
4257 CHECK TABLE ta3b4_dynamic;;
4258 Table Op Msg_type Msg_text
4259 test.ta3b4_dynamic check status OK
4260 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL update_now WAIT_FOR update_done';
4261 ALTER TABLE ta3b4_dynamic ADD PRIMARY KEY (c0);
4262 SET DEBUG_SYNC='now WAIT_FOR update_now';
4263 # Metadata from INFORMATION_SCHEMA.TABLES
4264 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
4265 test/ta3b4_dynamic 17 6 2
4266 # Metadata from INFORMATION_SCHEMA.COLUMNS
4267 NAME POS MTYPE PRTYPE HAS_DEFAULT
4268 c0 0 6 1027 0
4269 c1 1 5 16711932 0
4270 c2 2 6 1027 0
4271 c3 3 6 1283 0
4272 c4 4 6 1027 0
4273 c5 5 6 1283 0
4274 c6 6 6 1027 1
4275 c7 7 6 1283 1
4276 c8 8 6 1027 1
4277 c9 9 6 1283 1
4278 c10 10 6 1027 1
4279 c11 11 6 1283 1
4280 c12 12 6 1027 1
4281 c13 13 6 1283 1
4282 SELECT * FROM ta3b4_dynamic;
4283 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
4284 1 row1 2 3 4 5 6 7 8 9 10 11 12 13
4285 2 row2 NULL 33 40 55 NULL 77 80 99 NULL 1111 120 1313
4286 SHOW CREATE TABLE ta3b4_dynamic;
4287 Table Create Table
4288 ta3b4_dynamic CREATE TABLE `ta3b4_dynamic` (
4289 `c0` int DEFAULT NULL,
4290 `c1` text,
4291 `c2` int DEFAULT NULL,
4292 `c3` int NOT NULL,
4293 `c4` int DEFAULT '40',
4294 `c5` int NOT NULL DEFAULT '50',
4295 `c6` int DEFAULT NULL,
4296 `c7` int NOT NULL,
4297 `c8` int DEFAULT '80',
4298 `c9` int NOT NULL DEFAULT '90',
4299 `c10` int DEFAULT NULL,
4300 `c11` int NOT NULL,
4301 `c12` int DEFAULT '120',
4302 `c13` int NOT NULL DEFAULT '130'
4303 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
4304 CHECK TABLE ta3b4_dynamic;
4305 Table Op Msg_type Msg_text
4306 test.ta3b4_dynamic check status OK
4307 UPDATE ta3b4_dynamic SET c2 = 1;
4308 # Metadata from INFORMATION_SCHEMA.TABLES
4309 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
4310 test/ta3b4_dynamic 17 6 2
4311 # Metadata from INFORMATION_SCHEMA.COLUMNS
4312 NAME POS MTYPE PRTYPE HAS_DEFAULT
4313 c0 0 6 1027 0
4314 c1 1 5 16711932 0
4315 c2 2 6 1027 0
4316 c3 3 6 1283 0
4317 c4 4 6 1027 0
4318 c5 5 6 1283 0
4319 c6 6 6 1027 1
4320 c7 7 6 1283 1
4321 c8 8 6 1027 1
4322 c9 9 6 1283 1
4323 c10 10 6 1027 1
4324 c11 11 6 1283 1
4325 c12 12 6 1027 1
4326 c13 13 6 1283 1
4327 SELECT * FROM ta3b4_dynamic;
4328 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
4329 1 row1 1 3 4 5 6 7 8 9 10 11 12 13
4330 2 row2 1 33 40 55 NULL 77 80 99 NULL 1111 120 1313
4331 SHOW CREATE TABLE ta3b4_dynamic;
4332 Table Create Table
4333 ta3b4_dynamic CREATE TABLE `ta3b4_dynamic` (
4334 `c0` int DEFAULT NULL,
4335 `c1` text,
4336 `c2` int DEFAULT NULL,
4337 `c3` int NOT NULL,
4338 `c4` int DEFAULT '40',
4339 `c5` int NOT NULL DEFAULT '50',
4340 `c6` int DEFAULT NULL,
4341 `c7` int NOT NULL,
4342 `c8` int DEFAULT '80',
4343 `c9` int NOT NULL DEFAULT '90',
4344 `c10` int DEFAULT NULL,
4345 `c11` int NOT NULL,
4346 `c12` int DEFAULT '120',
4347 `c13` int NOT NULL DEFAULT '130'
4348 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
4349 CHECK TABLE ta3b4_dynamic;
4350 Table Op Msg_type Msg_text
4351 test.ta3b4_dynamic check status OK
4352 SET DEBUG_SYNC='now SIGNAL update_done';
4353 # Metadata from INFORMATION_SCHEMA.TABLES
4354 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
4355 test/ta3b4_dynamic 17 0 0
4356 # Metadata from INFORMATION_SCHEMA.COLUMNS
4357 NAME POS MTYPE PRTYPE HAS_DEFAULT
4358 c0 0 6 1283 0
4359 c1 1 5 16711932 0
4360 c2 2 6 1027 0
4361 c3 3 6 1283 0
4362 c4 4 6 1027 0
4363 c5 5 6 1283 0
4364 c6 6 6 1027 0
4365 c7 7 6 1283 0
4366 c8 8 6 1027 0
4367 c9 9 6 1283 0
4368 c10 10 6 1027 0
4369 c11 11 6 1283 0
4370 c12 12 6 1027 0
4371 c13 13 6 1283 0
4372 SELECT * FROM ta3b4_dynamic;
4373 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
4374 1 row1 1 3 4 5 6 7 8 9 10 11 12 13
4375 2 row2 1 33 40 55 NULL 77 80 99 NULL 1111 120 1313
4376 SHOW CREATE TABLE ta3b4_dynamic;
4377 Table Create Table
4378 ta3b4_dynamic CREATE TABLE `ta3b4_dynamic` (
4379 `c0` int NOT NULL,
4380 `c1` text,
4381 `c2` int DEFAULT NULL,
4382 `c3` int NOT NULL,
4383 `c4` int DEFAULT '40',
4384 `c5` int NOT NULL DEFAULT '50',
4385 `c6` int DEFAULT NULL,
4386 `c7` int NOT NULL,
4387 `c8` int DEFAULT '80',
4388 `c9` int NOT NULL DEFAULT '90',
4389 `c10` int DEFAULT NULL,
4390 `c11` int NOT NULL,
4391 `c12` int DEFAULT '120',
4392 `c13` int NOT NULL DEFAULT '130',
4393 PRIMARY KEY (`c0`)
4394 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
4395 CHECK TABLE ta3b4_dynamic;
4396 Table Op Msg_type Msg_text
4397 test.ta3b4_dynamic check status OK
4398 DROP TABLE ta3b4_dynamic;
4399 # Cleanup
4400 # Shutdown server
4401 # Remove temp files used
4402 # Restart server to restore server state
4403 # restart