Debian Codegraph @

test/command/suite/wal_recover/ja/update/chunk/free_2_ginfos.expected

raw
1 table_create Memos TABLE_HASH_KEY ShortText
2 [[0,0.0,0.0],true]
3 column_create Memos content COLUMN_SCALAR Text
4 [[0,0.0,0.0],true]
5 io_flush
6 [[0,0.0,0.0],true]
7 check --obj Memos.content
8 [
9 [
10 0,
11 0.0,
12 0.0
13 ],
14 {
15 "details": {
16 "segments": [
17 {
18 "id": 0,
19 "type": 3,
20 "type_name": "element info",
21 "element_info_index": 0,
22 "referred_segment": 0,
23 "valid": true
24 },
25 {
26 "id": 1,
27 "type": 2,
28 "type_name": "huge",
29 "value": 0
30 },
31 {
32 "id": 2,
33 "type": 2,
34 "type_name": "huge",
35 "value": 0
36 }
37 ],
38 "garbage_counts": {},
39 "free_elements": {}
40 },
41 "summary": {
42 "flags": "0000C000",
43 "curr seg": 0,
44 "curr pos": 4194304,
45 "max_element_size": 65536,
46 "chunk_threshold": 16,
47 "n_element_variations": 14,
48 "n_using_segments": 3,
49 "valid": true
50 }
51 }
52 ]
53 check --obj Memos.content
54 [
55 [
56 0,
57 0.0,
58 0.0
59 ],
60 {
61 "details": {
62 "segments": [
63 {
64 "id": 0,
65 "type": 3,
66 "type_name": "element info",
67 "element_info_index": 0,
68 "referred_segment": 0,
69 "valid": true
70 },
71 {
72 "id": 1,
73 "type": 2,
74 "type_name": "huge",
75 "value": 0
76 },
77 {
78 "id": 2,
79 "type": 2,
80 "type_name": "huge",
81 "value": 0
82 },
83 {
84 "id": 3,
85 "type": 0,
86 "type_name": "chunk",
87 "variation": 0
88 }
89 ],
90 "garbage_counts": {},
91 "free_elements": {
92 "0": {
93 "segment": 3,
94 "position": 1688,
95 "valid": true
96 }
97 }
98 },
99 "summary": {
100 "flags": "0000C000",
101 "curr seg": 0,
102 "curr pos": 4194304,
103 "max_element_size": 65536,
104 "chunk_threshold": 16,
105 "n_element_variations": 14,
106 "n_using_segments": 4,
107 "valid": true
108 }
109 }
110 ]
111 delete Memos --filter _id==3
112 [[0,0.0,0.0],true]
113 check --obj Memos.content
114 [
115 [
116 0,
117 0.0,
118 0.0
119 ],
120 {
121 "details": {
122 "segments": [
123 {
124 "id": 0,
125 "type": 3,
126 "type_name": "element info",
127 "element_info_index": 0,
128 "referred_segment": 0,
129 "valid": true
130 },
131 {
132 "id": 1,
133 "type": 2,
134 "type_name": "huge",
135 "value": 0
136 },
137 {
138 "id": 2,
139 "type": 2,
140 "type_name": "huge",
141 "value": 0
142 },
143 {
144 "id": 3,
145 "type": 0,
146 "type_name": "chunk",
147 "variation": 0
148 },
149 {
150 "id": 4,
151 "type": 4,
152 "type_name": "garbage info",
153 "variation": 0,
154 "head": 1,
155 "tail": 0,
156 "n_garbages": 1,
157 "next": 0,
158 "valid": true
159 }
160 ],
161 "garbage_counts": {
162 "0": {
163 "total": 1,
164 "details": {
165 "4": 1
166 },
167 "valid": true
168 }
169 },
170 "free_elements": {
171 "0": {
172 "segment": 3,
173 "position": 1688,
174 "valid": true
175 }
176 }
177 },
178 "summary": {
179 "flags": "0000C000",
180 "curr seg": 0,
181 "curr pos": 4194304,
182 "max_element_size": 65536,
183 "chunk_threshold": 16,
184 "n_element_variations": 14,
185 "n_using_segments": 5,
186 "valid": true
187 }
188 }
189 ]
190 delete Memos --filter _id<=2
191 [[0,0.0,0.0],true]
192 check --obj Memos.content
193 [
194 [
195 0,
196 0.0,
197 0.0
198 ],
199 {
200 "details": {
201 "segments": [
202 {
203 "id": 0,
204 "type": 3,
205 "type_name": "element info",
206 "element_info_index": 0,
207 "referred_segment": 0,
208 "valid": true
209 },
210 {
211 "id": 3,
212 "type": 0,
213 "type_name": "chunk",
214 "variation": 0
215 },
216 {
217 "id": 4,
218 "type": 4,
219 "type_name": "garbage info",
220 "variation": 0,
221 "head": 1,
222 "tail": 0,
223 "n_garbages": 1,
224 "next": 0,
225 "valid": true
226 }
227 ],
228 "garbage_counts": {
229 "0": {
230 "total": 1,
231 "details": {
232 "4": 1
233 },
234 "valid": true
235 }
236 },
237 "free_elements": {
238 "0": {
239 "segment": 3,
240 "position": 1688,
241 "valid": true
242 }
243 }
244 },
245 "summary": {
246 "flags": "0000C000",
247 "curr seg": 0,
248 "curr pos": 4194304,
249 "max_element_size": 65536,
250 "chunk_threshold": 16,
251 "n_element_variations": 14,
252 "n_using_segments": 3,
253 "valid": true
254 }
255 }
256 ]
257 delete Memos --filter true
258 [[0,0.0,0.0],true]
259 check --obj Memos.content
260 [
261 [
262 0,
263 0.0,
264 0.0
265 ],
266 {
267 "details": {
268 "segments": [
269 {
270 "id": 0,
271 "type": 3,
272 "type_name": "element info",
273 "element_info_index": 0,
274 "referred_segment": 0,
275 "valid": true
276 },
277 {
278 "id": 1,
279 "type": 4,
280 "type_name": "garbage info",
281 "variation": 0,
282 "head": 0,
283 "tail": 0,
284 "n_garbages": 100,
285 "next": 2,
286 "valid": true
287 },
288 {
289 "id": 2,
290 "type": 4,
291 "type_name": "garbage info",
292 "variation": 0,
293 "head": 11,
294 "tail": 0,
295 "n_garbages": 11,
296 "next": 0,
297 "valid": true
298 },
299 {
300 "id": 3,
301 "type": 0,
302 "type_name": "chunk",
303 "variation": 0
304 },
305 {
306 "id": 4,
307 "type": 4,
308 "type_name": "garbage info",
309 "variation": 0,
310 "head": 0,
311 "tail": 0,
312 "n_garbages": 100,
313 "next": 1,
314 "valid": true
315 }
316 ],
317 "garbage_counts": {
318 "0": {
319 "total": 211,
320 "details": {
321 "1": 100,
322 "2": 11,
323 "4": 100
324 },
325 "valid": true
326 }
327 },
328 "free_elements": {
329 "0": {
330 "segment": 3,
331 "position": 1688,
332 "valid": true
333 }
334 }
335 },
336 "summary": {
337 "flags": "0000C000",
338 "curr seg": 0,
339 "curr pos": 4194304,
340 "max_element_size": 65536,
341 "chunk_threshold": 16,
342 "n_element_variations": 14,
343 "n_using_segments": 5,
344 "valid": true
345 }
346 }
347 ]
348 check --obj Memos.content
349 [
350 [
351 0,
352 0.0,
353 0.0
354 ],
355 {
356 "details": {
357 "segments": [
358 {
359 "id": 0,
360 "type": 3,
361 "type_name": "element info",
362 "element_info_index": 0,
363 "referred_segment": 0,
364 "valid": true
365 },
366 {
367 "id": 2,
368 "type": 4,
369 "type_name": "garbage info",
370 "variation": 0,
371 "head": 11,
372 "tail": 1,
373 "n_garbages": 10,
374 "next": 0,
375 "valid": true
376 },
377 {
378 "id": 3,
379 "type": 0,
380 "type_name": "chunk",
381 "variation": 0
382 }
383 ],
384 "garbage_counts": {
385 "0": {
386 "total": 10,
387 "details": {
388 "2": 10
389 },
390 "valid": true
391 }
392 },
393 "free_elements": {
394 "0": {
395 "segment": 3,
396 "position": 1768,
397 "valid": true
398 }
399 }
400 },
401 "summary": {
402 "flags": "0000C000",
403 "curr seg": 0,
404 "curr pos": 4194304,
405 "max_element_size": 65536,
406 "chunk_threshold": 16,
407 "n_element_variations": 14,
408 "n_using_segments": 3,
409 "valid": true
410 }
411 }
412 ]
413 select Memos
414 [
415 [
416 0,
417 0.0,
418 0.0
419 ],
420 [
421 [
422 [
423 211
424 ],
425 [
426 [
427 "_id",
428 "UInt32"
429 ],
430 [
431 "_key",
432 "ShortText"
433 ],
434 [
435 "content",
436 "Text"
437 ]
438 ],
439 [
440 3,
441 "chunk: 8B <= && < 64KiB: 9",
442 "chunkXXX"
443 ],
444 [
445 4,
446 "chunk: 8B <= && < 64KiB: 8",
447 "chunkXXX"
448 ],
449 [
450 5,
451 "chunk: 8B <= && < 64KiB: 7",
452 "chunkXXX"
453 ],
454 [
455 6,
456 "chunk: 8B <= && < 64KiB: 6",
457 "chunkXXX"
458 ],
459 [
460 7,
461 "chunk: 8B <= && < 64KiB: 5",
462 "chunkXXX"
463 ],
464 [
465 8,
466 "chunk: 8B <= && < 64KiB: 4",
467 "chunkXXX"
468 ],
469 [
470 9,
471 "chunk: 8B <= && < 64KiB: 3",
472 "chunkXXX"
473 ],
474 [
475 10,
476 "chunk: 8B <= && < 64KiB: 2",
477 "chunkXXX"
478 ],
479 [
480 11,
481 "chunk: 8B <= && < 64KiB: 1",
482 "chunkXXX"
483 ],
484 [
485 12,
486 "chunk: 8B <= && < 64KiB: 99",
487 "chunkXXX"
488 ]
489 ]
490 ]
491 ]
492 _database_close
493 [[0,0.0,0.0],true]
494 _database_reopen
495 [[0,0.0,0.0],true]
496 select Memos
497 [
498 [
499 0,
500 0.0,
501 0.0
502 ],
503 [
504 [
505 [
506 211
507 ],
508 [
509 [
510 "_id",
511 "UInt32"
512 ],
513 [
514 "_key",
515 "ShortText"
516 ],
517 [
518 "content",
519 "Text"
520 ]
521 ],
522 [
523 3,
524 "chunk: 8B <= && < 64KiB: 9",
525 "chunkXXX"
526 ],
527 [
528 4,
529 "chunk: 8B <= && < 64KiB: 8",
530 "chunkXXX"
531 ],
532 [
533 5,
534 "chunk: 8B <= && < 64KiB: 7",
535 "chunkXXX"
536 ],
537 [
538 6,
539 "chunk: 8B <= && < 64KiB: 6",
540 "chunkXXX"
541 ],
542 [
543 7,
544 "chunk: 8B <= && < 64KiB: 5",
545 "chunkXXX"
546 ],
547 [
548 8,
549 "chunk: 8B <= && < 64KiB: 4",
550 "chunkXXX"
551 ],
552 [
553 9,
554 "chunk: 8B <= && < 64KiB: 3",
555 "chunkXXX"
556 ],
557 [
558 10,
559 "chunk: 8B <= && < 64KiB: 2",
560 "chunkXXX"
561 ],
562 [
563 11,
564 "chunk: 8B <= && < 64KiB: 1",
565 "chunkXXX"
566 ],
567 [
568 12,
569 "chunk: 8B <= && < 64KiB: 99",
570 "chunkXXX"
571 ]
572 ]
573 ]
574 ]
575 check --obj Memos.content
576 [
577 [
578 0,
579 0.0,
580 0.0
581 ],
582 {
583 "details": {
584 "segments": [
585 {
586 "id": 0,
587 "type": 3,
588 "type_name": "element info",
589 "element_info_index": 0,
590 "referred_segment": 0,
591 "valid": true
592 },
593 {
594 "id": 2,
595 "type": 4,
596 "type_name": "garbage info",
597 "variation": 0,
598 "head": 11,
599 "tail": 1,
600 "n_garbages": 10,
601 "next": 0,
602 "valid": true
603 },
604 {
605 "id": 3,
606 "type": 0,
607 "type_name": "chunk",
608 "variation": 0
609 }
610 ],
611 "garbage_counts": {
612 "0": {
613 "total": 10,
614 "details": {
615 "2": 10
616 },
617 "valid": true
618 }
619 },
620 "free_elements": {
621 "0": {
622 "segment": 3,
623 "position": 1768,
624 "valid": true
625 }
626 }
627 },
628 "summary": {
629 "flags": "0000C000",
630 "curr seg": 0,
631 "curr pos": 4194304,
632 "max_element_size": 65536,
633 "chunk_threshold": 16,
634 "n_element_variations": 14,
635 "n_using_segments": 3,
636 "valid": true
637 }
638 }
639 ]