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

Allow count to work with query hints

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor - P4
    • Resolution: Fixed
    • 1.8.0-rc0
    • 2.5.5
    • None
    • None
    • Redhat 6.0
    • Fully Compatible

    Description

      Add ability to hint count commands.

      // using explicit command form
      		 
      db.runCommand({count:'test', query:{f:1}, hint:'_id_'})
      		 
       
      		 
      // using shell helper
      		 
      db.test.find({f:1}).hint('x_1').count()

      If there is no predicate for the query given to the count command, the hint will be ignored and the result will be pulled directly from the collection metadata.

      Attachments

        Issue Links

          is depended on by

          Improvement - An improvement or enhancement to an existing feature or task. JAVA-1344 Allow count to work with query hints

          • Major - P3 - Major loss of function.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. SERVER-10749 Query results differ depending on the utilized index

          • Critical - P2 - Crashes, loss of data, severe memory leak.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. SERVER-7105 Please provide a way to use $hint for Update/FindAndModify, and/or fix the Query Optimizer

          • Major - P3 - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. SERVER-14799 Count with hint doesn't work when hint is a document

          • Major - P3 - Major loss of function.
          • Closed
          related to

          New Feature - A new feature of the product, which has yet to be developed. SERVER-1599 support ability to pass hint to update

          • Major - P3 - Major loss of function.
          • Closed

          Task - A task that needs to be done. DOCS-3066 count + hint

          • Major - P3 - Major loss of function.
          • Closed

          Activity

            People

              dan@mongodb.com Daniel Pasette (Inactive)
              realzyy Yunyang Zhang
              Votes:
              20 Vote for this issue
              Watchers:
              16 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: