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

$nin:[[],...] queries are not indexed

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major - P3
    • Resolution: Unresolved
    • Affects Version/s: 4.0.9, 4.1.9
    • Fix Version/s: Backlog
    • Component/s: Querying
    • Operating System:
      ALL
    • Steps To Reproduce:
      Hide
      1. Create an index for an Array field
      2. Run a query for $nin: [[], null] on that field
      3. Observe that a No query solutions occurs, even though an index was created, because the query no longer respects the index.
      Show
      Create an index for an Array field Run a query for $nin: [[], null] on that field Observe that a No query solutions occurs, even though an index was created, because the query no longer respects the index.

      Description

      Since v4.0.9, $nin queries containing arrays are no longer possible when the notablescan setting is enabled on the server. The server will always throw a "No query solutions" error, due to SERVER-38949.

      original description

      Since v4.0.9, $nin queries are no longer possible when the notablescan setting is enabled on the server. The server will always throw a "No query solutions" error, because indexes made for the fields being queried are not respected for a $nin query, resulting in a full-table scan and the error. This is most likely due to SERVER-38949

       

       

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                10 Start watching this issue

                Dates

                • Created:
                  Updated: