mirror of https://gitee.com/bigwinds/arangodb
55 lines
3.4 KiB
Plaintext
55 lines
3.4 KiB
Plaintext
arangosh> db.old.ensureIndex({ <span class="hljs-attr">type</span>: <span class="hljs-string">"skiplist"</span>, <span class="hljs-attr">fields</span>: [ <span class="hljs-string">"age"</span> ] });
|
|
{
|
|
<span class="hljs-string">"deduplicate"</span> : <span class="hljs-literal">true</span>,
|
|
<span class="hljs-string">"fields"</span> : [
|
|
<span class="hljs-string">"age"</span>
|
|
],
|
|
<span class="hljs-string">"id"</span> : <span class="hljs-string">"old/209"</span>,
|
|
<span class="hljs-string">"isNewlyCreated"</span> : <span class="hljs-literal">true</span>,
|
|
<span class="hljs-string">"name"</span> : <span class="hljs-string">"idx_1646382025055141890"</span>,
|
|
<span class="hljs-string">"selectivityEstimate"</span> : <span class="hljs-number">1</span>,
|
|
<span class="hljs-string">"sparse"</span> : <span class="hljs-literal">false</span>,
|
|
<span class="hljs-string">"type"</span> : <span class="hljs-string">"skiplist"</span>,
|
|
<span class="hljs-string">"unique"</span> : <span class="hljs-literal">false</span>,
|
|
<span class="hljs-string">"code"</span> : <span class="hljs-number">201</span>
|
|
}
|
|
arangosh> db.old.insert({ <span class="hljs-attr">age</span>: <span class="hljs-number">15</span> });
|
|
{
|
|
<span class="hljs-string">"_id"</span> : <span class="hljs-string">"old/213"</span>,
|
|
<span class="hljs-string">"_key"</span> : <span class="hljs-string">"213"</span>,
|
|
<span class="hljs-string">"_rev"</span> : <span class="hljs-string">"_ZXF5oWC---"</span>
|
|
}
|
|
arangosh> db.old.insert({ <span class="hljs-attr">age</span>: <span class="hljs-number">25</span> });
|
|
{
|
|
<span class="hljs-string">"_id"</span> : <span class="hljs-string">"old/215"</span>,
|
|
<span class="hljs-string">"_key"</span> : <span class="hljs-string">"215"</span>,
|
|
<span class="hljs-string">"_rev"</span> : <span class="hljs-string">"_ZXF5oWC--A"</span>
|
|
}
|
|
arangosh> db.old.insert({ <span class="hljs-attr">age</span>: <span class="hljs-number">30</span> });
|
|
{
|
|
<span class="hljs-string">"_id"</span> : <span class="hljs-string">"old/217"</span>,
|
|
<span class="hljs-string">"_key"</span> : <span class="hljs-string">"217"</span>,
|
|
<span class="hljs-string">"_rev"</span> : <span class="hljs-string">"_ZXF5oWC--C"</span>
|
|
}
|
|
arangosh> db.old.closedRange(<span class="hljs-string">"age"</span>, <span class="hljs-number">10</span>, <span class="hljs-number">30</span>).toArray();
|
|
[
|
|
{
|
|
<span class="hljs-string">"_key"</span> : <span class="hljs-string">"213"</span>,
|
|
<span class="hljs-string">"_id"</span> : <span class="hljs-string">"old/213"</span>,
|
|
<span class="hljs-string">"_rev"</span> : <span class="hljs-string">"_ZXF5oWC---"</span>,
|
|
<span class="hljs-string">"age"</span> : <span class="hljs-number">15</span>
|
|
},
|
|
{
|
|
<span class="hljs-string">"_key"</span> : <span class="hljs-string">"215"</span>,
|
|
<span class="hljs-string">"_id"</span> : <span class="hljs-string">"old/215"</span>,
|
|
<span class="hljs-string">"_rev"</span> : <span class="hljs-string">"_ZXF5oWC--A"</span>,
|
|
<span class="hljs-string">"age"</span> : <span class="hljs-number">25</span>
|
|
},
|
|
{
|
|
<span class="hljs-string">"_key"</span> : <span class="hljs-string">"217"</span>,
|
|
<span class="hljs-string">"_id"</span> : <span class="hljs-string">"old/217"</span>,
|
|
<span class="hljs-string">"_rev"</span> : <span class="hljs-string">"_ZXF5oWC--C"</span>,
|
|
<span class="hljs-string">"age"</span> : <span class="hljs-number">30</span>
|
|
}
|
|
]
|