A hint: This file contains one or more very long lines, so maybe it is better readable using the pure text view mode that shows the contents as wrapped lines within the browser window.
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": 2, 27 "type": 2, 28 "type_name": "huge", 29 "value": 0 30 } 31 ], 32 "garbage_counts": { 33 }, 34 "free_elements": { 35 } 36 }, 37 "summary": { 38 "flags": "0000C000", 39 "curr seg": 0, 40 "curr pos": 4194304, 41 "max_element_size": 65536, 42 "chunk_threshold": 16, 43 "n_element_variations": 14, 44 "n_using_segments": 2, 45 "valid": true 46 } 47 } 48 ] 49 plugin_register functions/string 50 [[0,0.0,0.0],true] 51 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 52 [ 53 [ 54 0, 55 0.0, 56 0.0 57 ], 58 [ 59 [ 60 [ 61 1 62 ], 63 [ 64 [ 65 "_key", 66 "ShortText" 67 ], 68 [ 69 "content_head", 70 "ShortText" 71 ], 72 [ 73 "content_tail", 74 "ShortText" 75 ], 76 [ 77 "content_length", 78 "UInt32" 79 ] 80 ], 81 [ 82 "huge: 4MiB <=: 1 segment", 83 "ABCDA", 84 "DABCD", 85 4194304 86 ] 87 ] 88 ] 89 ] 90 _database_close 91 [[0,0.0,0.0],true] 92 _database_reopen 93 [[0,0.0,0.0],true] 94 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 95 [ 96 [ 97 0, 98 0.0, 99 0.0 100 ], 101 [ 102 [ 103 [ 104 1 105 ], 106 [ 107 [ 108 "_key", 109 "ShortText" 110 ], 111 [ 112 "content_head", 113 "ShortText" 114 ], 115 [ 116 "content_tail", 117 "ShortText" 118 ], 119 [ 120 "content_length", 121 "UInt32" 122 ] 123 ], 124 [ 125 "huge: 4MiB <=: 1 segment", 126 "ABCDA", 127 "DABCD", 128 4194304 129 ] 130 ] 131 ] 132 ] 133 check --obj Memos.content 134 [ 135 [ 136 0, 137 0.0, 138 0.0 139 ], 140 { 141 "details": { 142 "segments": [ 143 { 144 "id": 0, 145 "type": 3, 146 "type_name": "element info", 147 "element_info_index": 0, 148 "referred_segment": 0, 149 "valid": true 150 }, 151 { 152 "id": 2, 153 "type": 2, 154 "type_name": "huge", 155 "value": 0 156 } 157 ], 158 "garbage_counts": { 159 }, 160 "free_elements": { 161 } 162 }, 163 "summary": { 164 "flags": "0000C000", 165 "curr seg": 0, 166 "curr pos": 4194304, 167 "max_element_size": 65536, 168 "chunk_threshold": 16, 169 "n_element_variations": 14, 170 "n_using_segments": 2, 171 "valid": true 172 } 173 } 174 ]