Debian Codegraph @

test/command/suite/wal_recover/ja/add/sequential.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": 1,
28 "type_name": "sequential",
29 "value": 65544,
30 "n_elements": 1,
31 "s_elements": 65544,
32 "n_del_elements": 0,
33 "s_del_elements": 0
34 }
35 ],
36 "garbage_counts": {},
37 "free_elements": {}
38 },
39 "summary": {
40 "flags": "0000C000",
41 "curr seg": 1,
42 "curr pos": 65544,
43 "max_element_size": 65536,
44 "chunk_threshold": 16,
45 "n_element_variations": 14,
46 "n_using_segments": 2,
47 "valid": true
48 }
49 }
50 ]
51 plugin_register functions/string
52 [[0,0.0,0.0],true]
53 select --table Memos --columns[content_head].stage output --columns[content_head].flags COLUMN_SCALAR --columns[content_head].type ShortText --columns[content_head].value 'string_slice(content, 0, 5)' --columns[content_tail].stage output --columns[content_tail].flags COLUMN_SCALAR --columns[content_tail].type ShortText --columns[content_tail].value 'string_slice(content, -5, 5)' --columns[content_length].stage output --columns[content_length].flags COLUMN_SCALAR --columns[content_length].type UInt32 --columns[content_length].value 'string_length(content)' --output_columns _key,content_head,content_tail,content_length
54 [
55 [
56 0,
57 0.0,
58 0.0
59 ],
60 [
61 [
62 [
63 1
64 ],
65 [
66 [
67 "_key",
68 "ShortText"
69 ],
70 [
71 "content_head",
72 "ShortText"
73 ],
74 [
75 "content_tail",
76 "ShortText"
77 ],
78 [
79 "content_length",
80 "UInt32"
81 ]
82 ],
83 [
84 "sequential: 64KiB < && < 4MiB",
85 "abcda",
86 "abcdx",
87 65537
88 ]
89 ]
90 ]
91 ]
92 _database_close
93 [[0,0.0,0.0],true]
94 _database_reopen
95 [[0,0.0,0.0],true]
96 select --table Memos --columns[content_head].stage output --columns[content_head].flags COLUMN_SCALAR --columns[content_head].type ShortText --columns[content_head].value 'string_slice(content, 0, 5)' --columns[content_tail].stage output --columns[content_tail].flags COLUMN_SCALAR --columns[content_tail].type ShortText --columns[content_tail].value 'string_slice(content, -5, 5)' --columns[content_length].stage output --columns[content_length].flags COLUMN_SCALAR --columns[content_length].type UInt32 --columns[content_length].value 'string_length(content)' --output_columns _key,content_head,content_tail,content_length
97 [
98 [
99 0,
100 0.0,
101 0.0
102 ],
103 [
104 [
105 [
106 1
107 ],
108 [
109 [
110 "_key",
111 "ShortText"
112 ],
113 [
114 "content_head",
115 "ShortText"
116 ],
117 [
118 "content_tail",
119 "ShortText"
120 ],
121 [
122 "content_length",
123 "UInt32"
124 ]
125 ],
126 [
127 "sequential: 64KiB < && < 4MiB",
128 "abcda",
129 "abcdx",
130 65537
131 ]
132 ]
133 ]
134 ]
135 check --obj Memos.content
136 [
137 [
138 0,
139 0.0,
140 0.0
141 ],
142 {
143 "details": {
144 "segments": [
145 {
146 "id": 0,
147 "type": 3,
148 "type_name": "element info",
149 "element_info_index": 0,
150 "referred_segment": 0,
151 "valid": true
152 },
153 {
154 "id": 1,
155 "type": 1,
156 "type_name": "sequential",
157 "value": 65544,
158 "n_elements": 1,
159 "s_elements": 65544,
160 "n_del_elements": 0,
161 "s_del_elements": 0
162 }
163 ],
164 "garbage_counts": {},
165 "free_elements": {}
166 },
167 "summary": {
168 "flags": "0000C000",
169 "curr seg": 1,
170 "curr pos": 65544,
171 "max_element_size": 65536,
172 "chunk_threshold": 16,
173 "n_element_variations": 14,
174 "n_using_segments": 2,
175 "valid": true
176 }
177 }
178 ]