Uploaded image for project: 'Documentation'
  1. Documentation
  2. DOCS-2718

OR queries involving TEXT have to be fully indexed. (also doc or and geo)

    XMLWordPrintableJSON

Details

    • Icon: Improvement Improvement
    • Resolution: Done
    • Icon: Major - P3 Major - P3
    • v1.3.2, mongodb-2.6
    • None
    • manual
    • None

    Description

      consider

      { $or : [
       {$text: {$search: "findme"}},
      { a : {$gt: 12345} },
      ] }

      Both clauses of the OR need to be indexed. We cannot have $text clause be satisfied by a text index and {a: {$gt...} be executed with a collection scan.

      add blurb about $or and geo SERVER-3984

      Attachments

        Activity

          People

            kay.kim@mongodb.com Kay Kim (Inactive)
            benety.goh@mongodb.com Benety Goh
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              9 years, 50 weeks, 2 days ago