Core Server
  1. Core Server
  2. SERVER-2585

Allow nested $or operator

      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
      • # 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

          is depended on by

          New Feature - A new feature of the product, which has yet to be developed. SERVER-3192 allow nesting $or within $and

          • Major - P3 - Major loss of function.
          • Closed - The issue is considered finished, the resolution is correct. Issues which are closed can be reopened.

            Activity

            Ascending order - Click to sort in descending order
            • Comments
            5 older comments
            Hide
            Permalink
            auto (Inactive)             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 (Inactive)             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
            Permalink
            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
            Permalink
            auto (Inactive)             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 (Inactive)             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
            Permalink
            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
            Permalink
            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:
                  3 years, 29 weeks, 1 day ago
                  Date of 1st Reply: