MongoDB Unique Index issue in array of subdocuments

Question

I have a document like this:

{
   _id : ObjectID(),
   title: "",
   items: [
      {
         "itemId" : 1234678,
      }
   ]
}

itemId is a unique index created like this:

db.allItems.createIndex( { "items.itemId" : 1 }, { unique: true});

And then everything works fine, until I set items array (not pushing one), in this case, unique index does not work. The following data in the update operation (using $set) does not throw an error and works fine, which MUST NOT. I mean it creates the sub-document without any unique error

items: [
  {
    itemId: 1234678
  },
  {
    itemId: 1234678
  }
]

While I expect MongoDB to throw error that itemId is not unique.

Valijon · Accepted Answer · 2020-02-05 08:52:57Z

1

MongoDb index uniqueness is applicable for documents, not for nested arrays.

If you try to insert new document with:

items: [
  {
     "itemId" : 1234678,
  },
  ...
]

MonogDB will throw E11000 duplicate key error collection

answered Feb 5, 2020 at 8:52

Valijon

13.2k4 gold badges40 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mostafa Talebi Over a year ago

is it related to $set or it generally ignores it?

Valijon Over a year ago

@MostafaTalebi it generally ignores

Collectives™ on Stack Overflow

MongoDB Unique Index issue in array of subdocuments

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related