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

hint() is not respected in find()

    • Fully Compatible
    • ALL

      Triage update:

      Under 2.4.8, the planner generates a single indexed solution when a hint is provided.
      Under 2.5.4, a collection scan is generated in addition to the indexed solution. It's possible for the collection scan to be ranked higher than the indexed solution, resulting in the hinted solution being ignored.

      ------

      mongo --shell test.js
      > use dummy
      switched to db dummy
      > doit()
      BasicCursor
      

      Expected to see "BtreeCursor ace.val_1 multi" output.

        1. server12056.js
          1 kB
          Benety Goh
        2. server12056.js
          1 kB
          Benety Goh
        3. test.js
          0.3 kB
          Alexander Komyagin

            Assignee:
            benety.goh@mongodb.com Benety Goh
            Reporter:
            alex.komyagin@mongodb.com Alexander Komyagin (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: