Debian Codegraph @

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

raw
1 # Import an .ibd from 5.7
2 create table t1 (a INT, b INT, c BLOB, PRIMARY KEY (a,b), d TEXT) CHARSET=latin1;
3 ALTER TABLE t1 DISCARD TABLESPACE;
4 # copy 5.7 .ibd and .cfg
5 ALTER TABLE t1 IMPORT TABLESPACE;
6 SELECT * FROM t1;
7 a b c d
8 1 1 satya narayana
9 2 2 satti narayana
10 3 3 satti narayana
11 4 4 sreenika sita
12 ["ibd2sdi"
13 ,
14 {
15 "type": 1,
16 "id": X,
17 "object":
18 {
19 "mysqld_version_id": X,
20 "dd_version": X,
21 "sdi_version": X,
22 "dd_object_type": "Table",
23 "dd_object": {
24 "name": "t1",
25 "mysql_version_id": X,
26 "created": NNN,
27 "last_altered": NNN,
28 "hidden": 1,
29 "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;",
30 "columns": [
31 {
32 "name": "a",
33 "type": 4,
34 "is_nullable": false,
35 "is_zerofill": false,
36 "is_unsigned": false,
37 "is_auto_increment": false,
38 "is_virtual": false,
39 "hidden": 1,
40 "ordinal_position": 1,
41 "char_length": 11,
42 "numeric_precision": 10,
43 "numeric_scale": 0,
44 "numeric_scale_null": false,
45 "datetime_precision": 0,
46 "datetime_precision_null": 1,
47 "has_no_default": true,
48 "default_value_null": false,
49 "srs_id_null": true,
50 "srs_id": 0,
51 "default_value": "AAAAAA==",
52 "default_value_utf8_null": true,
53 "default_value_utf8": "",
54 "default_option": "",
55 "update_option": "",
56 "comment": "",
57 "generation_expression": "",
58 "generation_expression_utf8": "",
59 "options": "interval_count=0;",
60 "se_private_data": "table_id=X",
61 "engine_attribute": "",
62 "secondary_engine_attribute": "",
63 "column_key": 2,
64 "column_type_utf8": "int",
65 "elements": [],
66 "collation_id": 8,
67 "is_explicit_collation": false
68 },
69 {
70 "name": "b",
71 "type": 4,
72 "is_nullable": false,
73 "is_zerofill": false,
74 "is_unsigned": false,
75 "is_auto_increment": false,
76 "is_virtual": false,
77 "hidden": 1,
78 "ordinal_position": 2,
79 "char_length": 11,
80 "numeric_precision": 10,
81 "numeric_scale": 0,
82 "numeric_scale_null": false,
83 "datetime_precision": 0,
84 "datetime_precision_null": 1,
85 "has_no_default": true,
86 "default_value_null": false,
87 "srs_id_null": true,
88 "srs_id": 0,
89 "default_value": "AAAAAA==",
90 "default_value_utf8_null": true,
91 "default_value_utf8": "",
92 "default_option": "",
93 "update_option": "",
94 "comment": "",
95 "generation_expression": "",
96 "generation_expression_utf8": "",
97 "options": "interval_count=0;",
98 "se_private_data": "table_id=X",
99 "engine_attribute": "",
100 "secondary_engine_attribute": "",
101 "column_key": 2,
102 "column_type_utf8": "int",
103 "elements": [],
104 "collation_id": 8,
105 "is_explicit_collation": false
106 },
107 {
108 "name": "c",
109 "type": 27,
110 "is_nullable": true,
111 "is_zerofill": false,
112 "is_unsigned": false,
113 "is_auto_increment": false,
114 "is_virtual": false,
115 "hidden": 1,
116 "ordinal_position": 3,
117 "char_length": 65535,
118 "numeric_precision": 0,
119 "numeric_scale": 0,
120 "numeric_scale_null": true,
121 "datetime_precision": 0,
122 "datetime_precision_null": 1,
123 "has_no_default": false,
124 "default_value_null": true,
125 "srs_id_null": true,
126 "srs_id": 0,
127 "default_value": "",
128 "default_value_utf8_null": true,
129 "default_value_utf8": "",
130 "default_option": "",
131 "update_option": "",
132 "comment": "",
133 "generation_expression": "",
134 "generation_expression_utf8": "",
135 "options": "interval_count=0;",
136 "se_private_data": "table_id=X",
137 "engine_attribute": "",
138 "secondary_engine_attribute": "",
139 "column_key": 1,
140 "column_type_utf8": "blob",
141 "elements": [],
142 "collation_id": 63,
143 "is_explicit_collation": true
144 },
145 {
146 "name": "d",
147 "type": 27,
148 "is_nullable": true,
149 "is_zerofill": false,
150 "is_unsigned": false,
151 "is_auto_increment": false,
152 "is_virtual": false,
153 "hidden": 1,
154 "ordinal_position": 4,
155 "char_length": 65535,
156 "numeric_precision": 0,
157 "numeric_scale": 0,
158 "numeric_scale_null": true,
159 "datetime_precision": 0,
160 "datetime_precision_null": 1,
161 "has_no_default": false,
162 "default_value_null": true,
163 "srs_id_null": true,
164 "srs_id": 0,
165 "default_value": "",
166 "default_value_utf8_null": true,
167 "default_value_utf8": "",
168 "default_option": "",
169 "update_option": "",
170 "comment": "",
171 "generation_expression": "",
172 "generation_expression_utf8": "",
173 "options": "interval_count=0;",
174 "se_private_data": "table_id=X",
175 "engine_attribute": "",
176 "secondary_engine_attribute": "",
177 "column_key": 1,
178 "column_type_utf8": "text",
179 "elements": [],
180 "collation_id": 8,
181 "is_explicit_collation": false
182 },
183 {
184 "name": "DB_TRX_ID",
185 "type": 10,
186 "is_nullable": false,
187 "is_zerofill": false,
188 "is_unsigned": false,
189 "is_auto_increment": false,
190 "is_virtual": false,
191 "hidden": 2,
192 "ordinal_position": 5,
193 "char_length": 6,
194 "numeric_precision": 0,
195 "numeric_scale": 0,
196 "numeric_scale_null": true,
197 "datetime_precision": 0,
198 "datetime_precision_null": 1,
199 "has_no_default": false,
200 "default_value_null": true,
201 "srs_id_null": true,
202 "srs_id": 0,
203 "default_value": "",
204 "default_value_utf8_null": true,
205 "default_value_utf8": "",
206 "default_option": "",
207 "update_option": "",
208 "comment": "",
209 "generation_expression": "",
210 "generation_expression_utf8": "",
211 "options": "",
212 "se_private_data": "table_id=X",
213 "engine_attribute": "",
214 "secondary_engine_attribute": "",
215 "column_key": 1,
216 "column_type_utf8": "",
217 "elements": [],
218 "collation_id": 63,
219 "is_explicit_collation": false
220 },
221 {
222 "name": "DB_ROLL_PTR",
223 "type": 9,
224 "is_nullable": false,
225 "is_zerofill": false,
226 "is_unsigned": false,
227 "is_auto_increment": false,
228 "is_virtual": false,
229 "hidden": 2,
230 "ordinal_position": 6,
231 "char_length": 7,
232 "numeric_precision": 0,
233 "numeric_scale": 0,
234 "numeric_scale_null": true,
235 "datetime_precision": 0,
236 "datetime_precision_null": 1,
237 "has_no_default": false,
238 "default_value_null": true,
239 "srs_id_null": true,
240 "srs_id": 0,
241 "default_value": "",
242 "default_value_utf8_null": true,
243 "default_value_utf8": "",
244 "default_option": "",
245 "update_option": "",
246 "comment": "",
247 "generation_expression": "",
248 "generation_expression_utf8": "",
249 "options": "",
250 "se_private_data": "table_id=X",
251 "engine_attribute": "",
252 "secondary_engine_attribute": "",
253 "column_key": 1,
254 "column_type_utf8": "",
255 "elements": [],
256 "collation_id": 63,
257 "is_explicit_collation": false
258 }
259 ],
260 "schema_ref": "test",
261 "se_private_id":NNN,
262 "engine": "InnoDB",
263 "last_checked_for_upgrade_version_id": X,
264 "comment": "",
265 "se_private_data": "discard=0;",
266 "engine_attribute": "",
267 "secondary_engine_attribute": "",
268 "row_format": 2,
269 "partition_type": 0,
270 "partition_expression": "",
271 "partition_expression_utf8": "",
272 "default_partitioning": 0,
273 "subpartition_type": 0,
274 "subpartition_expression": "",
275 "subpartition_expression_utf8": "",
276 "default_subpartitioning": 0,
277 "indexes": [
278 {
279 "name": "PRIMARY",
280 "hidden": false,
281 "is_generated": false,
282 "ordinal_position": 1,
283 "comment": "",
284 "options": "flags=0;",
285 "se_private_data": "id=A;root=B;space_id=C,table_id=D,trx_id=E",
286 "type": 1,
287 "algorithm": 2,
288 "is_algorithm_explicit": false,
289 "is_visible": true,
290 "engine": "InnoDB",
291 "engine_attribute": "",
292 "secondary_engine_attribute": "",
293 "elements": [
294 {
295 "ordinal_position": 1,
296 "length": 4,
297 "order": 2,
298 "hidden": false,
299 "column_opx": 0
300 },
301 {
302 "ordinal_position": 2,
303 "length": 4,
304 "order": 2,
305 "hidden": false,
306 "column_opx": 1
307 },
308 {
309 "ordinal_position": 3,
310 "length": 4294967295,
311 "order": 2,
312 "hidden": true,
313 "column_opx": 4
314 },
315 {
316 "ordinal_position": 4,
317 "length": 4294967295,
318 "order": 2,
319 "hidden": true,
320 "column_opx": 5
321 },
322 {
323 "ordinal_position": 5,
324 "length": 4294967295,
325 "order": 2,
326 "hidden": true,
327 "column_opx": 2
328 },
329 {
330 "ordinal_position": 6,
331 "length": 4294967295,
332 "order": 2,
333 "hidden": true,
334 "column_opx": 3
335 }
336 ],
337 "tablespace_ref": "test/t1"
338 }
339 ],
340 "foreign_keys": [],
341 "check_constraints": [],
342 "partitions": [],
343 "collation_id": 8
344 }
345 }
346 }
347 ,
348 {
349 "type": 2,
350 "id": X,
351 "object":
352 {
353 "mysqld_version_id": X,
354 "dd_version": X,
355 "sdi_version": X,
356 "dd_object_type": "Tablespace",
357 "dd_object": {
358 "name": "test/t1",
359 "comment": "",
360 "options": "autoextend_size=0;encryption=N;",
361 "se_private_data": "flags=X;id=Y;server_version=Z;space_version=M;state=normal;",
362 "engine": "InnoDB",
363 "engine_attribute": "",
364 "files": [
365 {
366 "ordinal_position": 1,
367 "filename": "./test/t1.ibd",
368 "se_private_data": "id=X"
369 }
370 ]
371 }
372 }
373 }
374 ]
375 # restart
376 DROP TABLE t1;