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

Use $not as a top-level logical op

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Backlog
    • Trivial - P5
    • Resolution: Unresolved
    • None
    • None
    • Querying
    • None
    • Query Optimization
    • v4.4, v4.2, v4.0
    • Query Optimization 2021-06-14, QO 2021-09-20, QO 2021-10-04, QO 2021-10-18, QO 2021-11-01, QO 2021-11-15, QO 2021-11-29, QO 2021-12-13, QO 2021-12-27, QO 2022-01-10, QO 2022-01-24, QO 2022-02-07, QO 2022-02-21, QO 2022-03-07

    Description

      In our MongoDB-CSharp driver we convert code expressions like that to documents queries.

      !(Address.IsDefault && Adress.Name=="foo")

      The problem here is that the ! operator reverses the meaning of both equality checks. This scenario would be much easier to accomplish when we could use the $not operator like the $or operator.

      Example:

      { $not : [ 
          { "Address.IsDefault" : true },
      		 
          { "Address.Name" : "foo" }
      		 
      ] }

      I think also that this is more the way the users expect to use the $not operator.

      Attachments

        Issue Links

          is duplicated by

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-10708 negation of query expressions using "$not"

          • Minor - P4 - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. JAVA-4006 Filters can produce invalid query shapes in Java 4.0+

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

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-58772 improve error message for top level $not expression

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

          Bug - A problem which impairs or prevents the functions of the product. SERVER-39019 $elemMatch $ne serialization is incorrect, doesn't roundtrip

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

          Bug - A problem which impairs or prevents the functions of the product. SERVER-43349 Incorrect serialization for $elemMatch $not $ne

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

          Improvement - An improvement or enhancement to an existing feature or task. JAVA-4008 Document JAVA-4006 in Driver Upgrade notes

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

          Activity

            People

              backlog-query-optimization Backlog - Query Optimization
              lanwin Steve Wagner
              Votes:
              17 Vote for this issue
              Watchers:
              23 Start watching this issue

              Dates

                Created:
                Updated: