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

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

    XMLWordPrintable

    Details

    • 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.
    • Sprint:
      Query Optimization 2021-05-17, Query Optimization 2021-06-14, Query Optimization 2021-06-28, Query Optimization 2021-07-12, Query Optimization 2021-07-26, QO 2021-09-06, Query Optimization 2021-08-09, QO 2021-09-20, QO 2021-10-04, QO 2021-10-18, QO 2021-11-01, QO 2021-08-23
    • Case:

      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

              Assignee:
              jacob.evans Jacob Evans
              Reporter:
              tubbo Tom Scott
              Participants:
              Votes:
              0 Vote for this issue
              Watchers:
              14 Start watching this issue

                Dates

                Created:
                Updated: