Use index is order dependent

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Duplicate
    • Priority: Major - P3
    • None
    • Affects Version/s: 2.6.1
    • Component/s: Index Maintenance
    • None
    • ALL
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      mongodb (2.6.1) use index is order dependent.

      in mongodb (2.4.10):
      indexes: (a_1), (a_1, b_1)

      db.test.find(

      {a: 1, b: 1}

      ).explain() -->
      indexBounds: (a_1, b_1)

      but in mongodb (2.6.1):
      indexes: (a_1), (a_1, b_1)

      db.test.find(

      {a: 1, b: 1}

      ).explain() -->
      indexBounds: (a_1)

      if I build index in reverse order:
      indexes: (a_1, b_1), (a_1)

      db.test.find(

      {a: 1, b: 1}

      ).explain() -->
      indexBounds: (a_1, b_1)

            Assignee:
            Unassigned
            Reporter:
            Michael Yang
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: