| 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 |
plugin_register functions/string |
| 8 |
[[0,0.0,0.0],true] |
| 9 |
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 |
| 10 |
[ |
| 11 |
[ |
| 12 |
0, |
| 13 |
0.0, |
| 14 |
0.0 |
| 15 |
], |
| 16 |
[ |
| 17 |
[ |
| 18 |
[ |
| 19 |
1 |
| 20 |
], |
| 21 |
[ |
| 22 |
[ |
| 23 |
"_key", |
| 24 |
"ShortText" |
| 25 |
], |
| 26 |
[ |
| 27 |
"content_head", |
| 28 |
"ShortText" |
| 29 |
], |
| 30 |
[ |
| 31 |
"content_tail", |
| 32 |
"ShortText" |
| 33 |
], |
| 34 |
[ |
| 35 |
"content_length", |
| 36 |
"UInt32" |
| 37 |
] |
| 38 |
], |
| 39 |
[ |
| 40 |
"huge: 4MiB <=: 1 segment", |
| 41 |
"abcda", |
| 42 |
"dabcd", |
| 43 |
4194304 |
| 44 |
] |
| 45 |
] |
| 46 |
] |
| 47 |
] |
| 48 |
_database_close |
| 49 |
[[0,0.0,0.0],true] |
| 50 |
_database_reopen |
| 51 |
[[0,0.0,0.0],true] |
| 52 |
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 |
| 53 |
[ |
| 54 |
[ |
| 55 |
0, |
| 56 |
0.0, |
| 57 |
0.0 |
| 58 |
], |
| 59 |
[ |
| 60 |
[ |
| 61 |
[ |
| 62 |
1 |
| 63 |
], |
| 64 |
[ |
| 65 |
[ |
| 66 |
"_key", |
| 67 |
"ShortText" |
| 68 |
], |
| 69 |
[ |
| 70 |
"content_head", |
| 71 |
"ShortText" |
| 72 |
], |
| 73 |
[ |
| 74 |
"content_tail", |
| 75 |
"ShortText" |
| 76 |
], |
| 77 |
[ |
| 78 |
"content_length", |
| 79 |
"UInt32" |
| 80 |
] |
| 81 |
], |
| 82 |
[ |
| 83 |
"huge: 4MiB <=: 1 segment", |
| 84 |
"abcda", |
| 85 |
"dabcd", |
| 86 |
4194304 |
| 87 |
] |
| 88 |
] |
| 89 |
] |
| 90 |
] |