Details

    • Type: Improvement Improvement
    • Status: Closed Closed
    • Priority: Major - P3 Major - P3
    • Resolution: Fixed
    • Affects Version/s: 1.6.0, 1.6.1, 1.6.2, 1.6.3, 1.6.4, 1.6.5, 1.7.0, 1.7.1, 1.7.2, 1.7.3, 1.7.4, 1.7.5, 1.7.6
    • Fix Version/s: 1.9.1
    • Component/s: Querying
    • Labels:
      None
    • Backport:
      No
    • # Replies:
      11
    • Last comment by Customer:
      true

      Description

      Allowing nested $or operators would dramatically simplify the logic to build queries. The work of transformation/normalizing the query so that the engine understands it should be done by the server, not the client.

        Issue Links

          Activity

          Hide
          auto
          added a comment -

          Author:

          {u'login': u'astaple', u'name': u'Aaron', u'email': u'aaron@10gen.com'}

          Message: SERVER-3192 SERVER-2585 allow nested or clauses in queries, opaque to indexing system
          Branch: master
          https://github.com/mongodb/mongo/commit/0b32ad4e6d5629525001add932fe78ba517cb503

          Show
          auto
          added a comment - Author: {u'login': u'astaple', u'name': u'Aaron', u'email': u'aaron@10gen.com'} Message: SERVER-3192 SERVER-2585 allow nested or clauses in queries, opaque to indexing system Branch: master https://github.com/mongodb/mongo/commit/0b32ad4e6d5629525001add932fe78ba517cb503
          Hide
          Aaron Staple (Inactive)
          added a comment -

          We've added in matching for nested or clauses, but not index support. Index support is SERVER-3327.

          Show
          Aaron Staple (Inactive)
          added a comment - We've added in matching for nested or clauses, but not index support. Index support is SERVER-3327 .
          Hide
          auto
          added a comment -

          Author:

          {u'login': u'astaple', u'name': u'Aaron', u'email': u'aaron@10gen.com'}

          Message: SERVER-2585 test
          Branch: master
          https://github.com/mongodb/mongo/commit/8b35cf0f945c5636df17709bf03a03f63217273f

          Show
          auto
          added a comment - Author: {u'login': u'astaple', u'name': u'Aaron', u'email': u'aaron@10gen.com'} Message: SERVER-2585 test Branch: master https://github.com/mongodb/mongo/commit/8b35cf0f945c5636df17709bf03a03f63217273f
          Hide
          Xiaofeng Wu
          added a comment -

          I have tried with 1.9.1 development release and night build with nested $or like this. I saw the message as following:
          "failed with exception: exception: 13090 nested $or/$nor not allowed", but I checked the source code(matcher.cpp), this information has been removed. I wonder if the build is not based on latest code. Please check out.

          Show
          Xiaofeng Wu
          added a comment - I have tried with 1.9.1 development release and night build with nested $or like this. I saw the message as following: "failed with exception: exception: 13090 nested $or/$nor not allowed", but I checked the source code(matcher.cpp), this information has been removed. I wonder if the build is not based on latest code. Please check out.
          Hide
          Aaron Staple (Inactive)
          added a comment -

          Xiaofeng - can you send the git hash for the mongod version you are using (this is logged on mongod startup).

          Show
          Aaron Staple (Inactive)
          added a comment - Xiaofeng - can you send the git hash for the mongod version you are using (this is logged on mongod startup).

            People

            • Votes:
              22 Vote for this issue
              Watchers:
              13 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since reply:
                2 years, 35 weeks, 1 day ago
                Date of 1st Reply: