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

hint() is not respected in find()

    XMLWordPrintableJSON

Details

    • Fully Compatible
    • ALL

    Description

      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.

      Attachments

        1. server12056.js
          1 kB
        2. server12056.js
          1 kB
        3. test.js
          0.3 kB

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: