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

Nested $or queries with $text nodes should use the $or with clustered collection scan

    XMLWordPrintableJSON

Details

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Major - P3 Major - P3
    • None
    • None
    • None
    • Query Integration
    • ALL

    Description

      SERVER-77280 added queries during subplanning for $or that will allow plans with OR and clustered collection scans. SERVER-61259 extended these plans to work with $text nodes. However, subplanning is only entered for rooted $or queries, so queries like the one below won't use the new plans. We should add logic to use the new plans with these types of queries too.

      t.find({a: 0, $or: [{_id: 2}, {$text: {$search: "foo"}}]} 

      Attachments

        Activity

          People

            backlog-query-integration Backlog - Query Integration
            gil.alon@mongodb.com Gil Alon
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: