mirror of https://gitee.com/bigwinds/arangodb
33 lines
3.1 KiB
Plaintext
33 lines
3.1 KiB
Plaintext
arangosh> db.test.ensureIndex({ <span class="hljs-attr">type</span>: <span class="hljs-string">"hash"</span>, <span class="hljs-attr">fields</span>: [ <span class="hljs-string">"a"</span>, <span class="hljs-string">"b.c"</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">"a"</span>,
|
|
<span class="hljs-string">"b.c"</span>
|
|
],
|
|
<span class="hljs-string">"id"</span> : <span class="hljs-string">"test/74778"</span>,
|
|
<span class="hljs-string">"isNewlyCreated"</span> : <span class="hljs-literal">true</span>,
|
|
<span class="hljs-string">"name"</span> : <span class="hljs-string">"idx_1646382081983381504"</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">"hash"</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> db.test.save({ <span class="hljs-attr">a</span> : <span class="hljs-number">1</span>, <span class="hljs-attr">b</span> : { <span class="hljs-attr">c</span> : <span class="hljs-number">1</span> } });
|
|
{
|
|
<span class="hljs-string">"_id"</span> : <span class="hljs-string">"test/74782"</span>,
|
|
<span class="hljs-string">"_key"</span> : <span class="hljs-string">"74782"</span>,
|
|
<span class="hljs-string">"_rev"</span> : <span class="hljs-string">"_ZXF6dXK--_"</span>
|
|
}
|
|
arangosh> db.test.save({ <span class="hljs-attr">a</span> : <span class="hljs-number">1</span>, <span class="hljs-attr">b</span> : { <span class="hljs-attr">c</span> : <span class="hljs-number">1</span> } });
|
|
[ArangoError <span class="hljs-number">1210</span>: unique constraint violated - <span class="hljs-keyword">in</span> index idx_1646382081983381504 <span class="hljs-keyword">of</span> type hash over <span class="hljs-string">'a, b.c'</span>; conflicting key: <span class="hljs-number">74782</span>]
|
|
arangosh> db.test.save({ <span class="hljs-attr">a</span> : <span class="hljs-number">1</span>, <span class="hljs-attr">b</span> : { <span class="hljs-attr">c</span> : <span class="hljs-literal">null</span> } });
|
|
{
|
|
<span class="hljs-string">"_id"</span> : <span class="hljs-string">"test/74786"</span>,
|
|
<span class="hljs-string">"_key"</span> : <span class="hljs-string">"74786"</span>,
|
|
<span class="hljs-string">"_rev"</span> : <span class="hljs-string">"_ZXF6dXO---"</span>
|
|
}
|
|
arangosh> db.test.save({ <span class="hljs-attr">a</span> : <span class="hljs-number">1</span> });
|
|
[ArangoError <span class="hljs-number">1210</span>: unique constraint violated - <span class="hljs-keyword">in</span> index idx_1646382081983381504 <span class="hljs-keyword">of</span> type hash over <span class="hljs-string">'a, b.c'</span>; conflicting key: <span class="hljs-number">74786</span>]
|