Uploaded image for project: 'Documentation'
  1. Documentation
  2. DOCS-694

problem about creating unqiue index with "dropDups" option

    XMLWordPrintableJSON

Details

    • Icon: Improvement Improvement
    • Resolution: Done
    • Icon: Major - P3 Major - P3
    • None
    • None
    • None

    Description

      db.people.insert([

      { "_id" : ObjectId("508f639c086512dc1f8694bd"), "username" : "smith", "age" : 48, "user_id" : 0 }

      ,

      { "_id" : ObjectId("508f63a1086512dc1f8694be"), "username" : "smith", "age" : 30, "user_id" : 1 }

      ,

      { "_id" : ObjectId("508f63ae086512dc1f8694bf"), "username" : "john", "age" : 36, "user_id" : 2 }

      ,

      { "_id" : ObjectId("508f63b9086512dc1f8694c0"), "username" : "john", "age" : 18, "user_id" : 3 }

      ,

      { "_id" : ObjectId("508f63ca086512dc1f8694c1"), "username" : "joe", "age" : 36, "user_id" : 4 }

      ,

      { "_id" : ObjectId("508f63d5086512dc1f8694c2"), "username" : "john", "age" : 7, "user_id" : 5 }

      ,

      { "_id" : ObjectId("508f63e0086512dc1f8694c3"), "username" : "simon", "age" : 3, "user_id" : 6 }

      ,

      { "_id" : ObjectId("508f63ee086512dc1f8694c4"), "username" : "joe", "age" : 27, "user_id" : 7 }

      ,

      { "_id" : ObjectId("508f63f9086512dc1f8694c5"), "username" : "jacob", "age" : 17, "user_id" : 8 }

      ,

      { "_id" : ObjectId("508f6404086512dc1f8694c6"), "username" : "sally", "age" : 52, "user_id" : 9 }

      ,

      { "_id" : ObjectId("508f640d086512dc1f8694c7"), "username" : "simon", "age" : 59, "user_id" : 10 }

      ])

      db.people.ensureIndex(

      {"age": 1}

      ,

      {"dropDups": true}

      ) # step 1
      db.people.ensureIndex(

      {"age": 1}

      ,

      {"unique": true, "dropDups": true}

      ) # step 2

      The step 2 doesn't take effect after I run step 1...

      Reporter: Ryououki
      E-mail: ytao_s@hotmail.com

      Attachments

        Activity

          People

            sam.kleinman Sam Kleinman (Inactive)
            auto auto
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              11 years, 15 weeks, 1 day ago