Debian Codegraph @

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

raw
1 CREATE TABLE t1(a INT PRIMARY KEY, b JSON, c BLOB, d LONGBLOB, e MEDIUMBLOB, f TINYBLOB);
2 # stop purge so that ibd2sdi can see delete-marked
3 # records
4 SET GLOBAL innodb_purge_stop_now = ON;
5 # do ALTER which are meta-data change only. This will
6 # delete current SDI and insert a fresh SDI
7 ALTER TABLE t1 CHANGE a pk INT;
8 ALTER TABLE t1 CHANGE pk pk2 INT;
9 ALTER TABLE t1 CHANGE pk2 pk3 INT;
10 ALTER TABLE t1 CHANGE pk3 pk4 INT;
11 ALTER TABLE t1 CHANGE b b1 JSON;
12 ALTER TABLE t1 CHANGE c c2 BLOB;
13 ALTER TABLE t1 CHANGE d d2 LONGBLOB;
14 ALTER TABLE t1 CHANGE e e2 MEDIUMBLOB;
15 ALTER TABLE t1 CHANGE f f2 TINYBLOB;
16 SET GLOBAL DEBUG= '+d, skip_purge_check_shutdown';
17 ["ibd2sdi"
18 ,
19 {
20 "type": 1,
21 "id": X,
22 "object":
23 {
24 "mysqld_version_id": X,
25 "dd_version": X,
26 "sdi_version": X,
27 "dd_object_type": "Table",
28 "dd_object": {
29 "name": "t1",
30 "mysql_version_id": X,
31 "created": NNN,
32 "last_altered": NNN,
33 "hidden": 1,
34 "options": "avg_row_length=0;encrypt_type=N;key_block_size=0;keys_disabled=0;pack_record=1;stats_auto_recalc=0;stats_sample_pages=0;",
35 "columns": [
36 {
37 "name": "pk4",
38 "type": 4,
39 "is_nullable": false,
40 "is_zerofill": false,
41 "is_unsigned": false,
42 "is_auto_increment": false,
43 "is_virtual": false,
44 "hidden": 1,
45 "ordinal_position": 1,
46 "char_length": 11,
47 "numeric_precision": 10,
48 "numeric_scale": 0,
49 "numeric_scale_null": false,
50 "datetime_precision": 0,
51 "datetime_precision_null": 1,
52 "has_no_default": true,
53 "default_value_null": false,
54 "srs_id_null": true,
55 "srs_id": 0,
56 "default_value": "AAAAAA==",
57 "default_value_utf8_null": true,
58 "default_value_utf8": "",
59 "default_option": "",
60 "update_option": "",
61 "comment": "",
62 "generation_expression": "",
63 "generation_expression_utf8": "",
64 "options": "interval_count=0;",
65 "se_private_data": "table_id=X",
66 "engine_attribute": "",
67 "secondary_engine_attribute": "",
68 "column_key": 2,
69 "column_type_utf8": "int",
70 "elements": [],
71 "collation_id": 8,
72 "is_explicit_collation": false
73 },
74 {
75 "name": "b1",
76 "type": 31,
77 "is_nullable": true,
78 "is_zerofill": false,
79 "is_unsigned": false,
80 "is_auto_increment": false,
81 "is_virtual": false,
82 "hidden": 1,
83 "ordinal_position": 2,
84 "char_length": 4294967295,
85 "numeric_precision": 0,
86 "numeric_scale": 0,
87 "numeric_scale_null": true,
88 "datetime_precision": 0,
89 "datetime_precision_null": 1,
90 "has_no_default": false,
91 "default_value_null": true,
92 "srs_id_null": true,
93 "srs_id": 0,
94 "default_value": "",
95 "default_value_utf8_null": true,
96 "default_value_utf8": "",
97 "default_option": "",
98 "update_option": "",
99 "comment": "",
100 "generation_expression": "",
101 "generation_expression_utf8": "",
102 "options": "interval_count=0;",
103 "se_private_data": "table_id=X",
104 "engine_attribute": "",
105 "secondary_engine_attribute": "",
106 "column_key": 1,
107 "column_type_utf8": "json",
108 "elements": [],
109 "collation_id": 46,
110 "is_explicit_collation": true
111 },
112 {
113 "name": "c2",
114 "type": 27,
115 "is_nullable": true,
116 "is_zerofill": false,
117 "is_unsigned": false,
118 "is_auto_increment": false,
119 "is_virtual": false,
120 "hidden": 1,
121 "ordinal_position": 3,
122 "char_length": 65535,
123 "numeric_precision": 0,
124 "numeric_scale": 0,
125 "numeric_scale_null": true,
126 "datetime_precision": 0,
127 "datetime_precision_null": 1,
128 "has_no_default": false,
129 "default_value_null": true,
130 "srs_id_null": true,
131 "srs_id": 0,
132 "default_value": "",
133 "default_value_utf8_null": true,
134 "default_value_utf8": "",
135 "default_option": "",
136 "update_option": "",
137 "comment": "",
138 "generation_expression": "",
139 "generation_expression_utf8": "",
140 "options": "interval_count=0;",
141 "se_private_data": "table_id=X",
142 "engine_attribute": "",
143 "secondary_engine_attribute": "",
144 "column_key": 1,
145 "column_type_utf8": "blob",
146 "elements": [],
147 "collation_id": 63,
148 "is_explicit_collation": true
149 },
150 {
151 "name": "d2",
152 "type": 26,
153 "is_nullable": true,
154 "is_zerofill": false,
155 "is_unsigned": false,
156 "is_auto_increment": false,
157 "is_virtual": false,
158 "hidden": 1,
159 "ordinal_position": 4,
160 "char_length": 4294967295,
161 "numeric_precision": 0,
162 "numeric_scale": 0,
163 "numeric_scale_null": true,
164 "datetime_precision": 0,
165 "datetime_precision_null": 1,
166 "has_no_default": false,
167 "default_value_null": true,
168 "srs_id_null": true,
169 "srs_id": 0,
170 "default_value": "",
171 "default_value_utf8_null": true,
172 "default_value_utf8": "",
173 "default_option": "",
174 "update_option": "",
175 "comment": "",
176 "generation_expression": "",
177 "generation_expression_utf8": "",
178 "options": "interval_count=0;",
179 "se_private_data": "table_id=X",
180 "engine_attribute": "",
181 "secondary_engine_attribute": "",
182 "column_key": 1,
183 "column_type_utf8": "longblob",
184 "elements": [],
185 "collation_id": 63,
186 "is_explicit_collation": true
187 },
188 {
189 "name": "e2",
190 "type": 25,
191 "is_nullable": true,
192 "is_zerofill": false,
193 "is_unsigned": false,
194 "is_auto_increment": false,
195 "is_virtual": false,
196 "hidden": 1,
197 "ordinal_position": 5,
198 "char_length": 16777215,
199 "numeric_precision": 0,
200 "numeric_scale": 0,
201 "numeric_scale_null": true,
202 "datetime_precision": 0,
203 "datetime_precision_null": 1,
204 "has_no_default": false,
205 "default_value_null": true,
206 "srs_id_null": true,
207 "srs_id": 0,
208 "default_value": "",
209 "default_value_utf8_null": true,
210 "default_value_utf8": "",
211 "default_option": "",
212 "update_option": "",
213 "comment": "",
214 "generation_expression": "",
215 "generation_expression_utf8": "",
216 "options": "interval_count=0;",
217 "se_private_data": "table_id=X",
218 "engine_attribute": "",
219 "secondary_engine_attribute": "",
220 "column_key": 1,
221 "column_type_utf8": "mediumblob",
222 "elements": [],
223 "collation_id": 63,
224 "is_explicit_collation": true
225 },
226 {
227 "name": "f2",
228 "type": 24,
229 "is_nullable": true,
230 "is_zerofill": false,
231 "is_unsigned": false,
232 "is_auto_increment": false,
233 "is_virtual": false,
234 "hidden": 1,
235 "ordinal_position": 6,
236 "char_length": 255,
237 "numeric_precision": 0,
238 "numeric_scale": 0,
239 "numeric_scale_null": true,
240 "datetime_precision": 0,
241 "datetime_precision_null": 1,
242 "has_no_default": false,
243 "default_value_null": true,
244 "srs_id_null": true,
245 "srs_id": 0,
246 "default_value": "",
247 "default_value_utf8_null": true,
248 "default_value_utf8": "",
249 "default_option": "",
250 "update_option": "",
251 "comment": "",
252 "generation_expression": "",
253 "generation_expression_utf8": "",
254 "options": "interval_count=0;",
255 "se_private_data": "table_id=X",
256 "engine_attribute": "",
257 "secondary_engine_attribute": "",
258 "column_key": 1,
259 "column_type_utf8": "tinyblob",
260 "elements": [],
261 "collation_id": 63,
262 "is_explicit_collation": true
263 },
264 {
265 "name": "DB_TRX_ID",
266 "type": 10,
267 "is_nullable": false,
268 "is_zerofill": false,
269 "is_unsigned": false,
270 "is_auto_increment": false,
271 "is_virtual": false,
272 "hidden": 2,
273 "ordinal_position": 7,
274 "char_length": 6,
275 "numeric_precision": 0,
276 "numeric_scale": 0,
277 "numeric_scale_null": true,
278 "datetime_precision": 0,
279 "datetime_precision_null": 1,
280 "has_no_default": false,
281 "default_value_null": true,
282 "srs_id_null": true,
283 "srs_id": 0,
284 "default_value": "",
285 "default_value_utf8_null": true,
286 "default_value_utf8": "",
287 "default_option": "",
288 "update_option": "",
289 "comment": "",
290 "generation_expression": "",
291 "generation_expression_utf8": "",
292 "options": "",
293 "se_private_data": "table_id=X",
294 "engine_attribute": "",
295 "secondary_engine_attribute": "",
296 "column_key": 1,
297 "column_type_utf8": "",
298 "elements": [],
299 "collation_id": 63,
300 "is_explicit_collation": false
301 },
302 {
303 "name": "DB_ROLL_PTR",
304 "type": 9,
305 "is_nullable": false,
306 "is_zerofill": false,
307 "is_unsigned": false,
308 "is_auto_increment": false,
309 "is_virtual": false,
310 "hidden": 2,
311 "ordinal_position": 8,
312 "char_length": 7,
313 "numeric_precision": 0,
314 "numeric_scale": 0,
315 "numeric_scale_null": true,
316 "datetime_precision": 0,
317 "datetime_precision_null": 1,
318 "has_no_default": false,
319 "default_value_null": true,
320 "srs_id_null": true,
321 "srs_id": 0,
322 "default_value": "",
323 "default_value_utf8_null": true,
324 "default_value_utf8": "",
325 "default_option": "",
326 "update_option": "",
327 "comment": "",
328 "generation_expression": "",
329 "generation_expression_utf8": "",
330 "options": "",
331 "se_private_data": "table_id=X",
332 "engine_attribute": "",
333 "secondary_engine_attribute": "",
334 "column_key": 1,
335 "column_type_utf8": "",
336 "elements": [],
337 "collation_id": 63,
338 "is_explicit_collation": false
339 }
340 ],
341 "schema_ref": "test",
342 "se_private_id":NNN,
343 "engine": "InnoDB",
344 "last_checked_for_upgrade_version_id": X,
345 "comment": "",
346 "se_private_data": "",
347 "engine_attribute": "",
348 "secondary_engine_attribute": "",
349 "row_format": 2,
350 "partition_type": 0,
351 "partition_expression": "",
352 "partition_expression_utf8": "",
353 "default_partitioning": 0,
354 "subpartition_type": 0,
355 "subpartition_expression": "",
356 "subpartition_expression_utf8": "",
357 "default_subpartitioning": 0,
358 "indexes": [
359 {
360 "name": "PRIMARY",
361 "hidden": false,
362 "is_generated": false,
363 "ordinal_position": 1,
364 "comment": "",
365 "options": "flags=0;",
366 "se_private_data": "id=A;root=B;space_id=C,table_id=D,trx_id=E",
367 "type": 1,
368 "algorithm": 2,
369 "is_algorithm_explicit": false,
370 "is_visible": true,
371 "engine": "InnoDB",
372 "engine_attribute": "",
373 "secondary_engine_attribute": "",
374 "elements": [
375 {
376 "ordinal_position": 1,
377 "length": 4,
378 "order": 2,
379 "hidden": false,
380 "column_opx": 0
381 },
382 {
383 "ordinal_position": 2,
384 "length": 4294967295,
385 "order": 2,
386 "hidden": true,
387 "column_opx": 6
388 },
389 {
390 "ordinal_position": 3,
391 "length": 4294967295,
392 "order": 2,
393 "hidden": true,
394 "column_opx": 7
395 },
396 {
397 "ordinal_position": 4,
398 "length": 4294967295,
399 "order": 2,
400 "hidden": true,
401 "column_opx": 1
402 },
403 {
404 "ordinal_position": 5,
405 "length": 4294967295,
406 "order": 2,
407 "hidden": true,
408 "column_opx": 2
409 },
410 {
411 "ordinal_position": 6,
412 "length": 4294967295,
413 "order": 2,
414 "hidden": true,
415 "column_opx": 3
416 },
417 {
418 "ordinal_position": 7,
419 "length": 4294967295,
420 "order": 2,
421 "hidden": true,
422 "column_opx": 4
423 },
424 {
425 "ordinal_position": 8,
426 "length": 4294967295,
427 "order": 2,
428 "hidden": true,
429 "column_opx": 5
430 }
431 ],
432 "tablespace_ref": "test/t1"
433 }
434 ],
435 "foreign_keys": [],
436 "check_constraints": [],
437 "partitions": [],
438 "collation_id": 255
439 }
440 }
441 }
442 ,
443 {
444 "type": 2,
445 "id": X,
446 "object":
447 {
448 "mysqld_version_id": X,
449 "dd_version": X,
450 "sdi_version": X,
451 "dd_object_type": "Tablespace",
452 "dd_object": {
453 "name": "test/t1",
454 "comment": "",
455 "options": "autoextend_size=0;encryption=N;",
456 "se_private_data": "flags=X;id=Y;server_version=Z;space_version=M;state=normal;",
457 "engine": "InnoDB",
458 "engine_attribute": "",
459 "files": [
460 {
461 "ordinal_position": 1,
462 "filename": "./test/t1.ibd",
463 "se_private_data": "id=X"
464 }
465 ]
466 }
467 }
468 }
469 ]
470 # restart
471 DROP TABLE t1;