1
0
Fork 0
arangodb/Documentation/Examples/ensureUniqueSkiplistSingle....

36 lines
2.7 KiB
Plaintext

arangosh&gt; db.ids.ensureIndex({ <span class="hljs-attr">type</span>: <span class="hljs-string">"skiplist"</span>, <span class="hljs-attr">fields</span>: [ <span class="hljs-string">"myId"</span> ], <span class="hljs-attr">unique</span>: <span class="hljs-literal">true</span> });
{
<span class="hljs-string">"deduplicate"</span> : <span class="hljs-literal">true</span>,
<span class="hljs-string">"fields"</span> : [
<span class="hljs-string">"myId"</span>
],
<span class="hljs-string">"id"</span> : <span class="hljs-string">"ids/74892"</span>,
<span class="hljs-string">"isNewlyCreated"</span> : <span class="hljs-literal">true</span>,
<span class="hljs-string">"name"</span> : <span class="hljs-string">"idx_1646382082012741632"</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">true</span>,
<span class="hljs-string">"code"</span> : <span class="hljs-number">201</span>
}
arangosh&gt; db.ids.save({ <span class="hljs-string">"myId"</span>: <span class="hljs-number">123</span> });
{
<span class="hljs-string">"_id"</span> : <span class="hljs-string">"ids/74896"</span>,
<span class="hljs-string">"_key"</span> : <span class="hljs-string">"74896"</span>,
<span class="hljs-string">"_rev"</span> : <span class="hljs-string">"_ZXF6dY6--_"</span>
}
arangosh&gt; db.ids.save({ <span class="hljs-string">"myId"</span>: <span class="hljs-number">456</span> });
{
<span class="hljs-string">"_id"</span> : <span class="hljs-string">"ids/74898"</span>,
<span class="hljs-string">"_key"</span> : <span class="hljs-string">"74898"</span>,
<span class="hljs-string">"_rev"</span> : <span class="hljs-string">"_ZXF6dZ----"</span>
}
arangosh&gt; db.ids.save({ <span class="hljs-string">"myId"</span>: <span class="hljs-number">789</span> });
{
<span class="hljs-string">"_id"</span> : <span class="hljs-string">"ids/74900"</span>,
<span class="hljs-string">"_key"</span> : <span class="hljs-string">"74900"</span>,
<span class="hljs-string">"_rev"</span> : <span class="hljs-string">"_ZXF6dZ---A"</span>
}
arangosh&gt; db.ids.save({ <span class="hljs-string">"myId"</span>: <span class="hljs-number">123</span> });
[ArangoError <span class="hljs-number">1210</span>: unique constraint violated - <span class="hljs-keyword">in</span> index idx_1646382082012741632 <span class="hljs-keyword">of</span> type skiplist over <span class="hljs-string">'myId'</span>; conflicting key: <span class="hljs-number">74896</span>]