Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-5807

Query doesn't process correctly advanced queries on Multikeys index

    XMLWordPrintableJSON

Details

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major - P3 Major - P3
    • None
    • None
    • None
    • None
    • ALL

    Description

      The lookups index has been set as explained in http://www.mongodb.org/display/DOCS/Using+Multikeys+to+Simulate+a+Large+Number+of+Indexes

      The following query doesn't return any value
      Query condition: { "_lookups" : { "state" :

      { "$in" : ["Active", "Verified"] }

      } }
      Explain:
      { "cursor" : "BtreeCursor lookups", "nscanned" : 0, "nscannedObjects" : 0, "n" : 0, "millis" : 0, "nYields" : 0, "nChunkSkips" : 0, "isMultiKey" : true, "indexOnly" : false, "indexBounds" : { "_lookups" : [[{ "state" :

      { "$in" : ["Active", "Verified"] }

      }, { "state" :

      { "$in" : ["Active", "Verified"] }

      }]] } }

      While
      Query condition: { "$or" : [{ "_lookups" :

      { "state" : "Active" }

      }, { "_lookups" :

      { "state" : "Verified" }

      }] }
      Explain: { "cursor" : "BtreeCursor lookups", "nscanned" : 10, "nscannedObjects" : 10, "n" : 10, "millis" : 0, "nYields" : 0, "nChunkSkips" : 0, "isMultiKey" : true, "indexOnly" : false, "indexBounds" : { "_lookups" : [[

      { "state" : "Active" }

      ,

      { "state" : "Active" }

      ]] } }

      works

      Attachments

        Activity

          People

            Unassigned Unassigned
            priam Laurent
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: