Debian Codegraph @

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

raw
1 # Additional test cases to verify that ALTER ADD PRIMARY KEY works fine
2 #
3 # What this test is doing:
4 #
5 # Upgrade server to latest
6 # Keep a zipped copy of upgraded datadir
7 #
8 # For all possible primary key columns
9 # --let = [c3, c7, c11, c5, c9, c13] {
10 #
11 # Shutdown server, unzip upgraded datadir
12 # Now we can process
13 #
14 # For all row formats
15 # --let = [redundant, compact, dynamic] {
16 # --source suite/innodb/include/bug33788578_ddl_prepare.inc
17 #
18 # For all tables
19 # --let = [ta1b1, ta1b2, ta1b4, ta2b1, ta2b2, ta2b4, ta4b1 ta4b2, ta4b4] _ {
20 # Add the primary key
21 # --source suite/innodb/include/bug33788578_ddl.inc
22 # }
23 # }
24 #
25 # }
26 # Check comments near end of file to see what a1b1, a2b4, etc., means
27 # This column will be made as the primary key. TODO: include cases for each possible pk_col - test may take too long
28 # Upgrade previous tables to current
29 # Restart the server
30 # restart: --datadir=DATADIR
31 SHOW TABLES;
32 Tables_in_test
33 ta1b1_compact
34 ta1b1_dynamic
35 ta1b1_redundant
36 ta1b2_compact
37 ta1b2_dynamic
38 ta1b2_redundant
39 ta1b4_compact
40 ta1b4_dynamic
41 ta1b4_redundant
42 ta2b1_compact
43 ta2b1_dynamic
44 ta2b1_redundant
45 ta2b2_compact
46 ta2b2_dynamic
47 ta2b2_redundant
48 ta2b4_compact
49 ta2b4_dynamic
50 ta2b4_redundant
51 ta4b1_compact
52 ta4b1_dynamic
53 ta4b1_redundant
54 ta4b2_compact
55 ta4b2_dynamic
56 ta4b2_redundant
57 ta4b4_compact
58 ta4b4_dynamic
59 ta4b4_redundant
60 # For all REDUNDANT tables:
61 # Prepare the table
62 # Insert some rows just after upgrade
63 # a1 => no alter in 8.0.28
64 # ta1b1_*, ta1b2_*, ta1b4_* -- insert rows
65 INSERT INTO ta1b1_redundant VALUES (11, "row11", 12, 13, 14, 15);;
66 INSERT INTO ta1b1_redundant (c0, c1, c3, c5) VALUES (12, "row12", 133, 155);;
67 INSERT INTO ta1b2_redundant VALUES (11, "row11", 12, 13, 14, 15);;
68 INSERT INTO ta1b2_redundant (c0, c1, c3, c5) VALUES (12, "row12", 133, 155);;
69 INSERT INTO ta1b4_redundant VALUES (11, "row11", 12, 13, 14, 15);;
70 INSERT INTO ta1b4_redundant (c0, c1, c3, c5) VALUES (12, "row12", 133, 155);;
71 # a2 => alter in 8.0.28 but no insert
72 # ta2b1_*, ta2b2_*, ta2b4_* -- insert rows:
73 INSERT INTO ta2b1_redundant VALUES (13, "row13", 1222, 1333, 1444, 1555, 1666, 1777, 1888, 1999);;
74 INSERT INTO ta2b1_redundant (c0, c1, c3, c5, c7, c9) VALUES (14, "row14", 13333, 15555, 17777, 19999);;
75 INSERT INTO ta2b2_redundant VALUES (13, "row13", 1222, 1333, 1444, 1555, 1666, 1777, 1888, 1999);;
76 INSERT INTO ta2b2_redundant (c0, c1, c3, c5, c7, c9) VALUES (14, "row14", 13333, 15555, 17777, 19999);;
77 INSERT INTO ta2b4_redundant VALUES (13, "row13", 1222, 1333, 1444, 1555, 1666, 1777, 1888, 1999);;
78 INSERT INTO ta2b4_redundant (c0, c1, c3, c5, c7, c9) VALUES (14, "row14", 13333, 15555, 17777, 19999);;
79 # a4 => alter + insert in 8.0.28
80 # ta4b1_*, ta4b2_*, ta4b4_* -- insert rows
81 INSERT INTO ta4b1_redundant VALUES (13, "row13", 1222, 1333, 1444, 1555, 1666, 1777, 1888, 1999);;
82 INSERT INTO ta4b1_redundant (c0, c1, c3, c5, c7, c9) VALUES (14, "row14", 13333, 15555, 17777, 19999);;
83 INSERT INTO ta4b2_redundant VALUES (13, "row13", 1222, 1333, 1444, 1555, 1666, 1777, 1888, 1999);;
84 INSERT INTO ta4b2_redundant (c0, c1, c3, c5, c7, c9) VALUES (14, "row14", 13333, 15555, 17777, 19999);;
85 INSERT INTO ta4b4_redundant VALUES (13, "row13", 1222, 1333, 1444, 1555, 1666, 1777, 1888, 1999);;
86 INSERT INTO ta4b4_redundant (c0, c1, c3, c5, c7, c9) VALUES (14, "row14", 13333, 15555, 17777, 19999);;
87 # b1 => no alter in trunk
88 # ta1b1_*, ta2b1_*, ta4b1_* -- no operation
89 # b2 => alter in trunk but no insert
90 # ta1b2_*, ta2b2_*, ta4b1_* -- ALTER TABLE no insert:
91 ALTER TABLE ta1b2_redundant ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
92 ALTER TABLE ta1b2_redundant ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
93 ALTER TABLE ta2b2_redundant ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
94 ALTER TABLE ta2b2_redundant ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
95 ALTER TABLE ta4b2_redundant ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
96 ALTER TABLE ta4b2_redundant ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
97 # b4 => alter + insert in trunk
98 # ta1b4_*, ta2b4_*, ta4b4_* -- ALTER TABLE + INSERT INTO
99 ALTER TABLE ta1b4_redundant ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
100 ALTER TABLE ta1b4_redundant ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
101 INSERT INTO ta1b4_redundant VALUES (5, "row5", 2002, 3003, 4004, 5005, 1010, 1111, 1212, 1313);;
102 INSERT INTO ta1b4_redundant (c0, c1, c3, c5, c11, c13) VALUES (6, "row6", 30030, 50050, 11110, 13130);;
103 ALTER TABLE ta2b4_redundant ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
104 ALTER TABLE ta2b4_redundant ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
105 INSERT INTO ta2b4_redundant VALUES (5, "row5", 2002, 3003, 4004, 5005, 6006, 7007, 8008, 9009, 1010, 1111, 1212, 1313);;
106 INSERT INTO ta2b4_redundant (c0, c1, c3, c5, c7, c9, c11, c13) VALUES (6, "row6", 30030, 50050, 70070, 90090, 11110, 13130);;
107 ALTER TABLE ta4b4_redundant ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
108 ALTER TABLE ta4b4_redundant ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
109 INSERT INTO ta4b4_redundant VALUES (5, "row5", 2002, 3003, 4004, 5005, 6006, 7007, 8008, 9009, 1010, 1111, 1212, 1313);;
110 INSERT INTO ta4b4_redundant (c0, c1, c3, c5, c7, c9, c11, c13) VALUES (6, "row6", 30030, 50050, 70070, 90090, 11110, 13130);;
111 # For each table, run the test
112 # Run for ta1b1
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 SHOW CREATE TABLE ta1b1_redundant;;
125 Table Create Table
126 ta1b1_redundant CREATE TABLE `ta1b1_redundant` (
127 `c0` int DEFAULT NULL,
128 `c1` text,
129 `c2` int DEFAULT NULL,
130 `c3` int NOT NULL,
131 `c4` int DEFAULT '40',
132 `c5` int NOT NULL DEFAULT '50'
133 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
134 SELECT * FROM ta1b1_redundant;;
135 c0 c1 c2 c3 c4 c5
136 1 row1 2 3 4 5
137 2 row2 NULL 33 40 55
138 11 row11 12 13 14 15
139 12 row12 NULL 133 40 155
140 CHECK TABLE ta1b1_redundant;;
141 Table Op Msg_type Msg_text
142 test.ta1b1_redundant check status OK
143 ALTER TABLE ta1b1_redundant ADD PRIMARY KEY (c3);;
144 # Metadata from INFORMATION_SCHEMA.TABLES
145 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
146 test/ta1b1_redundant 9 0 0
147 # Metadata from INFORMATION_SCHEMA.COLUMNS
148 NAME POS MTYPE PRTYPE HAS_DEFAULT
149 c0 0 6 1027 0
150 c1 1 5 16711932 0
151 c2 2 6 1027 0
152 c3 3 6 1283 0
153 c4 4 6 1027 0
154 c5 5 6 1283 0
155 SHOW CREATE TABLE ta1b1_redundant;;
156 Table Create Table
157 ta1b1_redundant CREATE TABLE `ta1b1_redundant` (
158 `c0` int DEFAULT NULL,
159 `c1` text,
160 `c2` int DEFAULT NULL,
161 `c3` int NOT NULL,
162 `c4` int DEFAULT '40',
163 `c5` int NOT NULL DEFAULT '50',
164 PRIMARY KEY (`c3`)
165 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
166 SELECT * FROM ta1b1_redundant;;
167 c0 c1 c2 c3 c4 c5
168 1 row1 2 3 4 5
169 11 row11 12 13 14 15
170 2 row2 NULL 33 40 55
171 12 row12 NULL 133 40 155
172 CHECK TABLE ta1b1_redundant;;
173 Table Op Msg_type Msg_text
174 test.ta1b1_redundant check status OK
175 # Run for ta1b2
176 # Metadata from INFORMATION_SCHEMA.TABLES
177 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
178 test/ta1b2_redundant 13 0 2
179 # Metadata from INFORMATION_SCHEMA.COLUMNS
180 NAME POS MTYPE PRTYPE HAS_DEFAULT
181 c0 0 6 1027 0
182 c1 1 5 16711932 0
183 c2 2 6 1027 0
184 c3 3 6 1283 0
185 c4 4 6 1027 0
186 c5 5 6 1283 0
187 c10 6 6 1027 1
188 c11 7 6 1283 1
189 c12 8 6 1027 1
190 c13 9 6 1283 1
191 SHOW CREATE TABLE ta1b2_redundant;;
192 Table Create Table
193 ta1b2_redundant CREATE TABLE `ta1b2_redundant` (
194 `c0` int DEFAULT NULL,
195 `c1` text,
196 `c2` int DEFAULT NULL,
197 `c3` int NOT NULL,
198 `c4` int DEFAULT '40',
199 `c5` int NOT NULL DEFAULT '50',
200 `c10` int DEFAULT NULL,
201 `c11` int NOT NULL,
202 `c12` int DEFAULT '120',
203 `c13` int NOT NULL DEFAULT '130'
204 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
205 SELECT * FROM ta1b2_redundant;;
206 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
207 1 row1 2 3 4 5 NULL 0 120 130
208 2 row2 NULL 33 40 55 NULL 0 120 130
209 11 row11 12 13 14 15 NULL 0 120 130
210 12 row12 NULL 133 40 155 NULL 0 120 130
211 CHECK TABLE ta1b2_redundant;;
212 Table Op Msg_type Msg_text
213 test.ta1b2_redundant check status OK
214 ALTER TABLE ta1b2_redundant ADD PRIMARY KEY (c3);;
215 # Metadata from INFORMATION_SCHEMA.TABLES
216 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
217 test/ta1b2_redundant 13 0 0
218 # Metadata from INFORMATION_SCHEMA.COLUMNS
219 NAME POS MTYPE PRTYPE HAS_DEFAULT
220 c0 0 6 1027 0
221 c1 1 5 16711932 0
222 c2 2 6 1027 0
223 c3 3 6 1283 0
224 c4 4 6 1027 0
225 c5 5 6 1283 0
226 c10 6 6 1027 0
227 c11 7 6 1283 0
228 c12 8 6 1027 0
229 c13 9 6 1283 0
230 SHOW CREATE TABLE ta1b2_redundant;;
231 Table Create Table
232 ta1b2_redundant CREATE TABLE `ta1b2_redundant` (
233 `c0` int DEFAULT NULL,
234 `c1` text,
235 `c2` int DEFAULT NULL,
236 `c3` int NOT NULL,
237 `c4` int DEFAULT '40',
238 `c5` int NOT NULL DEFAULT '50',
239 `c10` int DEFAULT NULL,
240 `c11` int NOT NULL,
241 `c12` int DEFAULT '120',
242 `c13` int NOT NULL DEFAULT '130',
243 PRIMARY KEY (`c3`)
244 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
245 SELECT * FROM ta1b2_redundant;;
246 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
247 1 row1 2 3 4 5 NULL 0 120 130
248 11 row11 12 13 14 15 NULL 0 120 130
249 2 row2 NULL 33 40 55 NULL 0 120 130
250 12 row12 NULL 133 40 155 NULL 0 120 130
251 CHECK TABLE ta1b2_redundant;;
252 Table Op Msg_type Msg_text
253 test.ta1b2_redundant check status OK
254 # Run for ta1b4
255 # Metadata from INFORMATION_SCHEMA.TABLES
256 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
257 test/ta1b4_redundant 13 0 2
258 # Metadata from INFORMATION_SCHEMA.COLUMNS
259 NAME POS MTYPE PRTYPE HAS_DEFAULT
260 c0 0 6 1027 0
261 c1 1 5 16711932 0
262 c2 2 6 1027 0
263 c3 3 6 1283 0
264 c4 4 6 1027 0
265 c5 5 6 1283 0
266 c10 6 6 1027 1
267 c11 7 6 1283 1
268 c12 8 6 1027 1
269 c13 9 6 1283 1
270 SHOW CREATE TABLE ta1b4_redundant;;
271 Table Create Table
272 ta1b4_redundant CREATE TABLE `ta1b4_redundant` (
273 `c0` int DEFAULT NULL,
274 `c1` text,
275 `c2` int DEFAULT NULL,
276 `c3` int NOT NULL,
277 `c4` int DEFAULT '40',
278 `c5` int NOT NULL DEFAULT '50',
279 `c10` int DEFAULT NULL,
280 `c11` int NOT NULL,
281 `c12` int DEFAULT '120',
282 `c13` int NOT NULL DEFAULT '130'
283 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
284 SELECT * FROM ta1b4_redundant;;
285 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
286 1 row1 2 3 4 5 NULL 0 120 130
287 2 row2 NULL 33 40 55 NULL 0 120 130
288 11 row11 12 13 14 15 NULL 0 120 130
289 12 row12 NULL 133 40 155 NULL 0 120 130
290 5 row5 2002 3003 4004 5005 1010 1111 1212 1313
291 6 row6 NULL 30030 40 50050 NULL 11110 120 13130
292 CHECK TABLE ta1b4_redundant;;
293 Table Op Msg_type Msg_text
294 test.ta1b4_redundant check status OK
295 ALTER TABLE ta1b4_redundant ADD PRIMARY KEY (c3);;
296 # Metadata from INFORMATION_SCHEMA.TABLES
297 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
298 test/ta1b4_redundant 13 0 0
299 # Metadata from INFORMATION_SCHEMA.COLUMNS
300 NAME POS MTYPE PRTYPE HAS_DEFAULT
301 c0 0 6 1027 0
302 c1 1 5 16711932 0
303 c2 2 6 1027 0
304 c3 3 6 1283 0
305 c4 4 6 1027 0
306 c5 5 6 1283 0
307 c10 6 6 1027 0
308 c11 7 6 1283 0
309 c12 8 6 1027 0
310 c13 9 6 1283 0
311 SHOW CREATE TABLE ta1b4_redundant;;
312 Table Create Table
313 ta1b4_redundant CREATE TABLE `ta1b4_redundant` (
314 `c0` int DEFAULT NULL,
315 `c1` text,
316 `c2` int DEFAULT NULL,
317 `c3` int NOT NULL,
318 `c4` int DEFAULT '40',
319 `c5` int NOT NULL DEFAULT '50',
320 `c10` int DEFAULT NULL,
321 `c11` int NOT NULL,
322 `c12` int DEFAULT '120',
323 `c13` int NOT NULL DEFAULT '130',
324 PRIMARY KEY (`c3`)
325 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
326 SELECT * FROM ta1b4_redundant;;
327 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
328 1 row1 2 3 4 5 NULL 0 120 130
329 11 row11 12 13 14 15 NULL 0 120 130
330 2 row2 NULL 33 40 55 NULL 0 120 130
331 12 row12 NULL 133 40 155 NULL 0 120 130
332 5 row5 2002 3003 4004 5005 1010 1111 1212 1313
333 6 row6 NULL 30030 40 50050 NULL 11110 120 13130
334 CHECK TABLE ta1b4_redundant;;
335 Table Op Msg_type Msg_text
336 test.ta1b4_redundant check status OK
337 # Run for ta2b1
338 # Metadata from INFORMATION_SCHEMA.TABLES
339 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
340 test/ta2b1_redundant 13 6 0
341 # Metadata from INFORMATION_SCHEMA.COLUMNS
342 NAME POS MTYPE PRTYPE HAS_DEFAULT
343 c0 0 6 1027 0
344 c1 1 5 16711932 0
345 c2 2 6 1027 0
346 c3 3 6 1283 0
347 c4 4 6 1027 0
348 c5 5 6 1283 0
349 c6 6 6 1027 1
350 c7 7 6 1283 1
351 c8 8 6 1027 1
352 c9 9 6 1283 1
353 SHOW CREATE TABLE ta2b1_redundant;;
354 Table Create Table
355 ta2b1_redundant CREATE TABLE `ta2b1_redundant` (
356 `c0` int DEFAULT NULL,
357 `c1` text,
358 `c2` int DEFAULT NULL,
359 `c3` int NOT NULL,
360 `c4` int DEFAULT '40',
361 `c5` int NOT NULL DEFAULT '50',
362 `c6` int DEFAULT NULL,
363 `c7` int NOT NULL,
364 `c8` int DEFAULT '80',
365 `c9` int NOT NULL DEFAULT '90'
366 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
367 SELECT * FROM ta2b1_redundant;;
368 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
369 1 row1 2 3 4 5 NULL 0 80 90
370 2 row2 NULL 33 40 55 NULL 0 80 90
371 13 row13 1222 1333 1444 1555 1666 1777 1888 1999
372 14 row14 NULL 13333 40 15555 NULL 17777 80 19999
373 CHECK TABLE ta2b1_redundant;;
374 Table Op Msg_type Msg_text
375 test.ta2b1_redundant check status OK
376 ALTER TABLE ta2b1_redundant ADD PRIMARY KEY (c3);;
377 # Metadata from INFORMATION_SCHEMA.TABLES
378 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
379 test/ta2b1_redundant 13 0 0
380 # Metadata from INFORMATION_SCHEMA.COLUMNS
381 NAME POS MTYPE PRTYPE HAS_DEFAULT
382 c0 0 6 1027 0
383 c1 1 5 16711932 0
384 c2 2 6 1027 0
385 c3 3 6 1283 0
386 c4 4 6 1027 0
387 c5 5 6 1283 0
388 c6 6 6 1027 0
389 c7 7 6 1283 0
390 c8 8 6 1027 0
391 c9 9 6 1283 0
392 SHOW CREATE TABLE ta2b1_redundant;;
393 Table Create Table
394 ta2b1_redundant CREATE TABLE `ta2b1_redundant` (
395 `c0` int DEFAULT NULL,
396 `c1` text,
397 `c2` int DEFAULT NULL,
398 `c3` int NOT NULL,
399 `c4` int DEFAULT '40',
400 `c5` int NOT NULL DEFAULT '50',
401 `c6` int DEFAULT NULL,
402 `c7` int NOT NULL,
403 `c8` int DEFAULT '80',
404 `c9` int NOT NULL DEFAULT '90',
405 PRIMARY KEY (`c3`)
406 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
407 SELECT * FROM ta2b1_redundant;;
408 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
409 1 row1 2 3 4 5 NULL 0 80 90
410 2 row2 NULL 33 40 55 NULL 0 80 90
411 13 row13 1222 1333 1444 1555 1666 1777 1888 1999
412 14 row14 NULL 13333 40 15555 NULL 17777 80 19999
413 CHECK TABLE ta2b1_redundant;;
414 Table Op Msg_type Msg_text
415 test.ta2b1_redundant check status OK
416 # Run for ta2b2
417 # Metadata from INFORMATION_SCHEMA.TABLES
418 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
419 test/ta2b2_redundant 17 6 2
420 # Metadata from INFORMATION_SCHEMA.COLUMNS
421 NAME POS MTYPE PRTYPE HAS_DEFAULT
422 c0 0 6 1027 0
423 c1 1 5 16711932 0
424 c2 2 6 1027 0
425 c3 3 6 1283 0
426 c4 4 6 1027 0
427 c5 5 6 1283 0
428 c6 6 6 1027 1
429 c7 7 6 1283 1
430 c8 8 6 1027 1
431 c9 9 6 1283 1
432 c10 10 6 1027 1
433 c11 11 6 1283 1
434 c12 12 6 1027 1
435 c13 13 6 1283 1
436 SHOW CREATE TABLE ta2b2_redundant;;
437 Table Create Table
438 ta2b2_redundant CREATE TABLE `ta2b2_redundant` (
439 `c0` int DEFAULT NULL,
440 `c1` text,
441 `c2` int DEFAULT NULL,
442 `c3` int NOT NULL,
443 `c4` int DEFAULT '40',
444 `c5` int NOT NULL DEFAULT '50',
445 `c6` int DEFAULT NULL,
446 `c7` int NOT NULL,
447 `c8` int DEFAULT '80',
448 `c9` int NOT NULL DEFAULT '90',
449 `c10` int DEFAULT NULL,
450 `c11` int NOT NULL,
451 `c12` int DEFAULT '120',
452 `c13` int NOT NULL DEFAULT '130'
453 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
454 SELECT * FROM ta2b2_redundant;;
455 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
456 1 row1 2 3 4 5 NULL 0 80 90 NULL 0 120 130
457 2 row2 NULL 33 40 55 NULL 0 80 90 NULL 0 120 130
458 13 row13 1222 1333 1444 1555 1666 1777 1888 1999 NULL 0 120 130
459 14 row14 NULL 13333 40 15555 NULL 17777 80 19999 NULL 0 120 130
460 CHECK TABLE ta2b2_redundant;;
461 Table Op Msg_type Msg_text
462 test.ta2b2_redundant check status OK
463 ALTER TABLE ta2b2_redundant ADD PRIMARY KEY (c3);;
464 # Metadata from INFORMATION_SCHEMA.TABLES
465 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
466 test/ta2b2_redundant 17 0 0
467 # Metadata from INFORMATION_SCHEMA.COLUMNS
468 NAME POS MTYPE PRTYPE HAS_DEFAULT
469 c0 0 6 1027 0
470 c1 1 5 16711932 0
471 c2 2 6 1027 0
472 c3 3 6 1283 0
473 c4 4 6 1027 0
474 c5 5 6 1283 0
475 c6 6 6 1027 0
476 c7 7 6 1283 0
477 c8 8 6 1027 0
478 c9 9 6 1283 0
479 c10 10 6 1027 0
480 c11 11 6 1283 0
481 c12 12 6 1027 0
482 c13 13 6 1283 0
483 SHOW CREATE TABLE ta2b2_redundant;;
484 Table Create Table
485 ta2b2_redundant CREATE TABLE `ta2b2_redundant` (
486 `c0` int DEFAULT NULL,
487 `c1` text,
488 `c2` int DEFAULT NULL,
489 `c3` int NOT NULL,
490 `c4` int DEFAULT '40',
491 `c5` int NOT NULL DEFAULT '50',
492 `c6` int DEFAULT NULL,
493 `c7` int NOT NULL,
494 `c8` int DEFAULT '80',
495 `c9` int NOT NULL DEFAULT '90',
496 `c10` int DEFAULT NULL,
497 `c11` int NOT NULL,
498 `c12` int DEFAULT '120',
499 `c13` int NOT NULL DEFAULT '130',
500 PRIMARY KEY (`c3`)
501 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
502 SELECT * FROM ta2b2_redundant;;
503 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
504 1 row1 2 3 4 5 NULL 0 80 90 NULL 0 120 130
505 2 row2 NULL 33 40 55 NULL 0 80 90 NULL 0 120 130
506 13 row13 1222 1333 1444 1555 1666 1777 1888 1999 NULL 0 120 130
507 14 row14 NULL 13333 40 15555 NULL 17777 80 19999 NULL 0 120 130
508 CHECK TABLE ta2b2_redundant;;
509 Table Op Msg_type Msg_text
510 test.ta2b2_redundant check status OK
511 # Run for ta2b4
512 # Metadata from INFORMATION_SCHEMA.TABLES
513 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
514 test/ta2b4_redundant 17 6 2
515 # Metadata from INFORMATION_SCHEMA.COLUMNS
516 NAME POS MTYPE PRTYPE HAS_DEFAULT
517 c0 0 6 1027 0
518 c1 1 5 16711932 0
519 c2 2 6 1027 0
520 c3 3 6 1283 0
521 c4 4 6 1027 0
522 c5 5 6 1283 0
523 c6 6 6 1027 1
524 c7 7 6 1283 1
525 c8 8 6 1027 1
526 c9 9 6 1283 1
527 c10 10 6 1027 1
528 c11 11 6 1283 1
529 c12 12 6 1027 1
530 c13 13 6 1283 1
531 SHOW CREATE TABLE ta2b4_redundant;;
532 Table Create Table
533 ta2b4_redundant CREATE TABLE `ta2b4_redundant` (
534 `c0` int DEFAULT NULL,
535 `c1` text,
536 `c2` int DEFAULT NULL,
537 `c3` int NOT NULL,
538 `c4` int DEFAULT '40',
539 `c5` int NOT NULL DEFAULT '50',
540 `c6` int DEFAULT NULL,
541 `c7` int NOT NULL,
542 `c8` int DEFAULT '80',
543 `c9` int NOT NULL DEFAULT '90',
544 `c10` int DEFAULT NULL,
545 `c11` int NOT NULL,
546 `c12` int DEFAULT '120',
547 `c13` int NOT NULL DEFAULT '130'
548 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
549 SELECT * FROM ta2b4_redundant;;
550 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
551 1 row1 2 3 4 5 NULL 0 80 90 NULL 0 120 130
552 2 row2 NULL 33 40 55 NULL 0 80 90 NULL 0 120 130
553 13 row13 1222 1333 1444 1555 1666 1777 1888 1999 NULL 0 120 130
554 14 row14 NULL 13333 40 15555 NULL 17777 80 19999 NULL 0 120 130
555 5 row5 2002 3003 4004 5005 6006 7007 8008 9009 1010 1111 1212 1313
556 6 row6 NULL 30030 40 50050 NULL 70070 80 90090 NULL 11110 120 13130
557 CHECK TABLE ta2b4_redundant;;
558 Table Op Msg_type Msg_text
559 test.ta2b4_redundant check status OK
560 ALTER TABLE ta2b4_redundant ADD PRIMARY KEY (c3);;
561 # Metadata from INFORMATION_SCHEMA.TABLES
562 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
563 test/ta2b4_redundant 17 0 0
564 # Metadata from INFORMATION_SCHEMA.COLUMNS
565 NAME POS MTYPE PRTYPE HAS_DEFAULT
566 c0 0 6 1027 0
567 c1 1 5 16711932 0
568 c2 2 6 1027 0
569 c3 3 6 1283 0
570 c4 4 6 1027 0
571 c5 5 6 1283 0
572 c6 6 6 1027 0
573 c7 7 6 1283 0
574 c8 8 6 1027 0
575 c9 9 6 1283 0
576 c10 10 6 1027 0
577 c11 11 6 1283 0
578 c12 12 6 1027 0
579 c13 13 6 1283 0
580 SHOW CREATE TABLE ta2b4_redundant;;
581 Table Create Table
582 ta2b4_redundant CREATE TABLE `ta2b4_redundant` (
583 `c0` int DEFAULT NULL,
584 `c1` text,
585 `c2` int DEFAULT NULL,
586 `c3` int NOT NULL,
587 `c4` int DEFAULT '40',
588 `c5` int NOT NULL DEFAULT '50',
589 `c6` int DEFAULT NULL,
590 `c7` int NOT NULL,
591 `c8` int DEFAULT '80',
592 `c9` int NOT NULL DEFAULT '90',
593 `c10` int DEFAULT NULL,
594 `c11` int NOT NULL,
595 `c12` int DEFAULT '120',
596 `c13` int NOT NULL DEFAULT '130',
597 PRIMARY KEY (`c3`)
598 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
599 SELECT * FROM ta2b4_redundant;;
600 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
601 1 row1 2 3 4 5 NULL 0 80 90 NULL 0 120 130
602 2 row2 NULL 33 40 55 NULL 0 80 90 NULL 0 120 130
603 13 row13 1222 1333 1444 1555 1666 1777 1888 1999 NULL 0 120 130
604 5 row5 2002 3003 4004 5005 6006 7007 8008 9009 1010 1111 1212 1313
605 14 row14 NULL 13333 40 15555 NULL 17777 80 19999 NULL 0 120 130
606 6 row6 NULL 30030 40 50050 NULL 70070 80 90090 NULL 11110 120 13130
607 CHECK TABLE ta2b4_redundant;;
608 Table Op Msg_type Msg_text
609 test.ta2b4_redundant check status OK
610 # Run for ta4b1
611 # Metadata from INFORMATION_SCHEMA.TABLES
612 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
613 test/ta4b1_redundant 13 6 0
614 # Metadata from INFORMATION_SCHEMA.COLUMNS
615 NAME POS MTYPE PRTYPE HAS_DEFAULT
616 c0 0 6 1027 0
617 c1 1 5 16711932 0
618 c2 2 6 1027 0
619 c3 3 6 1283 0
620 c4 4 6 1027 0
621 c5 5 6 1283 0
622 c6 6 6 1027 1
623 c7 7 6 1283 1
624 c8 8 6 1027 1
625 c9 9 6 1283 1
626 SHOW CREATE TABLE ta4b1_redundant;;
627 Table Create Table
628 ta4b1_redundant CREATE TABLE `ta4b1_redundant` (
629 `c0` int DEFAULT NULL,
630 `c1` text,
631 `c2` int DEFAULT NULL,
632 `c3` int NOT NULL,
633 `c4` int DEFAULT '40',
634 `c5` int NOT NULL DEFAULT '50',
635 `c6` int DEFAULT NULL,
636 `c7` int NOT NULL,
637 `c8` int DEFAULT '80',
638 `c9` int NOT NULL DEFAULT '90'
639 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
640 SELECT * FROM ta4b1_redundant;;
641 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
642 1 row1 2 3 4 5 NULL 0 80 90
643 2 row2 NULL 33 40 55 NULL 0 80 90
644 3 row3 222 333 444 555 666 777 888 999
645 4 row4 NULL 3333 40 5555 NULL 7777 80 9999
646 13 row13 1222 1333 1444 1555 1666 1777 1888 1999
647 14 row14 NULL 13333 40 15555 NULL 17777 80 19999
648 CHECK TABLE ta4b1_redundant;;
649 Table Op Msg_type Msg_text
650 test.ta4b1_redundant check status OK
651 ALTER TABLE ta4b1_redundant ADD PRIMARY KEY (c3);;
652 # Metadata from INFORMATION_SCHEMA.TABLES
653 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
654 test/ta4b1_redundant 13 0 0
655 # Metadata from INFORMATION_SCHEMA.COLUMNS
656 NAME POS MTYPE PRTYPE HAS_DEFAULT
657 c0 0 6 1027 0
658 c1 1 5 16711932 0
659 c2 2 6 1027 0
660 c3 3 6 1283 0
661 c4 4 6 1027 0
662 c5 5 6 1283 0
663 c6 6 6 1027 0
664 c7 7 6 1283 0
665 c8 8 6 1027 0
666 c9 9 6 1283 0
667 SHOW CREATE TABLE ta4b1_redundant;;
668 Table Create Table
669 ta4b1_redundant CREATE TABLE `ta4b1_redundant` (
670 `c0` int DEFAULT NULL,
671 `c1` text,
672 `c2` int DEFAULT NULL,
673 `c3` int NOT NULL,
674 `c4` int DEFAULT '40',
675 `c5` int NOT NULL DEFAULT '50',
676 `c6` int DEFAULT NULL,
677 `c7` int NOT NULL,
678 `c8` int DEFAULT '80',
679 `c9` int NOT NULL DEFAULT '90',
680 PRIMARY KEY (`c3`)
681 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
682 SELECT * FROM ta4b1_redundant;;
683 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
684 1 row1 2 3 4 5 NULL 0 80 90
685 2 row2 NULL 33 40 55 NULL 0 80 90
686 3 row3 222 333 444 555 666 777 888 999
687 13 row13 1222 1333 1444 1555 1666 1777 1888 1999
688 4 row4 NULL 3333 40 5555 NULL 7777 80 9999
689 14 row14 NULL 13333 40 15555 NULL 17777 80 19999
690 CHECK TABLE ta4b1_redundant;;
691 Table Op Msg_type Msg_text
692 test.ta4b1_redundant check status OK
693 # Run for ta4b2
694 # Metadata from INFORMATION_SCHEMA.TABLES
695 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
696 test/ta4b2_redundant 17 6 2
697 # Metadata from INFORMATION_SCHEMA.COLUMNS
698 NAME POS MTYPE PRTYPE HAS_DEFAULT
699 c0 0 6 1027 0
700 c1 1 5 16711932 0
701 c2 2 6 1027 0
702 c3 3 6 1283 0
703 c4 4 6 1027 0
704 c5 5 6 1283 0
705 c6 6 6 1027 1
706 c7 7 6 1283 1
707 c8 8 6 1027 1
708 c9 9 6 1283 1
709 c10 10 6 1027 1
710 c11 11 6 1283 1
711 c12 12 6 1027 1
712 c13 13 6 1283 1
713 SHOW CREATE TABLE ta4b2_redundant;;
714 Table Create Table
715 ta4b2_redundant CREATE TABLE `ta4b2_redundant` (
716 `c0` int DEFAULT NULL,
717 `c1` text,
718 `c2` int DEFAULT NULL,
719 `c3` int NOT NULL,
720 `c4` int DEFAULT '40',
721 `c5` int NOT NULL DEFAULT '50',
722 `c6` int DEFAULT NULL,
723 `c7` int NOT NULL,
724 `c8` int DEFAULT '80',
725 `c9` int NOT NULL DEFAULT '90',
726 `c10` int DEFAULT NULL,
727 `c11` int NOT NULL,
728 `c12` int DEFAULT '120',
729 `c13` int NOT NULL DEFAULT '130'
730 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
731 SELECT * FROM ta4b2_redundant;;
732 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
733 1 row1 2 3 4 5 NULL 0 80 90 NULL 0 120 130
734 2 row2 NULL 33 40 55 NULL 0 80 90 NULL 0 120 130
735 3 row3 222 333 444 555 666 777 888 999 NULL 0 120 130
736 4 row4 NULL 3333 40 5555 NULL 7777 80 9999 NULL 0 120 130
737 13 row13 1222 1333 1444 1555 1666 1777 1888 1999 NULL 0 120 130
738 14 row14 NULL 13333 40 15555 NULL 17777 80 19999 NULL 0 120 130
739 CHECK TABLE ta4b2_redundant;;
740 Table Op Msg_type Msg_text
741 test.ta4b2_redundant check status OK
742 ALTER TABLE ta4b2_redundant ADD PRIMARY KEY (c3);;
743 # Metadata from INFORMATION_SCHEMA.TABLES
744 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
745 test/ta4b2_redundant 17 0 0
746 # Metadata from INFORMATION_SCHEMA.COLUMNS
747 NAME POS MTYPE PRTYPE HAS_DEFAULT
748 c0 0 6 1027 0
749 c1 1 5 16711932 0
750 c2 2 6 1027 0
751 c3 3 6 1283 0
752 c4 4 6 1027 0
753 c5 5 6 1283 0
754 c6 6 6 1027 0
755 c7 7 6 1283 0
756 c8 8 6 1027 0
757 c9 9 6 1283 0
758 c10 10 6 1027 0
759 c11 11 6 1283 0
760 c12 12 6 1027 0
761 c13 13 6 1283 0
762 SHOW CREATE TABLE ta4b2_redundant;;
763 Table Create Table
764 ta4b2_redundant CREATE TABLE `ta4b2_redundant` (
765 `c0` int DEFAULT NULL,
766 `c1` text,
767 `c2` int DEFAULT NULL,
768 `c3` int NOT NULL,
769 `c4` int DEFAULT '40',
770 `c5` int NOT NULL DEFAULT '50',
771 `c6` int DEFAULT NULL,
772 `c7` int NOT NULL,
773 `c8` int DEFAULT '80',
774 `c9` int NOT NULL DEFAULT '90',
775 `c10` int DEFAULT NULL,
776 `c11` int NOT NULL,
777 `c12` int DEFAULT '120',
778 `c13` int NOT NULL DEFAULT '130',
779 PRIMARY KEY (`c3`)
780 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
781 SELECT * FROM ta4b2_redundant;;
782 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
783 1 row1 2 3 4 5 NULL 0 80 90 NULL 0 120 130
784 2 row2 NULL 33 40 55 NULL 0 80 90 NULL 0 120 130
785 3 row3 222 333 444 555 666 777 888 999 NULL 0 120 130
786 13 row13 1222 1333 1444 1555 1666 1777 1888 1999 NULL 0 120 130
787 4 row4 NULL 3333 40 5555 NULL 7777 80 9999 NULL 0 120 130
788 14 row14 NULL 13333 40 15555 NULL 17777 80 19999 NULL 0 120 130
789 CHECK TABLE ta4b2_redundant;;
790 Table Op Msg_type Msg_text
791 test.ta4b2_redundant check status OK
792 # Run for ta4b4
793 # Metadata from INFORMATION_SCHEMA.TABLES
794 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
795 test/ta4b4_redundant 17 6 2
796 # Metadata from INFORMATION_SCHEMA.COLUMNS
797 NAME POS MTYPE PRTYPE HAS_DEFAULT
798 c0 0 6 1027 0
799 c1 1 5 16711932 0
800 c2 2 6 1027 0
801 c3 3 6 1283 0
802 c4 4 6 1027 0
803 c5 5 6 1283 0
804 c6 6 6 1027 1
805 c7 7 6 1283 1
806 c8 8 6 1027 1
807 c9 9 6 1283 1
808 c10 10 6 1027 1
809 c11 11 6 1283 1
810 c12 12 6 1027 1
811 c13 13 6 1283 1
812 SHOW CREATE TABLE ta4b4_redundant;;
813 Table Create Table
814 ta4b4_redundant CREATE TABLE `ta4b4_redundant` (
815 `c0` int DEFAULT NULL,
816 `c1` text,
817 `c2` int DEFAULT NULL,
818 `c3` int NOT NULL,
819 `c4` int DEFAULT '40',
820 `c5` int NOT NULL DEFAULT '50',
821 `c6` int DEFAULT NULL,
822 `c7` int NOT NULL,
823 `c8` int DEFAULT '80',
824 `c9` int NOT NULL DEFAULT '90',
825 `c10` int DEFAULT NULL,
826 `c11` int NOT NULL,
827 `c12` int DEFAULT '120',
828 `c13` int NOT NULL DEFAULT '130'
829 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
830 SELECT * FROM ta4b4_redundant;;
831 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
832 1 row1 2 3 4 5 NULL 0 80 90 NULL 0 120 130
833 2 row2 NULL 33 40 55 NULL 0 80 90 NULL 0 120 130
834 3 row3 222 333 444 555 666 777 888 999 NULL 0 120 130
835 4 row4 NULL 3333 40 5555 NULL 7777 80 9999 NULL 0 120 130
836 13 row13 1222 1333 1444 1555 1666 1777 1888 1999 NULL 0 120 130
837 14 row14 NULL 13333 40 15555 NULL 17777 80 19999 NULL 0 120 130
838 5 row5 2002 3003 4004 5005 6006 7007 8008 9009 1010 1111 1212 1313
839 6 row6 NULL 30030 40 50050 NULL 70070 80 90090 NULL 11110 120 13130
840 CHECK TABLE ta4b4_redundant;;
841 Table Op Msg_type Msg_text
842 test.ta4b4_redundant check status OK
843 ALTER TABLE ta4b4_redundant ADD PRIMARY KEY (c3);;
844 # Metadata from INFORMATION_SCHEMA.TABLES
845 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
846 test/ta4b4_redundant 17 0 0
847 # Metadata from INFORMATION_SCHEMA.COLUMNS
848 NAME POS MTYPE PRTYPE HAS_DEFAULT
849 c0 0 6 1027 0
850 c1 1 5 16711932 0
851 c2 2 6 1027 0
852 c3 3 6 1283 0
853 c4 4 6 1027 0
854 c5 5 6 1283 0
855 c6 6 6 1027 0
856 c7 7 6 1283 0
857 c8 8 6 1027 0
858 c9 9 6 1283 0
859 c10 10 6 1027 0
860 c11 11 6 1283 0
861 c12 12 6 1027 0
862 c13 13 6 1283 0
863 SHOW CREATE TABLE ta4b4_redundant;;
864 Table Create Table
865 ta4b4_redundant CREATE TABLE `ta4b4_redundant` (
866 `c0` int DEFAULT NULL,
867 `c1` text,
868 `c2` int DEFAULT NULL,
869 `c3` int NOT NULL,
870 `c4` int DEFAULT '40',
871 `c5` int NOT NULL DEFAULT '50',
872 `c6` int DEFAULT NULL,
873 `c7` int NOT NULL,
874 `c8` int DEFAULT '80',
875 `c9` int NOT NULL DEFAULT '90',
876 `c10` int DEFAULT NULL,
877 `c11` int NOT NULL,
878 `c12` int DEFAULT '120',
879 `c13` int NOT NULL DEFAULT '130',
880 PRIMARY KEY (`c3`)
881 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
882 SELECT * FROM ta4b4_redundant;;
883 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
884 1 row1 2 3 4 5 NULL 0 80 90 NULL 0 120 130
885 2 row2 NULL 33 40 55 NULL 0 80 90 NULL 0 120 130
886 3 row3 222 333 444 555 666 777 888 999 NULL 0 120 130
887 13 row13 1222 1333 1444 1555 1666 1777 1888 1999 NULL 0 120 130
888 5 row5 2002 3003 4004 5005 6006 7007 8008 9009 1010 1111 1212 1313
889 4 row4 NULL 3333 40 5555 NULL 7777 80 9999 NULL 0 120 130
890 14 row14 NULL 13333 40 15555 NULL 17777 80 19999 NULL 0 120 130
891 6 row6 NULL 30030 40 50050 NULL 70070 80 90090 NULL 11110 120 13130
892 CHECK TABLE ta4b4_redundant;;
893 Table Op Msg_type Msg_text
894 test.ta4b4_redundant check status OK
895 # For all COMPACT tables:
896 # Prepare the table
897 # Insert some rows just after upgrade
898 # a1 => no alter in 8.0.28
899 # ta1b1_*, ta1b2_*, ta1b4_* -- insert rows
900 INSERT INTO ta1b1_compact VALUES (11, "row11", 12, 13, 14, 15);;
901 INSERT INTO ta1b1_compact (c0, c1, c3, c5) VALUES (12, "row12", 133, 155);;
902 INSERT INTO ta1b2_compact VALUES (11, "row11", 12, 13, 14, 15);;
903 INSERT INTO ta1b2_compact (c0, c1, c3, c5) VALUES (12, "row12", 133, 155);;
904 INSERT INTO ta1b4_compact VALUES (11, "row11", 12, 13, 14, 15);;
905 INSERT INTO ta1b4_compact (c0, c1, c3, c5) VALUES (12, "row12", 133, 155);;
906 # a2 => alter in 8.0.28 but no insert
907 # ta2b1_*, ta2b2_*, ta2b4_* -- insert rows:
908 INSERT INTO ta2b1_compact VALUES (13, "row13", 1222, 1333, 1444, 1555, 1666, 1777, 1888, 1999);;
909 INSERT INTO ta2b1_compact (c0, c1, c3, c5, c7, c9) VALUES (14, "row14", 13333, 15555, 17777, 19999);;
910 INSERT INTO ta2b2_compact VALUES (13, "row13", 1222, 1333, 1444, 1555, 1666, 1777, 1888, 1999);;
911 INSERT INTO ta2b2_compact (c0, c1, c3, c5, c7, c9) VALUES (14, "row14", 13333, 15555, 17777, 19999);;
912 INSERT INTO ta2b4_compact VALUES (13, "row13", 1222, 1333, 1444, 1555, 1666, 1777, 1888, 1999);;
913 INSERT INTO ta2b4_compact (c0, c1, c3, c5, c7, c9) VALUES (14, "row14", 13333, 15555, 17777, 19999);;
914 # a4 => alter + insert in 8.0.28
915 # ta4b1_*, ta4b2_*, ta4b4_* -- insert rows
916 INSERT INTO ta4b1_compact VALUES (13, "row13", 1222, 1333, 1444, 1555, 1666, 1777, 1888, 1999);;
917 INSERT INTO ta4b1_compact (c0, c1, c3, c5, c7, c9) VALUES (14, "row14", 13333, 15555, 17777, 19999);;
918 INSERT INTO ta4b2_compact VALUES (13, "row13", 1222, 1333, 1444, 1555, 1666, 1777, 1888, 1999);;
919 INSERT INTO ta4b2_compact (c0, c1, c3, c5, c7, c9) VALUES (14, "row14", 13333, 15555, 17777, 19999);;
920 INSERT INTO ta4b4_compact VALUES (13, "row13", 1222, 1333, 1444, 1555, 1666, 1777, 1888, 1999);;
921 INSERT INTO ta4b4_compact (c0, c1, c3, c5, c7, c9) VALUES (14, "row14", 13333, 15555, 17777, 19999);;
922 # b1 => no alter in trunk
923 # ta1b1_*, ta2b1_*, ta4b1_* -- no operation
924 # b2 => alter in trunk but no insert
925 # ta1b2_*, ta2b2_*, ta4b1_* -- ALTER TABLE no insert:
926 ALTER TABLE ta1b2_compact ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
927 ALTER TABLE ta1b2_compact ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
928 ALTER TABLE ta2b2_compact ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
929 ALTER TABLE ta2b2_compact ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
930 ALTER TABLE ta4b2_compact ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
931 ALTER TABLE ta4b2_compact ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
932 # b4 => alter + insert in trunk
933 # ta1b4_*, ta2b4_*, ta4b4_* -- ALTER TABLE + INSERT INTO
934 ALTER TABLE ta1b4_compact ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
935 ALTER TABLE ta1b4_compact ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
936 INSERT INTO ta1b4_compact VALUES (5, "row5", 2002, 3003, 4004, 5005, 1010, 1111, 1212, 1313);;
937 INSERT INTO ta1b4_compact (c0, c1, c3, c5, c11, c13) VALUES (6, "row6", 30030, 50050, 11110, 13130);;
938 ALTER TABLE ta2b4_compact ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
939 ALTER TABLE ta2b4_compact ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
940 INSERT INTO ta2b4_compact VALUES (5, "row5", 2002, 3003, 4004, 5005, 6006, 7007, 8008, 9009, 1010, 1111, 1212, 1313);;
941 INSERT INTO ta2b4_compact (c0, c1, c3, c5, c7, c9, c11, c13) VALUES (6, "row6", 30030, 50050, 70070, 90090, 11110, 13130);;
942 ALTER TABLE ta4b4_compact ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
943 ALTER TABLE ta4b4_compact ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
944 INSERT INTO ta4b4_compact VALUES (5, "row5", 2002, 3003, 4004, 5005, 6006, 7007, 8008, 9009, 1010, 1111, 1212, 1313);;
945 INSERT INTO ta4b4_compact (c0, c1, c3, c5, c7, c9, c11, c13) VALUES (6, "row6", 30030, 50050, 70070, 90090, 11110, 13130);;
946 # For each table, run the test
947 # Run for ta1b1
948 # Metadata from INFORMATION_SCHEMA.TABLES
949 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
950 test/ta1b1_compact 9 0 0
951 # Metadata from INFORMATION_SCHEMA.COLUMNS
952 NAME POS MTYPE PRTYPE HAS_DEFAULT
953 c0 0 6 1027 0
954 c1 1 5 16711932 0
955 c2 2 6 1027 0
956 c3 3 6 1283 0
957 c4 4 6 1027 0
958 c5 5 6 1283 0
959 SHOW CREATE TABLE ta1b1_compact;;
960 Table Create Table
961 ta1b1_compact CREATE TABLE `ta1b1_compact` (
962 `c0` int DEFAULT NULL,
963 `c1` text,
964 `c2` int DEFAULT NULL,
965 `c3` int NOT NULL,
966 `c4` int DEFAULT '40',
967 `c5` int NOT NULL DEFAULT '50'
968 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
969 SELECT * FROM ta1b1_compact;;
970 c0 c1 c2 c3 c4 c5
971 1 row1 2 3 4 5
972 2 row2 NULL 33 40 55
973 11 row11 12 13 14 15
974 12 row12 NULL 133 40 155
975 CHECK TABLE ta1b1_compact;;
976 Table Op Msg_type Msg_text
977 test.ta1b1_compact check status OK
978 ALTER TABLE ta1b1_compact ADD PRIMARY KEY (c3);;
979 # Metadata from INFORMATION_SCHEMA.TABLES
980 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
981 test/ta1b1_compact 9 0 0
982 # Metadata from INFORMATION_SCHEMA.COLUMNS
983 NAME POS MTYPE PRTYPE HAS_DEFAULT
984 c0 0 6 1027 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 SHOW CREATE TABLE ta1b1_compact;;
991 Table Create Table
992 ta1b1_compact CREATE TABLE `ta1b1_compact` (
993 `c0` int DEFAULT NULL,
994 `c1` text,
995 `c2` int DEFAULT NULL,
996 `c3` int NOT NULL,
997 `c4` int DEFAULT '40',
998 `c5` int NOT NULL DEFAULT '50',
999 PRIMARY KEY (`c3`)
1000 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
1001 SELECT * FROM ta1b1_compact;;
1002 c0 c1 c2 c3 c4 c5
1003 1 row1 2 3 4 5
1004 11 row11 12 13 14 15
1005 2 row2 NULL 33 40 55
1006 12 row12 NULL 133 40 155
1007 CHECK TABLE ta1b1_compact;;
1008 Table Op Msg_type Msg_text
1009 test.ta1b1_compact check status OK
1010 # Run for ta1b2
1011 # Metadata from INFORMATION_SCHEMA.TABLES
1012 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1013 test/ta1b2_compact 13 0 2
1014 # Metadata from INFORMATION_SCHEMA.COLUMNS
1015 NAME POS MTYPE PRTYPE HAS_DEFAULT
1016 c0 0 6 1027 0
1017 c1 1 5 16711932 0
1018 c2 2 6 1027 0
1019 c3 3 6 1283 0
1020 c4 4 6 1027 0
1021 c5 5 6 1283 0
1022 c10 6 6 1027 1
1023 c11 7 6 1283 1
1024 c12 8 6 1027 1
1025 c13 9 6 1283 1
1026 SHOW CREATE TABLE ta1b2_compact;;
1027 Table Create Table
1028 ta1b2_compact CREATE TABLE `ta1b2_compact` (
1029 `c0` int DEFAULT NULL,
1030 `c1` text,
1031 `c2` int DEFAULT NULL,
1032 `c3` int NOT NULL,
1033 `c4` int DEFAULT '40',
1034 `c5` int NOT NULL DEFAULT '50',
1035 `c10` int DEFAULT NULL,
1036 `c11` int NOT NULL,
1037 `c12` int DEFAULT '120',
1038 `c13` int NOT NULL DEFAULT '130'
1039 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
1040 SELECT * FROM ta1b2_compact;;
1041 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
1042 1 row1 2 3 4 5 NULL 0 120 130
1043 2 row2 NULL 33 40 55 NULL 0 120 130
1044 11 row11 12 13 14 15 NULL 0 120 130
1045 12 row12 NULL 133 40 155 NULL 0 120 130
1046 CHECK TABLE ta1b2_compact;;
1047 Table Op Msg_type Msg_text
1048 test.ta1b2_compact check status OK
1049 ALTER TABLE ta1b2_compact ADD PRIMARY KEY (c3);;
1050 # Metadata from INFORMATION_SCHEMA.TABLES
1051 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1052 test/ta1b2_compact 13 0 0
1053 # Metadata from INFORMATION_SCHEMA.COLUMNS
1054 NAME POS MTYPE PRTYPE HAS_DEFAULT
1055 c0 0 6 1027 0
1056 c1 1 5 16711932 0
1057 c2 2 6 1027 0
1058 c3 3 6 1283 0
1059 c4 4 6 1027 0
1060 c5 5 6 1283 0
1061 c10 6 6 1027 0
1062 c11 7 6 1283 0
1063 c12 8 6 1027 0
1064 c13 9 6 1283 0
1065 SHOW CREATE TABLE ta1b2_compact;;
1066 Table Create Table
1067 ta1b2_compact CREATE TABLE `ta1b2_compact` (
1068 `c0` int DEFAULT NULL,
1069 `c1` text,
1070 `c2` int DEFAULT NULL,
1071 `c3` int NOT NULL,
1072 `c4` int DEFAULT '40',
1073 `c5` int NOT NULL DEFAULT '50',
1074 `c10` int DEFAULT NULL,
1075 `c11` int NOT NULL,
1076 `c12` int DEFAULT '120',
1077 `c13` int NOT NULL DEFAULT '130',
1078 PRIMARY KEY (`c3`)
1079 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
1080 SELECT * FROM ta1b2_compact;;
1081 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
1082 1 row1 2 3 4 5 NULL 0 120 130
1083 11 row11 12 13 14 15 NULL 0 120 130
1084 2 row2 NULL 33 40 55 NULL 0 120 130
1085 12 row12 NULL 133 40 155 NULL 0 120 130
1086 CHECK TABLE ta1b2_compact;;
1087 Table Op Msg_type Msg_text
1088 test.ta1b2_compact check status OK
1089 # Run for ta1b4
1090 # Metadata from INFORMATION_SCHEMA.TABLES
1091 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1092 test/ta1b4_compact 13 0 2
1093 # Metadata from INFORMATION_SCHEMA.COLUMNS
1094 NAME POS MTYPE PRTYPE HAS_DEFAULT
1095 c0 0 6 1027 0
1096 c1 1 5 16711932 0
1097 c2 2 6 1027 0
1098 c3 3 6 1283 0
1099 c4 4 6 1027 0
1100 c5 5 6 1283 0
1101 c10 6 6 1027 1
1102 c11 7 6 1283 1
1103 c12 8 6 1027 1
1104 c13 9 6 1283 1
1105 SHOW CREATE TABLE ta1b4_compact;;
1106 Table Create Table
1107 ta1b4_compact CREATE TABLE `ta1b4_compact` (
1108 `c0` int DEFAULT NULL,
1109 `c1` text,
1110 `c2` int DEFAULT NULL,
1111 `c3` int NOT NULL,
1112 `c4` int DEFAULT '40',
1113 `c5` int NOT NULL DEFAULT '50',
1114 `c10` int DEFAULT NULL,
1115 `c11` int NOT NULL,
1116 `c12` int DEFAULT '120',
1117 `c13` int NOT NULL DEFAULT '130'
1118 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
1119 SELECT * FROM ta1b4_compact;;
1120 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
1121 1 row1 2 3 4 5 NULL 0 120 130
1122 2 row2 NULL 33 40 55 NULL 0 120 130
1123 11 row11 12 13 14 15 NULL 0 120 130
1124 12 row12 NULL 133 40 155 NULL 0 120 130
1125 5 row5 2002 3003 4004 5005 1010 1111 1212 1313
1126 6 row6 NULL 30030 40 50050 NULL 11110 120 13130
1127 CHECK TABLE ta1b4_compact;;
1128 Table Op Msg_type Msg_text
1129 test.ta1b4_compact check status OK
1130 ALTER TABLE ta1b4_compact ADD PRIMARY KEY (c3);;
1131 # Metadata from INFORMATION_SCHEMA.TABLES
1132 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1133 test/ta1b4_compact 13 0 0
1134 # Metadata from INFORMATION_SCHEMA.COLUMNS
1135 NAME POS MTYPE PRTYPE HAS_DEFAULT
1136 c0 0 6 1027 0
1137 c1 1 5 16711932 0
1138 c2 2 6 1027 0
1139 c3 3 6 1283 0
1140 c4 4 6 1027 0
1141 c5 5 6 1283 0
1142 c10 6 6 1027 0
1143 c11 7 6 1283 0
1144 c12 8 6 1027 0
1145 c13 9 6 1283 0
1146 SHOW CREATE TABLE ta1b4_compact;;
1147 Table Create Table
1148 ta1b4_compact CREATE TABLE `ta1b4_compact` (
1149 `c0` int DEFAULT NULL,
1150 `c1` text,
1151 `c2` int DEFAULT NULL,
1152 `c3` int NOT NULL,
1153 `c4` int DEFAULT '40',
1154 `c5` int NOT NULL DEFAULT '50',
1155 `c10` int DEFAULT NULL,
1156 `c11` int NOT NULL,
1157 `c12` int DEFAULT '120',
1158 `c13` int NOT NULL DEFAULT '130',
1159 PRIMARY KEY (`c3`)
1160 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
1161 SELECT * FROM ta1b4_compact;;
1162 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
1163 1 row1 2 3 4 5 NULL 0 120 130
1164 11 row11 12 13 14 15 NULL 0 120 130
1165 2 row2 NULL 33 40 55 NULL 0 120 130
1166 12 row12 NULL 133 40 155 NULL 0 120 130
1167 5 row5 2002 3003 4004 5005 1010 1111 1212 1313
1168 6 row6 NULL 30030 40 50050 NULL 11110 120 13130
1169 CHECK TABLE ta1b4_compact;;
1170 Table Op Msg_type Msg_text
1171 test.ta1b4_compact check status OK
1172 # Run for ta2b1
1173 # Metadata from INFORMATION_SCHEMA.TABLES
1174 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1175 test/ta2b1_compact 13 6 0
1176 # Metadata from INFORMATION_SCHEMA.COLUMNS
1177 NAME POS MTYPE PRTYPE HAS_DEFAULT
1178 c0 0 6 1027 0
1179 c1 1 5 16711932 0
1180 c2 2 6 1027 0
1181 c3 3 6 1283 0
1182 c4 4 6 1027 0
1183 c5 5 6 1283 0
1184 c6 6 6 1027 1
1185 c7 7 6 1283 1
1186 c8 8 6 1027 1
1187 c9 9 6 1283 1
1188 SHOW CREATE TABLE ta2b1_compact;;
1189 Table Create Table
1190 ta2b1_compact CREATE TABLE `ta2b1_compact` (
1191 `c0` int DEFAULT NULL,
1192 `c1` text,
1193 `c2` int DEFAULT NULL,
1194 `c3` int NOT NULL,
1195 `c4` int DEFAULT '40',
1196 `c5` int NOT NULL DEFAULT '50',
1197 `c6` int DEFAULT NULL,
1198 `c7` int NOT NULL,
1199 `c8` int DEFAULT '80',
1200 `c9` int NOT NULL DEFAULT '90'
1201 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
1202 SELECT * FROM ta2b1_compact;;
1203 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
1204 1 row1 2 3 4 5 NULL 0 80 90
1205 2 row2 NULL 33 40 55 NULL 0 80 90
1206 13 row13 1222 1333 1444 1555 1666 1777 1888 1999
1207 14 row14 NULL 13333 40 15555 NULL 17777 80 19999
1208 CHECK TABLE ta2b1_compact;;
1209 Table Op Msg_type Msg_text
1210 test.ta2b1_compact check status OK
1211 ALTER TABLE ta2b1_compact ADD PRIMARY KEY (c3);;
1212 # Metadata from INFORMATION_SCHEMA.TABLES
1213 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1214 test/ta2b1_compact 13 0 0
1215 # Metadata from INFORMATION_SCHEMA.COLUMNS
1216 NAME POS MTYPE PRTYPE HAS_DEFAULT
1217 c0 0 6 1027 0
1218 c1 1 5 16711932 0
1219 c2 2 6 1027 0
1220 c3 3 6 1283 0
1221 c4 4 6 1027 0
1222 c5 5 6 1283 0
1223 c6 6 6 1027 0
1224 c7 7 6 1283 0
1225 c8 8 6 1027 0
1226 c9 9 6 1283 0
1227 SHOW CREATE TABLE ta2b1_compact;;
1228 Table Create Table
1229 ta2b1_compact CREATE TABLE `ta2b1_compact` (
1230 `c0` int DEFAULT NULL,
1231 `c1` text,
1232 `c2` int DEFAULT NULL,
1233 `c3` int NOT NULL,
1234 `c4` int DEFAULT '40',
1235 `c5` int NOT NULL DEFAULT '50',
1236 `c6` int DEFAULT NULL,
1237 `c7` int NOT NULL,
1238 `c8` int DEFAULT '80',
1239 `c9` int NOT NULL DEFAULT '90',
1240 PRIMARY KEY (`c3`)
1241 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
1242 SELECT * FROM ta2b1_compact;;
1243 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
1244 1 row1 2 3 4 5 NULL 0 80 90
1245 2 row2 NULL 33 40 55 NULL 0 80 90
1246 13 row13 1222 1333 1444 1555 1666 1777 1888 1999
1247 14 row14 NULL 13333 40 15555 NULL 17777 80 19999
1248 CHECK TABLE ta2b1_compact;;
1249 Table Op Msg_type Msg_text
1250 test.ta2b1_compact check status OK
1251 # Run for ta2b2
1252 # Metadata from INFORMATION_SCHEMA.TABLES
1253 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1254 test/ta2b2_compact 17 6 2
1255 # Metadata from INFORMATION_SCHEMA.COLUMNS
1256 NAME POS MTYPE PRTYPE HAS_DEFAULT
1257 c0 0 6 1027 0
1258 c1 1 5 16711932 0
1259 c2 2 6 1027 0
1260 c3 3 6 1283 0
1261 c4 4 6 1027 0
1262 c5 5 6 1283 0
1263 c6 6 6 1027 1
1264 c7 7 6 1283 1
1265 c8 8 6 1027 1
1266 c9 9 6 1283 1
1267 c10 10 6 1027 1
1268 c11 11 6 1283 1
1269 c12 12 6 1027 1
1270 c13 13 6 1283 1
1271 SHOW CREATE TABLE ta2b2_compact;;
1272 Table Create Table
1273 ta2b2_compact CREATE TABLE `ta2b2_compact` (
1274 `c0` int DEFAULT NULL,
1275 `c1` text,
1276 `c2` int DEFAULT NULL,
1277 `c3` int NOT NULL,
1278 `c4` int DEFAULT '40',
1279 `c5` int NOT NULL DEFAULT '50',
1280 `c6` int DEFAULT NULL,
1281 `c7` int NOT NULL,
1282 `c8` int DEFAULT '80',
1283 `c9` int NOT NULL DEFAULT '90',
1284 `c10` int DEFAULT NULL,
1285 `c11` int NOT NULL,
1286 `c12` int DEFAULT '120',
1287 `c13` int NOT NULL DEFAULT '130'
1288 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
1289 SELECT * FROM ta2b2_compact;;
1290 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
1291 1 row1 2 3 4 5 NULL 0 80 90 NULL 0 120 130
1292 2 row2 NULL 33 40 55 NULL 0 80 90 NULL 0 120 130
1293 13 row13 1222 1333 1444 1555 1666 1777 1888 1999 NULL 0 120 130
1294 14 row14 NULL 13333 40 15555 NULL 17777 80 19999 NULL 0 120 130
1295 CHECK TABLE ta2b2_compact;;
1296 Table Op Msg_type Msg_text
1297 test.ta2b2_compact check status OK
1298 ALTER TABLE ta2b2_compact ADD PRIMARY KEY (c3);;
1299 # Metadata from INFORMATION_SCHEMA.TABLES
1300 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1301 test/ta2b2_compact 17 0 0
1302 # Metadata from INFORMATION_SCHEMA.COLUMNS
1303 NAME POS MTYPE PRTYPE HAS_DEFAULT
1304 c0 0 6 1027 0
1305 c1 1 5 16711932 0
1306 c2 2 6 1027 0
1307 c3 3 6 1283 0
1308 c4 4 6 1027 0
1309 c5 5 6 1283 0
1310 c6 6 6 1027 0
1311 c7 7 6 1283 0
1312 c8 8 6 1027 0
1313 c9 9 6 1283 0
1314 c10 10 6 1027 0
1315 c11 11 6 1283 0
1316 c12 12 6 1027 0
1317 c13 13 6 1283 0
1318 SHOW CREATE TABLE ta2b2_compact;;
1319 Table Create Table
1320 ta2b2_compact CREATE TABLE `ta2b2_compact` (
1321 `c0` int DEFAULT NULL,
1322 `c1` text,
1323 `c2` int DEFAULT NULL,
1324 `c3` int NOT NULL,
1325 `c4` int DEFAULT '40',
1326 `c5` int NOT NULL DEFAULT '50',
1327 `c6` int DEFAULT NULL,
1328 `c7` int NOT NULL,
1329 `c8` int DEFAULT '80',
1330 `c9` int NOT NULL DEFAULT '90',
1331 `c10` int DEFAULT NULL,
1332 `c11` int NOT NULL,
1333 `c12` int DEFAULT '120',
1334 `c13` int NOT NULL DEFAULT '130',
1335 PRIMARY KEY (`c3`)
1336 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
1337 SELECT * FROM ta2b2_compact;;
1338 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
1339 1 row1 2 3 4 5 NULL 0 80 90 NULL 0 120 130
1340 2 row2 NULL 33 40 55 NULL 0 80 90 NULL 0 120 130
1341 13 row13 1222 1333 1444 1555 1666 1777 1888 1999 NULL 0 120 130
1342 14 row14 NULL 13333 40 15555 NULL 17777 80 19999 NULL 0 120 130
1343 CHECK TABLE ta2b2_compact;;
1344 Table Op Msg_type Msg_text
1345 test.ta2b2_compact check status OK
1346 # Run for ta2b4
1347 # Metadata from INFORMATION_SCHEMA.TABLES
1348 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1349 test/ta2b4_compact 17 6 2
1350 # Metadata from INFORMATION_SCHEMA.COLUMNS
1351 NAME POS MTYPE PRTYPE HAS_DEFAULT
1352 c0 0 6 1027 0
1353 c1 1 5 16711932 0
1354 c2 2 6 1027 0
1355 c3 3 6 1283 0
1356 c4 4 6 1027 0
1357 c5 5 6 1283 0
1358 c6 6 6 1027 1
1359 c7 7 6 1283 1
1360 c8 8 6 1027 1
1361 c9 9 6 1283 1
1362 c10 10 6 1027 1
1363 c11 11 6 1283 1
1364 c12 12 6 1027 1
1365 c13 13 6 1283 1
1366 SHOW CREATE TABLE ta2b4_compact;;
1367 Table Create Table
1368 ta2b4_compact CREATE TABLE `ta2b4_compact` (
1369 `c0` int DEFAULT NULL,
1370 `c1` text,
1371 `c2` int DEFAULT NULL,
1372 `c3` int NOT NULL,
1373 `c4` int DEFAULT '40',
1374 `c5` int NOT NULL DEFAULT '50',
1375 `c6` int DEFAULT NULL,
1376 `c7` int NOT NULL,
1377 `c8` int DEFAULT '80',
1378 `c9` int NOT NULL DEFAULT '90',
1379 `c10` int DEFAULT NULL,
1380 `c11` int NOT NULL,
1381 `c12` int DEFAULT '120',
1382 `c13` int NOT NULL DEFAULT '130'
1383 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
1384 SELECT * FROM ta2b4_compact;;
1385 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
1386 1 row1 2 3 4 5 NULL 0 80 90 NULL 0 120 130
1387 2 row2 NULL 33 40 55 NULL 0 80 90 NULL 0 120 130
1388 13 row13 1222 1333 1444 1555 1666 1777 1888 1999 NULL 0 120 130
1389 14 row14 NULL 13333 40 15555 NULL 17777 80 19999 NULL 0 120 130
1390 5 row5 2002 3003 4004 5005 6006 7007 8008 9009 1010 1111 1212 1313
1391 6 row6 NULL 30030 40 50050 NULL 70070 80 90090 NULL 11110 120 13130
1392 CHECK TABLE ta2b4_compact;;
1393 Table Op Msg_type Msg_text
1394 test.ta2b4_compact check status OK
1395 ALTER TABLE ta2b4_compact ADD PRIMARY KEY (c3);;
1396 # Metadata from INFORMATION_SCHEMA.TABLES
1397 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1398 test/ta2b4_compact 17 0 0
1399 # Metadata from INFORMATION_SCHEMA.COLUMNS
1400 NAME POS MTYPE PRTYPE HAS_DEFAULT
1401 c0 0 6 1027 0
1402 c1 1 5 16711932 0
1403 c2 2 6 1027 0
1404 c3 3 6 1283 0
1405 c4 4 6 1027 0
1406 c5 5 6 1283 0
1407 c6 6 6 1027 0
1408 c7 7 6 1283 0
1409 c8 8 6 1027 0
1410 c9 9 6 1283 0
1411 c10 10 6 1027 0
1412 c11 11 6 1283 0
1413 c12 12 6 1027 0
1414 c13 13 6 1283 0
1415 SHOW CREATE TABLE ta2b4_compact;;
1416 Table Create Table
1417 ta2b4_compact CREATE TABLE `ta2b4_compact` (
1418 `c0` int DEFAULT NULL,
1419 `c1` text,
1420 `c2` int DEFAULT NULL,
1421 `c3` int NOT NULL,
1422 `c4` int DEFAULT '40',
1423 `c5` int NOT NULL DEFAULT '50',
1424 `c6` int DEFAULT NULL,
1425 `c7` int NOT NULL,
1426 `c8` int DEFAULT '80',
1427 `c9` int NOT NULL DEFAULT '90',
1428 `c10` int DEFAULT NULL,
1429 `c11` int NOT NULL,
1430 `c12` int DEFAULT '120',
1431 `c13` int NOT NULL DEFAULT '130',
1432 PRIMARY KEY (`c3`)
1433 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
1434 SELECT * FROM ta2b4_compact;;
1435 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
1436 1 row1 2 3 4 5 NULL 0 80 90 NULL 0 120 130
1437 2 row2 NULL 33 40 55 NULL 0 80 90 NULL 0 120 130
1438 13 row13 1222 1333 1444 1555 1666 1777 1888 1999 NULL 0 120 130
1439 5 row5 2002 3003 4004 5005 6006 7007 8008 9009 1010 1111 1212 1313
1440 14 row14 NULL 13333 40 15555 NULL 17777 80 19999 NULL 0 120 130
1441 6 row6 NULL 30030 40 50050 NULL 70070 80 90090 NULL 11110 120 13130
1442 CHECK TABLE ta2b4_compact;;
1443 Table Op Msg_type Msg_text
1444 test.ta2b4_compact check status OK
1445 # Run for ta4b1
1446 # Metadata from INFORMATION_SCHEMA.TABLES
1447 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1448 test/ta4b1_compact 13 6 0
1449 # Metadata from INFORMATION_SCHEMA.COLUMNS
1450 NAME POS MTYPE PRTYPE HAS_DEFAULT
1451 c0 0 6 1027 0
1452 c1 1 5 16711932 0
1453 c2 2 6 1027 0
1454 c3 3 6 1283 0
1455 c4 4 6 1027 0
1456 c5 5 6 1283 0
1457 c6 6 6 1027 1
1458 c7 7 6 1283 1
1459 c8 8 6 1027 1
1460 c9 9 6 1283 1
1461 SHOW CREATE TABLE ta4b1_compact;;
1462 Table Create Table
1463 ta4b1_compact CREATE TABLE `ta4b1_compact` (
1464 `c0` int DEFAULT NULL,
1465 `c1` text,
1466 `c2` int DEFAULT NULL,
1467 `c3` int NOT NULL,
1468 `c4` int DEFAULT '40',
1469 `c5` int NOT NULL DEFAULT '50',
1470 `c6` int DEFAULT NULL,
1471 `c7` int NOT NULL,
1472 `c8` int DEFAULT '80',
1473 `c9` int NOT NULL DEFAULT '90'
1474 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
1475 SELECT * FROM ta4b1_compact;;
1476 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
1477 1 row1 2 3 4 5 NULL 0 80 90
1478 2 row2 NULL 33 40 55 NULL 0 80 90
1479 3 row3 222 333 444 555 666 777 888 999
1480 4 row4 NULL 3333 40 5555 NULL 7777 80 9999
1481 13 row13 1222 1333 1444 1555 1666 1777 1888 1999
1482 14 row14 NULL 13333 40 15555 NULL 17777 80 19999
1483 CHECK TABLE ta4b1_compact;;
1484 Table Op Msg_type Msg_text
1485 test.ta4b1_compact check status OK
1486 ALTER TABLE ta4b1_compact ADD PRIMARY KEY (c3);;
1487 # Metadata from INFORMATION_SCHEMA.TABLES
1488 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1489 test/ta4b1_compact 13 0 0
1490 # Metadata from INFORMATION_SCHEMA.COLUMNS
1491 NAME POS MTYPE PRTYPE HAS_DEFAULT
1492 c0 0 6 1027 0
1493 c1 1 5 16711932 0
1494 c2 2 6 1027 0
1495 c3 3 6 1283 0
1496 c4 4 6 1027 0
1497 c5 5 6 1283 0
1498 c6 6 6 1027 0
1499 c7 7 6 1283 0
1500 c8 8 6 1027 0
1501 c9 9 6 1283 0
1502 SHOW CREATE TABLE ta4b1_compact;;
1503 Table Create Table
1504 ta4b1_compact CREATE TABLE `ta4b1_compact` (
1505 `c0` int DEFAULT NULL,
1506 `c1` text,
1507 `c2` int DEFAULT NULL,
1508 `c3` int NOT NULL,
1509 `c4` int DEFAULT '40',
1510 `c5` int NOT NULL DEFAULT '50',
1511 `c6` int DEFAULT NULL,
1512 `c7` int NOT NULL,
1513 `c8` int DEFAULT '80',
1514 `c9` int NOT NULL DEFAULT '90',
1515 PRIMARY KEY (`c3`)
1516 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
1517 SELECT * FROM ta4b1_compact;;
1518 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
1519 1 row1 2 3 4 5 NULL 0 80 90
1520 2 row2 NULL 33 40 55 NULL 0 80 90
1521 3 row3 222 333 444 555 666 777 888 999
1522 13 row13 1222 1333 1444 1555 1666 1777 1888 1999
1523 4 row4 NULL 3333 40 5555 NULL 7777 80 9999
1524 14 row14 NULL 13333 40 15555 NULL 17777 80 19999
1525 CHECK TABLE ta4b1_compact;;
1526 Table Op Msg_type Msg_text
1527 test.ta4b1_compact check status OK
1528 # Run for ta4b2
1529 # Metadata from INFORMATION_SCHEMA.TABLES
1530 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1531 test/ta4b2_compact 17 6 2
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 c6 6 6 1027 1
1541 c7 7 6 1283 1
1542 c8 8 6 1027 1
1543 c9 9 6 1283 1
1544 c10 10 6 1027 1
1545 c11 11 6 1283 1
1546 c12 12 6 1027 1
1547 c13 13 6 1283 1
1548 SHOW CREATE TABLE ta4b2_compact;;
1549 Table Create Table
1550 ta4b2_compact CREATE TABLE `ta4b2_compact` (
1551 `c0` int DEFAULT NULL,
1552 `c1` text,
1553 `c2` int DEFAULT NULL,
1554 `c3` int NOT NULL,
1555 `c4` int DEFAULT '40',
1556 `c5` int NOT NULL DEFAULT '50',
1557 `c6` int DEFAULT NULL,
1558 `c7` int NOT NULL,
1559 `c8` int DEFAULT '80',
1560 `c9` int NOT NULL DEFAULT '90',
1561 `c10` int DEFAULT NULL,
1562 `c11` int NOT NULL,
1563 `c12` int DEFAULT '120',
1564 `c13` int NOT NULL DEFAULT '130'
1565 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
1566 SELECT * FROM ta4b2_compact;;
1567 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
1568 1 row1 2 3 4 5 NULL 0 80 90 NULL 0 120 130
1569 2 row2 NULL 33 40 55 NULL 0 80 90 NULL 0 120 130
1570 3 row3 222 333 444 555 666 777 888 999 NULL 0 120 130
1571 4 row4 NULL 3333 40 5555 NULL 7777 80 9999 NULL 0 120 130
1572 13 row13 1222 1333 1444 1555 1666 1777 1888 1999 NULL 0 120 130
1573 14 row14 NULL 13333 40 15555 NULL 17777 80 19999 NULL 0 120 130
1574 CHECK TABLE ta4b2_compact;;
1575 Table Op Msg_type Msg_text
1576 test.ta4b2_compact check status OK
1577 ALTER TABLE ta4b2_compact ADD PRIMARY KEY (c3);;
1578 # Metadata from INFORMATION_SCHEMA.TABLES
1579 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1580 test/ta4b2_compact 17 0 0
1581 # Metadata from INFORMATION_SCHEMA.COLUMNS
1582 NAME POS MTYPE PRTYPE HAS_DEFAULT
1583 c0 0 6 1027 0
1584 c1 1 5 16711932 0
1585 c2 2 6 1027 0
1586 c3 3 6 1283 0
1587 c4 4 6 1027 0
1588 c5 5 6 1283 0
1589 c6 6 6 1027 0
1590 c7 7 6 1283 0
1591 c8 8 6 1027 0
1592 c9 9 6 1283 0
1593 c10 10 6 1027 0
1594 c11 11 6 1283 0
1595 c12 12 6 1027 0
1596 c13 13 6 1283 0
1597 SHOW CREATE TABLE ta4b2_compact;;
1598 Table Create Table
1599 ta4b2_compact CREATE TABLE `ta4b2_compact` (
1600 `c0` int DEFAULT NULL,
1601 `c1` text,
1602 `c2` int DEFAULT NULL,
1603 `c3` int NOT NULL,
1604 `c4` int DEFAULT '40',
1605 `c5` int NOT NULL DEFAULT '50',
1606 `c6` int DEFAULT NULL,
1607 `c7` int NOT NULL,
1608 `c8` int DEFAULT '80',
1609 `c9` int NOT NULL DEFAULT '90',
1610 `c10` int DEFAULT NULL,
1611 `c11` int NOT NULL,
1612 `c12` int DEFAULT '120',
1613 `c13` int NOT NULL DEFAULT '130',
1614 PRIMARY KEY (`c3`)
1615 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
1616 SELECT * FROM ta4b2_compact;;
1617 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
1618 1 row1 2 3 4 5 NULL 0 80 90 NULL 0 120 130
1619 2 row2 NULL 33 40 55 NULL 0 80 90 NULL 0 120 130
1620 3 row3 222 333 444 555 666 777 888 999 NULL 0 120 130
1621 13 row13 1222 1333 1444 1555 1666 1777 1888 1999 NULL 0 120 130
1622 4 row4 NULL 3333 40 5555 NULL 7777 80 9999 NULL 0 120 130
1623 14 row14 NULL 13333 40 15555 NULL 17777 80 19999 NULL 0 120 130
1624 CHECK TABLE ta4b2_compact;;
1625 Table Op Msg_type Msg_text
1626 test.ta4b2_compact check status OK
1627 # Run for ta4b4
1628 # Metadata from INFORMATION_SCHEMA.TABLES
1629 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1630 test/ta4b4_compact 17 6 2
1631 # Metadata from INFORMATION_SCHEMA.COLUMNS
1632 NAME POS MTYPE PRTYPE HAS_DEFAULT
1633 c0 0 6 1027 0
1634 c1 1 5 16711932 0
1635 c2 2 6 1027 0
1636 c3 3 6 1283 0
1637 c4 4 6 1027 0
1638 c5 5 6 1283 0
1639 c6 6 6 1027 1
1640 c7 7 6 1283 1
1641 c8 8 6 1027 1
1642 c9 9 6 1283 1
1643 c10 10 6 1027 1
1644 c11 11 6 1283 1
1645 c12 12 6 1027 1
1646 c13 13 6 1283 1
1647 SHOW CREATE TABLE ta4b4_compact;;
1648 Table Create Table
1649 ta4b4_compact CREATE TABLE `ta4b4_compact` (
1650 `c0` int DEFAULT NULL,
1651 `c1` text,
1652 `c2` int DEFAULT NULL,
1653 `c3` int NOT NULL,
1654 `c4` int DEFAULT '40',
1655 `c5` int NOT NULL DEFAULT '50',
1656 `c6` int DEFAULT NULL,
1657 `c7` int NOT NULL,
1658 `c8` int DEFAULT '80',
1659 `c9` int NOT NULL DEFAULT '90',
1660 `c10` int DEFAULT NULL,
1661 `c11` int NOT NULL,
1662 `c12` int DEFAULT '120',
1663 `c13` int NOT NULL DEFAULT '130'
1664 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
1665 SELECT * FROM ta4b4_compact;;
1666 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
1667 1 row1 2 3 4 5 NULL 0 80 90 NULL 0 120 130
1668 2 row2 NULL 33 40 55 NULL 0 80 90 NULL 0 120 130
1669 3 row3 222 333 444 555 666 777 888 999 NULL 0 120 130
1670 4 row4 NULL 3333 40 5555 NULL 7777 80 9999 NULL 0 120 130
1671 13 row13 1222 1333 1444 1555 1666 1777 1888 1999 NULL 0 120 130
1672 14 row14 NULL 13333 40 15555 NULL 17777 80 19999 NULL 0 120 130
1673 5 row5 2002 3003 4004 5005 6006 7007 8008 9009 1010 1111 1212 1313
1674 6 row6 NULL 30030 40 50050 NULL 70070 80 90090 NULL 11110 120 13130
1675 CHECK TABLE ta4b4_compact;;
1676 Table Op Msg_type Msg_text
1677 test.ta4b4_compact check status OK
1678 ALTER TABLE ta4b4_compact ADD PRIMARY KEY (c3);;
1679 # Metadata from INFORMATION_SCHEMA.TABLES
1680 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1681 test/ta4b4_compact 17 0 0
1682 # Metadata from INFORMATION_SCHEMA.COLUMNS
1683 NAME POS MTYPE PRTYPE HAS_DEFAULT
1684 c0 0 6 1027 0
1685 c1 1 5 16711932 0
1686 c2 2 6 1027 0
1687 c3 3 6 1283 0
1688 c4 4 6 1027 0
1689 c5 5 6 1283 0
1690 c6 6 6 1027 0
1691 c7 7 6 1283 0
1692 c8 8 6 1027 0
1693 c9 9 6 1283 0
1694 c10 10 6 1027 0
1695 c11 11 6 1283 0
1696 c12 12 6 1027 0
1697 c13 13 6 1283 0
1698 SHOW CREATE TABLE ta4b4_compact;;
1699 Table Create Table
1700 ta4b4_compact CREATE TABLE `ta4b4_compact` (
1701 `c0` int DEFAULT NULL,
1702 `c1` text,
1703 `c2` int DEFAULT NULL,
1704 `c3` int NOT NULL,
1705 `c4` int DEFAULT '40',
1706 `c5` int NOT NULL DEFAULT '50',
1707 `c6` int DEFAULT NULL,
1708 `c7` int NOT NULL,
1709 `c8` int DEFAULT '80',
1710 `c9` int NOT NULL DEFAULT '90',
1711 `c10` int DEFAULT NULL,
1712 `c11` int NOT NULL,
1713 `c12` int DEFAULT '120',
1714 `c13` int NOT NULL DEFAULT '130',
1715 PRIMARY KEY (`c3`)
1716 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
1717 SELECT * FROM ta4b4_compact;;
1718 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
1719 1 row1 2 3 4 5 NULL 0 80 90 NULL 0 120 130
1720 2 row2 NULL 33 40 55 NULL 0 80 90 NULL 0 120 130
1721 3 row3 222 333 444 555 666 777 888 999 NULL 0 120 130
1722 13 row13 1222 1333 1444 1555 1666 1777 1888 1999 NULL 0 120 130
1723 5 row5 2002 3003 4004 5005 6006 7007 8008 9009 1010 1111 1212 1313
1724 4 row4 NULL 3333 40 5555 NULL 7777 80 9999 NULL 0 120 130
1725 14 row14 NULL 13333 40 15555 NULL 17777 80 19999 NULL 0 120 130
1726 6 row6 NULL 30030 40 50050 NULL 70070 80 90090 NULL 11110 120 13130
1727 CHECK TABLE ta4b4_compact;;
1728 Table Op Msg_type Msg_text
1729 test.ta4b4_compact check status OK
1730 # For all DYNAMIC tables:
1731 # Prepare the table
1732 # Insert some rows just after upgrade
1733 # a1 => no alter in 8.0.28
1734 # ta1b1_*, ta1b2_*, ta1b4_* -- insert rows
1735 INSERT INTO ta1b1_dynamic VALUES (11, "row11", 12, 13, 14, 15);;
1736 INSERT INTO ta1b1_dynamic (c0, c1, c3, c5) VALUES (12, "row12", 133, 155);;
1737 INSERT INTO ta1b2_dynamic VALUES (11, "row11", 12, 13, 14, 15);;
1738 INSERT INTO ta1b2_dynamic (c0, c1, c3, c5) VALUES (12, "row12", 133, 155);;
1739 INSERT INTO ta1b4_dynamic VALUES (11, "row11", 12, 13, 14, 15);;
1740 INSERT INTO ta1b4_dynamic (c0, c1, c3, c5) VALUES (12, "row12", 133, 155);;
1741 # a2 => alter in 8.0.28 but no insert
1742 # ta2b1_*, ta2b2_*, ta2b4_* -- insert rows:
1743 INSERT INTO ta2b1_dynamic VALUES (13, "row13", 1222, 1333, 1444, 1555, 1666, 1777, 1888, 1999);;
1744 INSERT INTO ta2b1_dynamic (c0, c1, c3, c5, c7, c9) VALUES (14, "row14", 13333, 15555, 17777, 19999);;
1745 INSERT INTO ta2b2_dynamic VALUES (13, "row13", 1222, 1333, 1444, 1555, 1666, 1777, 1888, 1999);;
1746 INSERT INTO ta2b2_dynamic (c0, c1, c3, c5, c7, c9) VALUES (14, "row14", 13333, 15555, 17777, 19999);;
1747 INSERT INTO ta2b4_dynamic VALUES (13, "row13", 1222, 1333, 1444, 1555, 1666, 1777, 1888, 1999);;
1748 INSERT INTO ta2b4_dynamic (c0, c1, c3, c5, c7, c9) VALUES (14, "row14", 13333, 15555, 17777, 19999);;
1749 # a4 => alter + insert in 8.0.28
1750 # ta4b1_*, ta4b2_*, ta4b4_* -- insert rows
1751 INSERT INTO ta4b1_dynamic VALUES (13, "row13", 1222, 1333, 1444, 1555, 1666, 1777, 1888, 1999);;
1752 INSERT INTO ta4b1_dynamic (c0, c1, c3, c5, c7, c9) VALUES (14, "row14", 13333, 15555, 17777, 19999);;
1753 INSERT INTO ta4b2_dynamic VALUES (13, "row13", 1222, 1333, 1444, 1555, 1666, 1777, 1888, 1999);;
1754 INSERT INTO ta4b2_dynamic (c0, c1, c3, c5, c7, c9) VALUES (14, "row14", 13333, 15555, 17777, 19999);;
1755 INSERT INTO ta4b4_dynamic VALUES (13, "row13", 1222, 1333, 1444, 1555, 1666, 1777, 1888, 1999);;
1756 INSERT INTO ta4b4_dynamic (c0, c1, c3, c5, c7, c9) VALUES (14, "row14", 13333, 15555, 17777, 19999);;
1757 # b1 => no alter in trunk
1758 # ta1b1_*, ta2b1_*, ta4b1_* -- no operation
1759 # b2 => alter in trunk but no insert
1760 # ta1b2_*, ta2b2_*, ta4b1_* -- ALTER TABLE no insert:
1761 ALTER TABLE ta1b2_dynamic ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
1762 ALTER TABLE ta1b2_dynamic ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
1763 ALTER TABLE ta2b2_dynamic ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
1764 ALTER TABLE ta2b2_dynamic ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
1765 ALTER TABLE ta4b2_dynamic ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
1766 ALTER TABLE ta4b2_dynamic ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
1767 # b4 => alter + insert in trunk
1768 # ta1b4_*, ta2b4_*, ta4b4_* -- ALTER TABLE + INSERT INTO
1769 ALTER TABLE ta1b4_dynamic ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
1770 ALTER TABLE ta1b4_dynamic ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
1771 INSERT INTO ta1b4_dynamic VALUES (5, "row5", 2002, 3003, 4004, 5005, 1010, 1111, 1212, 1313);;
1772 INSERT INTO ta1b4_dynamic (c0, c1, c3, c5, c11, c13) VALUES (6, "row6", 30030, 50050, 11110, 13130);;
1773 ALTER TABLE ta2b4_dynamic ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
1774 ALTER TABLE ta2b4_dynamic ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
1775 INSERT INTO ta2b4_dynamic VALUES (5, "row5", 2002, 3003, 4004, 5005, 6006, 7007, 8008, 9009, 1010, 1111, 1212, 1313);;
1776 INSERT INTO ta2b4_dynamic (c0, c1, c3, c5, c7, c9, c11, c13) VALUES (6, "row6", 30030, 50050, 70070, 90090, 11110, 13130);;
1777 ALTER TABLE ta4b4_dynamic ADD COLUMN c10 INT, ADD COLUMN c11 INT NOT NULL, ALGORITHM=INSTANT;;
1778 ALTER TABLE ta4b4_dynamic ADD COLUMN c12 INT DEFAULT 120, ADD COLUMN c13 INT NOT NULL DEFAULT 130, ALGORITHM=INSTANT;;
1779 INSERT INTO ta4b4_dynamic VALUES (5, "row5", 2002, 3003, 4004, 5005, 6006, 7007, 8008, 9009, 1010, 1111, 1212, 1313);;
1780 INSERT INTO ta4b4_dynamic (c0, c1, c3, c5, c7, c9, c11, c13) VALUES (6, "row6", 30030, 50050, 70070, 90090, 11110, 13130);;
1781 # For each table, run the test
1782 # Run for ta1b1
1783 # Metadata from INFORMATION_SCHEMA.TABLES
1784 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1785 test/ta1b1_dynamic 9 0 0
1786 # Metadata from INFORMATION_SCHEMA.COLUMNS
1787 NAME POS MTYPE PRTYPE HAS_DEFAULT
1788 c0 0 6 1027 0
1789 c1 1 5 16711932 0
1790 c2 2 6 1027 0
1791 c3 3 6 1283 0
1792 c4 4 6 1027 0
1793 c5 5 6 1283 0
1794 SHOW CREATE TABLE ta1b1_dynamic;;
1795 Table Create Table
1796 ta1b1_dynamic CREATE TABLE `ta1b1_dynamic` (
1797 `c0` int DEFAULT NULL,
1798 `c1` text,
1799 `c2` int DEFAULT NULL,
1800 `c3` int NOT NULL,
1801 `c4` int DEFAULT '40',
1802 `c5` int NOT NULL DEFAULT '50'
1803 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
1804 SELECT * FROM ta1b1_dynamic;;
1805 c0 c1 c2 c3 c4 c5
1806 1 row1 2 3 4 5
1807 2 row2 NULL 33 40 55
1808 11 row11 12 13 14 15
1809 12 row12 NULL 133 40 155
1810 CHECK TABLE ta1b1_dynamic;;
1811 Table Op Msg_type Msg_text
1812 test.ta1b1_dynamic check status OK
1813 ALTER TABLE ta1b1_dynamic ADD PRIMARY KEY (c3);;
1814 # Metadata from INFORMATION_SCHEMA.TABLES
1815 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1816 test/ta1b1_dynamic 9 0 0
1817 # Metadata from INFORMATION_SCHEMA.COLUMNS
1818 NAME POS MTYPE PRTYPE HAS_DEFAULT
1819 c0 0 6 1027 0
1820 c1 1 5 16711932 0
1821 c2 2 6 1027 0
1822 c3 3 6 1283 0
1823 c4 4 6 1027 0
1824 c5 5 6 1283 0
1825 SHOW CREATE TABLE ta1b1_dynamic;;
1826 Table Create Table
1827 ta1b1_dynamic CREATE TABLE `ta1b1_dynamic` (
1828 `c0` int DEFAULT NULL,
1829 `c1` text,
1830 `c2` int DEFAULT NULL,
1831 `c3` int NOT NULL,
1832 `c4` int DEFAULT '40',
1833 `c5` int NOT NULL DEFAULT '50',
1834 PRIMARY KEY (`c3`)
1835 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
1836 SELECT * FROM ta1b1_dynamic;;
1837 c0 c1 c2 c3 c4 c5
1838 1 row1 2 3 4 5
1839 11 row11 12 13 14 15
1840 2 row2 NULL 33 40 55
1841 12 row12 NULL 133 40 155
1842 CHECK TABLE ta1b1_dynamic;;
1843 Table Op Msg_type Msg_text
1844 test.ta1b1_dynamic check status OK
1845 # Run for ta1b2
1846 # Metadata from INFORMATION_SCHEMA.TABLES
1847 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1848 test/ta1b2_dynamic 13 0 2
1849 # Metadata from INFORMATION_SCHEMA.COLUMNS
1850 NAME POS MTYPE PRTYPE HAS_DEFAULT
1851 c0 0 6 1027 0
1852 c1 1 5 16711932 0
1853 c2 2 6 1027 0
1854 c3 3 6 1283 0
1855 c4 4 6 1027 0
1856 c5 5 6 1283 0
1857 c10 6 6 1027 1
1858 c11 7 6 1283 1
1859 c12 8 6 1027 1
1860 c13 9 6 1283 1
1861 SHOW CREATE TABLE ta1b2_dynamic;;
1862 Table Create Table
1863 ta1b2_dynamic CREATE TABLE `ta1b2_dynamic` (
1864 `c0` int DEFAULT NULL,
1865 `c1` text,
1866 `c2` int DEFAULT NULL,
1867 `c3` int NOT NULL,
1868 `c4` int DEFAULT '40',
1869 `c5` int NOT NULL DEFAULT '50',
1870 `c10` int DEFAULT NULL,
1871 `c11` int NOT NULL,
1872 `c12` int DEFAULT '120',
1873 `c13` int NOT NULL DEFAULT '130'
1874 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
1875 SELECT * FROM ta1b2_dynamic;;
1876 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
1877 1 row1 2 3 4 5 NULL 0 120 130
1878 2 row2 NULL 33 40 55 NULL 0 120 130
1879 11 row11 12 13 14 15 NULL 0 120 130
1880 12 row12 NULL 133 40 155 NULL 0 120 130
1881 CHECK TABLE ta1b2_dynamic;;
1882 Table Op Msg_type Msg_text
1883 test.ta1b2_dynamic check status OK
1884 ALTER TABLE ta1b2_dynamic ADD PRIMARY KEY (c3);;
1885 # Metadata from INFORMATION_SCHEMA.TABLES
1886 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1887 test/ta1b2_dynamic 13 0 0
1888 # Metadata from INFORMATION_SCHEMA.COLUMNS
1889 NAME POS MTYPE PRTYPE HAS_DEFAULT
1890 c0 0 6 1027 0
1891 c1 1 5 16711932 0
1892 c2 2 6 1027 0
1893 c3 3 6 1283 0
1894 c4 4 6 1027 0
1895 c5 5 6 1283 0
1896 c10 6 6 1027 0
1897 c11 7 6 1283 0
1898 c12 8 6 1027 0
1899 c13 9 6 1283 0
1900 SHOW CREATE TABLE ta1b2_dynamic;;
1901 Table Create Table
1902 ta1b2_dynamic CREATE TABLE `ta1b2_dynamic` (
1903 `c0` int DEFAULT NULL,
1904 `c1` text,
1905 `c2` int DEFAULT NULL,
1906 `c3` int NOT NULL,
1907 `c4` int DEFAULT '40',
1908 `c5` int NOT NULL DEFAULT '50',
1909 `c10` int DEFAULT NULL,
1910 `c11` int NOT NULL,
1911 `c12` int DEFAULT '120',
1912 `c13` int NOT NULL DEFAULT '130',
1913 PRIMARY KEY (`c3`)
1914 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
1915 SELECT * FROM ta1b2_dynamic;;
1916 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
1917 1 row1 2 3 4 5 NULL 0 120 130
1918 11 row11 12 13 14 15 NULL 0 120 130
1919 2 row2 NULL 33 40 55 NULL 0 120 130
1920 12 row12 NULL 133 40 155 NULL 0 120 130
1921 CHECK TABLE ta1b2_dynamic;;
1922 Table Op Msg_type Msg_text
1923 test.ta1b2_dynamic check status OK
1924 # Run for ta1b4
1925 # Metadata from INFORMATION_SCHEMA.TABLES
1926 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1927 test/ta1b4_dynamic 13 0 2
1928 # Metadata from INFORMATION_SCHEMA.COLUMNS
1929 NAME POS MTYPE PRTYPE HAS_DEFAULT
1930 c0 0 6 1027 0
1931 c1 1 5 16711932 0
1932 c2 2 6 1027 0
1933 c3 3 6 1283 0
1934 c4 4 6 1027 0
1935 c5 5 6 1283 0
1936 c10 6 6 1027 1
1937 c11 7 6 1283 1
1938 c12 8 6 1027 1
1939 c13 9 6 1283 1
1940 SHOW CREATE TABLE ta1b4_dynamic;;
1941 Table Create Table
1942 ta1b4_dynamic CREATE TABLE `ta1b4_dynamic` (
1943 `c0` int DEFAULT NULL,
1944 `c1` text,
1945 `c2` int DEFAULT NULL,
1946 `c3` int NOT NULL,
1947 `c4` int DEFAULT '40',
1948 `c5` int NOT NULL DEFAULT '50',
1949 `c10` int DEFAULT NULL,
1950 `c11` int NOT NULL,
1951 `c12` int DEFAULT '120',
1952 `c13` int NOT NULL DEFAULT '130'
1953 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
1954 SELECT * FROM ta1b4_dynamic;;
1955 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
1956 1 row1 2 3 4 5 NULL 0 120 130
1957 2 row2 NULL 33 40 55 NULL 0 120 130
1958 11 row11 12 13 14 15 NULL 0 120 130
1959 12 row12 NULL 133 40 155 NULL 0 120 130
1960 5 row5 2002 3003 4004 5005 1010 1111 1212 1313
1961 6 row6 NULL 30030 40 50050 NULL 11110 120 13130
1962 CHECK TABLE ta1b4_dynamic;;
1963 Table Op Msg_type Msg_text
1964 test.ta1b4_dynamic check status OK
1965 ALTER TABLE ta1b4_dynamic ADD PRIMARY KEY (c3);;
1966 # Metadata from INFORMATION_SCHEMA.TABLES
1967 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
1968 test/ta1b4_dynamic 13 0 0
1969 # Metadata from INFORMATION_SCHEMA.COLUMNS
1970 NAME POS MTYPE PRTYPE HAS_DEFAULT
1971 c0 0 6 1027 0
1972 c1 1 5 16711932 0
1973 c2 2 6 1027 0
1974 c3 3 6 1283 0
1975 c4 4 6 1027 0
1976 c5 5 6 1283 0
1977 c10 6 6 1027 0
1978 c11 7 6 1283 0
1979 c12 8 6 1027 0
1980 c13 9 6 1283 0
1981 SHOW CREATE TABLE ta1b4_dynamic;;
1982 Table Create Table
1983 ta1b4_dynamic CREATE TABLE `ta1b4_dynamic` (
1984 `c0` int DEFAULT NULL,
1985 `c1` text,
1986 `c2` int DEFAULT NULL,
1987 `c3` int NOT NULL,
1988 `c4` int DEFAULT '40',
1989 `c5` int NOT NULL DEFAULT '50',
1990 `c10` int DEFAULT NULL,
1991 `c11` int NOT NULL,
1992 `c12` int DEFAULT '120',
1993 `c13` int NOT NULL DEFAULT '130',
1994 PRIMARY KEY (`c3`)
1995 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
1996 SELECT * FROM ta1b4_dynamic;;
1997 c0 c1 c2 c3 c4 c5 c10 c11 c12 c13
1998 1 row1 2 3 4 5 NULL 0 120 130
1999 11 row11 12 13 14 15 NULL 0 120 130
2000 2 row2 NULL 33 40 55 NULL 0 120 130
2001 12 row12 NULL 133 40 155 NULL 0 120 130
2002 5 row5 2002 3003 4004 5005 1010 1111 1212 1313
2003 6 row6 NULL 30030 40 50050 NULL 11110 120 13130
2004 CHECK TABLE ta1b4_dynamic;;
2005 Table Op Msg_type Msg_text
2006 test.ta1b4_dynamic check status OK
2007 # Run for ta2b1
2008 # Metadata from INFORMATION_SCHEMA.TABLES
2009 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2010 test/ta2b1_dynamic 13 6 0
2011 # Metadata from INFORMATION_SCHEMA.COLUMNS
2012 NAME POS MTYPE PRTYPE HAS_DEFAULT
2013 c0 0 6 1027 0
2014 c1 1 5 16711932 0
2015 c2 2 6 1027 0
2016 c3 3 6 1283 0
2017 c4 4 6 1027 0
2018 c5 5 6 1283 0
2019 c6 6 6 1027 1
2020 c7 7 6 1283 1
2021 c8 8 6 1027 1
2022 c9 9 6 1283 1
2023 SHOW CREATE TABLE ta2b1_dynamic;;
2024 Table Create Table
2025 ta2b1_dynamic CREATE TABLE `ta2b1_dynamic` (
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 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
2037 SELECT * FROM ta2b1_dynamic;;
2038 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
2039 1 row1 2 3 4 5 NULL 0 80 90
2040 2 row2 NULL 33 40 55 NULL 0 80 90
2041 13 row13 1222 1333 1444 1555 1666 1777 1888 1999
2042 14 row14 NULL 13333 40 15555 NULL 17777 80 19999
2043 CHECK TABLE ta2b1_dynamic;;
2044 Table Op Msg_type Msg_text
2045 test.ta2b1_dynamic check status OK
2046 ALTER TABLE ta2b1_dynamic ADD PRIMARY KEY (c3);;
2047 # Metadata from INFORMATION_SCHEMA.TABLES
2048 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2049 test/ta2b1_dynamic 13 0 0
2050 # Metadata from INFORMATION_SCHEMA.COLUMNS
2051 NAME POS MTYPE PRTYPE HAS_DEFAULT
2052 c0 0 6 1027 0
2053 c1 1 5 16711932 0
2054 c2 2 6 1027 0
2055 c3 3 6 1283 0
2056 c4 4 6 1027 0
2057 c5 5 6 1283 0
2058 c6 6 6 1027 0
2059 c7 7 6 1283 0
2060 c8 8 6 1027 0
2061 c9 9 6 1283 0
2062 SHOW CREATE TABLE ta2b1_dynamic;;
2063 Table Create Table
2064 ta2b1_dynamic CREATE TABLE `ta2b1_dynamic` (
2065 `c0` int DEFAULT NULL,
2066 `c1` text,
2067 `c2` int DEFAULT NULL,
2068 `c3` int NOT NULL,
2069 `c4` int DEFAULT '40',
2070 `c5` int NOT NULL DEFAULT '50',
2071 `c6` int DEFAULT NULL,
2072 `c7` int NOT NULL,
2073 `c8` int DEFAULT '80',
2074 `c9` int NOT NULL DEFAULT '90',
2075 PRIMARY KEY (`c3`)
2076 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
2077 SELECT * FROM ta2b1_dynamic;;
2078 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
2079 1 row1 2 3 4 5 NULL 0 80 90
2080 2 row2 NULL 33 40 55 NULL 0 80 90
2081 13 row13 1222 1333 1444 1555 1666 1777 1888 1999
2082 14 row14 NULL 13333 40 15555 NULL 17777 80 19999
2083 CHECK TABLE ta2b1_dynamic;;
2084 Table Op Msg_type Msg_text
2085 test.ta2b1_dynamic check status OK
2086 # Run for ta2b2
2087 # Metadata from INFORMATION_SCHEMA.TABLES
2088 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2089 test/ta2b2_dynamic 17 6 2
2090 # Metadata from INFORMATION_SCHEMA.COLUMNS
2091 NAME POS MTYPE PRTYPE HAS_DEFAULT
2092 c0 0 6 1027 0
2093 c1 1 5 16711932 0
2094 c2 2 6 1027 0
2095 c3 3 6 1283 0
2096 c4 4 6 1027 0
2097 c5 5 6 1283 0
2098 c6 6 6 1027 1
2099 c7 7 6 1283 1
2100 c8 8 6 1027 1
2101 c9 9 6 1283 1
2102 c10 10 6 1027 1
2103 c11 11 6 1283 1
2104 c12 12 6 1027 1
2105 c13 13 6 1283 1
2106 SHOW CREATE TABLE ta2b2_dynamic;;
2107 Table Create Table
2108 ta2b2_dynamic CREATE TABLE `ta2b2_dynamic` (
2109 `c0` int DEFAULT NULL,
2110 `c1` text,
2111 `c2` int DEFAULT NULL,
2112 `c3` int NOT NULL,
2113 `c4` int DEFAULT '40',
2114 `c5` int NOT NULL DEFAULT '50',
2115 `c6` int DEFAULT NULL,
2116 `c7` int NOT NULL,
2117 `c8` int DEFAULT '80',
2118 `c9` int NOT NULL DEFAULT '90',
2119 `c10` int DEFAULT NULL,
2120 `c11` int NOT NULL,
2121 `c12` int DEFAULT '120',
2122 `c13` int NOT NULL DEFAULT '130'
2123 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
2124 SELECT * FROM ta2b2_dynamic;;
2125 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
2126 1 row1 2 3 4 5 NULL 0 80 90 NULL 0 120 130
2127 2 row2 NULL 33 40 55 NULL 0 80 90 NULL 0 120 130
2128 13 row13 1222 1333 1444 1555 1666 1777 1888 1999 NULL 0 120 130
2129 14 row14 NULL 13333 40 15555 NULL 17777 80 19999 NULL 0 120 130
2130 CHECK TABLE ta2b2_dynamic;;
2131 Table Op Msg_type Msg_text
2132 test.ta2b2_dynamic check status OK
2133 ALTER TABLE ta2b2_dynamic ADD PRIMARY KEY (c3);;
2134 # Metadata from INFORMATION_SCHEMA.TABLES
2135 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2136 test/ta2b2_dynamic 17 0 0
2137 # Metadata from INFORMATION_SCHEMA.COLUMNS
2138 NAME POS MTYPE PRTYPE HAS_DEFAULT
2139 c0 0 6 1027 0
2140 c1 1 5 16711932 0
2141 c2 2 6 1027 0
2142 c3 3 6 1283 0
2143 c4 4 6 1027 0
2144 c5 5 6 1283 0
2145 c6 6 6 1027 0
2146 c7 7 6 1283 0
2147 c8 8 6 1027 0
2148 c9 9 6 1283 0
2149 c10 10 6 1027 0
2150 c11 11 6 1283 0
2151 c12 12 6 1027 0
2152 c13 13 6 1283 0
2153 SHOW CREATE TABLE ta2b2_dynamic;;
2154 Table Create Table
2155 ta2b2_dynamic CREATE TABLE `ta2b2_dynamic` (
2156 `c0` int DEFAULT NULL,
2157 `c1` text,
2158 `c2` int DEFAULT NULL,
2159 `c3` int NOT NULL,
2160 `c4` int DEFAULT '40',
2161 `c5` int NOT NULL DEFAULT '50',
2162 `c6` int DEFAULT NULL,
2163 `c7` int NOT NULL,
2164 `c8` int DEFAULT '80',
2165 `c9` int NOT NULL DEFAULT '90',
2166 `c10` int DEFAULT NULL,
2167 `c11` int NOT NULL,
2168 `c12` int DEFAULT '120',
2169 `c13` int NOT NULL DEFAULT '130',
2170 PRIMARY KEY (`c3`)
2171 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
2172 SELECT * FROM ta2b2_dynamic;;
2173 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
2174 1 row1 2 3 4 5 NULL 0 80 90 NULL 0 120 130
2175 2 row2 NULL 33 40 55 NULL 0 80 90 NULL 0 120 130
2176 13 row13 1222 1333 1444 1555 1666 1777 1888 1999 NULL 0 120 130
2177 14 row14 NULL 13333 40 15555 NULL 17777 80 19999 NULL 0 120 130
2178 CHECK TABLE ta2b2_dynamic;;
2179 Table Op Msg_type Msg_text
2180 test.ta2b2_dynamic check status OK
2181 # Run for ta2b4
2182 # Metadata from INFORMATION_SCHEMA.TABLES
2183 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2184 test/ta2b4_dynamic 17 6 2
2185 # Metadata from INFORMATION_SCHEMA.COLUMNS
2186 NAME POS MTYPE PRTYPE HAS_DEFAULT
2187 c0 0 6 1027 0
2188 c1 1 5 16711932 0
2189 c2 2 6 1027 0
2190 c3 3 6 1283 0
2191 c4 4 6 1027 0
2192 c5 5 6 1283 0
2193 c6 6 6 1027 1
2194 c7 7 6 1283 1
2195 c8 8 6 1027 1
2196 c9 9 6 1283 1
2197 c10 10 6 1027 1
2198 c11 11 6 1283 1
2199 c12 12 6 1027 1
2200 c13 13 6 1283 1
2201 SHOW CREATE TABLE ta2b4_dynamic;;
2202 Table Create Table
2203 ta2b4_dynamic CREATE TABLE `ta2b4_dynamic` (
2204 `c0` int DEFAULT NULL,
2205 `c1` text,
2206 `c2` int DEFAULT NULL,
2207 `c3` int NOT NULL,
2208 `c4` int DEFAULT '40',
2209 `c5` int NOT NULL DEFAULT '50',
2210 `c6` int DEFAULT NULL,
2211 `c7` int NOT NULL,
2212 `c8` int DEFAULT '80',
2213 `c9` int NOT NULL DEFAULT '90',
2214 `c10` int DEFAULT NULL,
2215 `c11` int NOT NULL,
2216 `c12` int DEFAULT '120',
2217 `c13` int NOT NULL DEFAULT '130'
2218 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
2219 SELECT * FROM ta2b4_dynamic;;
2220 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
2221 1 row1 2 3 4 5 NULL 0 80 90 NULL 0 120 130
2222 2 row2 NULL 33 40 55 NULL 0 80 90 NULL 0 120 130
2223 13 row13 1222 1333 1444 1555 1666 1777 1888 1999 NULL 0 120 130
2224 14 row14 NULL 13333 40 15555 NULL 17777 80 19999 NULL 0 120 130
2225 5 row5 2002 3003 4004 5005 6006 7007 8008 9009 1010 1111 1212 1313
2226 6 row6 NULL 30030 40 50050 NULL 70070 80 90090 NULL 11110 120 13130
2227 CHECK TABLE ta2b4_dynamic;;
2228 Table Op Msg_type Msg_text
2229 test.ta2b4_dynamic check status OK
2230 ALTER TABLE ta2b4_dynamic ADD PRIMARY KEY (c3);;
2231 # Metadata from INFORMATION_SCHEMA.TABLES
2232 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2233 test/ta2b4_dynamic 17 0 0
2234 # Metadata from INFORMATION_SCHEMA.COLUMNS
2235 NAME POS MTYPE PRTYPE HAS_DEFAULT
2236 c0 0 6 1027 0
2237 c1 1 5 16711932 0
2238 c2 2 6 1027 0
2239 c3 3 6 1283 0
2240 c4 4 6 1027 0
2241 c5 5 6 1283 0
2242 c6 6 6 1027 0
2243 c7 7 6 1283 0
2244 c8 8 6 1027 0
2245 c9 9 6 1283 0
2246 c10 10 6 1027 0
2247 c11 11 6 1283 0
2248 c12 12 6 1027 0
2249 c13 13 6 1283 0
2250 SHOW CREATE TABLE ta2b4_dynamic;;
2251 Table Create Table
2252 ta2b4_dynamic CREATE TABLE `ta2b4_dynamic` (
2253 `c0` int DEFAULT NULL,
2254 `c1` text,
2255 `c2` int DEFAULT NULL,
2256 `c3` int NOT NULL,
2257 `c4` int DEFAULT '40',
2258 `c5` int NOT NULL DEFAULT '50',
2259 `c6` int DEFAULT NULL,
2260 `c7` int NOT NULL,
2261 `c8` int DEFAULT '80',
2262 `c9` int NOT NULL DEFAULT '90',
2263 `c10` int DEFAULT NULL,
2264 `c11` int NOT NULL,
2265 `c12` int DEFAULT '120',
2266 `c13` int NOT NULL DEFAULT '130',
2267 PRIMARY KEY (`c3`)
2268 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
2269 SELECT * FROM ta2b4_dynamic;;
2270 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
2271 1 row1 2 3 4 5 NULL 0 80 90 NULL 0 120 130
2272 2 row2 NULL 33 40 55 NULL 0 80 90 NULL 0 120 130
2273 13 row13 1222 1333 1444 1555 1666 1777 1888 1999 NULL 0 120 130
2274 5 row5 2002 3003 4004 5005 6006 7007 8008 9009 1010 1111 1212 1313
2275 14 row14 NULL 13333 40 15555 NULL 17777 80 19999 NULL 0 120 130
2276 6 row6 NULL 30030 40 50050 NULL 70070 80 90090 NULL 11110 120 13130
2277 CHECK TABLE ta2b4_dynamic;;
2278 Table Op Msg_type Msg_text
2279 test.ta2b4_dynamic check status OK
2280 # Run for ta4b1
2281 # Metadata from INFORMATION_SCHEMA.TABLES
2282 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2283 test/ta4b1_dynamic 13 6 0
2284 # Metadata from INFORMATION_SCHEMA.COLUMNS
2285 NAME POS MTYPE PRTYPE HAS_DEFAULT
2286 c0 0 6 1027 0
2287 c1 1 5 16711932 0
2288 c2 2 6 1027 0
2289 c3 3 6 1283 0
2290 c4 4 6 1027 0
2291 c5 5 6 1283 0
2292 c6 6 6 1027 1
2293 c7 7 6 1283 1
2294 c8 8 6 1027 1
2295 c9 9 6 1283 1
2296 SHOW CREATE TABLE ta4b1_dynamic;;
2297 Table Create Table
2298 ta4b1_dynamic CREATE TABLE `ta4b1_dynamic` (
2299 `c0` int DEFAULT NULL,
2300 `c1` text,
2301 `c2` int DEFAULT NULL,
2302 `c3` int NOT NULL,
2303 `c4` int DEFAULT '40',
2304 `c5` int NOT NULL DEFAULT '50',
2305 `c6` int DEFAULT NULL,
2306 `c7` int NOT NULL,
2307 `c8` int DEFAULT '80',
2308 `c9` int NOT NULL DEFAULT '90'
2309 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
2310 SELECT * FROM ta4b1_dynamic;;
2311 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
2312 1 row1 2 3 4 5 NULL 0 80 90
2313 2 row2 NULL 33 40 55 NULL 0 80 90
2314 3 row3 222 333 444 555 666 777 888 999
2315 4 row4 NULL 3333 40 5555 NULL 7777 80 9999
2316 13 row13 1222 1333 1444 1555 1666 1777 1888 1999
2317 14 row14 NULL 13333 40 15555 NULL 17777 80 19999
2318 CHECK TABLE ta4b1_dynamic;;
2319 Table Op Msg_type Msg_text
2320 test.ta4b1_dynamic check status OK
2321 ALTER TABLE ta4b1_dynamic ADD PRIMARY KEY (c3);;
2322 # Metadata from INFORMATION_SCHEMA.TABLES
2323 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2324 test/ta4b1_dynamic 13 0 0
2325 # Metadata from INFORMATION_SCHEMA.COLUMNS
2326 NAME POS MTYPE PRTYPE HAS_DEFAULT
2327 c0 0 6 1027 0
2328 c1 1 5 16711932 0
2329 c2 2 6 1027 0
2330 c3 3 6 1283 0
2331 c4 4 6 1027 0
2332 c5 5 6 1283 0
2333 c6 6 6 1027 0
2334 c7 7 6 1283 0
2335 c8 8 6 1027 0
2336 c9 9 6 1283 0
2337 SHOW CREATE TABLE ta4b1_dynamic;;
2338 Table Create Table
2339 ta4b1_dynamic CREATE TABLE `ta4b1_dynamic` (
2340 `c0` int DEFAULT NULL,
2341 `c1` text,
2342 `c2` int DEFAULT NULL,
2343 `c3` int NOT NULL,
2344 `c4` int DEFAULT '40',
2345 `c5` int NOT NULL DEFAULT '50',
2346 `c6` int DEFAULT NULL,
2347 `c7` int NOT NULL,
2348 `c8` int DEFAULT '80',
2349 `c9` int NOT NULL DEFAULT '90',
2350 PRIMARY KEY (`c3`)
2351 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
2352 SELECT * FROM ta4b1_dynamic;;
2353 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9
2354 1 row1 2 3 4 5 NULL 0 80 90
2355 2 row2 NULL 33 40 55 NULL 0 80 90
2356 3 row3 222 333 444 555 666 777 888 999
2357 13 row13 1222 1333 1444 1555 1666 1777 1888 1999
2358 4 row4 NULL 3333 40 5555 NULL 7777 80 9999
2359 14 row14 NULL 13333 40 15555 NULL 17777 80 19999
2360 CHECK TABLE ta4b1_dynamic;;
2361 Table Op Msg_type Msg_text
2362 test.ta4b1_dynamic check status OK
2363 # Run for ta4b2
2364 # Metadata from INFORMATION_SCHEMA.TABLES
2365 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2366 test/ta4b2_dynamic 17 6 2
2367 # Metadata from INFORMATION_SCHEMA.COLUMNS
2368 NAME POS MTYPE PRTYPE HAS_DEFAULT
2369 c0 0 6 1027 0
2370 c1 1 5 16711932 0
2371 c2 2 6 1027 0
2372 c3 3 6 1283 0
2373 c4 4 6 1027 0
2374 c5 5 6 1283 0
2375 c6 6 6 1027 1
2376 c7 7 6 1283 1
2377 c8 8 6 1027 1
2378 c9 9 6 1283 1
2379 c10 10 6 1027 1
2380 c11 11 6 1283 1
2381 c12 12 6 1027 1
2382 c13 13 6 1283 1
2383 SHOW CREATE TABLE ta4b2_dynamic;;
2384 Table Create Table
2385 ta4b2_dynamic CREATE TABLE `ta4b2_dynamic` (
2386 `c0` int DEFAULT NULL,
2387 `c1` text,
2388 `c2` int DEFAULT NULL,
2389 `c3` int NOT NULL,
2390 `c4` int DEFAULT '40',
2391 `c5` int NOT NULL DEFAULT '50',
2392 `c6` int DEFAULT NULL,
2393 `c7` int NOT NULL,
2394 `c8` int DEFAULT '80',
2395 `c9` int NOT NULL DEFAULT '90',
2396 `c10` int DEFAULT NULL,
2397 `c11` int NOT NULL,
2398 `c12` int DEFAULT '120',
2399 `c13` int NOT NULL DEFAULT '130'
2400 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
2401 SELECT * FROM ta4b2_dynamic;;
2402 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
2403 1 row1 2 3 4 5 NULL 0 80 90 NULL 0 120 130
2404 2 row2 NULL 33 40 55 NULL 0 80 90 NULL 0 120 130
2405 3 row3 222 333 444 555 666 777 888 999 NULL 0 120 130
2406 4 row4 NULL 3333 40 5555 NULL 7777 80 9999 NULL 0 120 130
2407 13 row13 1222 1333 1444 1555 1666 1777 1888 1999 NULL 0 120 130
2408 14 row14 NULL 13333 40 15555 NULL 17777 80 19999 NULL 0 120 130
2409 CHECK TABLE ta4b2_dynamic;;
2410 Table Op Msg_type Msg_text
2411 test.ta4b2_dynamic check status OK
2412 ALTER TABLE ta4b2_dynamic ADD PRIMARY KEY (c3);;
2413 # Metadata from INFORMATION_SCHEMA.TABLES
2414 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2415 test/ta4b2_dynamic 17 0 0
2416 # Metadata from INFORMATION_SCHEMA.COLUMNS
2417 NAME POS MTYPE PRTYPE HAS_DEFAULT
2418 c0 0 6 1027 0
2419 c1 1 5 16711932 0
2420 c2 2 6 1027 0
2421 c3 3 6 1283 0
2422 c4 4 6 1027 0
2423 c5 5 6 1283 0
2424 c6 6 6 1027 0
2425 c7 7 6 1283 0
2426 c8 8 6 1027 0
2427 c9 9 6 1283 0
2428 c10 10 6 1027 0
2429 c11 11 6 1283 0
2430 c12 12 6 1027 0
2431 c13 13 6 1283 0
2432 SHOW CREATE TABLE ta4b2_dynamic;;
2433 Table Create Table
2434 ta4b2_dynamic CREATE TABLE `ta4b2_dynamic` (
2435 `c0` int DEFAULT NULL,
2436 `c1` text,
2437 `c2` int DEFAULT NULL,
2438 `c3` int NOT NULL,
2439 `c4` int DEFAULT '40',
2440 `c5` int NOT NULL DEFAULT '50',
2441 `c6` int DEFAULT NULL,
2442 `c7` int NOT NULL,
2443 `c8` int DEFAULT '80',
2444 `c9` int NOT NULL DEFAULT '90',
2445 `c10` int DEFAULT NULL,
2446 `c11` int NOT NULL,
2447 `c12` int DEFAULT '120',
2448 `c13` int NOT NULL DEFAULT '130',
2449 PRIMARY KEY (`c3`)
2450 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
2451 SELECT * FROM ta4b2_dynamic;;
2452 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
2453 1 row1 2 3 4 5 NULL 0 80 90 NULL 0 120 130
2454 2 row2 NULL 33 40 55 NULL 0 80 90 NULL 0 120 130
2455 3 row3 222 333 444 555 666 777 888 999 NULL 0 120 130
2456 13 row13 1222 1333 1444 1555 1666 1777 1888 1999 NULL 0 120 130
2457 4 row4 NULL 3333 40 5555 NULL 7777 80 9999 NULL 0 120 130
2458 14 row14 NULL 13333 40 15555 NULL 17777 80 19999 NULL 0 120 130
2459 CHECK TABLE ta4b2_dynamic;;
2460 Table Op Msg_type Msg_text
2461 test.ta4b2_dynamic check status OK
2462 # Run for ta4b4
2463 # Metadata from INFORMATION_SCHEMA.TABLES
2464 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2465 test/ta4b4_dynamic 17 6 2
2466 # Metadata from INFORMATION_SCHEMA.COLUMNS
2467 NAME POS MTYPE PRTYPE HAS_DEFAULT
2468 c0 0 6 1027 0
2469 c1 1 5 16711932 0
2470 c2 2 6 1027 0
2471 c3 3 6 1283 0
2472 c4 4 6 1027 0
2473 c5 5 6 1283 0
2474 c6 6 6 1027 1
2475 c7 7 6 1283 1
2476 c8 8 6 1027 1
2477 c9 9 6 1283 1
2478 c10 10 6 1027 1
2479 c11 11 6 1283 1
2480 c12 12 6 1027 1
2481 c13 13 6 1283 1
2482 SHOW CREATE TABLE ta4b4_dynamic;;
2483 Table Create Table
2484 ta4b4_dynamic CREATE TABLE `ta4b4_dynamic` (
2485 `c0` int DEFAULT NULL,
2486 `c1` text,
2487 `c2` int DEFAULT NULL,
2488 `c3` int NOT NULL,
2489 `c4` int DEFAULT '40',
2490 `c5` int NOT NULL DEFAULT '50',
2491 `c6` int DEFAULT NULL,
2492 `c7` int NOT NULL,
2493 `c8` int DEFAULT '80',
2494 `c9` int NOT NULL DEFAULT '90',
2495 `c10` int DEFAULT NULL,
2496 `c11` int NOT NULL,
2497 `c12` int DEFAULT '120',
2498 `c13` int NOT NULL DEFAULT '130'
2499 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
2500 SELECT * FROM ta4b4_dynamic;;
2501 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
2502 1 row1 2 3 4 5 NULL 0 80 90 NULL 0 120 130
2503 2 row2 NULL 33 40 55 NULL 0 80 90 NULL 0 120 130
2504 3 row3 222 333 444 555 666 777 888 999 NULL 0 120 130
2505 4 row4 NULL 3333 40 5555 NULL 7777 80 9999 NULL 0 120 130
2506 13 row13 1222 1333 1444 1555 1666 1777 1888 1999 NULL 0 120 130
2507 14 row14 NULL 13333 40 15555 NULL 17777 80 19999 NULL 0 120 130
2508 5 row5 2002 3003 4004 5005 6006 7007 8008 9009 1010 1111 1212 1313
2509 6 row6 NULL 30030 40 50050 NULL 70070 80 90090 NULL 11110 120 13130
2510 CHECK TABLE ta4b4_dynamic;;
2511 Table Op Msg_type Msg_text
2512 test.ta4b4_dynamic check status OK
2513 ALTER TABLE ta4b4_dynamic ADD PRIMARY KEY (c3);;
2514 # Metadata from INFORMATION_SCHEMA.TABLES
2515 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS
2516 test/ta4b4_dynamic 17 0 0
2517 # Metadata from INFORMATION_SCHEMA.COLUMNS
2518 NAME POS MTYPE PRTYPE HAS_DEFAULT
2519 c0 0 6 1027 0
2520 c1 1 5 16711932 0
2521 c2 2 6 1027 0
2522 c3 3 6 1283 0
2523 c4 4 6 1027 0
2524 c5 5 6 1283 0
2525 c6 6 6 1027 0
2526 c7 7 6 1283 0
2527 c8 8 6 1027 0
2528 c9 9 6 1283 0
2529 c10 10 6 1027 0
2530 c11 11 6 1283 0
2531 c12 12 6 1027 0
2532 c13 13 6 1283 0
2533 SHOW CREATE TABLE ta4b4_dynamic;;
2534 Table Create Table
2535 ta4b4_dynamic CREATE TABLE `ta4b4_dynamic` (
2536 `c0` int DEFAULT NULL,
2537 `c1` text,
2538 `c2` int DEFAULT NULL,
2539 `c3` int NOT NULL,
2540 `c4` int DEFAULT '40',
2541 `c5` int NOT NULL DEFAULT '50',
2542 `c6` int DEFAULT NULL,
2543 `c7` int NOT NULL,
2544 `c8` int DEFAULT '80',
2545 `c9` int NOT NULL DEFAULT '90',
2546 `c10` int DEFAULT NULL,
2547 `c11` int NOT NULL,
2548 `c12` int DEFAULT '120',
2549 `c13` int NOT NULL DEFAULT '130',
2550 PRIMARY KEY (`c3`)
2551 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
2552 SELECT * FROM ta4b4_dynamic;;
2553 c0 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13
2554 1 row1 2 3 4 5 NULL 0 80 90 NULL 0 120 130
2555 2 row2 NULL 33 40 55 NULL 0 80 90 NULL 0 120 130
2556 3 row3 222 333 444 555 666 777 888 999 NULL 0 120 130
2557 13 row13 1222 1333 1444 1555 1666 1777 1888 1999 NULL 0 120 130
2558 5 row5 2002 3003 4004 5005 6006 7007 8008 9009 1010 1111 1212 1313
2559 4 row4 NULL 3333 40 5555 NULL 7777 80 9999 NULL 0 120 130
2560 14 row14 NULL 13333 40 15555 NULL 17777 80 19999 NULL 0 120 130
2561 6 row6 NULL 30030 40 50050 NULL 70070 80 90090 NULL 11110 120 13130
2562 CHECK TABLE ta4b4_dynamic;;
2563 Table Op Msg_type Msg_text
2564 test.ta4b4_dynamic check status OK
2565 # Cleanup
2566 # Shutdown server
2567 # Remove temp files used
2568 # Restart server to restore server state
2569 # restart